command list[@more@]
sqlplus -prelim
oradebug setmypid
oradebug unlimit
oradebug -g all dump systemstate 10
oradebug setmypid
oradebug setinst all
oradebug -g def hanganalyze
level:
1-2 Only hanganalyze output, no process dump at all
3 Level 2 + Dump only processes thought to be in a hang (IN_HANG state)
4 Level 3 + Dump leaf nodes (blockers) in wait chains (LEAF, LEAF_NW,IGN_DMP state)
5 Level 4 + Dump all processes involved in wait chains (NLEAF state)
10 Dump all processes (IGN state)
other:
perl DumpOraProc.pl
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/717880/viewspace-1057494/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
