A list of the Oracle Event codes.
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