List of common Oracle diagnostic events

Source: http://www.xifenfei.com/1570.html

 

Event	Description	Example
Event 10013-monitor transaction recovery	Tracking transaction recovery at startup	Alter session set events '10013 trace name context forever, level 1 ′;
Event 10015-dump undo segment headers-	Dump the rollback field header information after the transaction is restored	Alter session set events '10015 trace name context forever, level 1 ′;
Event 10032-dump sort statistics	Dump sorting statistics	Alter session set events '10032 trace name context forever, level 10 ′;
Event 10033-dump sort intermediate run statistics	Interaction between memory sorting areas and temporary tablespace during sorting	Alter session set events '10033 trace name context forever, level 10 ′;
Event 10045-trace Free List Management Operations	Freelist management operations	Alter session set events '10045 trace name context forever, level 1 ′;
Event 10046-enable SQL statement trace	Trace SQL, have execution plan, state variable and wait statistical information, Level 12 is the most detailed.	Alter session set events '10046 trace name context forever, level 12 ′; Level is defined as follows: 1: SQL statement, execution plan and execution status Add variable binding information. Information plus wait event information + 4 + 8
Event 10053-dump optimizer decisions	When analyzing SQL statements, dump out the optimizer's selection, level 1 is the most detailed	Alter session set events '10053 trace name context forever, level 1 ′; Level is defined as follows: 1: Status and estimation information 2: only show estimation information
Event 10060-dump predicates	Break information in dump SQL statements. The following table needs to be created under the user who needs dump Create Table kkoipt_table (C1 integer, C2 varchar2 (80 )); The break information is written into the table.	Alter session set events '10060 trace name context forever, level 1 ′;
Event 10065-Restrict library Cache dump output for State object dumps	Limit the details of library cache information when the object state is dump 1 Address of library object only 2 as Level 1 Plus Library object lock details 3 As Level 2 Plus Library object handle and library object The default value is Level 3.	Alter session set events '10065 trace name context forever, level level ';
Event 10079-dump SQL * Net statistics-	Dump SQL * Net statistics	Alter session set events '10079 trace name context forever, Level 2 ′;
Event 10081-trace high water mark changes	Hwm changes	Alter session set events '10081 trace name context forever, level 1 ′;
Event 10104-dump hash join statistics	Hash join statistics	Alter session set events '10104 trace name context forever, level 10 ′;
Event 10128-dump partition pruning Information	Partition Table adjustment information	Alter session set events '10128 trace name context forever, level level '; Level value: 1 dump pruning descriptor for each partitioned object 0 × 0002 dump partition iterators 0 × 0004 dump optimizer decisions about partition-Wise joins 0 × 0008 dump rowid range scan pruning Information In 9.0.1 or later versions, the following table needs to be created after Level 2: Create Table kkpap_pruning ( Partition_count number, Iterator varchar2 (32 ), Partition_level varchar2 (32 ), Order_pt varchar2 (12 ), Call_time varchar2 (12 ), Part # number, Subp # number, ABS # Number );
Event	Description	Example
Event 10200-dump consistent reads	Dump consistent read information	Alter session set events '10200 trace name context forever, level 1 ′;
Event 10201-dump consistent read undo Application	Dump consistent read content involving undo Information	Alter session set events '10201 trace name context forever, level 1 ′;
Event 10220-dump changes to undo Header	Dump changes the Undo header information	Alter session set events '10220 trace name context forever, level 1 ′;
Event 10221-dump undo changes	Dump undo changes	Alter session set events '10221 trace name context forever, level 7 ′;
Event 10224-dump index block splits/deletes	Split and D delete information of index Blocks	Alter session set events '10224 trace name context forever, level 1 ′;
Event 10225-dump changes to dictionary managed extents	Dump field management extension changes	Alter session set events '10225 trace name context forever, level 1 ′;
Event 10231	Skipping Bad blocks during full table scan is useful for saving data when there are bad Blocks	Alter system set events '10231 trace name context forever, level 10 ′;
Event 10241-dump Remote SQL Execution	Execution information of Remote SQL statements	Alter session set events '10241 trace name context forever, level 1 ′;
Event 10246-trace pmon Process	Tracking pmon Processes	Only parameters can be modified, but not alter System Event = "10246 trace name context forever, level 1 ″
Event 10248-trace dispatcher Processes	Tracking dispatcher operations	Event = "10248 trace name context forever, level 10 ″
Event 10249-trace Shared Server (MTS) processes-	Tracking the working status of shared servers	Event = "10249 trace name context forever, level 10 ″
Event 10270-Debug shared cursors	Tracking shared cursors	Event = "10270 trace name context forever, level 10 ″
Event 10299-Debug prefetching	Tracking the prefetching of table data blocks and index data blocks	Event = "10299 trace name context forever, level 1 ″
Event 10357-Debug direct path		Alter session set events '10357 trace name context forever, level 1 ′;
Event 10390-dump parallel execution slave statistics	Tracking the status of slave in parallel operations	Alter session set events '10390 trace name context forever, level 1;
Event 10391-dump parallel execution granule allocation	Granularity of tracking parallel operations	Alter session set events '10391 trace name context forever, Level 2 ′;
Event 10393-dump parallel execution statistics	Track the status of parallel operations (each slave lists the status separately)	Alter session set events '10393 trace name context forever, level 1 ′;
Event 10500-trace SMON Process	Trace the SMON Process	Event = "10500 trace name context forever, level 1 ″
Event 10608-trace bitmap index creation	Detailed process of creating a bitmap Index	Alter session set events '10608 trace name context forever, level 10 ′;
Event 10704-trace enqueues	Tracking lock usage	Alter session set events '10704 trace name context forever, level 1 ′;
Event 10706-trace global enqueue manipulation	Tracking global lock usage	Alter session set events '10706 trace name context forever, level 1 ′;
Event 10708-trace RAC buffer cache	Trace the buffer cache in the RAC Environment	Alter session set events '10708 trace name context forever, level 10 ′;
Event	Description	Example
Event 10710-trace bitmap index access	Tracking bitmap index access	Alter session set events '10710 trace name context forever, level 1 ′;
Event 10711-trace bitmap index merge operation	Merge Bitmap indexes	Alter session set events '10711 trace name context forever, level 1 ′;
Event 10712-trace bitmap index or operation	Tracking Bitmap indexes or operations	Alter session set events '10712 trace name context forever, level 1 ′;
Event 10713-trace bitmap index and Operation	Tracking Bitmap indexes and operations	Alter session set events '10713 trace name context forever, level 1 ′;
Event 10714-trace bitmap index minus operation	Trace bitmap index minus operations	Alter session set events '10714 trace name context forever, level 1 ′;
Event 10715-trace bitmap index conversion to rowids operation	Tracking bitmap index conversion rowid operation	Alter session set events '10715 trace name context forever, level 1 ′;
Event 10716-trace bitmap index compress/decompress	Tracking bitmap index compression and decompression	Alter session set events '10716 trace name context forever, level 1 ′;
Event 10717-trace bitmap index Compaction		Alter session set events '10717 trace name context forever, level 1 ′;
Event 10719-trace bitmap index DML	Trace the DML operation of the bitmap index column (DML operation that causes the bitmap index to change)	Alter session set events '10719 trace name context forever, level 1 ′;
Event 10730-trace fine grained access predicates	Trace the break of fine-grained Audit	Alter session set events '10730 trace name context forever, level 1 ′;
Event 10731-trace cursor statements	Trace cursor statements	Alter session set events '10731 trace name context forever, level level '; Level Definition 1 print parent query and subquery 2 print subquery only
Event 10928-trace PL/SQL Execution	Trace PL/SQL Execution	Alter session set events '10928 trace name context forever, level 1 ′;
Event 10938-dump PL/SQL Execution statistics	Trace PL/SQL Execution status. Run tracetab. SQL under rdbms/admin before use.	Alter session set events '10938 trace name context forever, level 1 ′;
Flush_cache	Refresh buffer cache	Alter session set events 'immediate trace name flush_cache ';
Drop_segments	Manually delete temporary segments. When these temporary segments cannot be automatically cleared, they can be manually cleared.	Alter session set events 'immediate trace name drop_segments level ts # + 1 ′; TS # It refers to the table space of the temporary segment to be deleted #