深入理解Oracle中的Mutex(7)

　　htl=0x8e6bd598[0x8e542f60,0x979da4d0] htb=0x979da4d0 ssga=0x979d96c8

　　user=a841bd18 session=a841bd18 count=1 flags=CBK[0020] savepoint=0×0

　　LIBRARY OBJECT HANDLE: handle=a7864b08 mtx=0xa7864c38(0) lct=2 pct=3 cdp=0

　　namespace=CRSR flags=RON/KGHP/PN0/EXP/[10010100]

　　kkkk-dddd-llll=0000-0001-0001 lock=N pin=X latch#=3 hpc=0002 hlc=0002

　　lwt=0xa7864bb0[0xa7864bb0,0xa7864bb0] ltm=0xa7864bc0[0xa7864bc0,0xa7864bc0]

　　pwt=0xa7864b78[0xa7864b78,0xa7864b78] ptm=0xa7864b88[0xa7864b88,0xa7864b88]

　　ref=0xa7864be0[0x954eb320,0x954eb320] lnd=0xa7864bf8[0xa7864bf8,0xa7864bf8]

　　LIBRARY OBJECT: object=95ac6128

　　type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0

　　DATA BLOCKS:

　　data# heap pointer status pins change whr

　　—- ——- ——- ——— —- —— —

　　0 8d81aa70 95ac6240 I/P/A/-/- 0 NONE 00

　　6 954eb0f0 8fd90128 I/P/A/-/E 0 NONE 00

　　并行执行6个SQL语句 并做systemstate dump :

　　[oracle@vrh8 ~]$ grep SHRD /s01/admin/G10R25/udump/g10r25_ora_32716.trc |grep 0×95987388

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

　　Mutex 0×95987388(0, 6) idn 7fff8f32fff6 oper SHRD

原文转自：http://blogread.cn/it/article/6410