kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=1 hpc=8cfe hlc=8cfe
lwt=700000cd6e94460[700000cd6e94460,700000cd6e94460] ltm=700000cd6e94470[700000cd6e94470,700000cd6e94470]
pwt=700000cd6e94428[700000cd6e94428,700000cd6e94428] ptm=700000cd6e94438[700000cd6e94438,700000cd6e94438]
ref=700000cd6e94490[700000cd6e94490,700000cd6e94490] lnd=700000cd6e944a8[700000cd6e944a8,700000cd6e944a8]
LIBRARY OBJECT: object=700000ca9df62b0
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=32
child# table reference handle
------ -------- --------- --------
0 700000ca9df6160 700000ca9df5cc0 700000cd6e94188
1 700000ca9df6160 700000ca9dc1f80 700000cd6e7d8b0
2 700000ca9df6160 700000ca9c46200 700000cd6e02da8
3 700000ca9df6160 700000c89cda488 700000cd6a32fa0
4 700000ca9df6160 700000c89cb50e8 700000cd6a2ab48
5 700000ca9df6160 700000c89c3eec8 700000cd6a10bd8
6 700000ca9df6160 700000c89bf29d0 700000cd6a16428
7 700000ca9df6160 700000c89aec600 700000cd69afc98
8 700000ca9df6160 700000c89a02750 700000cd696f638
9 700000ca9df6160 700000c89939788 700000cd6933770
10 700000ca9df6160 700000c8925a618 700000cd673f7c0
11 700000ca9df6160 700000c4d74c530 700000cd644cb08
12 700000ca9df6160 700000c4d19bf68 700000cd62b9110
13 700000ca9df6160 700000c0eb3c030 700000cd612c1d8
14 700000ca9df6160 700000bcc1cf3b0 700000bf39564f0
15 700000ca9df6160 700000b14df18e0 700000b18f17e30
16 700000b14df19f8 700000c4d475738 700000cd6ca9110
17 700000b14df19f8 700000c893e41a0 700000bf32629b8
19 700000b14df19f8 700000c4daa6ee0 700000bf37d38a0
20 700000b14df19f8 700000c4d731b58 700000b18e5f288
21 700000b14df19f8 700000c4dfff140 700000b18640318
22 700000b14df19f8 700000b52bba898 700000b18314e78
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 700000cd6e942f8 700000ca9df63c8 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 700000c98c678b0, type: 53, owner: 700000cd047d060, flag: INIT/-/-/0x00
通过该段内容我没有看出什么问题来，但是我获得了很多有用的信息，如当前堵塞会话的sql就在其中，且我获得了object handel地址： handle=700000cd6e943b8，该用户在library cache中的信息
user=700000cd047d060 session=700000cd047d060 count=1 flags=[0000] savepoint=0x5330e331
LIBRARY OBJECT HANDLE: handle=700000cd6e943b8 mtx=700000cd6e944e8(4) lct=379499 pct=1 cdp=4
htl=700000c98ff6290[700000ae75279e8,700000c430397a0] htb=700000ae75279e8 ssga=700000ae7526aa0
user=700000cd047d060 session=700000cd047d060 count=1 flags=[0000] savepoint=0x5330e331
LIBRARY OBJECT: object=700000ca9df62b0
继续看啊，分析如下信息：
LIBRARY OBJECT LOCK: lock=700000c981e53b0 handle=700000cd7ebcd08 mode=N
call pin=0 session pin=0 hpc=0000 hlc=0000
htl=700000c981e5430[700000ae75273e8,700000c9809c3a8] htb=700000ae75273e8 ssga=700000ae7526aa0
user=700000cd047d060 session=700000cd047d060 count=1 flags=[0000] savepoint=0x5330e331
LIBRARY OBJECT HANDLE: handle=700000cd7ebcd08 mtx=700000cd7ebce38(6) lct=1172176 pct=1 cdp=6
name=INSERT INTO T_CONTRACT_CHANGED SELECT ID,SYSDATE FROM T_CONTRACT_CONTENT T WHERE T.AFFAIRID=:B1
hash=ea90bb8989793260486f86d42172bf83 timestamp=02-13-2014 22:16:32
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/KST/DBN/MTX/[500100d0]
kkkk-dddd-llll=0000-0001-00