Category Archives: oracle events

Collect Oracle useful trace events

10511 event

简介:    Automatic Undo Management下禁止SMON Offline空闲的rollback segment 使用方法:    在init.ora中设置event:     event=”10511 trace name context forever, level 2″     然后restart database 相关文档:     metalink Note:301432.1  

Posted in oracle events | 98 Comments

Index treedump event

简介: 将索引结构以树状打印出来 使用方法: alter session set events ‘immediate trace name treedump level obj#'; -- obj# is the index’s object_id Trace结果范例: —– begin tree dump branch: 0x8001ea 8389098 (0: nrow: 5, level: 2)    branch: 0x300049a 50332826 (-1: nrow: 5, level: … Continue reading

Posted in oracle events | 84 Comments

10132 trace event

简介: 10132 trace event 生成实际执行的execution plan,格式简单明了,包括PQ和Partition信息 使用方法: alter session set events ‘10132 trace name context forever,level 1′; alter session set events ‘10132 trace name context off'; Trace结果范例: *** 2007-01-15 19:13:48.890 *** SESSION ID:(18.2014) 2007-01-15 19:13:48.888 Current SQL statement for this … Continue reading

Posted in oracle events | 101 Comments

10704 trace event

在一次troubleshooting中使用到了这个trace event,感觉还是蛮好用的,和大家分享一下。 10704 event用于trace enqueue的获取过程。 $oerr ora 10704 10704, 00000, “Print out information about what enqueues are being obtained” // *Cause: When enabled, prints out arguments to calls to ksqcmi and // ksqlrl and the return values. // *Action: Level … Continue reading

Posted in oracle events | 135 Comments