结论
1,基于oradebug 的alter system set events='60 trace name errorstack forever,level 3';是分析或获取死锁信息的一处重要手段
2,errorstack适用于诊断某种特定的ORACLE错误
3,且记是alter system set events,而非set event,否则会报错
4,还有一点,通过10046也可以分析死锁
测试
--oracle version
SQL> select * from v$version where rownum=1;
BANNER
----------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Prodoction
---event parameter
SQL> show parameter event
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
event string
SQL> oradebug setospid 15936
Oracle pid: 184, Unix process pid: 15936, image: oracle@seconary (TNS V1-V3)
SQL> alter system set events='60 trace name errorstack forever,level 3';
System altered.
SQL> alter system set events='60 trace name errorstack off';
System altered.
SQL> oradebug tracefile_name
/oracle/diag/rdbms/guowang/guowang/trace/guowang_ora_15936.trc
产生的TRACE FILE我再列举,和前文格式相同,内容一致
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-1826378/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-1826378/