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