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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-721718/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22664653/viewspace-721718/