插入时件代码oracle,ORACLE 事件代码

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