DEADLOCKDETECTED(ORA-00060)(五)

2014-11-24 15:45:43 · 作者: · 浏览: 3
01 lock=N pin=0 latch#=35 hpc=fc06 hlc=fc06
lwt=700000cd7ebcdb0[700000cd7ebcdb0,700000cd7ebcdb0] ltm=700000cd7ebcdc0[700000cd7ebcdc0,700000cd7ebcdc0]
pwt=700000cd7ebcd78[700000cd7ebcd78,700000cd7ebcd78] ptm=700000cd7ebcd88[700000cd7ebcd88,700000cd7ebcd88]
ref=700000cd7ebcde0[700000cd7ebcde0,700000cd7ebcde0] lnd=700000cd7ebcdf8[700000cd7e039c0,700000cd7ec5318]
LIBRARY OBJECT: object=700000cace600d8
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 700000cace5ff88 700000cace5fae8 700000cd7ebc460
1 700000cace5ff88 700000cacacd478 700000cd7d6b9d8
2 700000cace5ff88 700000cac7e9398 700000cd7c840e8
3 700000cace5ff88 700000b9a865140 700000bceb1aca8
4 700000cace5ff88 700000b9ad05c40 700000bcea501c8
5 700000cace5ff88 700000be8c01768 700000cd77f72d8
6 700000cace5ff88 700000b538eadb8 700000cd7270e60
7 700000cace5ff88 700000cac149578 700000cd7d76320
8 700000cace5ff88 700000cacbcdba8 700000cd7c79560
9 700000cace5ff88 700000cac7c4be0 700000c494053b0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 700000cd7ed7b10 700000cace601f0 I/P/A/-/- 0 NONE 00
----------------------------------------
SO: 700000cb52fa9d0, type: 40, owner: 700000cd047d060, flag: INIT/-/-/0x00
(trans) flg = 0x1e03, flg2 = 0xc0000, prx = 0x0, ros = 2147483647 bsn = 0x1ae8cb bndsn = 0x1ae8ce spn = 0x1ae8fe
efd = 4
file:kta.c lineno:1443
DID: 0001-0208-00024147
parent xid: 0x0000.000.00000000
env: (scn: 0x0c80.e5b63a1f xid: 0x0006.008.0006c82d uba: 0x00920c63.7d1b.18 statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0c80.e5b63a21 0sch: scn: 0x0000.00000000)
cev: (spc = 5162 arsp = 700000cb83e5168 ubk tsn: 1 rdba: 0x00920c63 useg tsn: 1 rdba: 0x00800059
hwm uba: 0x00920c63.7d1b.18 col uba: 0x00000000.0000.00
num bl: 1 bk list: 0x700000cb410d118)
cr opc: 0x0 spc: 5162 uba: 0x00920c63.7d1b.18
(enqueue) TX-00060008-0006C82D DID: 0001-0208-00024147
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x6
mode: X, lock_flag: 0x0, lock: 0x700000cb52faa08, res: 0x700000cd05ee608
own: 0x700000cd047d060, sess: 0x700000cd047d060, proc: 0x700000cd0334588, prv: 0x700000cd05ee618
xga: 0x0, heap: UGA
Trans IMU st: 0 Pool index 65535, Redo pool 0x700000cb52fb0b8, Undo pool 0x700000cb52fb1a0
Redo pool range [0x1103ca6d0 0x1103ca6d0 0x1103cced0]
Undo pool range [0x1103c7ed0 0x1103c7ed0 0x1103ca6d0]
----------------------------------------
SO: 700000cb50d1740, type: 36, owner: 700000cb52fa9d0, flag: INIT/-/-/0x00
DML LOCK: tab=176729 flg=11 chi=0
his[0]: mod=3 spn=1763581
(enqueue) TM-0002B259-00000000 DID: 0001-0208-00024147
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x6
mode: SX, lock_flag: 0x0, lock: 0x700000cb50d1768, res: 0x700000cd0625c40
own: 0x700000cd047d060, sess: 0x700000cd047d060, proc: 0x700000cd0334588, prv: 0x700000cb50cfc30
----------------------------------------
SO: 700000cb50d1620, type: 36, owner: 700000cb52fa9d0, flag: INIT/-/-/0x00
DML LOCK: tab=176711 flg=11 chi=0
his[0]: mod=3 spn=1763579
(enqueue) TM-0002B247-00000000 DID: 0001-0208-00024147
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x6
mode: SX, lock_flag: 0x0, lock: 0x700000cb50d1648, res: 0x700000cd05ecd50
own: 0x700000cd047d060, sess: 0x700000cd047d060, proc: 0x700000cd0334588, prv: 0x7000