Database Administrator

Case: Add students and return to all students in the class. Create or replace procedure add_stu (P_sid stu. sid % type,P_sname stu. sname % type,P_cid stu. cid % type,P_data out sys_refcursor -- output variable, system reference cursor)AsBeginInsert

Show parameter recover -- view the path for storing archived log files Alter database archive -- change the database to archive Mode Archive log list/SQL> select name, log_mode from v $ database; view the current status of the database Modify the

I. Prepare the development environment1. install Linux first. Ubuntu 10.10 is used here.2. Install the MySQL software package. MySQL 10.10 is included in the system repository:Sudo apt-get install mysql-serverSudo apt-get install mysql-clientSudo

MySQL installed in the rpm package in Linux does not install the/etc/my. cnf file, As to why MySQL can be started and used normally without this file, there are two points, The first statement is that my. cnf is only a parameter file during MySQL

I recently learned about Oracle Data Mining and found that there is very little information on the Internet. I suggest you sort it out by yourself. Data Mining PL/SQL Packages Oracle Data Mining supports supervised and unsupervised data mining.

The Flashback Database function is very similar to the incomplete recovery of RMAN. It can roll back the entire Database to a certain time point in the past. This function depends on the Flashback log. Faster and more efficient than RMAN. Therefore,

Introduction: Database suddenly reported: ORA-01654: unable to extend index BO. INDEX_indexname by 311072 in tablespace error. There is only one reason to check the Internet, which is to increase the size of tablespace. because the tablespace of the

The following error is reported on the master database after Standby is restarted. PING [ARC0]: Heartbeat failed to connect to standby 'standby'. Error is 16047. Find other people's solutions on the Internet and solve the problem successfully. The

Recently, when helping customers build an OSB cluster environment, after the managed server in the cluster is started, there will be a BEA-473007 warning "clustering unable to accept clustering Statistics ", I found a solution on the Internet as

Sequence: sequence creation method and use when inserting data; -- Sequence CreationCreate sequence sqIncrement by 1Start with 1Maxvalue 10Minvalue 1CycleCache 5 -- General (a sequence can be used in multiple tables, but generally, a table

ORA-01555 ultra-long Query Duration time Symptom:The Alert Log reports a ORA-01555 error, but what is incredible is the ultra-long Query Duration (1382909202 sec ).Mon Oct 28 05:26:42 2013ORA-01555 caused by SQL statement below (Query Duration = 1382

Idle> startupThe Oracle routine has been started. Total System Global Area 3407261696 bytesFixed Size 2180504 bytesVariable Size 2348812904 bytesDatabase Buffers 1040187392 bytesRedo Buffers 16080896 bytesThe database has been loaded.ORA-03113: End

Here I have selected the version of mysql-5.5.33-linux2.6-x86_64.tar.gz. You can select it based on your actual needs.1. MYSQLhttp: // mirrors.sohu.com/mysql/2. Download the source package wget

An error is reported when I help my colleagues handle an SQL statement (simplified: mysql> select date_format('2013-11-19','Y-m-d') > timediff('2013-11-19', '2013-11-20'); ERROR 1267 (HY000): Illegal mix of

Remote settings of MySQL Databases in Linux 1. Start the service and log on[Root @ localhost ~] #/Etc/init. d/mysqld restartStopping mysqld: [OK]Starting mysqld: [OK][Root @ localhost ~] # Mysql-u root-pEnter password:Welcome to the MySQL monitor.

In the RAC environment where two virtual machines are started, we usually need to shut down the host. In this case, the two virtual machines are usually sleep separately. After several practices, after each restart, there are various problems in the

Mysql binlog3 formats: row, mixed, and statement. Parsing Mysqlbinlog -- base64-output = DECODE-ROWS-v mysql-bin.000144 | more   -- Base64-output = DECODE-ROWS: displays the SQL changes brought about by row mode. -V: displays SQL statements in

A long time ago, I gave a lecture and used the command ipcs to find that the Oracle Sharing Section is small, as shown below: Oracle @ mydb ~] $ Ipcs- ------ Shared Memory Segments --------Key shmid owner perms bytes nattch status0x00000000 32768

MySQL -- Binary log Recently, when I checked the monitoring server, I found that there were as many as 14 GB log files. I checked the information and introduced it as follows: Binary log is a very important part of mysql. It has two main functions:

Lock table read lock If a thread acquires a read lock on a table, the thread and all other threads can only read data from the table and cannot perform any write operations. Lock tables user read; // read the locked table Unlock tables; //