Level | Action |
0x0001 | Dump pruning descriptor for each partitioned object |
0x0002 | Dump partition iterators |
0x0004 | Dump optimizer decisions about partition-wise joins |
0x0008 | Dump ROWID range scan pruning information |
在9.0.1或者后面的版本,在level 2后还需要建立如下的表:
Event 10200 - Dump Consistent Reads---Dump出一致读的信息
ALTER SESSION SET EVENTS '10200 trace name context forever, level 1';
Event 10201 - Dump Consistent Read Undo Application---(不明白)
ALTER SESSION SET EVENTS '10201 trace name context forever, level 1';
Event 10220 - Dump Changes to Undo Header—Dump出Undo头信息的改变
ALTER SESSION SET EVENTS '10220 trace name context forever, level 1';
Event 10221 - Dump Undo Changes—Dump Undo的改变
ALTER SESSION SET EVENTS '10221 trace name context forever, level 7';
Event 10224 - Dump Index Block Splits / Deletes—Dump索引块的Split和Delete信息
ALTER SESSION SET EVENTS '10224 trace name context forever, level 1';
Event 10225 - Dump Changes to Dictionary Managed Extents---Dump出在Row Cache中,字典管理的Extents的改变
ALTER SESSION SET EVENTS '10225 trace name context forever, level 1';
Event 10231--设置在做全表扫描时跳过损坏的数据块(在做EXP时,如果有坏块,设置这个可以使EXP导出时跳过坏块,使得部分数据能可以使用)
ALTER SYSTEM SET EVENTS '10231 trace name context forever,level 10';
Event 10241 - Dump Remote SQL Execution—Dump远程SQL语句的执行信息
ALTER SESSION SET EVENTS '10241 trace name context forever, level 1';
Event 10246 - Trace PMON Process---只能在init.ora中做,不能用ALTER SYSTEM做
event = "10246 trace name context forever, level 1"
Event 10248 - Trace Dispatcher Processes---在init.ora中做(9iDump到udump目录中)
event = "10248 trace name context forever, level 10"
Event 10249 - Trace Shared Server (MTS) Processes---在init.ora中做(9iDump到udump目录中)
event = "10249 trace name context forever, level 10"
Event 10270 - Debug Shared Cursors—(不明白)
event = "10270 trace name context forever, level 10"
Event 10299 - Debug Prefetching---(参考http://www.juliandyke.com/)
event = "10299 trace name context forever, level 1"
Event 10357 - Debug Direct Path---(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10357 trace name context forever, level 1';
Event 10390 - Dump Parallel Execution Slave Statistics--(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10390 trace name context forever, level level';
Event 10391-Dump Parallel Execution Granule Allocation---
(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10391 trace name context forever, level level';
Event 10393 - Dump Parallel Execution Statistics--(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10393 trace name context forever, level 1';
Event 10500 - Trace SMON Process--在init.ora中做
event = "10500 trace name context forever, level 1"
Event 10608 - Trace Bitmap Index Creation—跟踪二位图索引
ALTER SESSION SET EVENTS '10608 trace name context forever, level 10';
Event 10704 - Trace Enqueues—跟踪队列
ALTER SESSION SET EVENTS '10704 trace name context forever, level 1';
Event 10706 - Trace Global Enqueue Manipulation-(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10706 trace name context forever, level 1';
Event 10708 - Trace RAC Buffer Cache—跟踪RAC的Buffer Cache
ALTER SESSION SET EVENTS '10708 trace name context forever, level 10';
Event 10710 - Trace Bitmap Index Access--(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS '10710 trace name context forever, level 1';
Event 10711 - Trace Bitmap Index Merge Operation—
ALTER SESSION SET EVENTS '10711 trace name context forever, level 1';
Event 10712 - Trace Bitmap Index OR Operation—
ALTER SESSION SET EVENTS '10712 trace name context forever, level 1';
Event 10713 - Trace Bitmap Index AND Operation—
ALTER SESSION SET EVENTS '10713 trace name context forever, level 1';
Event 10714 - Trace Bitmap Index MINUS Operation—
ALTER SESSION SET EVENTS '10714 trace name context forever, level 1';
Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation—
ALTER SESSION SET EVENTS '10715 trace name context forever, level 1';
Event 10716 - Trace Bitmap Index Compress/Decompress—
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—
ALTER SESSION SET EVENTS '10719 trace name context forever, level 1';
Event 10730 - Trace Fine Grained Access Predicates—
ALTER SESSION SET EVENTS '10730 trace name context forever, level 1';
Event 10731 - Trace CURSOR Statements—
ALTER SESSION SET EVENTS '10731 trace name context forever, level level';
Levels are:
Level | Action |
1 | Print parent query and subquery |
2 | Print subquery only |
Event 10928 - Trace PL/SQL Execution—
ALTER SESSION SET EVENTS '10928 trace name context forever, level 1';
Event 10938 - Dump PL/SQL Execution Statistics—
ALTER SESSION SET EVENTS '10938 trace name context forever, level 1';
一些其他的Events:
ALTER SESSION SET EVENTS 'immediate trace name flush_cache';--Flush the Buffer cache
资料来源http://www.juliandyke.com/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/756652/viewspace-343395/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/756652/viewspace-343395/