Database Administrator

Install the MySQL Sample Database Sakila Generally, there is no data available for testing and use on a brand new MySQL server. MySQL provides us with some sample databases for basic operations and stress testing based on these databases. This

Configure HugePage in Linux For Oracle database servers with large memory, it is necessary to configure HugePage. The following describes how to configure Huge: My environment: OS: CentOS release 6.4 (Final) Oracle: 11.2.0.4 RAC HugePage needs to be

Use RMAN to migrate the file system to ASM 1. Full backup database PROD Run {Allocate channel c1 device type disk;Allocate channel c2 device type disk;Backup tag 'sh _ db' as compressed backupset format'/home/Oracle/full _ % U. Bak' databaseInclude

Enable Oracle startup in CentOS 6.4 Objective: To enable Oracle to start on CentOS 6.4 Solution: First add start, close, restart Oracle services and instance services, and then add this service to the System Service running level. Set CentOS to

Mysql load data infile usage, mysqlinfile The load data infile statement reads a table from a text file at a high speed. 1. Basic syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name

Oracle 11g new feature system partition table, oracle11g A new feature in 11g is the Partition Table of the system. Here is an experiment: SQL> select * from v $ version;BANNER--------------------------------------------------------------------------

Path Problem in mysql5.5 and in mysql5.5 The parameters in my. ini are as follows: Basedir = "C:/Program Files/MySQL Server 6.0 /" Datadir = "" path for storing the table structure Innodb_data_home_dir = "" This is the path for storing table

Rac_grid self-check failed to report PRVF-4007, rac_gridprvf-4007 Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally

64-bit oracle databases cannot be connected with 32-bit plsql developer (oci. dll cannot be loaded), plsqloci. dll Install the oracle database in a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 6

MySQL database startup and shutdown, mysql database Shutdown MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started to start

Hierarchy is an idea and an idea.The database has a three-tier mode and two-tier image. This layer is designed as needed and has certain functions for each layer. This design concept of "performing their jobs" is not only used in databases, but also

/Var/tmp/. oracle and oracle listener (listener)   Test the functions of/var/tmp/. oracle ~ --- View/var/tmp Permissions [Root @ lixora var] # llTotal 164...Drwxrwxrwt3 root 4096 Oct 31 tmp   [Root @ lixora. oracle] # llTotal 0Srwxrwxrwx 1 oracle10g

An error ora-28056, oracleora-28056 reported when an oracle instance is started under windows In oracle in windows, when an instance is started, it will write startup information to the event viewer of the windows operating system-Application Part,

Simple ORACLE database operation function usage, simple oracle operation 1. DISTINCT usage: Select distinct a. NAME, A. STUDENT_ID, A. SEX FROM TABLE STUDENT This SQL statement queries the name, student ID, and gender from the student table, but the

Oracle Performance Analysis 12: Object statistics and oracle statistics Object statistics describe how data is stored in the database. The query optimizer uses these statistics to make the correct decision. Oracle has three types of object

Dbms_xplan.display_awr method to obtain the experiment of the Execution Plan and the previous misleading, dbmsxplan. display This blog article "view several common methods of Oracle execution plans-Series 1"

Database Connection operations (1), database connection operations ( Connect to the Database Using JSP, including data query, deletion, and modification. add data to the database. The database is MySQL. The files include login. jsp, do_login.jsp

Hibernate Persistence principlesPersistence java classes must follow the following principles:1. This class usually requires an id. We recommend that you use the encapsulation type.2. This class cannot be modified by final.3. You need to provide a

Analyze the usage of the oracle index space and whether the index needs to be rebuilt.Analyze the index space usage and whether the index needs to be rebuiltThe analyze any permission is required to analyze indexes of other users.Check the table

Mysql1130 remote connection does not have permission solution, mysql1130 permission There are two reasons why the remote connection has no permissions: mysql and firewall. 1. Solve firewall restrictions: Shut down the firewall on the mysql