Oracle跟蹤事件:set events 整理

一、跟蹤檔案

Oracle跟蹤檔案

Oracle跟蹤檔案分為三種型別，

• 一種是後臺報警日誌檔案，記錄資料庫在啟動、關閉和執行期間後臺程式的活動情況,如表空間建立、回滾段建立、某些alter命令、日誌切換、錯誤訊息等。在資料庫出現故障時，應首先檢視該檔案，但檔案中的資訊與任何錯誤狀態沒有必然的聯絡。後臺報警日誌檔案儲存BACKGROUND_DUMP_DEST引數指定的目錄中，檔案格式為ALRT_.LOG。
• 另一種型別是DBWR、LGWR、SMON等後臺程式建立的後臺跟蹤檔案。後臺跟蹤檔案根據後臺程式執行情況產生，後臺跟蹤檔案也儲存在BACKGROUND_DUMP_DEST引數指定的目錄中，檔案格式為_dbwr_xxx.trc等（不同的oracle,os版本可能不同）。
• 還有一種型別是由連線到Oracle的使用者程式(Server Processes)生成的使用者跟蹤檔案。這些檔案僅在使用者會話期間遇到錯誤時產生。此外，使用者可以透過執行oracle跟蹤事件（見後面）來生成該類檔案，使用者跟蹤檔案儲存在USER_DUMP_DEST引數指定的目錄中，檔案格式為_ora_.trc（不同的oracle,os版本可能不同）。

二、Oracle跟蹤事件

       Oracle提供了一類命令，可以將Oracle各類內部結構中所包含的資訊轉儲(dump)到跟蹤檔案中，以便使用者能根據檔案內容來解決各種故障。

設定跟蹤事件有兩種方法:

       一種是在init.ora檔案中設定事件，這樣open資料庫後，將影響到所有的會話。設定格式如下：

EVENT="eventnumber trace name eventname [forever,] [level levelnumber] : ......."

       透過:符號，可以連續設定多個事件，也可以透過連續使用event來設定多個事件。

       另一種方法是在會話過程中使用alter session set events命令，只對當前會話有影響。設定格式如下：

alter session set events '[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : .......'

       透過:符號，可以連續設定多個事件，也可以透過連續使用alter session set events 來設定多個事件。

         例如： alter system set events '10046 trace name context forever, level 12';

格式說明：

eventnumber指觸發dump的事件號，事件號可以是Oracle錯誤號（出現相應錯誤時跟蹤指定的事件）或oralce內部事件號，內部事件號在10000到10999之間，不能與immediate關鍵字同用。

immediate關鍵字表示命令發出後，立即將指定的結構dump到跟蹤檔案中，這個關鍵字只用在alter session語句中，並且不能與 eventnumber、forever關鍵字同用。

trace name 是關鍵字。

eventname指事件名稱（見後面），即要進行dump的實際結構名。若eventname為context，則指根據內部事件號進行跟蹤。

forever關鍵字表示事件在例項或會話的週期內保持有效狀態，不能與immediate同用。

level為事件級別關鍵字。但在dump錯誤棧(errorstack)時不存在級別。

levelnumber表示事件級別號，一般從1到10，1表示只dump結構頭部資訊，10表示dump結構的所有資訊。

eventname

1、buffers事件：dump SGA緩衝區中的db buffer結構

alter session set events 'immediate trace name buffers level 1'; --表示dump緩衝區的頭部。

2、blockdump事件：dump資料檔案、索引檔案、回滾段檔案結構

alter session set events 'immediate trace name blockdump level 66666'; --表示dump塊地址為6666的資料塊。

在Oracle 8以後該命令已改為：

alter system dump datafile 11 block 9; --表示dump資料檔案號為11中的第9個資料塊。

3、controlf事件：dump控制檔案結構

alter session set events 'immediate trace name controlf level 10'; --表示dump控制檔案的所有內容。

4、locks事件：dump LCK程式的鎖資訊

alter session set events 'immediate trace name locks level 5';

5、redohdr事件：dump redo日誌的頭部資訊

alter session set events 'immediate trace name redohdr level 1'; --表示dump redo日誌頭部的控制檔案項。

alter session set events 'immediate trace name redohdr level 2'; --表示dump redo日誌的通用檔案頭。

alter session set events 'immediate trace name redohdr level 10'; --表示dump redo日誌的完整檔案頭。

注意：redo日誌的內容dump可以採用下面的語句:

alter system dump logfile 'logfilename';

6、loghist事件：dump控制檔案中的日誌歷史項

alter session set events 'immediate trace name loghist level 1'; --表示只dump最早和最遲的日誌歷史項。

levelnumber大於等於2時，表示2的levelnumber次方個日誌歷史項。

alter session set events 'immediate trace name loghist level 4'; --表示dump 16個日誌歷史項。

7、file_hdrs事件：dump 所有資料檔案的頭部資訊

alter session set events 'immediate trace name file_hdrs level 1'; --表示dump 所有資料檔案頭部的控制檔案項。

alter session set events 'immediate trace name file_hdrs level 2'; --表示dump 所有資料檔案的通用檔案頭。

alter session set events 'immediate trace name file_hdrs level 10'; --表示dump 所有資料檔案的完整檔案頭。

8、errorstack事件：dump 錯誤棧資訊，通常Oracle發生錯誤時前臺程式將得到一條錯誤資訊，但某些情況下得不到錯誤資訊，可以採用這種方式得到Oracle錯誤。

alter session set events '604 trace name errorstack forever'; --表示當出現604錯誤時，dump 錯誤棧和程式棧。

9、systemstate事件：dump所有系統狀態和程式狀態

alter session set events 'immediate trace name systemstate level 10'; --表示dump 所有系統狀態和程式狀態。

10、coalesec事件：dump指定表空間中的自由區間

levelnumber以十六進位制表示時，兩個高位位元組表示自由區間數目，兩個低位位元組表示表空間號，如0x00050000表示dump系統表空間中的5個自由區間，轉換成十進位制就是327680，即：

alter session set events 'immediate trace name coalesec level 327680';

11、processsate事件：dump程式狀態

alter session set events 'immediate trace name processsate level 10';

12、library_cache事件：dump library cache資訊

alter session set events 'immediate trace name library_cache level 10';

13、heapdump事件：dump PGA、SGA、UGA中的資訊

alter session set events 'immediate trace name heapdump level 1';

14、row_cache事件：dump資料字典緩衝區中的資訊

alter session set events 'immediate trace name row_cache level 1';

三、內部事件號

1、10013：用於監視事務恢復

2、10015：轉儲UNDO SEGMENT頭部

event = "10015 trace name context forever"

3、10029：用於給出會話期間的登陸資訊

4、10030：用於給出會話期間的登出資訊

5、10032：轉儲排序的統計資訊

6、10033：轉儲排序增長的統計資訊

7、10045：跟蹤Freelist管理操作

8、10046：跟蹤SQL語句

alter session set events '10046 trace name context forever, level 4'; --跟蹤SQL語句並顯示繫結變數

alter session set events '10046 trace name context forever, level 8'; --跟蹤SQL語句並顯示等待事件

9、10053：轉儲最佳化策略

10、10059：模擬redo日誌中的建立和清除錯誤

11、10061：阻止SMON程式在啟動時清除臨時段

12、10079：轉儲 SQL*NET統計資訊

13、10081：轉儲高水標記變化

14、10104：轉儲Hash連線統計資訊

15、10128：轉儲分割槽休整資訊

16、10200：轉儲一致性讀資訊

17、10201：轉儲一致性讀中Undo應用

18、10209：允許在控制檔案中模擬錯誤

19、10210：觸發資料塊檢查事件

event = "10210 trace name context forever, level 10"

20、10211：觸發索引檢查事件

21、10213：模擬在寫控制檔案後崩潰

22、10214：模擬在控制檔案中的寫錯誤

levelnumber從1-9表示產生錯誤的塊號，大於等於10則每個控制檔案將出錯

23、10215：模擬在控制檔案中的讀錯誤

24、10220：轉儲Undo頭部變化

25、10221；轉儲Undo變化

26、10224：轉儲索引的分隔與刪除

27、10225：轉儲基於字典管理的區間的變化

28、10229：模擬在資料檔案上的I/O錯誤

29、10231：設定在全表掃描時忽略損壞的資料塊

alter session set events '10231 trace name context off'; -- 關閉會話期間的資料塊檢查

event = "10231 trace name context forever, level 10" -- 對任何程式讀入SGA的資料塊進行檢查

30、10232：將設定為軟損壞（DBMS_REPAIR包設定或DB_BLOCK_CHECKING為TRUE時設定）的資料塊dump到跟蹤檔案

31、10235：用於記憶體堆檢查

alter session set events '10235 trace name context forever, level 1';

32、10241：轉儲遠端SQL執行

33、10246：跟蹤PMON程式

34、10248：跟蹤dispatch程式

35、10249：跟蹤MTS程式

36、10252：模擬寫資料檔案頭部錯誤

37、10253：模擬寫redo日誌檔案錯誤

38、10262：允許連線時存在記憶體洩漏

alter session set events '10262 trace name context forever, level 300'; -- 允許存在300個位元組的記憶體洩漏

39、10270：轉儲共享遊標

40、10285：模擬控制檔案頭部損壞

41、10286：模擬控制檔案開啟錯誤

42、10287：模擬歸檔出錯

43、10357：除錯直接路徑機制

44、10500：跟蹤SMON程式

45、10608：跟蹤點陣圖索引的建立

46、10704：跟蹤enqueues

47、10706：跟蹤全域性enqueues

48、10708：跟蹤RAC的buffer cache

49、10710：跟蹤對點陣圖索引的訪問

50、10711：跟蹤點陣圖索引合併操作

51、10712：跟蹤點陣圖索引OR操作

52、10713：跟蹤點陣圖索引AND操作

53、10714：跟蹤點陣圖索引MINUS操作

54、10715：跟蹤點陣圖索引向ROWID的轉化

55、10716：跟蹤點陣圖索引的壓縮與解壓

56、10719：跟蹤點陣圖索引的修改

57、10731：跟蹤遊標宣告

58、10928：跟蹤PL/SQL執行

59、10938：轉儲PL/SQL執行統計資訊

最後要說明的是，由於版本不同以上語法可能有些變化，但大多數還是可用的。

附完整的跟蹤事件列表，event No.10000 to 10999

SET SERVEROUTPUT ON
DECLARE
err_msg VARCHAR2(120);
BEGIN
dbms_output.enable (1000000);
FOR err_num IN 10000..10999
LOOP
err_msg := SQLERRM (-err_num);
IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
dbms_output.put_line (err_msg);
END IF;
END LOOP;
END;
/

（以下來自11gr2）

ORA-10000: control file debug event, name 'control_file' ORA-10001: control file crash event1 ORA-10002: control file crash event2 ORA-10003: control file crash event3 ORA-10004: block recovery testing - internal error ORA-10005: trace latch operations for debugging ORA-10006: block recovery testing - external error ORA-10007: log switch debug crash after new log select, thread ORA-10008: log switch debug crash after new log header write, thread ORA-10009: log switch debug crash after old log header write, thread ORA-10010: Begin Transaction ORA-10011: End   Transaction ORA-10012: Abort Transaction ORA-10013: Instance Recovery ORA-10014: Roll Back to Save Point ORA-10015: Undo Segment Recovery ORA-10016: Undo Segment extend ORA-10017: Undo Segment Wrap ORA-10018: Data Segment Create ORA-10019: Turn off data/space search cache ORA-10020: partial link restored to linked list (KSG) ORA-10021: KST event to trace control file header writes and reads ORA-10022: trace ktsgsp ORA-10023: Create Save Undo Segment ORA-10024: Write to Save Undo ORA-10026: Apply Save Undo ORA-10027: Specify Deadlock Trace Information to be Dumped ORA-10028: Dump trace information during lock / resource latch cleanup ORA-10029: session logon (KSU) ORA-10030: session logoff (KSU) ORA-10031: sort debug event (S*) ORA-10032: sort statistics (SOR*) ORA-10033: sort run information (SRD*/SRS*) ORA-10035: Write parse failures to alert log file ORA-10036: create remote row source (QKANET) ORA-10037: allocate remote row source (QKARWS) ORA-10038: dump row source tree (QBADRV) ORA-10039: type checking (OPITCA) ORA-10040: disable result-cache ORA-10041: dump undo records skipped ORA-10043: check consistency of owner/waiter/converter lists in KSQ ORA-10044: free list undo operations ORA-10045: free list update operations - ktsrsp, ktsunl ORA-10046: enable SQL statement timing ORA-10047: trace switching of sessions ORA-10048: Undo segment shrink ORA-10049: protect library cache memory heaps ORA-10050: sniper trace ORA-10051: trace OPI calls ORA-10052: don't clean up obj$ ORA-10053: CBO Enable optimizer trace ORA-10054: CBO Enable optimizer trace for recursive statement (RPI) ORA-10056: dump analyze stats (kdg) ORA-10057: suppress file names in error messages ORA-10058: use table scan cost in tab$.spare1 ORA-10059: simulate error in logfile create/clear ORA-10060: CBO Enable predicate dump ORA-10061: disable SMON from cleaning temp segment ORA-10062: disable usage of OS Roles in osds ORA-10063: disable usage of DBA and OPER privileges in osds ORA-10064: thread enable debug crash level , thread ORA-10065: limit library cache dump information for state object dump ORA-10066: simulate failure to verify file ORA-10067: force redo log checksum errors - block number ORA-10068: force redo log checksum errors - file number ORA-10070: force datafile checksum errors - block number ORA-10071: force datafile checksum errors - file number ORA-10073: latch cleanup tracing ORA-10074: default trace function mask for kst ORA-10075: CBO Disable outer-join to regular join conversion ORA-10076: CBO Enable cartesian product join costing ORA-10077: CBO Disable view-merging optimization for outer-joins ORA-10078: CBO Disable constant predicate elimination optimization ORA-10079: trace data sent/received via SQL*Net ORA-10080: dump a block on a segment list which cannot be exchanged ORA-10081: segment High Water Mark has been advanced ORA-10082: free list head block is the same as the last block ORA-10084: free list becomes empty ORA-10085: free lists have been merged ORA-10086: CBO Enable error if kko and qka disagree on oby sort ORA-10087: disable repair of media corrupt data blocks ORA-10088: CBO Disable new NOT IN optimization ORA-10089: CBO Disable index sorting ORA-10090: invoke other events before crash recovery ORA-10091: CBO Disable constant predicate merging ORA-10092: CBO Disable hash join ORA-10093: CBO Enable force hash joins ORA-10094: before resizing a data file ORA-10095: dump debugger commands to trace file ORA-10096: after the cross instance call when resizing a data file ORA-10097: after generating redo when resizing a data file ORA-10098: after the OS has increased the size of a data file ORA-10099: after updating the file header with the new file size ORA-10100: after the OS has decreased the size of a data file ORA-10101: DBWR refresh fails on cross instance resize call ORA-10102: switch off anti-joins ORA-10103: CBO Disable hash join swapping ORA-10104: dump hash join statistics to trace file ORA-10105: CBO Enable constant pred trans and MPs w WHERE-clause ORA-10106: CBO Disable evaluating correlation pred last for NOT IN ORA-10107: CBO Always use bitmap index ORA-10108: CBO Don't use bitmap index ORA-10109: CBO Disable move of negated predicates ORA-10110: CBO Try index rowid range scans ORA-10111: Bitmap index creation switch ORA-10112: Bitmap index creation switch ORA-10113: Bitmap index creation switch ORA-10114: Bitmap index creation switch ORA-10115: CBO Bitmap optimization use maximal expression ORA-10116: CBO Bitmap optimization switch ORA-10117: CBO Disable new parallel cost model ORA-10118: CBO Enable hash join costing ORA-10119: QKA Disable GBY sort elimination ORA-10120: generate relative file # different from absolute ORA-10121: CBO Don't sort bitmap chains ORA-10122: Disable transformation of count(col) to count(*) ORA-10124: Force creation of segmented arrays by kscsAllocate ORA-10125: Disable remote sort elimination ORA-10126: Debug oracle java xa ORA-10127: Disable remote query block operation ORA-10128: Dump Partition Pruning Information ORA-10129: Alter histogram lookup for remote queries ORA-10130: sort disable readaheads ORA-10131: CONNECT BY debug event ORA-10132: dump plan after compilation ORA-10133: testing for SQL Memory Management ORA-10134: tracing for SQL Memory Management for session ORA-10135: CBO do not count 0 rows partitions ORA-10136: CBO turn off fix for bug 1089848 ORA-10137: CBO turn off fix for bug 1344111 ORA-10138: CBO turn off fix for bug 1577003 ORA-10139: CBO turn off fix for bug 1386119 ORA-10140: CBO turn off fix for bug 1332980 ORA-10141: CBO disable additional keys for inlist in bitmap optimization ORA-10142: CBO turn off advanced OR-expansion checks ORA-10143: CBO turn off hints ORA-10144: CBO turn off cost based selection of bji over bsj subquery ORA-10145: test auditing network errors ORA-10146: enable Oracle TRACE collection ORA-10147: enable join push through UNION view ORA-10149: allow the creation of constraints with illegal date constants ORA-10150: import exceptions ORA-10152: CBO don't consider function costs in plans ORA-10153: Switch to use public synonym if private one does not translate ORA-10154: Switch to disallow synonyms in DDL statements ORA-10155: CBO disable generation of transitive OR-chains ORA-10156: CBO disable index fast full scan ORA-10157: CBO disable index access path for in-list ORA-10158: CBO preserve predicate order in post-filters ORA-10159: CBO disable order-by sort pushdown into domain indexes ORA-10160: CBO disable use of join index ORA-10161: CBO recursive semi-join on/off-switch ORA-10162: CBO join-back elimination on/off-switch ORA-10163: CBO join-back elimination on/off-switch ORA-10164: CBO disable subquery-adjusted cardinality fix ORA-10165: mark session to be aborted during shutdown normal ORA-10166: trace long operation statistics updates ORA-10167: CBO use old index MIN/MAX optimization ORA-10168: CBO disable single-table predicate predicate generation ORA-10169: CBO disable histograms for multi partitions ORA-10170: CBO use old bitmap costing ORA-10171: CBO disable transitive join predicates ORA-10172: CBO force hash join back ORA-10173: Dynamic Sampling time-out error ORA-10174: view join-back elimination switch ORA-10175: CBO star transformation switch ORA-10176: CBO colocated join switch ORA-10177: CBO colocated join switch ORA-10178: CBO turn off hash cluster filtering through memcmp ORA-10179: CBO turn off transitive predicate replacement ORA-10180: temp table transformation print error messages ORA-10181: CBO disable multi-column in-list processing ORA-10182: CBO disable generation of implied predicates ORA-10183: CBO disable cost rounding ORA-10184: CBO disable OR-exp if long inlist on bitmap column ORA-10185: CBO force index joins ORA-10186: CBO disable index join ORA-10187: CBO additional index join switch ORA-10188: CBO additional index join switch ORA-10189: CBO turn off FFS null fix ORA-10190: Analyze use old frequency histogram collection and density ORA-10191: Avoid conversion of in-lists back to OR-expanded form ORA-10192: nopushdown when number of groups exceed number of rows ORA-10193: Force repeatable sampling with specified seed ORA-10194: CBO disable new LIKE selectivity heuristic ORA-10195: CBO don't use check constraints for transitive predicates ORA-10196: CBO disable index skip scan ORA-10197: CBO force index skip scan ORA-10199: set parameter in session ORA-10200: consistent read buffer status ORA-10201: consistent read undo application ORA-10202: consistent read block header ORA-10203: block cleanout ORA-10204: signal recursive extend ORA-10205: row cache debugging ORA-10206: transaction table consistent read ORA-10207: consistent read transactions' status report ORA-10208: consistent read loop check ORA-10209: enable simulated error on control file ORA-10210: check data block integrity ORA-10212: check cluster integrity ORA-10213: crash after control file write ORA-10214: simulate write errors on control file ORA-10215: simulate read errors on control file ORA-10216: dump control file header ORA-10217: debug sequence numbers ORA-10218: dump uba of applied undo ORA-10219: monitor multi-pass row locking ORA-10220: show updates to the transaction table ORA-10221: show changes done with undo ORA-10222: row cache ORA-10223: transaction layer - turn on verification codes ORA-10224: index block split/delete trace ORA-10225: free/used extent row cache ORA-10226: trace CR applications of undo for data operations ORA-10227: verify (multi-piece) row structure ORA-10228: trace application of redo by kcocbk ORA-10229: simulate I/O error against datafiles ORA-10230: KSFD block repair test event ORA-10231: skip corrupted blocks on _table_scans_ ORA-10232: dump corrupted blocks symbolically when kcbgotten ORA-10233: skip corrupted blocks on index operations ORA-10234: trigger event after calling kcrapc to do redo N times ORA-10235: check memory manager internal structures ORA-10236: dump redo on object no. or block type mismatch errors 1410/8103 ORA-10237: simulate ^C (for testing purposes) ORA-10238: instantiation manager ORA-10239: multi-instance library cache manager ORA-10240: dump dba's of blocks that we wait for ORA-10241: remote SQL execution tracing/validation ORA-10242: suppress OER 2063 (for testing distrib w/o different error log) ORA-10243: simulated error for test  of K2GTAB latch cleanup ORA-10244: make tranids in error msgs print as 0.0.0 (for testing) ORA-10245: Testing event used by server I/O ksfd/ksfq module ORA-10246: print trace of PMON actions to trace file ORA-10247: Turn on scgcmn tracing. (VMS ONLY) ORA-10248: turn on tracing for dispatchers ORA-10249: turn on tracing for multi-stated servers ORA-10250: Trace all allocate and free calls to the topmost SGA heap ORA-10251: check consistency of transaction table and undo block ORA-10252: shared IO pool error simulation ORA-10254: trace cross-instance calls ORA-10255: pl/sql parse checking ORA-10257: trace shared server load balancing ORA-10258: force shared servers to be chosen round-robin ORA-10259: get error message text from remote using explicit call ORA-10261: Limit the size of the PGA heap ORA-10262: Don't check for memory leaks ORA-10263: Don't free empty PGA heap extents ORA-10265: Keep random system generated output out of error messages ORA-10266: Trace OSD stack usage ORA-10267: Inhibit KSEDMP for testing ORA-10268: Don't do forward coalesce when deleting extents ORA-10269: Don't do coalesces of free space in SMON ORA-10270: Debug shared cursors ORA-10271: distributed transaction after COLLECT ORA-10272: distributed transaction before PREPARE ORA-10273: distributed transaction after PREPARE ORA-10274: distributed transaction before COMMIT ORA-10275: distributed transaction after COMMIT ORA-10276: distributed transaction before FORGET ORA-10277: Cursor sharing (or not) related event (used for testing) ORA-10278: Internal testing ORA-10279: Simulate block corruption in kdb4chk ORA-10280: Internal testing - segmentation fault during crash recovery ORA-10281: maximum time to wait for process creation ORA-10282: Inhibit signalling of other backgrounds when one dies ORA-10284: simulate zero/infinite asynch I/O buffering ORA-10285: Simulate control file header corruption ORA-10286: Simulate control file open error ORA-10287: Simulate archiver error ORA-10288: Do not check block type in ktrget ORA-10289: Do block dumps to trace file in hex rather than fromatted ORA-10290: Internal sequence tracing event ORA-10291: die in tbsdrv to test control file undo ORA-10292: hang analysis trace event ORA-10293: trace log switch media recovery checkpoints ORA-10294: ksrpc tracing ORA-10295: die after file header update durning cf xact ORA-10296: disable ORA-379 ORA-10297: shared I/O pool tracing ORA-10298: ksfd i/o tracing ORA-10299: Trace prefetch tracking decisions made by CKPT ORA-10300: Distributed transaction tracing ORA-10301: Enable LCK timeout table consistency check ORA-10302: trace create or drop internal trigger ORA-10303: trace loading of library cache for internal triggers ORA-10304: trace replication trigger ORA-10305: trace updatable materialized view trigger ORA-10306: trace materialized view log trigger ORA-10307: trace RepCat execution ORA-10308: replication testing event ORA-10309: Trigger Debug event ORA-10310: trace synchronous change table trigger ORA-10311: Disable Flashback Table Timestamp checking ORA-10312: Allow disable to log rows into the mapping table ORA-10314: Enable extra stats gathering for CR ORA-10316: Events for extensible txn header, non zero ext header size ORA-10317: Events for extensible txn header, zero ext header size ORA-10318: Trace extensible txn header movements ORA-10319: Trace PGA statistics maintenance ORA-10320: Enable data layer (kdtgrs) tracing of space management calls ORA-10321: Datafile header verification debug failure. ORA-10322: CBO don't simplify inlist predicates ORA-10323: before committing an add datafile command ORA-10324: Enable better checking of redo logs errors ORA-10325: Trace control file record section expand and shrink operations ORA-10326: clear logfile debug crash at , log ORA-10327: simulate ORA-00235 error for testing ORA-10328: disable first-to-mount split-brain error, for testing ORA-10329: simulate out-of-memory error during first pass of recovery ORA-10330: clear MTTR statistics in checkpoint progress record ORA-10331: simulate resilvering during recovery ORA-10332: force ALTER SYSTEM QUIESCE RESTRICTED command to fail ORA-10333: dump MTTR statistics each time it is updated ORA-10334: force FG to wait to be killed during MTTR advisory simulation ORA-10335: trace database open status ORA-10336: Do remote object transfer using remote SQL ORA-10337: enable padding owner name in slave sql ORA-10338: CBO don't use inlist iterator with function-based indexes ORA-10339: CBO disable DECODE simplification ORA-10340: Buffer queues sanity check for corrupted buffers ORA-10341: Simulate out of PGA memory in DBWR during object reuse ORA-10342: Raise unknown exception in ACQ_ADD when checkpointing ORA-10343: Raise an out of memory exception-OER 4031 in ACQ_ADD ORA-10344: reserved for simulating object hash reorganization ORA-10345: validate queue when linking or unlinking a buffer ORA-10346: check that all buffers for checkpoint have been written ORA-10347: dump active checkpoint entries and checkpoint buffers ORA-10348: test abnormal termination of process initiating file checkpoint ORA-10349: do not allow ckpt to complete ORA-10350: Simulate more than one object & tsn id in object reuse ORA-10351: size of slots ORA-10352: report direct path statistics ORA-10353: number of slots ORA-10354: turn on direct read path for parallel query ORA-10355: turn on direct read path for scans ORA-10356: turn on hint usage for direct read ORA-10357: turn on debug information for direct path ORA-10358: Simulate out of PGA memory in cache advisory reset ORA-10359: turn off updates to control file for direct writes ORA-10360: enable dbwr consistency checking ORA-10361: check buffer change vector count consistency ORA-10362: simulate a write error to take a file offline ORA-10363: Simulate messaging error for fast object reuse/checkpoint ORA-10364: Do not clear GIMH_STC_SHUT_BEGIN state during shutdown ORA-10365: turn on debug information for adaptive direct reads ORA-10366: kgnfs tracing ORA-10367: kgodm tracing ORA-10368: maximum number of internal errors a process will tolerate ORA-10369: test SQL monitoring feature ORA-10370: parallel query server kill event ORA-10371: disable TQ hint ORA-10372: parallel query server kill event proc ORA-10373: parallel query server kill event ORA-10375: turn on checks for statistics rollups ORA-10376: enable archive compression loads ORA-10377: force slave allocation ORA-10378: force hard process/range affinity ORA-10380: kxfp latch cleanup testing event ORA-10381: kxfp latch cleanup testing event ORA-10382: parallel query server interrupt (reset) ORA-10383: auto parallelization testing event ORA-10384: parallel dataflow scheduler tracing ORA-10385: parallel table scan range sampling method ORA-10386: parallel SQL hash and range statistics ORA-10387: parallel query server interrupt (normal) ORA-10388: parallel query server interrupt (failure) ORA-10389: parallel query server interrupt (cleanup) ORA-10390: Trace parallel query slave execution ORA-10391: trace PX granule allocation/assignment ORA-10392: parallel query debugging bits ORA-10393: print parallel query statistics ORA-10394: generate a fake load to test adaptive and load balancing ORA-10395: adjust sample size for range table queues ORA-10397: suppress verbose parallel coordinator error reporting ORA-10398: enable timeouts in parallel query threads ORA-10399: trace buffer allocation ORA-10400: turn on system state dumps for shutdown debugging ORA-10401: turn on IPC (ksxp) debugging ORA-10402: turn on IPC (skgxp) debugging ORA-10403: fake CPU number for default degree of parallelism ORA-10404: crash dbwr after write ORA-10405: emulate broken mirrors ORA-10406: enable datetime TIMESTAMP, INTERVAL datatype creation ORA-10407: enable datetime TIME datatype creation ORA-10408: disable OLAP builtin window function usage ORA-10409: enable granule memset and block invalidation at startup ORA-10410: trigger simulated communications errors in KSXP ORA-10412: dump the call stack if an error is signaled ORA-10413: force simulated error for testing purposes ORA-10414: simulated error from event  level ORA-10415: parallel degree specified is too large, max value allowed ORA-10416: disable fix for 2736734 ORA-10417: limit 1 file per sbtinfo2() validation call ORA-10418: disable re-creating tempfile ORA-10419: create tempfile without create_scn and time ORA-10420: trace KSO OS-process operations ORA-10421: enable dump from ksbwco if there is no reply ORA-10422: KSU debugging ORA-10423: dump the call stack if the specified error is cleared ORA-10424: KGE debugging ORA-10425: enable global enqueue operations event trace ORA-10426: enable ges/gcs reconfiguration event trace ORA-10427: enable global enqueue service traffic controller event trace ORA-10428: enable tracing of global enqueue service cached resource ORA-10429: enable tracing of global enqueue service IPC calls ORA-10430: enable ges/gcs dynamic remastering event trace ORA-10431: enable verification messages on pi consistency ORA-10432: enable tracing of global cache service fusion calls ORA-10433: global enqueue service testing event ORA-10434: enable tracing of global enqueue service multiple LMS ORA-10435: enable tracing of global enqueue service deadlock detetction ORA-10436: enable global cache service duplicate ping checking ORA-10437: enable trace of global enqueue service S optimized resources ORA-10438: force lowest node to be master of all gcs resources ORA-10439: enable tracing of global cache service fusion calls - part 2 ORA-10440: enable global enqueue service inquire resource modes trace ORA-10441: enable diagnosibility daemon (DIAG) trace ORA-10442: enable trace of kst for ORA-01555 diagnostics ORA-10444: enable DLM timeout testing ORA-10449: enable trace of kst for undo manageability features diagnostics ORA-10450: signal ctrl-c in kdddca (drop column) after n rows ORA-10451: Force heap segment compression bypassing compatibility checks ORA-10452: Cannot do block media recovery; media recovery session may be in progress ORA-10453: Dump compression statistics to trace file ORA-10454: Disable column reordering during compression ORA-10455: Do Compression Block Checking ORA-10456: cannot open standby database; media recovery session may be in progress ORA-10457: cannot close standby database due to active media recovery ORA-10458: standby database requires recovery ORA-10459: cannot start media recovery on standby database; conflicting state detected ORA-10460: Perform. backward tablescans for consistent read reduction ORA-10461: Simulate control file corruption during write operation ORA-10462: enable recovery debug module ORA-10463: enable controlfile test ORA-10464: enable incremental checkpoint debug for split brain check ORA-10465: force slave death during parallel crash recovery ORA-10466: enable HARD check for block write ORA-10467: amplify control file record expansion for testing ORA-10468: log writer debug module ORA-10469: error creating control file backup, no checkpoint ORA-10470: disable compatibility check for lost write detection ORA-10471: PQ slave allocation timeout test ORA-10472: dump reading log buffer hit ratio histogram to lgwr trace file ORA-10473: enable BRR tracing ORA-10474: controlfile time tracing ORA-10475: readable standby debug event ORA-10476: control file corruption range testing ORA-10477: simulated rollback error ORA-10478: DBW0 file identification trace event ORA-10479: disk sector size test event ORA-10480: Soft asserts for fast detection of datafile storage problems ORA-10481: Backup data block for data file has an unlogged change ORA-10482: Automatic block repair cannot repair an offline or read-only data file ORA-10483: Simulate overly advanced incremental checkpoint ORA-10484: Enable test move operation ORA-10485: Real-Time Query cannot be enabled while applying migration redo. ORA-10486: Verify data file-related SGA alignment ORA-10489: Generate future redo for testing ORA-10490: Trace OSM misc. events ORA-10491: Trace OSM messaging (KFN) events ORA-10492: Trace OSM metadata events ORA-10493: Return empty define buffers on 1422 ORA-10494: Trace OSM metadata events ORA-10495: Trace OSM metadata events ORA-10496: Turn off fix for bug 2554178 ORA-10497: Trace OSM metadata events ORA-10498: Trim blank characters including contol characters ORA-10499: Trace OSM metadata events ORA-10500: turn on traces for SMON ORA-10501: periodically check selected heap ORA-10502: CBO disable the fix for bug 2098120 ORA-10503: enable user-specified graduated bind lengths ORA-10504: CBO disable the fix for bug 2607029 ORA-10505: CBO enable dynamic sampling dump to table ORA-10506: Disable fix for bug 2588217 ORA-10507: Trace bind equivalence logic ORA-10509: Check kghu subheaps at call boundaries ORA-10510: turn off SMON check to offline pending offline rollback segment ORA-10511: turn off SMON check to cleanup undo dictionary ORA-10512: turn off SMON check to shrink rollback segments ORA-10515: turn on event to use physical cleanout ORA-10519: enable ALTER TYPE RESET support ORA-10520: recreate view only if definition has changed ORA-10521: CMON connection pool test event ORA-10522: turn off wrap source compression ORA-10523: force recreate package even if definition is unchanged ORA-10524: CMON connection pool trace event ORA-10525: Disable automatic object validation for describe ORA-10543: Standby Block Media Recovery (bmr) and split brain testing event ORA-10544: Inject standby autobmr failures ORA-10545: Print standby autobmr messages in alert log ORA-10546: Cannot perform. block media recovery; standby database does not have requisite redo. ORA-10547: Cannot perform. block media recovery; standby database is not caught up with primary. ORA-10548: Cannot perform. block media recovery on a read-only plugged-in datafile. ORA-10549: Cannot perform. block media recovery using a read-only plugged-in backup datafile. ORA-10550: signal error during create as select/create index after n rows ORA-10551: Internal testing for ORA-1551 error handling ORA-10553: Incompatible UNTIL CONSISTENT clause ORA-10554: Media recovery failed to bring datafile  to a consistent point ORA-10560: block type '' ORA-10561: block type '', data object# ORA-10562: Error occurred while applying redo to data block (file# , block# ) ORA-10563: Test recovery had to corrupt data block (file# , block# ) in order to proceed ORA-10564: tablespace ORA-10565: Another test recovery session is active ORA-10566: Test recovery has used all the memory it can use ORA-10567: Redo is inconsistent with data block (file# , block# , file offset is  bytes) ORA-10568: Failed to allocate recovery state object: out of SGA memory ORA-10570: Test recovery complete ORA-10571: Test recovery canceled ORA-10572: Test recovery canceled due to errors ORA-10573: Test recovery tested redo from change  to ORA-10574: Test recovery did not corrupt any data block ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred ORA-10577: Can not invoke test recovery for managed standby database recovery ORA-10578: Can not allow corruption for managed standby database recovery ORA-10579: Can not modify control file during test recovery ORA-10580: Can not modify datafile header during test recovery ORA-10581: Can not modify redo log header during test recovery ORA-10582: The control file is not a backup control file ORA-10583: Can not recovery file  renamed as missing during test recovery ORA-10584: Can not invoke parallel recovery for test recovery ORA-10585: Test recovery can not apply redo that may modify control file ORA-10586: Test recovery had to corrupt 1 data block in order to proceed ORA-10587: Invalid count for ALLOW n CORRUPTION option ORA-10589: Test recovery had to corrupt  data blocks in order to proceed ORA-10590: kga (argus debugger) test flags ORA-10591: kga (argus debugger) test flags ORA-10592: kga (argus debugger) test flags ORA-10593: kga (argus debugger) test flags ORA-10594: kga (argus debugger) test flags ORA-10595: kga (argus debugger) test flags ORA-10596: kga (argus debugger) test flags ORA-10597: kga (argus debugger) test flags ORA-10598: kga (argus debugger) test flags ORA-10599: kga (argus debugger) test flags ORA-10600: check cursor frame. allocation ORA-10601: turn on debugging for cursor_sharing (literal replacement) ORA-10603: cause an error to occur during truncate (for testing purposes) ORA-10604: trace parallel create index ORA-10605: enable parallel create index by default ORA-10606: trace parallel create index ORA-10607: trace index rowid partition scan ORA-10608: trace create bitmap index ORA-10609: trace for array index insertion ORA-10610: trace create index pseudo optimizer ORA-10611: causes migration to fail - testing only ORA-10612: prints debug information for auto-space managed segments ORA-10613: prints debug information for auto-space managed segments ORA-10614: Operation not allowed on this segment ORA-10615: Invalid tablespace type for temporary tablespace ORA-10616: Operation not allowed on this tablespace ORA-10617: Cannot create rollback segment in dictionary managed tablespace ORA-10618: Operation not allowed on this segment ORA-10619: Avoid assertions when possible ORA-10620: Operation not allowed on this segment ORA-10621: specify retry count for online index build cleanup DML lock get ORA-10622: test/trace online index (re)build ORA-10624: Disable UJV invalidation on drop index ORA-10625: Turn off redo log dump for the index when OERI 12700 ORA-10626: specify timeout for online index rebuild to wait for DML ORA-10627: Dump the content of the index leaf block ORA-10628: Turn on sanity check for kdiss index skip scan state ORA-10629: force online index build to backoff and retry DML lock upgrade ORA-10630: Illegal syntax specified with SHRINK clause ORA-10631: SHRINK clause should not be specified for this object ORA-10632: Invalid rowid ORA-10633: No space found in the segment ORA-10634: Segment is already being shrunk ORA-10635: Invalid segment or tablespace type ORA-10636: ROW MOVEMENT is not enabled ORA-10637: The segment does not exist ORA-10638: Index status is invalid ORA-10639: Dump library cache during kksfbc-reparse-infinite-loop error ORA-10640: Operation not permitted during SYSTEM tablespace migration ORA-10641: Cannot find a rollback segment to bind to ORA-10642: Found rollback segments in dictionary managed tablespaces ORA-10643: Database should be mounted in restricted mode and Exclusive mode ORA-10644: SYSTEM tablespace cannot be default temporary tablespace ORA-10645: Recursive Extension in SYSTEM tablespace during migration ORA-10646: Too many recursive extensions during SYSTEM tablespace migration ORA-10647: Tablespace other than SYSTEM, ,  not found in read only mode ORA-10648: Tablespace SYSAUX is not offline ORA-10649: Turn off/trace lob index freelist coalesce ORA-10650: disable cache-callback optimisation ORA-10651: incorrect file number block number specified ORA-10652: Object has on-commit materialized views ORA-10653: Table is in a cluster ORA-10654: Table is of type temporary or external ORA-10655: Segment can be shrunk ORA-10656: Table is in unusable state due to incomplete operation ORA-10657: Lob column to be shrunk does not exist ORA-10658: Lob column to be shrunk is marked unused ORA-10659: Segment being shrunk is not a lob ORA-10660: Segment is a shared lob segment ORA-10661: Invalid option specified ORA-10662: Segment has long columns ORA-10663: Object has rowid based materialized views ORA-10664: Table has bitmap join indexes ORA-10665: Inject Evil Literals ORA-10666: Do not get database enqueue name ORA-10667: Cause sppst to check for valid process ids ORA-10668: Inject Evil Identifiers ORA-10690: Set shadow process core file dump type (Unix only) ORA-10691: Set background process core file type (Unix only) ORA-10700: Alter access violation exception handler ORA-10701: Dump direct loader index keys ORA-10704: Print out information about what enqueues are being obtained ORA-10706: Print out information about global enqueue manipulation ORA-10707: Simulate process death for instance registration ORA-10708: print out trace information from the RAC buffer cache ORA-10709: enable parallel instances in create index by default ORA-10710: trace bitmap index access ORA-10711: trace bitmap index merge ORA-10712: trace bitmap index or ORA-10713: trace bitmap index and ORA-10714: trace bitmap index minus ORA-10715: trace bitmap index conversion to rowids ORA-10716: trace bitmap index compress/decompress ORA-10717: trace bitmap index compaction trace for index creation ORA-10718: event to disable automatic compaction after index creation ORA-10719: trace bitmap index dml ORA-10720: trace db scheduling ORA-10721: Internal testing - temp table transformation ORA-10722: set parameters for CPU frequency calculation (debug) ORA-10723: Internal testing - release buffer for buffer cache shrink ORA-10724: trace cross-instance broadcast ORA-10725: bitmap index version control ORA-10726: frequent itemset counting ORA-10727: introduce failure events in IPC ORA-10730: trace row level security policy predicates ORA-10731: dump SQL for CURSOR expressions ORA-10732: honor pctfree during insert into AQ IOTs ORA-10733: test transient-IOT metadata during PMO cleanup ORA-10734: reroute external procedures ORA-10735: debug ksws operations ORA-10736: buffer cache pin history dump ORA-10737: test block checking ORA-10738: internal block testing ORA-10739: debug WLM (kywm) operations ORA-10740: disables fix for bug 598861 ORA-10750: test rollback segment blksize guessing for index array insert ORA-10751: override for remote row source maximum buffer size ORA-10752: override for the Exponential Moving Average factor ORA-10753: enforce deterministic behaviour for prefetching row source ORA-10780: LogMiner API trace event ORA-10781: LogMiner reader trace event ORA-10782: LogMiner preparer trace event ORA-10783: LogMiner builder trace event ORA-10784: LogMiner dictionary trace event ORA-10785: LogMiner trace event ORA-10786: call push/pop (KSU) ORA-10787: trace intra-instance broadcast ORA-10788: trace call stacks ORA-10789: LogMiner test event ORA-10790: LogMiner trace event ORA-10791: Logical Standby swithover/failover trace event ORA-10792: Logical Standby XDAT trace event ORA-10793: Logical Standby trace event ORA-10794: Logical Standby trace event ORA-10795: VKTM Process trace event ORA-10796: Elevate Scheduler Priority trace event ORA-10797: Logical Standby Test Event ORA-10800: disable Smart Disk scan ORA-10804: reserved for ksxb ORA-10806: Switch to 7.3 mode when detaching sessions ORA-10807: Disable user id check when switching to a global transaction ORA-10808: Enable assert when waiting without a reason ORA-10809: Trace state object allocate / free history ORA-10810: Trace snapshot too old ORA-10811: Trace block cleanouts ORA-10812: Trace Consistent Reads ORA-10826: enable upgrade/downgrade error message trace ORA-10827: enable upgrade/downgrade diagnostics ORA-10828: memory allocator error ORA-10830: Trace group by sort row source ORA-10831: Trace group by rollup row source ORA-10832: Trace approximate NDV row source ORA-10839: trace / debug caching module (qesca.c) ORA-10840: trace / debug pl/sql caching module (kkxmInitCache) ORA-10841: Default un-inintialized charact set form. to SQLCS_IMPLICIT ORA-10842: Event for OCI Tracing and Statistics Info ORA-10843: Event for client result cache tracing ORA-10844: turn on Native Net IPC debugging (skgxp) ORA-10845: Enable Director tracing ORA-10846: Enable Director Single Node Testing ORA-10847: OCI dump action is being invoked for internal error ORA- ORA-10848: OCI Non Blocking not supported with ORA-10849: Internal OCI event number ORA-10850: Enable time manager tracing ORA-10851: Allow Drop command to drop queue tables ORA-10852: Enable tracing for Enqueue Dequeue Operations ORA-10854: Sets poll count used for AQ listen code under RAC ORA-10856: Disable AQ propagator from using streaming ORA-10857: Force AQ propagator to use two-phase commit ORA-10858: Crash the AQ propagator at different stages of commit ORA-10859: Disable updates of message retry count ORA-10860: event for AQ admin disable new name parser ORA-10861: disable storing extended message properties ORA-10862: resolve default queue owner to current user in enqueue/dequeue ORA-10863: Control behavior. of buffered background operations ORA-10864: event to enable AQ dedicated propagation ORA-10865: Control tracing of notification operations ORA-10866: event to order dequeue by condition ORA-10867: event to turn off authentication for emon to oci client connections ORA-10870: Disable multi-instance standby role transition ORA-10871: dump file open/close timestamp during media recovery ORA-10872: Flashback Database fault insertion event #. ORA-10873: file  needs to be either taken out of backup mode or media recovered ORA-10874: Change max logfiles in hashtable in krfbVerifyRedoAvailable ORA-10875: Require instance bounce after switchover to primary ORA-10876: IDR Test event ORA-10877: error signaled in parallel recovery slave ORA-10878: parallel recovery slave died unexpectedly ORA-10879: error signaled in parallel recovery slave ORA-10880: trace Java VM execution ORA-10890: ADG test event ORA-10891: disable column pruning in ANSI join transformation ORA-10900: extent manager fault insertion event # ORA-10901: disable the fix for bug 1230798 ORA-10902: disable seghdr conversion for ro operation ORA-10903: Force tablespaces to become locally managed ORA-10904: Allow locally managed tablespaces to have user allocation ORA-10905: Do cache verification (kcbcxx) on extent allocation ORA-10906: Unable to extend segment after insert direct load ORA-10907: Trace extent management events ORA-10908: Trace temp tablespace events ORA-10909: Trace free list events ORA-10910: inject corner case events into the RAC buffer cache ORA-10911: Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support ORA-10912: Used to perform. admin operations on locally managed SYSTEM tablespace ORA-10913: Create locally managed database if compatible > 920 by default ORA-10914: invalid TABLESPACE GROUP clause ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace ORA-10916: TABLESPACE GROUP already specified ORA-10917: TABLESPACE GROUP cannot be specified ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name ORA-10919: Default temporary tablespace group must have at least one tablespace ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group ORA-10922: Temporary tablespace group is empty ORA-10923: prints debug information for object space server manageability ORA-10924: import storage parse error ignore event ORA-10925: trace name context forever ORA-10926: trace name context forever ORA-10927: trace name context forever ORA-10928: trace name context forever ORA-10929: trace name context forever ORA-10930: trace name context forever ORA-10931: trace name context forever ORA-10932: trace name context forever ORA-10933: trace name context forever ORA-10934: trace name context forever ORA-10936: trace name context forever ORA-10937: trace name context forever ORA-10938: trace name context forever ORA-10939: trace name context forever ORA-10940: trace name context forever ORA-10941: trace name context forever ORA-10943: trace name context forever ORA-10944: trace name context forever ORA-10945: trace name context forever ORA-10946: trace name context forever ORA-10947: trace name context forever ORA-10948: trace name context forever ORA-10949: Disable autotune direct path read for full table scan ORA-10960: AQ tracing event ORA-10970: backout event for bug 2133357 ORA-10971: prints debugging information for LOBs ORA-10972: raise a 1551 exception in kdu_array_flush ORA-10973: backout evet for 2619509 ORA-10974: Turn on LOB integrity verification ORA-10975: trace execution of parallel propagation ORA-10976: internal package related tracing ORA-10977: trace event for RepAPI ORA-10978: general event for materialized view logs ORA-10979: trace flags for join index implementation ORA-10980: prevent sharing of parsed query during Materialized View query generation ORA-10981: dscn computation-related event in replication ORA-10982: event to turn off CDC-format MV Logs ORA-10983: event to enable Create_Change_Table debugging ORA-10984: subquery materialized view-related event ORA-10985: event for NULL refresh of materialized views ORA-10986: donot use HASH_AJ in refresh ORA-10987: event for the support of caching table with object feature ORA-10988: event to get exclusive lock during materialized view refresh in IAS ORA-10989: event to internally create statistics MV ORA-10990: dump spreadsheet info ORA-10991: event for optimizing the online redefinition instantiation ORA-10992: event to enable dbms_job instead of dbms_scheduler ORA-10993: Runtime enable IOQ batching ORA-10994: Compiletime enable IOQ batching ORA-10995: general event for materialized views ORA-10997: another startup/shutdown operation of this instance inprogress ORA-10998: event to enable short stack dumps in system state dumps ORA-10999: do not get database enqueue name