Database Administrator

Insert a large amount of data into a table in the MySQL database: Usage: DELIMITER $USE 'macross _ wudi '$Drop procedure if exists 'test' $Create procedure 'test '()BEGINDECLARE I INT DEFAULT 333;DECLARE j int default 333;WHILE (I Replace into

ORA-00600 [KSLFFRE_PVT2] abnormal termination of instance: Sat Oct 20 02:00:22 2012 Errors in file/u01/Oracle/app/oracle/admin/demo/bdump/demo_lms2_774478.trc: ORA-00600: internal error code, arguments: [KSLFFRE_PVT2], [0x700000CE1327F90], [23058

1. Clustering factor) The storage order of the index row is similar to that of the row in the table. When the similarity is high, these data rows will be stored in a relatively small number of data blocks, which is a good condition for clustering

Two years ago, I would like to sum up that there are many online articles about the causes of database locks caused by deep foreign key indexes, so I will not detail them here. 1. Slow database response. Check that a large number of enq locks exist

The backup and recovery capabilities are "broken. The principle is briefly introduced here: Oracle records the changes of all data files in the form of logs. Therefore, as long as all oracle data files are backed up in a certain period of time and

Memcached is a distributed memory object cache system, which is usually used for dynamic Web applications to reduce database load. Memcached is a hashmap based on a storage key pair. When the table is full, it is replaced by the LRU (least recently

In Windows, you do not need to create a data directory or an authorization table after installing mysql. A set of pre-initialized account authorization tables exist in the MySQL database under the Data Directory. Do not run the mysql_install_db

Sybase Contral Center (future name: SAP Contral Center) is a unified Web-based resource management framework. Sybase ASE does not contain SCC. SCC must be downloaded and installed independently. If ASE has a valid license, SCC does not require any

What is the maximum storage space supported by a single mysql table? In fact, this problem has to be split into two problems. The first is the size of a single file supported by the file system used by the operating system, for example: Linux

Decompress and install MySQL 5.1.65 in Ubuntu 12.10. 1. Download Http://downloads.mysql.com/archives.php? P = mysql-5.1 & o = linux- Http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.65-linux-i686-glibc23.tar.gz 2. Decompress Gunzip mysql-

I. environment required The IP addresses of MYSQL services installed on both virtual machines are 192.168.1.1 192.168.1.2. 2. The procedure is as follows; Virtual Server 1 [Root @ localhost ~] # Yum install mysql-server-y [Root @ localhost ~] #

When you use insert into select to load data in batches, the entire insert statement cannot be executed because some data does not meet the loading conditions. In this case, you can use the DML Error Log feature to solve this problem. You only need

1. jsp calls Oracle  1. install tomcat[Root @ h1 ROOT] # cd/var/App/[Root @ h1 App] # unzip apache-tomcat-6.0.14.zip 2. Copy ojdbc. jar [Root @ h1 ~] # Cd/app/oracle/product/11.2.0/dbhome_2/jdbc/lib[Root @ h1 lib] # find ojdbc6.jarOjdbc6.jar[Root @

When writing an Oracle stored procedure, my colleagues modified it based on the previously written process and wanted to change the name. due to negligence, I did not change the name and compiled it. After compilation, I realized it. Then the

First, create a test table. Create table test1 (c1 number, c2 number, c3 number );Create table test2 (c1 number, c2 number, c3 number ); Start testing SQL> declare22 l_stat_ SQL varchar2 (2000): = 'select value from v $ mystat ms, v $ statname sn

Installation environment Linux Server: SUSE10 sp2 64-bit Oracle Server: Oracle11gR2 64-bitSystem Requirements Requirements for installing Oracle in Linux System Requirements Description Memory Physical memory must be

Batch update refers to updating a large volume of data in a transaction, and batch Delete refers to deleting a large volume of data in a transaction. The following program uses the Hibernate API to update the AGE fields of all records whose AGE is

Install Oracle 10gR2 on Solaris 10. 1. Create a user, group, and oracle directory Log on as the root user and create a directory: Mkdir-p/opt/app/oracle Mkdir-p/opt/app/oracle/product/10.2.0/db Create an oracle group and user and assign users and

Oracle Database Management Experiment1. Transfer tablespace2. Create a partition table and a partition Index3fga fine-grained AuditIv. Monitoring Index usage5. Create a table with special fields6. Flashback flash back Technology1. migrate the

Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/30615151 The experiment process is as follows: 1. Create the table guo_test1 gyj@PROD> create table guoyJoe_t1(id int,name varchar2(10));Table created.gyj@PROD>