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