Example uses of Oracle event codes.
To enable block header and trailer checking to detect corrupt blocks:
event="10210 trace name context forever, level 10" for tables
event="10211 trace name context forever, level 10" for indexes
and to go with these the undocumented parameter setting:
_db_block_cache_protect=TRUE
Which will prevent corruption from getting to your disks (at the cost of a database crash)
For tracing of a MAX_CURSORS exceeded error:
event="1000 trace name ERRORSTACK level 3"
To get an error stack related to a SQLNET ORA-03120 error:
event="3120 trace name error stack"
To turn on bitmapped indexes in 7.3.2:
event="10111 trace name context forever"
event="10112 trace name context forever"
event="10114 trace name context forever"
and?set the initialization parameter COMPATIBLE to 7.3.2
To work around a space leak problem:
event="10262 trace name context forever, level 1024"
To trace memory shortages:
event="10235 trace name context forever, level 4"
event="600 trace name heapdump, level 4"
Events are also used as the SESSION level:
alter session set events '10046 trace name context forever level NN'
where NN:
1 ? same as a regular trace
4 ? also dump bind variables
8 ? also dump wait information
12 ? dump both bind and wait information
You can get info about the events from the oraus.msg file: grep 10612 $ORACLE_HOME/rdbms/mesg/oraus.msg 10612, 00000, "prints debug information for auto-space managed segments"复制
Code | Description |
10000 | Control file debug event, name ?control_file? |
10001 | Control file crash event1 |
10002 | Control file crash event2 |
10003 | Control file crash event3 |
10004 | Control file crash event4 |
10005 | Trace latch operations for debugging |
10006 | Testing - block recovery forced |
10007 | Log switch debug crash after new log select, thread %s |
10008 | Log switch debug crash after new log header write, thread %s |
10009 | Log switch debug crash after old log header write, thread %s |
10010 | Begin Transaction |
10011 | End Transaction |
10012 | Abort Transaction |
10013 | Instance Recovery |
10014 | Roll Back to Save Point |
10015 | Undo Segment Recovery |
10016 | Undo Segment extend |
10017 | Undo Segment Wrap |
10018 | Data Segment Create |
10019 | Data Segment Recovery |
10020 | Partial link restored to linked list (KSG) |
10021 | Latch cleanup for state objects (KSS) |
10022 | Trace ktsgsp |
10023 | Create Save Undo Segment |
10024 | Write to Save Undo |
10025 | Extend Save Undo Segment |
10026 | Apply Save Undo |
10027 | Latch cleanup for enqueue locks (KSQ) |
10028 | Latch cleanup for enqueue resources (KSQ) |
10029 | Session logon (KSU) |
10030 | Session logoff (KSU) |
10031 | Row source debug event (R*) |
10032 | Sort end (SOR*) |
10035 | Parse SQL statement (OPIPRS) |
10036 | Create remote row source (QKANET) |
10037 | Allocate remote row source (QKARWS) |
10038 | Dump row source tree (QBADRV) |
10039 | Type checking (OPITCA) |
10040 | Dirty cache list |
10041 | Dump undo records skipped |
10042 | Trap error during undo application |
10044 | Free list undo operations |
10045 | Free list update operations - ktsrsp, ktsunl |
10046 | Enable SQL statement timing |
10047 | Trace switching of sessions |
10048 | Undo segment shrink |
10049 | Protect library cache memory heaps |
10050 | Sniper trace |
10051 | Trace OPI calls |
10052 | Don?t clean up obj$ |
10053 | CBO Enable optimizer trace |
10054 | Trace UNDO handling in MLS |
10055 | Trace UNDO handing |
10056 | Dump analyze stats (kdg) |
10057 | Suppress file names in error messages |
10058 | Use table scan cost in tab$.spare1 |
10060 | CBO Enable predicate dump |
10061 | Disable SMON from cleaning temp segment |
10062 | Disable usage of OS Roles in osds |
10063 | Disable usage of DBA and OPER privileges in osds |
10064 | Thread enable debug crash level %s, thread %s |
10065 | Limit library cache dump information for state object dump |
10066 | Simulate failure to verify file |
10067 | Force redo log checksum errors - block number |
10068 | Force redo log checksum errors - file number |
10069 | Trusted Oracle test event |
10070 | Force datafile checksum errors - block number |
10071 | Force datafile checksum errors - file number |
10072 | Protect latch recovery memory |
10073 | Have PMON dump info before latch cleanup |
10074 | Default trace function mask for kst |
10075 | CBO Disable outer-join to regular join conversion |
10076 | CBO Enable cartesian product join costing |
10077 | CBO Disable view-merging optimization for outer-joins |
10078 | CBO Disable constant predicate elimination optimization |
10080 | Dump a block on a segment list which cannot be exchanged |
10081 | Segment High Water Mark has been advanced |
10082 | Free list head block is the same as the last block |
10083 | A brand new block has been requested from space management |
10084 | Free list becomes empty |
10085 | Free lists have been merged |
10086 | CBO Enable error if kko and qka disagree on oby sort |
10087 | Disable repair of media corrupt data blocks |
10088 | CBO Disable new NOT IN optimization |
10089 | CBO Disable index sorting |
10090 | Invoke other events before crash recovery |
10091 | CBO Disable constant predicate merging |
10092 | CBO Disable hash join |
10093 | CBO Enable force hash joins |
10094 | Before resizing a data file |
10095 | Dump debugger commands to trace file |
10096 | After the cross instance call when resizing a data file |
10097 | After generating redo when resizing a data file |
10098 | After the OS has increased the size of a data file |
10099 | After updating the file header with the new file size |
10100 | After the OS has decreased the size of a data file |
10101 | Atomic redo write recovery |
10102 | Switch off anti-joins |
10103 | CBO Disable hash join swapping |
10104 | Dump hash join statistics to trace file |
10105 | CBO Enable constant pred trans and MPs w WHERE-clause |
10106 | CBO Disable evaluating correlation pred last for NOT IN |
10107 | CBO Always use bitmap index |
10108 | CBO Don?t use bitmap index |
10109 | CBO Disable move of negated predicates |
10110 | CBO Try index rowid range scans |
10111 | Bitmap index creation switch |
10112 | Bitmap index creation switch |
10113 | Bitmap index creation switch |
10114 | Bitmap index creation switch |
10115 | CBO Bitmap optimization use maximal expression |
10116 | CBO Bitmap optimization switch |
10117 | CBO Disable new parallel cost model |
10118 | CBO Enable hash join costing |
10119 | QKA Disable GBY sort elimination |
10120 | CBO Disable index fast full scan |
10121 | CBO Don?t sort bitmap chains |
10122 | CBO disable count(col) = count(*) transformation |
10123 | QKA Disable Bitmap And-EQuals |
10145 | Test auditing network errors |
10146 | Enable Oracle TRACE collection |
10200 | Block cleanout |
10201 | Consistent read undo application |
10202 | Consistent read block header |
10203 | Consistent read buffer status |
10204 | Signal recursive extend |
10205 | Row cache debugging |
10206 | Transaction table consistent read |
10207 | Consistent read transactions? status report |
10208 | Consistent read loop check |
10209 | Enable simulated error on control file |
10210 | Check data block integrity |
10211 | Check index block integrity |
10212 | Check cluster integrity |
10213 | Crash after control file write |
10214 | Simulate write errors on control file |
10215 | Simulate read errors on control file |
10216 | Dump control file header |
10217 | Debug sequence numbers |
10218 | Dump uba of applied undo |
10219 | Monitor multi-pass row locking |
10220 | Show updates to the transaction table |
10221 | Show changes done with undo |
10222 | Row cache |
10223 | Transaction layer - turn on verification codes |
10226 | Trace CR applications of undo for data operations |
10227 | Verify (multi-piece) row structure |
10228 | Trace application of redo by kcocbk |
10230 | Check redo generation by copying before applying |
10231 | Skip corrupted blocks on _table_scans_ |
10232 | Dump corrupted blocks symbolically when kcbgotten |
10233 | Skip corrupted blocks on index operations |
10234 | Trigger event after calling kcrapc to do redo N times |
10235 | Check memory manager internal structures |
10236 | Library cache manager |
10237 | Simulate ^C (for testing purposes) |
10238 | Instantiation manager |
10239 | Multi-instance library cache manager |
10240 | Dump dba?s of blocks that we wait for |
10241 | Dump SQL generated for remote execution (OPIX) |
10243 | Simulated error for test %s of K2GTAB latch cleanup |
10244 | Make tranids in error msgs print as 0.0.0 (for testing) |
10245 | Simulate lock conflict error for testing PMON |
10246 | Print trace of PMON actions to trace file |
10247 | Turn on scgcmn tracing. (VMS ONLY) |
10248 | Turn on tracing for dispatchers |
10249 | Turn on tracing for multi-stated servers |
10250 | Trace all allocate and free calls to the topmost SGA heap |
10251 | Check consistency of transaction table and undo block |
10252 | Simulate write error to data file header |
10253 | Simulate write error to redo log |
10254 | Trace cross-instance calls |
10256 | Turn off multi-threaded server load balancing |
10257 | Trace multi-threaded server load balancing |
10258 | Force shared servers to be chosen round-robin |
10259 | Get error message text from remote using explicit call |
10260 | Trace calls to SMPRSET (VMS ONLY) |
10261 | Limit the size of the PGA heap |
10262 | Don?t check for memory leaks |
10263 | Don?t free empty PGA heap extents |
10264 | Collect statistics on context area usage (x$ksmcx) |
10265 | Keep random system generated output out of error messages |
10266 | Trace OSD stack usage |
10267 | Inhibit KSEDMP for testing |
10268 | Don?t do forward coalesce when deleting extents |
10269 | Don?t do coalesces of free space in SMON |
10270 | Debug shared cursors |
10271 | Distributed transaction after COLLECT |
10272 | Distributed transaction before PREPARE |
10273 | Distributed transaction after PREPARE |
10274 | Distributed transaction before COMMIT |
10275 | Distributed transaction after COMMIT |
10276 | Distributed transaction before FORGET |
10277 | Cursor sharing (or not) related event (used for testing) |
10281 | Maximum time to wait for process creation |
10282 | Inhibit signalling of other backgrounds when one dies |
10286 | Simulate control file open error |
10287 | Simulate archiver error |
10288 | Do not check block type in ktrget |
10289 | Do block dumps to trace file in hex rather than fromatted |
10290 | Kdnchk - checkvalid event - not for general purpose use. |
10291 | Die in dtsdrv to test controlfile undo? |
10292 | Dump uet entries on a 1561 from dtsdrv? |
10293 | Dump debugging information when doing block recovery? |
10294 | Enable PERSISTENT DLM operations on non-compliant systems? |
10300 | Disable undo compatibility check at database open |
10301 | Enable LCK timeout table consistency check? |
10320 | Enable data layer (kdtgrs) tracing of space management calls? |
10352 | Report direct path statistics |
10353 | Number of slots |
10354 | Turn on direct read path for parallel query |
10355 | Turn on direct read path for scans |
10356 | Turn on hint usage for direct read |
10357 | Turn on debug information for direct path |
10374 | Parallel query server interrupt (validate lock value) |
10375 | Turn on checks for statistics rollups |
10376 | Turn on table queue statistics |
10377 | Turn off load balancing |
10379 | Direct read for rowid range scans (unimplemented) |
10380 | Kxfp latch cleanup testing event |
10381 | Kxfp latch cleanup testing event |
10382 | Parallel query server interrupt (reset) |
10383 | Auto parallelization testing event |
10384 | Parallel dataflow scheduler tracing |
10385 | Parallel table scan range sampling method |
10386 | Parallel SQL hash and range statistics |
10387 | Parallel query server interrupt (normal) |
10388 | Parallel query server interrupt (failure) |
10389 | Parallel query server interrupt (cleanup) |
10390 | Trace parallel query slave execution |
10391 | Trace rowid range partitioning |
10392 | Parallel query debugging bits |
10393 | Print parallel query statistics |
10394 | Allow parallelization of small tables |
10395 | Adjust sample size for range table queues |
10396 | Circumvent range table queues for queries |
10397 | Suppress verbose parallel coordinator error reporting |
10398 | Enable timeouts in parallel query threads |
10399 | Use different internal maximum buffer size |
10400 | Turn on system state dumps for shutdown debugging |
10500 | Turn on traces for SMON |
10510 | Turn off SMON check to offline pending offline rollbacksegment |
10511 | Turn off SMON check to cleanup undo dictionary |
10512 | Turn off SMON check to shrink rollback segments |
10600 | Check cursor frame allocation |
10602 | Cause an access violation (for testing purposes) |
10603 | Cause an error to occur during truncate (for testing purposes) |
10604 | Trace parallel create index |
10605 | Enable parallel create index by default |
10606 | Trace parallel create index |
10607 | Trace index rowid partition scan |
10608 | Trace create bitmap index |
10610 | Trace create index pseudo optimizer |
10666 | Do not get database enqueue name |
10667 | Cause sppst to check for valid process ids |
10690 | Set shadow process core file dump type (Unix only) |
10691 | Set background process core file type (Unix only) |
10700 | Alter access violation exception handler |
10701 | Dump direct loader index keys |
10702 | Enable histogram data generation |
10703 | Simulate process death during enqueue get |
10704 | Print out information about what enqueues are being obtained |
10706 | Print out information about instance lock manipulation |
10707 | Simulate process death for instance registration |
10708 | Print out Tracing information for skxf multi instance comms |
10709 | Enable parallel instances in create index by default |
10710 | Trace bitmap index access |
10711 | Trace bitmap index merge |
10712 | Trace bitmap index or |
10713 | Trace bitmap index and |
10714 | Trace bitmap index minus |
10715 | Trace bitmap index conversion to rowids |
10800 | Disable Smart Disk scan |
10801 | Enable Smart Disk trace |
10802 | Reserved for Smart Disk |
10803 | Write timing statistics on OPS recovery scan |
10804 | Reserved for ksxb |
10805 | Reserved for row sort |
10900 | Extent manager fault insertion event #%s |
10924 | Import storage parse error ignore event |
10925 | Trace name context forever |
10926 | Trace name context forever |
10927 | trace name context forever |
10928 | trace name context forever |
10999 | do not get database enqueue name |
Table 15: List of Oracle Event Codes
