Oracle

I. Data Control statement (DML) section 1.insert (Insert the statement into the data sheet) Insert into table name (field name 1, field Name 2, ...) Values (value 1, value 2, ...); Insert into table name (field name 1, field Name 2, ...) Select

1, the primary key defined as the automatic growth identifier type In MySQL, if the primary key of the table is set to the Auto_increment type, the database is automatically assigned the primary key. For example: CREATE TABLE Customers (ID int

First see what columns exist in v$process Sys@orcl>desc v$process Name Null? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (4) PID number SPID VARCHAR2 (12) USERNAME VARCHAR2 (15) serial#

For the heap table in Oracle, we can get the value of the rowid of the corresponding row record through Oracle's built-in ROWID pseudo columns (note that this rowid is just a pseudo column, which does not exist in the actual block). We can then use

Today's optimization has been transformed to the optimization Wait (waits), in fact, the most fundamental point of performance optimization is also focused on Io, which is the most important aspect of performance, it is a good idea to wait in the

In 10g, Oracle has added dbms_monitor packages, making it easier for users to set up trace and statistical information. This article describes the process of statistical correlation. In addition to providing trace opening and closing, the

Yesterday a friend asked me how to monitor the operation of a pl/sql, here is a brief introduction to several methods. Introduce more professional dbms_pipe implementation methods. If you think the Dbms_application_info package is not professional

Today, a friend of mine to see if a phenomenon is not a bug, if the direct query error, if nested one layer plus rownum will not be an error, if removed rownum will lead to false recurrence, regardless of the rownum specified query how many lines,

Action steps are as follows: Step 1 Log on to the server with an Oracle user and execute the following command into Sqlplus. Oracle@smgwrpt:~> sqlplus "/as sysdba" Step 2 View the current archive mode for the database. Sql> Archive Log List

Today, a test machine Oracle server, when the tester built the character set into the we8mswin1252 character sets, resulting in the inability to save Russian and other national languages. So I suggest that the test change the character set to

Briefly describes some of the problems with performing a DBMS_LOB package at the distal end. Because the LOB locator cannot be used across the database chain, it is necessary to call the procedure in the remote DBMS_LOB package when accessing the

The ALTER user statement has an optional replace statement that is used to enter the original password after the password validation function is started. By default, the user does not need to provide the current password to modify his or her

Branch of the database performance problems, help to help diagnose. The database is a Oracle10.2.0.3 RAC environment, but is now in a single node working state. The current problem is that page access is slow and no further information is available.

or the test environment in the previous article: sql> CREATE TABLE T1 2 (ID number, NAME VARCHAR2 (30)); Table created. Sql> INSERT into T1 2 SELECT rownum, Tname 3 from TAB; Created rows. sql> CREATE TABLE T2 2 (ID number, NAME VARCHAR2 (30

A new Clientid_overwrite event has been added to Oracle 11g so that v$session can automatically react to setting the result after executing the set_client_info information for the Dbms_application_info package. By default, after the Set_client_info

1.dba_logstdby_events This view can be viewed as a logical standby action log, so if an error occurs, you can see what the recent logic standby has done with the view. By default, this view retains only the records of the last 100 events (you can

The primary database and the standby database are all RAC 11.1.0.6 for Solaris10 SPARC, the shared storage primary database takes Volumn CLUSTER MANAGER, and the standby database uses ASM. Before deploying, first check to see if the current primary

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary. This article describes the Create Pfile method to check initialization parameters. There are a number of methods that are used to

0, the entire database to do a closed state of the full consistent backup; 1, ALTER DATABASE backup Controlfile to trace; 2, shutdown immediate; 3. Locate the trace file containing the script for rebuilding the control file and make the

Spool is a control command provided by Oracle Sqlplus. You can use the combination of spool and SELECT statements to dynamically generate some SQL scripts or some data. There are probably two types of statement classifications that can be executed