티스토리 뷰

데이터베이스/oracle

oracle 10g R2 event, level

쌀맛나는세상 2008. 1. 7. 16:06
Event # Level Description
8186 -

ALTER SESSION SET EVENTS '8186 trace name context OFF' - VERSIONS BETWEEN query

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 (blocks dumped to disk and read back) - poss. no levels.
10033 10 Dump Sort Intermediate Run Statistics
10045 1 Trace Free List Management Operations
10046 0 No statistics generated
10046 1 Standard trace output including parsing, executes and fetches plus more
10046 2 Same as Level 1
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
10132 12 Dumps SQL statements into UDUMP along with the actual execution plan
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
10289 1 Dump a database block in hexadecimal
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
10401 1 KSXP tracing - event 10401 trace name context forever, level 1 (for RAC kernel)
10402 1 SKGXP tracing - event 10402 trace name context forever, level 1 (for RAC kernel) minimal tracing
10402 127 SKGXP tracing - event 10402 trace name context forever, level 1 (for RAC kernel) maximum tracing
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

Use "dbms_monitor.session_trace_enable()" instead of "alter session set events ..." and you will see the columns sys.gv_$session updated

'데이터베이스 > oracle' 카테고리의 다른 글

oradebug help  (0) 2008.02.13
oracle 10g audit_trail 사용  (0) 2008.01.26
Oracle Datapump 사용해 보기  (0) 2008.01.11
Automatically Restarting ONS  (0) 2007.12.31
오라클 OBJECT 조회  (0) 2007.12.26