| level 10'''';
Event 10128 - Dump Partition Pruning Information—Dump分区表信息
ALTER SESSION SET EVENTS ''''10128 trace name context forever, level level'''';
Level参考
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后还需要建立如下的表: 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 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/)
上一页 [1] [2] [3] [4] 下一页 | 
