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
联系客服