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