深入理解Oracle中的Mutex(6)

　　txn branch: (nil)

　　oct: 0, prv: 0, sql: 0x8d88bf90, psql: (nil), user: 0/SYS

　　service name: SYS$USERS

　　O/S info: user: oracle, term: pts/5, ospid: 32510, machine: vrh8.oracle.com

　　program: sqlplus@vrh8.oracle.com (TNS V1-V3)

　　application name: sqlplus@vrh8.oracle.com (TNS V1-V3), hash value=543908804

　　waiting for ‘cursor: pin S wait on X’ wait_time=0, seconds since wait started=0

　　idn=7abadecf, value=9100000000, where|sleeps=500003645

　　blocking sess=0x(nil) seq=13901

　　Dumping Session Wait History

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.266596 sec

　　idn=7abadecf, value=9100000000, where|sleeps=500003644

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.010679 sec

　　idn=7abadecf, value=9100000000, where|sleeps=500003643

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.010633 sec

　　idn=7abadecf, value=9100000000, where|sleeps=500003642

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.010843 sec

　　idn=7abadecf, value=9100000000, where|sleeps=500003641

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.011008 sec

　　idn=7abadecf, value=9100000000, where|sleeps=500003640

　　for ‘cursor: pin S wait on X’ count=1 wait_time=0.010406 sec

　　SO: 0xa8416738, type: 4, owner: 0xa830bfa8, flag: INIT/-/-/0×00

　　(session) sid: 145 trans: (nil), creator: 0xa830bfa8, flag: (80000041) USR/- BSY/-/-/-/-/-

　　DID: 0001-0017-0000008E, short-term DID: 0000-0000-00000000

　　txn branch: (nil)

　　oct: 3, prv: 0, sql: 0x8d88bf90, psql: (nil), user: 0/SYS

　　service name: SYS$USERS

　　O/S info: user: oracle, term: pts/4, ospid: 32485, machine: vrh8.oracle.com

　　program: sqlplus@vrh8.oracle.com (TNS V1-V3)

　　application name: sqlplus@vrh8.oracle.com (TNS V1-V3), hash value=543908804

　　waiting for ‘library cache lock’ wait_time=0, seconds since wait started=165

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　blocking sess=0x(nil) seq=9

　　Dumping Session Wait History

　　for ‘library cache lock’ count=1 wait_time=3.297287 sec

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　for ‘library cache lock’ count=1 wait_time=2.930321 sec

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　for ‘library cache lock’ count=1 wait_time=2.930856 sec

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　for ‘library cache lock’ count=1 wait_time=2.930698 sec

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　for ‘library cache lock’ count=1 wait_time=2.931518 sec

　　handle address=a7115ef0, lock address=978def20, 100*mode+namespace=c9

　　SO: 0x978def20, type: 53, owner: 0xa8456058, flag: INIT/-/-/0×00

　　LIBRARY OBJECT LOCK: lock=978def20 handle=a7115ef0 request=S

　　call pin=(nil) session pin=(nil) hpc=0005 hlc=0000

　　htl=0x978defa0[0x8e4a8950,0x8e4a8950] htb=0x8e4a8950 ssga=0x8e4a7a88

　　user=a8416738 session=a8416738 count=0 flags=RES/[0010] savepoint=0x1f

　　LIBRARY OBJECT HANDLE: handle=a7115ef0 mtx=0xa7116020(0) lct=8 pct=10 cdp=0

　　name=SYS.MAC_KKS

　　hash=c066b9b9c6c80736a15f5ba325563fdb timestamp=04-14-2013 00:43:14

　　namespace=TABL flags=KGHP/TIM/SML/[02000000]

　　kkkk-dddd-llll=0000-0701-0201 lock=X pin=X latch#=3 hpc=0006 hlc=0004

　　lwt=0xa7115f98[0x978def50,0x978def50] ltm=0xa7115fa8[0xa7115fa8,0xa7115fa8]

　　pwt=0xa7115f60[0xa7115f60,0xa7115f60] ptm=0xa7115f70[0xa7115f70,0xa7115f70]

　　ref=0xa7115fc8[0xa7115fc8,0xa7115fc8] lnd=0xa7115fe0[0x9cc2c260,0xa79fd198]

　　LIBRARY OBJECT: object=95f0e5b0

　　type=TABL flags=EXS/LOC/UPD[0905] pflags=[0000] status=VALD load=0

　　DATA BLOCKS:

　　data# heap pointer status pins change whr

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

　　0 a78d3840 95f0e708 I/P/A/-/- 0 NONE 00

　　8 957a6ad8 94461f88 I/P/A/-/- 1 UPDATE 00

　　Mutex 0x954eaff8 被 SID=145 oper EXCL以X mode Hold 该Mutex

　　体现为 子游标child cursor被以 X mode pin

　　SO: 0x8e6bd518, type: 53, owner: 0xa841bd18, flag: INIT/-/-/0×00

　　LIBRARY OBJECT LOCK: lock=8e6bd518 handle=a7864b08 mode=N

　　call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

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