教你熟练使用hanganalyze来分析数据库

核心提示： SINGLE_NODE/SINGLE_NODE_NW：近似于空闲会话实战hanganalyze:生成跟踪文件SQL> oradebug setmypid已处理的语句SQL> oradebug hanganalyze 3查看跟踪文件==HANG ANALYSIS:==Open c

SINGLE_NODE/SINGLE_NODE_NW：近似于空闲会话

实战hanganalyze:

生成跟踪文件
SQL> oradebug setmypid
已处理的语句
SQL> oradebug hanganalyze 3

查看跟踪文件

==============
HANG ANALYSIS:
==============
Open chains found:
Chain 1 : <sid/sess_srno/proc_ptr/ospid/wait_event> :
<5/1/0x843630f8/2531/No Wait>
Chain 2 : <sid/sess_srno/proc_ptr/ospid/wait_event> :
<12/1/0x84364e48/2521/instance state change>

有一个等待事件，操作系统进程是2521，经检查，是smon，占用了一个CPU的98％的资源

Other chains found:
Extra information that will be dumped at higher levels:
[level　4] :　 2 node dumps -- [LEAF] [LEAF_NW] [IGN_DMP]
[level 10] :　 6 node dumps -- [IGN]
State of nodes
([nodenum]/sid/sess_srno/session/state/
start/finish/[adjlist]/predecessor):
[0]/1/1/0x84405460/IGN/1/2//none
[1]/2/1/0x84405de0/IGN/3/4//none
[2]/3/1/0x84406760/IGN/5/6//none
[3]/4/1/0x844070e0/IGN/7/8//none
[4]/5/1/0x84407a60/LEAF_NW/9/10//none
[5]/6/1/0x844083e0/IGN/11/12//none
[10]/11/1/0x8440b360/IGN/13/14//none
[11]/12/1/0x8440bce0/LEAF/15/16//none
Dumping System_State and
Fixed_SGA in process with ospid 2521
Dumping Process information
for process with ospid 2531
Dumping Process information
for process with ospid 2521
*** 2004-12-09 00:07:49.680
====================
END OF HANG ANALYSIS
====================

我们看到，并没有发生死锁，Smon进程忙，说明在正确释放资源。