ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【Oracle】Oracle常用EVENT之二

【Oracle】Oracle常用EVENT之二

原创 Linux操作系统 作者:杨奇龙 时间:2012-04-19 20:31:50 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
MySQL DBA NoSQL DEVOPS

注册时间:2009-10-07

  • 博文量
    1026
  • 访问量
    7498200