본문 바로가기

Oracle Wait Interface

HangAnalyze 3

SQL> oradebug hanganalyze 3   [ 3, 5, 10 ]
Hang Analysis in /oracle/app/admin/EJD/udump/ejd_ora_2683086_SGA_with_level_2_SharedPoolDump.trc

[level  5] :   4 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP] 
[level 10] :  36 node dumps -- [IGN] 

*** 2011-07-31 02:48:40.154
==============
HANG ANALYSIS:
==============
Open chains found:
Other chains found:
Chain 1 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
    <0/3187/24886/0x8e1f8d48/2683086/No Wait>
Chain 2 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
    <0/3253/14530/0x8e1ff3a8/2437280/Streams AQ: qmn slave idle wait>
Chain 3 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
    <0/3285/2/0x8e1f3e88/2551902/Streams AQ: waiting for time man>
Chain 4 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
    <0/3286/1/0x8e1f36a8/2625594/Streams AQ: qmn coordinator idle>
Extra information that will be dumped at higher levels:
[level  5] :   4 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP] 
[level 10] :  36 node dumps -- [IGN] 
 
State of nodes
([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist]/predecessor):
[3151]/0/3152/29278/0x8d90adc8/2719958/IGN/1/2//none
[3152]/0/3153/61163/0x8d90c330/2195616/IGN/3/4//none
[3181]/0/3182/56114/0x8d932ff8/2502828/IGN/5/6//none
[3186]/0/3187/24886/0x8d939b00/2683086/SINGLE_NODE_NW/7/8//none
[3189]/0/3190/49531/0x8d93db38/2580570/IGN/9/10//none
[3192]/0/3193/16194/0x8d941b70/2506938/IGN/11/12//none
[3193]/0/3194/17714/0x8d9430d8/2490422/IGN/13/14//none
[3201]/0/3202/15442/0x8d94dc18/2355206/IGN/15/16//none
[3202]/0/3203/15286/0x8d94f180/2482380/IGN/17/18//none
[3210]/0/3211/61584/0x8d959cc0/2400432/IGN/19/20//none
[3213]/0/3214/34581/0x8d95dcf8/2535592/IGN/21/22//none
[3221]/0/3222/52361/0x8d968838/2420832/IGN/23/24//none
[3223]/0/3224/32496/0x8d96b308/2109560/IGN/25/26//none
[3240]/0/3241/6313/0x8d981ef0/2093200/IGN/27/28//none
[3242]/0/3243/15819/0x8d9849c0/2531542/IGN/29/30//none
[3245]/0/3246/54162/0x8d9889f8/2416644/IGN/31/32//none
[3250]/0/3251/27084/0x8d98f500/544970/IGN/33/34//none
[3252]/0/3253/14530/0x8d991fd0/2437280/SINGLE_NODE/35/36//none
[3255]/0/3256/56417/0x8d996008/2285660/IGN/37/38//none
[3256]/0/3257/39153/0x8d997570/438482/IGN/39/40//none
[3257]/0/3258/34051/0x8d998ad8/303316/IGN/41/42//none
[3260]/0/3261/43227/0x8d99cb10/2498638/IGN/43/44//none
[3264]/0/3265/319/0x8d9a20b0/2105376/IGN/45/46//none
[3266]/0/3267/40080/0x8d9a4b80/888904/IGN/47/48//none
[3279]/0/3280/31291/0x8d9b61c8/2433230/IGN/49/50//none
[3284]/0/3285/2/0x8d9bccd0/2551902/SINGLE_NODE/51/52//none
[3285]/0/3286/1/0x8d9be238/2625594/SINGLE_NODE/53/54//none
[3289]/0/3290/1/0x8d9c37d8/2101450/IGN/55/56//none
[3290]/0/3291/1/0x8d9c4d40/2302014/IGN/57/58//none
[3294]/0/3295/1/0x8d9ca2e0/2617464/IGN/59/60//none
[3295]/0/3296/1/0x8d9cb848/2715770/IGN/61/62//none
[3296]/0/3297/1/0x8d9ccdb0/2678978/IGN/63/64//none
[3297]/0/3298/1/0x8d9ce318/2691284/IGN/65/66//none
[3298]/0/3299/1/0x8d9cf880/356498/IGN/67/68//none
[3299]/0/3300/1/0x8d9d0de8/917716/IGN/69/70//none
[3300]/0/3301/1/0x8d9d2350/2641996/IGN/71/72//none
[3301]/0/3302/1/0x8d9d38b8/2396306/IGN/73/74//none
[3302]/0/3303/1/0x8d9d4e20/2469896/IGN/75/76//none
[3303]/0/3304/1/0x8d9d6388/2515080/IGN/77/78//none
[3304]/0/3305/1/0x8d9d78f0/2613324/IGN/79/80//none
====================
END OF HANG ANALYSIS
====================


'Oracle Wait Interface' 카테고리의 다른 글

buffer is pinned count  (0) 2014.02.07
조동욱 님의 OWI (Oracle Wait Interface)  (0) 2011.08.04
Systemstate dumps  (0) 2011.07.31
Dump SGA level 2  (0) 2011.07.31