Мар 242011

Некоторые из этих событий я уже описывал и буду продолжать описывать по мере того, как буду находить что-нибудь полезное.
Вот список событий. Надо понимать, что большинство из них совершенно недокументировано и включать их без разрешения Oracle Support нельзя.

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

По мере написания новых постов и нахождения в Сети полезной информации, я буду добавлять в эту табличку ссылки.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre lang="" line="" escaped="" cssfile="">