Oracle

My colleague added a field to a table in the test database, prompting ORA-00054, resource busy. The table object lock is not released. Use the following SQL statement to check the locking status of related objects in the system: View plain/*

1. Use the expdp command to back up data on the 11g Server Expdp userid = 'sys/cuc2009 @ cuc as sysdba 'schemas = sybj directory = DATA_PUMP_DIR dumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0 The red text is rewritten as needed. For

Recently, when inserting data, I encountered the BUG of "ORA-01461: Can only assign values to the LOGN values of the inserted LOGN columns ". The data type in oracle is varchar2 (4000 byte). The inserted data cannot exceed 4000. Changes to varchar2 (

Question 1: Which process is responsible for hard parsing? In addition to low hit rate, what are the other causes of unreasonable shared pool settings?   When it comes to soft parsing (soft prase) and hard parsing (hard prase), it is not worth

1 Overview (In a session) when the transaction starts: When the database encounters the first DML (UPDATE/INSERT/DELETE/MERGE) statement. (In a session) when the transaction ends: the transaction ends at the first COMMIT/ROLLBACK/DDL/GRANT/REVOKE.

The customer requested that the historical data in the database of the two projects on the current network be cleaned up recently, so he sorted out the section usage in the next application, mainly to view the table section. The script used is as

  There is an overhead space (overhead) at the beginning of the database block, which stores a transaction table for the block. For each "actual" transaction that locks some data in the block, there is a corresponding entry in this transaction table.

  Segments are the database objects that occupy the storage space. Each object that occupies the storage space is stored in a segment, such as tables, indexes, and rollback segments. Segment type 1) Table segment 2) table partition or

  Oracle 11.2.0.3 impdp error:   Gg2:/u01/backup> impdp dave/dave directory = backup dumpfile = pdba. dmp logfile = table. log tables = pdba table_exists_action = replace;   Import: Release 11.2.0.3.0-Production onWed Nov 16 12:35:19

Oracle up/down keys prompt history when Oracle in linux is used, its up/down keys by default do not prompt historical records. Therefore, we need to install an additional package, this package can achieve this function 1: Install readline (usually

Oracle query statement from last Monday to weekend [SQL] -- Oracle obtains the SQL statement from the last Monday to the weekend -- in this way, select to_char (to_date ('123 ', 'yyyymmdd'), 'D') from dual; -- result: 6 Note: 2013.09.06 is Friday,

Oracle to_number () function learning 1, Converts a string to the NUMBER data type (convert a string to a numeric data type) TO_NUMBER ( [, , ]) RETURN NUMBERselect to_number ('123') from dual; to_number ('123') 00001228 select trunc (to_number ('12

Linux hugepage configuration-optimizing oracle memory linux is not as powerful as aix and hp unix, but linux is also very good. To improve linux performance, it uses a lot of io, memory scheduling mechanism. linux uses the memory mode by vm, that is,

Oracle flashback drop knowledge sorting 1) No downtime or backup is required. 2) You do not need to configure it. you can disable it through permissions. 3) Only data in non-SYSTEM tablespace managed locally (non-dictionary management) will enter

Oracle 11g 11.2.0.1 setting HuagePage causes TRC to become larger and more recently found diag /.... the size of the sid_ora_xxxx.trc file in the/trac/directory is 11 mb and the number of similar files is large. as a result, 8 GB of hard disk space

A shallow summary of oracle log miner Sometimes, we shocould recover one or more rows data which is deleted carelessly by users, but it is not necessary to recover the whole db and the flashback does not recovery the data because it's timeout. for

Oracle database 10g falshback knowledge1. Knowledge reserve 1) when the media is damaged (such as the loss of data files), any flash back method is useless and can only perform standard backup, restoration, and recovery. 2. SCN record method [SQL]

ORA-00314, redolog corruption, or loss of processing method alertsid. log error message: Fri Sep 27 15:18:39 2013Started redo scanFri Sep 27 15:18:39 2013Errors in file /oracle/admin/lixora/udump/lixora_ora_23439.trc:ORA-00314: log 2 of thread 1,

Oracle functions and triggers today write about Oracle functions and triggers, define and use stored procedures, functions, and triggers in the database, this improves the efficiency of database access. The database functions include declaration,

Restart Oracle 11g RAC record the process of restarting Oracle ========================== Node 1 (oracle user) 1. lsnrctl stop // close listener 2. sqlplus/nolog // close database connect/as sysdba shutdown immedidate Node 2 (oracle user) 1. lsnrctl