Event Numbering Range 10000 - 10999
Event Definitions Event # Level Description 10013 1 Monitor Transaction Recovery 10015 1 Dump Undo Segment Headers 10015 3 Identify corrupt undo segments 10032 4 Dump Sort Statistics 10032 10 Dump Sort Statistics 10033 4 Dump Sort Large Run Statistics 10033 10 Dump Sort Intermediate Run Statistics 10045 1 Trace Free List Management Operations 10046 1 Print SQL statements, execution plans and execution statistics 10046 4 Level 1 + Bind Variables 10046 8 Level 1 + Waits 10046 12 Level 1 + Bind Variables & Waits 10053 1 Dump Optimizer Statistics and Computations 10053 2 Dump Optimizer Computations only 10060 1 10060 - Dump Predicates * 10065 1 Restrict Library Cache Output for State Object Dumps - Library Objects Only 10065 2 Restrict Library Cache Output for State Object Dumps + library object lock details 10065 3 Restrict Library Cache Output for State Object Dumps + library object handle and library object 10079 2 Dump SQL*Net Statistics 10081 1 Dump High Water Mark Changes 10104 10 Dump Hash Join Statistics 10128 0x0001 Dump Partition Pruning Information * 10128 0x0002 Dump partition iterators 10128 0x0004 Dump optimizer decisions about partition-wise joins 10128 0x0008 Dump ROWID range scan pruning information 10200 1 Dump Consistent Reads 10201 1 Dump Consistent Read Undo Application 10210 10 Table Integrity Check 10211 10 Index Integrity Check 10220 1 Dump Changes to Undo Header 10221 7 Dump Undo Changes 10224 1 Dump Index Block Splits / Deletes 10225 1 Dump Changes to Dictionary Managed Extents 10231 10 Causes full table scans to skip corrupt blocks, rather than fail with an ORA-1578 error 10232 10 Causes corrupt blocks to be dumped to the process trace file 10233 10 Traces memory usage statistics 10235 1 Check memory manager internal structures (use with ORA-600/ORA-7445 errors) 10241 1 Dump Remote SQL Execution 10246 1 Trace PMON Process 10248 10 Trace Dispatcher Processes 10249 10 Trace Shared Server (MTS) Processes 10270 10 Debug Shared Cursors 10299 1 Debug Prefetch 10357 1 Debug Direct Path 10390 0x0001 Dump Parallel Execution Slave Statistics - Slave-side execution messages 10390 0x0002 Dump Parallel Execution Slave Statistics - Coordinator-side execution messages 10390 0x0004 Dump Parallel Execution Slave Statistics - Slave context state changes 10390 0x0008 Dump Parallel Execution Slave Statistics - Slave ROWID range bind variables and xty 10390 0x0010 Dump Parallel Execution Slave Statistics - Slave fetched rows as enqueued to TQ 10390 0x0020 Dump Parallel Execution Slave Statistics - Coordinator wait reply handling 10390 0x0040 Dump Parallel Execution Slave Statistics - Coordinator wait message buffering 10390 0x0080 Dump Parallel Execution Slave Statistics - Slave dump timing 10390 0x0100 Dump Parallel Execution Slave Statistics - Coordinator dump timing 10390 0x0200 Dump Parallel Execution Slave Statistics - Slave dump allocation file number 10390 0x0400 Dump Parallel Execution Slave Statistics - Terse format for debug dumps 10390 0x0800 Dump Parallel Execution Slave Statistics - Trace CRI random sampling 10390 0x1000 Dump Parallel Execution Slave Statistics - Trace signals 10390 0x2000 Dump Parallel Execution Slave Statistics - Trace parallel execution granule operations 10390 0x4000 Dump Parallel Execution Slave Statistics - Force compilation by slave 0 10391 0x0001 Dump Parallel Execution Granule Allocation - Summary of each object scanned in parallel 10391 0x0002 Dump Parallel Execution Granule Allocation - Full dump of each object except extent map 10391 0x0004 Dump Parallel Execution Granule Allocation - Full dump of each object including extent map 10391 0x0010 Dump Parallel Execution Granule Allocation - Summary of each granule generators 10391 0x0020 Dump Parallel Execution Granule Allocation - Granule generators except granule instances 10391 0x0040 Dump Parallel Execution Granule Allocation - Granule generators including granule instances 10391 0x0080 Dump Parallel Execution Granule Allocation - System information 10391 0x0100 Dump Parallel Execution Granule Allocation - Reference object for the query 10391 0x0200 Dump Parallel Execution Granule Allocation - kxfralo timing 10391 0x0400 Dump Parallel Execution Granule Allocation - Affinity module 10391 0x0800 Dump Parallel Execution Granule Allocation - Granule allocation during query execution 10391 0x1000 Dump Parallel Execution Granule Allocation - Object flush 10393 1 Dump Parallel Execution Statistics 10500 1 Trace SMON Process 10608 10 Trace Bitmap Index Creation 10704 1 Trace Enqueues 10706 1 Trace Global Enqueue Manipulation 10708 10 Trace RAC Buffer Cache 10710 1 Trace Bitmap Index Access 10711 1 Trace Bitmap Index Merge Operation 10712 1 Trace Bitmap Index OR Operation 10713 1 Trace Bitmap Index AND Operation 10714 1 Trace Bitmap Index MINUS Operation 10715 1 Trace Bitmap Index Conversion to ROWIDs 10716 1 Trace Bitmap Index Compress / Decompress 10717 1 Trace Bitmap Index Compaction 10719 1 10719 - Trace Bitmap Index DML 10730 1 Trace Fine Grained Access Predicates 10731 1 Trace CURSOR Statements 10731 2 Trace CURSOR Statements 10901 Disable extent trimming 10928 1 Trace PL/SQL Execution 10938 1 Trace PL/SQL Execution Statistics 29700 Enable the collection of DLM lock conversion statistics to query GV$DLM_CONVERT_LOCAL and GV$DLM_CONVERT_REMOTE
|