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 |