Oracle

Creating a Stored Procedure Create or Replace procedure test (var_name_1 in type,var_name_2 out type) as --Declaring variables (variable name variable type) Begin --The execution body of the stored procedure End test; Print out the time

One what is the Smon process The systemmonitor performs recovery when a failed instance starts up again. In a oraclereal application clusters database, the Smon process of one instance Canperform instance for other Stances that have failed. Smon

The principle of backing up a control file is to back up the control file after the physical structure of the database has changed. 1. Trace: Used to control file rebuilding (generated trace file in Udump) sql> ALTER DATABASE backup Controlfile to

1, instance function: For managing and accessing the database. 2, init parameter files: Manages instance-related startup parameters. Location: $ORACLE _home/dbs 3, Pfile: Static parameter file. (1) A text file that can be modified by an editor.

1, first to understand Oracle on the operating system to open the Shutdown Database command Start Stop database script under command line, execute with Oracle user $ Dbstart Open Database $ Dbshut Close Database But to enable the above command,

Description (1). The db_name needs to be the same when Rman is backed up to a different machine recovery. If you want to change to another instance name, you can change it with the NID command after the restore succeeds. The information of the

A simple example of how an oracle who has not contacted Oracle for a project in the company is prepared to use the Proc implementation additions and deletions: CREATE TABLE T1 ( SID number NOT NULL primary key, Sname VARCHAR2 (10) ) Tablespace

Two days ago in the pub to see someone met this problem, today's lectures met, but the night to simulate the dead and alive are not reproduced. The problem is to first block the Flash recovery area function, and then restore the function, the

First, create a backup A physical standby database is equivalent to a mirrored copy of a primary database at a point in time, so you must have at least one full backup of the primary database before you create the physical standby database. Oracle

Role: Merge into solution with B table and new a table data, if a table does not, then the B table data into a table; Grammar: MERGE into [Your table-name] [rename your table-here] using ([Write your query here]) [rename your query-sql and using

Colleagues in the test library on a table add fields, prompt ORA-00054, resources busy. The lock on the Table object should not be released. Use the following SQL to view the locking of related objects in the system: /* formatted on 2012/2/13 14:2

--The syntax is as followsMerge into QCFANG.BBB b using (SELECT * from QCFANG.AAA) aOn (b.a_id=a.a_id)When matched thenUpdate setB.a_name=a.a_name, B.a_sex = a.a_sex, B.a_type = A.a_type,b.a_salary = A.a_salaryWhen not matched

--View the Locked object Select A.session_id,a.object_id,a.oracle_username,b.object_type,b.object_name from V$locked_object a,all_objects b where a.object_id = b.object_id; --Unlocking method 1 Find SID, serial# Select c.sid,c.serial# from

1. Index Information View: Select * from User_ind_columns; Select * from User_indexes; 2, monitor the index of the Open: ALTER INDEX index_name monitoring USAGE; 3. See if the index you created is valid: Execute the query SQL statement first,

For SQL optimization, from the actual work experience, summed up as follows: 1, where filter section, the equation left without any calculation and nesting functions, to find an equivalent replacement, on the right side of the equation to make

As an enhancement to the flashback operation (flashback), ORACLE10G provides a function to convert the SCN and timestamp to each other. The current SCN value of the system can be obtained first through Dbms_flashback.get_system_change_number: Sql>

To prevent remote SSH logons for Oracle users, the passwd file was modified with VIPW today and added at the end of the Oracle User::/sbin/nologin Test discovery does prevent users from SSH logons, but the following errors are reported after you

Starting with Oracle 9i, Oracle allows you to make a reputation for primary keys, unique keys, and foreign KEY constraints for view. The NOT NULL constraint can inherit from the base table, so it is not allowed to display the declaration. Because

1. Compare Sql*loader performance differences that are loaded using conventional traditional and direct methods. First, the concept 1. Direct Load Advantage (1) Direct loading is higher than traditional loading efficiency (2) Do not scan the

The way in which roles (database permission sets) interact with stored procedures, functions, and packets is one of the most difficult parts of the Oracle security model to handle. Object permissions in Oracle can be indirectly granted to users,