系统出现大量的enqueue,oradebug了一些信息

显示全部楼层 · 2008-2-13 12:43:03

……
*** SESSION ID

410.40637) 2011-03-24 15:49:21.693
*** 2011-03-24 15:49:21.693
==============
HANG ANALYSIS:
==============
Found 12 objects waiting for

Open chains found:
Chain 1 ::

--
--
Other chains found:
Chain 2 ::

Chain 3 ::

Extra information that will be dumped at higher levels:
[level4] : 1 node dumps -- [REMOTE_WT] [LEAF] [LEAF_NW]
[level5] : 3 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP]
[level6] : 1 node dumps -- [NLEAF]
[level 10] : 445 node dumps -- [IGN]

State of nodes
([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist]/predecessor):
[0]/0/1/1/0x4628d5b8/1094244/IGN/1/2//none
[1]/0/2/1/0x45281980/1466762/IGN/3/4//none
[2]/0/3/1/0x442812f0/1131138/IGN/5/6//none
[3]/0/4/1/0x4827c788/393794/IGN/7/8//none
[4]/0/5/1/0x47369e10/1368264/IGN/9/10//none
[5]/0/6/1/0x4628e048/1318978/IGN/11/12//none
[6]/0/7/1/0x45282410/1503536/LEAF/13/14//165
[7]/0/8/1/0x44281d80/1396774/IGN/15/16//none
[8]/0/9/1/0x4827d218/1433610/IGN/17/18//none
[9]/0/10/1/0x4736a8a0/1905318/SINGLE_NODE/19/20//none
[30]/0/31/13366/0x46291518/196968/IGN_DMP/49/52/[165]/none
[31]/0/32/22707/0x452858e0/1991352/IGN/53/54//none
[51]/0/52/31517/0x45288320/1843940/IGN/83/84//none
[52]/0/53/60681/0x44287c90/585968/IGN/85/86//none
[53]/0/54/17344/0x48283128/1098490/IGN/87/88//none
[55]/0/56/17352/0x462949e8/328366/IGN/89/90//none
[56]/0/57/42970/0x45288db0/1118964/IGN/91/92//none
[58]/0/59/32061/0x48283bb8/1454486/IGN/93/94/[165]/none
[59]/0/60/7678/0x47371240/192636/IGN/95/96//none
[61]/0/62/12510/0x45289840/987680/IGN/97/98//none
[62]/0/63/11235/0x442891b0/1598076/IGN/99/100//none
[63]/0/64/310/0x48284648/668206/IGN/101/102//none
[64]/0/65/57590/0x47371cd0/1536556/IGN/103/104//none
[65]/0/66/7165/0x46295f08/1315172/IGN/105/106//none
[66]/0/67/44524/0x4528a2d0/1344000/IGN/107/108//none
[68]/0/69/3849/0x482850d8/1413372/IGN/109/110//none
[70]/0/71/44779/0x46296998/1147060/IGN/111/112//none
[71]/0/72/63488/0x4528ad60/1856116/IGN/113/114//none
[73]/0/74/59218/0x48285b68/1516260/IGN/115/116//none
[74]/0/75/39068/0x473731f0/1647204/IGN/117/118//none
[77]/0/78/23588/0x4428b160/1303270/IGN/119/120//none
[78]/0/79/61987/0x482865f8/467410/IGN/121/122//none
[79]/0/80/33964/0x47373c80/688722/IGN/123/124//none
[80]/0/81/5698/0x46297eb8/368722/IGN/125/126//none
[81]/0/82/40855/0x4528c280/815700/IGN/127/128//none
[82]/0/83/58051/0x4428bbf0/807446/IGN/129/130//none
[83]/0/84/13384/0x48287088/197200/IGN/131/132//none
[84]/0/85/45093/0x47374710/1700484/IGN/133/134//none
[85]/0/86/38129/0x46298948/778876/IGN/135/136//none
[86]/0/87/25279/0x4528cd10/1310950/IGN/137/138//none
[87]/0/88/45672/0x4428c680/422604/IGN/139/140//none
[88]/0/89/57522/0x48287b18/1032584/IGN/141/142//none
[89]/0/90/42130/0x473751a0/1606178/IGN/143/144//none
[90]/0/91/28549/0x462993d8/803532/IGN/145/146//none
[91]/0/92/21172/0x4528d7a0/1983186/IGN/147/148//none
[92]/0/93/41975/0x4428d110/1061056/IGN/149/150//none
[93]/0/94/3132/0x482885a8/995410/IGN/151/152//none
[94]/0/95/39885/0x47375c30/1376996/IGN/153/154//none
[95]/0/96/10558/0x46299e68/1065472/IGN/155/156//none
[97]/0/98/10064/0x4428dba0/873032/IGN/157/158//none
[98]/0/99/58671/0x48289038/1651384/IGN/159/160//none
[99]/0/100/52125/0x473766c0/1307208/IGN/161/162//none
[102]/0/103/48788/0x4428e630/1028732/IGN/163/164//none
[122]/0/123/64000/0x44291070/807080/IGN/193/194//none
[123]/0/124/6544/0x4828c508/250386/IGN/195/196//none
[124]/0/125/43788/0x47379b90/1225268/IGN/197/198//none
[125]/0/126/62066/0x4629ddc8/942482/IGN/199/200//none
[126]/0/127/37852/0x45292190/659936/IGN/201/202/[165]/none
[152]/0/153/14145/0x44294fd0/889348/IGN/237/238//none
[153]/0/154/12920/0x48290468/913504/IGN/239/240//none
[155]/0/156/20143/0x462a1d28/1274316/IGN/241/242//none
[157]/0/158/2890/0x44295a60/1639084/IGN/243/244//none
[160]/0/161/39379/0x462a27b8/98856/IGN/245/246//none
[163]/0/164/7938/0x48291988/1348264/IGN/247/248//none
[165]/0/166/47921/0x462a3248/238046/NLEAF/50/51/[6]/30
[166]/0/167/49934/0x45297610/1610494/IGN/249/250//none
[167]/0/168/43713/0x44296f80/860756/IGN/251/252//none
[184]/0/185/11850/0x47381a50/471532/IGN/283/284//none
[185]/0/186/42323/0x462a5c88/1172088/IGN/285/286//none
[186]/0/187/54518/0x4529a050/1528440/IGN/287/288//none
[188]/0/189/28943/0x48294e58/1294394/IGN/289/290/[165]/none
[189]/0/190/14242/0x473824e0/438910/IGN/291/292//none
[190]/0/191/12431/0x462a6718/1327262/IGN/293/294//none
[191]/0/192/50626/0x4529aae0/1221236/IGN/295/296//none
[193]/0/194/40759/0x482958e8/1384940/IGN/297/298//none
[194]/0/195/44401/0x47382f70/1319294/IGN/299/300//none
[195]/0/196/27048/0x462a71a8/217440/IGN/301/302/[165]/none
[196]/0/197/12746/0x4529b570/1151518/IGN/303/304//none
[197]/0/198/59041/0x4429aee0/864920/IGN/305/306//none
[198]/0/199/55253/0x48296378/2040368/IGN/307/308//none
[199]/0/200/12174/0x47383a00/151804/IGN/309/310//none
[200]/0/201/35511/0x462a7c38/1966686/IGN/311/312//none
[202]/0/203/47858/0x4429b970/225528/IGN/313/314//none
[203]/0/204/14523/0x48296e08/1052714/IGN/315/316//none
[280]/0/281/21016/0x462b2538/1343592/IGN/435/436//none
[282]/0/283/49178/0x442a6270/1335450/IGN/437/438//none
[283]/0/284/23307/0x482a1708/1298996/IGN/439/440//none
[284]/0/285/61610/0x4738ed90/840266/IGN/441/442//none
[285]/0/286/14544/0x462b2fc8/385228/IGN/443/444//none
[286]/0/287/23724/0x452a7390/1446134/IGN/445/446//none
[289]/0/290/20012/0x4738f820/1938140/IGN/447/448/[165]/none
[290]/0/291/4384/0x462b3a58/1434214/IGN/449/450//none
[320]/0/321/53019/0x462b79b8/901152/IGN/495/496//none
[321]/0/322/674/0x452abd80/1417530/IGN/497/498//none
[322]/0/323/12673/0x442ab6f0/1409246/IGN/499/500//none
[323]/0/324/27293/0x482a6b88/901796/IGN/501/502//none
[324]/0/325/11580/0x47394210/692540/IGN/503/504//none
[325]/0/326/6321/0x462b8448/877086/IGN/505/506//none
[326]/0/327/18373/0x452ac810/1016424/IGN/507/508//none
[327]/0/328/29947/0x442ac180/180350/IGN/509/510//none
[328]/0/329/52688/0x482a7618/823918/IGN/511/512//none
[348]/0/349/10623/0x482aa058/1241352/IGN/545/546//none
[349]/0/350/52563/0x473976e0/311888/IGN/547/548//none
[350]/0/351/11064/0x462bb918/811588/IGN/549/550//none
[351]/0/352/35672/0x452afce0/361152/IGN/551/552//none
[352]/0/353/63025/0x442af650/1458876/IGN/553/554//none
[353]/0/354/32068/0x482aaae8/1528120/IGN/555/556/[165]/none
[358]/0/359/29916/0x482ab578/1106520/IGN/557/558//none
[359]/0/360/33908/0x47398c00/1356520/IGN/559/560//none
[360]/0/361/52014/0x462bce38/2023942/IGN/561/562//none
[363]/0/364/28284/0x482ac008/1020044/IGN/563/564//none
[365]/0/366/30107/0x462bd8c8/1204236/IGN/565/566//none
[366]/0/367/53347/0x452b1c90/279080/IGN/567/568//none
[367]/0/368/28754/0x442b1600/1405480/IGN/569/570//none
[368]/0/369/17291/0x482aca98/426562/IGN/571/572//none
[370]/0/371/45887/0x462be358/1212800/IGN/573/574//none
[371]/0/372/22522/0x452b2720/1704512/IGN/575/576//none
[372]/0/373/16580/0x442b2090/1413742/IGN/577/578//none
[376]/0/377/44281/0x452b31b0/1286720/IGN/579/580//none
[406]/0/407/57264/0x452b7110/1142990/IGN/623/624//none
[407]/0/408/50431/0x442b6a80/1147162/IGN/625/626//none
[408]/0/409/32370/0x482b1f18/1110764/IGN/627/628//none
[409]/0/410/40637/0x4739f5a0/1372478/SINGLE_NODE_NW/629/630//none
[410]/0/411/60602/0x462c37d8/508172/IGN/631/632//none
[411]/0/412/34697/0x452b7ba0/221766/IGN/633/634//none
[433]/0/434/4138/0x482b53e8/933894/IGN/663/664//none
[434]/0/435/14782/0x473a2a70/2036436/IGN/665/666//none
[436]/0/437/47872/0x452bb070/1716826/IGN/667/668//none
[439]/0/440/34397/0x473a3500/733720/IGN/669/670/[165]/none
[440]/0/441/23594/0x462c7738/844328/IGN/671/672//none
[441]/0/442/56102/0x452bbb00/1577628/IGN/673/674//none
[442]/0/443/26036/0x442bb470/975014/IGN/675/676//none
[443]/0/444/1009/0x482b6908/1635048/IGN/677/678//none
[444]/0/445/18869/0x473a3f90/434342/IGN/679/680//none
[445]/0/446/57506/0x462c81c8/283106/IGN/681/682//none
[446]/0/447/20743/0x452bc590/1585836/IGN/683/684//none
[447]/0/448/42769/0x442bbf00/1901102/IGN/685/686//none
[449]/0/450/52316/0x473a4a20/1372722/IGN/687/688//none
[450]/0/451/41865/0x462c8c58/290924/IGN/689/690//none
[451]/0/452/50824/0x452bd020/950894/IGN/691/692//none
[452]/0/453/10525/0x442bc990/1925674/IGN/693/694/[165]/none
[453]/0/454/27077/0x482b7e28/1479356/IGN/695/696//none
[476]/0/477/24857/0x452c04f0/1237666/IGN/727/728//none
[477]/0/478/30129/0x442bfe60/1471144/IGN/729/730//none
[478]/0/479/10565/0x482bb2f8/1122918/IGN/731/732//none
[479]/0/480/56926/0x473a8980/1258206/IGN/733/734/[165]/none
[507]/0/508/25711/0x442c3dc0/1044948/IGN/777/778//none
[508]/0/509/37477/0x482bf258/201186/IGN/779/780//none
[509]/0/510/22171/0x473ac8e0/1233386/IGN/781/782/[165]/none
[529]/0/530/64234/0x473af320/107034/IGN/817/818/[165]/none
[578]/0/579/6483/0x482c8638/893552/IGN/897/898//none
[580]/0/581/16679/0x462d9ef8/1229476/IGN/899/900//none
====================
END OF HANG ANALYSIS
====================
SWTAS024:/oracle/JDE_Data/export_prod>
SWTAS024:/oracle/JDE_Data/export_prod>

千问 · 2008-2-13 12:43:03

从这些信息中能否看出谁阻塞了谁？

千问 · 2008-2-13 12:43:03

查询v$lock不是更快.

千问 · 2008-2-13 12:43:03

这个是有点复杂的

千问 · 2008-2-13 12:43:03

select * from v$lock,查看锁对象，锁类型，锁级别，id1,id2等等