Re: Trace events - what numbers do what?

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 15 Feb 2003 08:16:53 GMT
Message-ID: <b2kt1i$1dmeqh$3@ID-82536.news.dfncis.de>

> I have seen numerous messages with trace event numbers and levels.
> I know how to use them, but wonder if there's a list of them
> somewhere. I have not (yet) discovered them on tahiti

Hello

Here's a list that I picked up somewhere. Don't know how accurate it is and if you're even allowed to use it on a server, but here you go

Hht
Rene Nyffenegger

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 formatted 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 rollback segment 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 source 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

-- 
  no sig today

Received on Sat Feb 15 2003 - 02:16:53 CST