ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle常用EVENT参考(二)

Oracle常用EVENT参考(二)

原创 Linux操作系统 作者:xuelu2000 时间:2009-04-04 23:09:38 0 删除 编辑

转载:http://hi.baidu.com/edeed/blog/item/ee6811df1c1f4f1762279859.html

事件

说明

例子

Event 10200 - Dump Consistent Reads

DUMP一致读的信息

ALTER SESSION SET EVENTS '10200 trace name context forever, level 1';

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

DumpUndo头信息的改变

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/95233/viewspace-584662/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-23

  • 博文量
    89
  • 访问量
    235655