Oracle

We can use the Oracle Audit function to record user login information, but if opening the Audit function will degrade Oracle performance and even cause Oracle to crash. So how can we record user login information? We can actually do this by creating

Recently, after installing the Oracle 10g RAC on the client based on SuSE SP3, I received an error message when Clusterware execution/u01/app/crs/root.sh was installed, Failed to upgrade Oracle Cluster Registry configuration because the current

1, NVL (Arg,value): represents if the value of the preceding ARG is NULL then the returned value is the following, and if value is NULL, NULL is returned.2, substr (' Kong ', Startposition,[length]): startposition If it is negative, it indicates

Exchange Partition provides a way for you to migrate data between a table and a table or partition and partition, noting that the table is not converted to a constituent or non-partitioned form, but only to the number of migrated tablesIt is the

1. Rebuilding the host's Oracle User Group Unified Specification UID GID to ensure shared storage hooks or other requirements for permission specificationUserdel-501 Oracle#ID oracleuid= (Oracle) gid= (oinstall) group = (Oinstall), 501 (DBA)2.

Close the database as Sysdbashutdown Abort Clear Oracle SoftwareSu--RF * rm-rf/etc/ora* 4 (Tikanga) changed to version 5 vi/etc/pam.d/Login Line at the end of the deletion session required pam_limits.so vi/etc/security/for Oracle2047163841

Oracle's lock table and unlockOracle's Lock table and unlock SELECT/*+ Rule */s.username,Decode (L.type, ' TM ', ' TABLE LOCK ',' TX ', ' ROW LOCK ',NULL) Lock_level,O.owner,o.object_name,o.object_type,S.sid,s.serial#,s.terminal,s.machine,s.program,

Under Oracle 10g, the dependency is judged to be at the object level, which means that once the object accessed by the stored procedure has changed, Oracle will place the stored procedure in the invalid state. So after the DDL operation for the

Sometimes it takes a table join query in two databases to use the database link.The role of database link is to build databases and database connections.1. First look at how to create using the Pl\sql tool.Locate the database links right-click

Flashback TipsThe following tips and restrictions apply to using flashback features. Flashback tips–performance For better performance, generate statistics on all tables involved in a Flashback Query DBMS_STATS by using the package, and Ke EP

An exact numeric data type that uses integer data. bigint from  -2^63  ( -9223372036854775808)   to  2^63-1  (9223372036854775807) Integer data for   (all numbers). The storage size is  8  bytes. int from  -2^31  ( -2,147,483,648)   to  2^31 

The database field types commonly used by Oracle are as follows: Field type Chinese description Restriction conditions Other instructions CHAR Fixed-length strings Max Length bytes

Reprinted from: http://blog.sina.com.cn/s/blog_613fee860100yhyz.html1. The Ctxsys user needs to be unlocked in order to obtain the operation rights of the CTX_DDL package.Enter the system user, enter the following command to unlock the Ctxsys

ExportExp Username/[email protected] File=db.dmpImportImp username/[email protected] file=h:\db.dmp full=yNote: Before importing, please clear views, sequences, TablesYou can also export using the bat fileThe contents of the bat file are as follows:@

1, check the database lock, the source and type of diagnostic lock:Select Object_id,session_id,locked_mode from V$locked_object;or use the following command:Select B.owner,b.object_name,l.session_id,l.locked_modeFrom V$locked_object L, dba_objects

Step 1: Login with Administrator account or DBA authority, such as system accountSTEP2: Execute SELECT * from Dba_users where username like '%test% 'Where Account_status is the state.The state can be divided into two categories: 1. Basic state; 2.

Common ORACLE commands 1. How can I view all tables in the database? Select * from sys. user_tables; 2. How to connect to a database Sqlplus/nolog; conn sys/oracle as sysdba; 3. How to start a database Startup; 4. view the ORACLE instance

Oracle troubleshooting (ORA-00600), oracleora-00600 This error has been shown in the alarm log for the past two

Oracle listener details Typical Listener Configuration template: There are multiple ways to create a listener: (1) netca (2) netmgr (3) manually edit the listener. ora file; The following is a standard template for Listener Configuration: Key

Linux_x64 install Oracle11g (full version), linux_x64oracle11g 1. Modify core operating system parameters Perform the following steps under the Root user: 1) modify the user's SHELL restrictions and modify the/etc/security/limits. conf file Enter