【Oracle】Oracle常用EVENT之二

event 10200 - dump consistent reads

dump一緻讀的資訊

alter session set events '10200 trace name context forever, level 1';

oracle常用event之二

event 10201 - dump consistent read undo application

dump一緻性讀涉及undo資訊的内容

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

索引塊的分裂和d删除資訊

alter session set events '10224 trace name context forever, level 1';

event 10225 - dump changes to dictionary managed extents

dump字段管理的擴充變化

alter session set events '10225 trace name context forever, level 1';

event 10231

全表掃描時跳過壞塊，在有壞塊的情況下做資料拯救時很有用

alter system set events '10231 trace name context forever,level 10';

event 10241 - dump remote sql execution

遠端sql語句的執行資訊

alter session set events '10241 trace name context forever, level 1';

event 10246 - trace pmon process

跟蹤pmon程序

隻能修改參數，不能用alter system

event = "10246 trace name context forever, level 1"

event 10248 - trace dispatcher processes

跟蹤dispatcher的工作情況

event = "10248 trace name context forever, level 10"

event 10249 - trace shared server (mts) processes-

跟蹤共享伺服器的工作情況

event = "10249 trace name context forever, level 10"

event 10270 - debug shared cursors

跟蹤共享cursors的情況

event = "10270 trace name context forever, level 10"

event 10299 - debug prefetching

跟蹤表資料塊和索引資料塊的prefetching

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

跟蹤并行操作中的slave的狀态

alter session set events '10390 trace name context forever, level 1;

event 10391-dump parallel execution granule allocation

跟蹤并行操作的粒度

alter session set events '10391 trace name context forever, level 2';

event 10393 - dump parallel execution statistics

跟蹤并行操作的狀态（每個slave單獨列出狀态）

alter session set events '10393 trace name context forever, level 1';

event 10500 - trace smon process

跟蹤smon程序

event = "10500 trace name context forever, level 1"

event 10608 - trace bitmap index creation

跟蹤bitmap索引建立的詳細過程

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

跟蹤全局鎖的使用情況

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';