DEADLOCK DETECTED ( ORA-00060 )(一)

2014-11-24 17:28:18 · 作者: · 浏览: 1

LIBRARY OBJECT HANDLE: handle=700000cdbd16378 mtx=700000cdbd164a8(0) lct=1153 pct=353019 cdp=0
name=CUECM.CUECM
hash=6d403276b57f649433d0b74590d7e2b9 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch#=3 hpc=0900 hlc=0900
lwt=700000cdbd16420[700000cdbd16420,700000cdbd16420] ltm=700000cdbd16430[700000cdbd16430,700000cdbd16430]
pwt=700000cdbd163e8[700000cdbd163e8,700000cdbd163e8] ptm=700000cdbd163f8[700000cdbd163f8,700000cdbd163f8]
ref=700000cdbd16450[700000cdbd16450,700000cdbd16450] lnd=700000cdbd16468[700000cdbd16468,700000cdbd16468]
LIBRARY OBJECT: object=700000ca3f26a70
type=EVNT flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 700000cdbd162b8 700000ca3f26bc8 I/-/A/-/- 0 NONE 00
3 700000ca3f26c08 700000ca0e41460 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 700000b19deca88, type: 52, owner: 700000cd047d060, flag: INIT/-/-/0x00
user lock: lock=700000b19deca88 mode=S
user resource: user=700000cae541a40 uid=191 mode=S
----------------------------------------
SO: 700000b18121008, type: 52, owner: 700000cd047d060, flag: INIT/-/-/0x00
user lock: lock=700000b18121008 mode=S
user resource: user=700000cae541a40 uid=191 mode=S
----------------------------------------
SO: 700000cb83c1f78, type: 41, owner: 700000cd047d060, flag: INIT/-/-/0x00
(dummy) nxc=1, nlb=1
----------------------------------------
SO: 700000cb52f35a0, type: 40, owner: 700000cb83c1f78, flag: INIT/-/-/0x00

(trans) flg = 0x04, flg2 = 0x00, prx = 0x700000cb52fa9d0, ros = 2147483647 bsn = 0x1ae8f5 bndsn = 0x1ae8f5 spn = 0x1ae8f6
efd = 4
file:aud.c lineno:1214
DID: 0000-0000-00000000
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.00000000 xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 statement num=0 parent xid: xid: 0x0000.000.00000000 scn: 0x0000.00000000 0sch: scn: 0x0000.00000000)
cev: (spc = 0 arsp = 0 ubk tsn: 0 rdba: 0x00000000 useg tsn: 0 rdba: 0x00000000
hwm uba: 0x00000000.0000.00 col uba: 0x00000000.0000.00
num bl: 0 bk list: 0x0)
cr opc: 0x0 spc: 0 uba: 0x00000000.0000.00
(enqueue) released enqueue or enqueue in flux
lock_flag: 0x0, lock: 0x700000cb52f35d8, res: 0x700000cd05dd1f8
own: 0x700000cd047d060, sess: 0x700000cd047d060, prv: 0x700000cb52f35e8
xga: 0x0, heap: UGA
Trans IMU st: 2 Pool index 65535, Redo pool 0x700000cb52f3c88, Undo pool 0x700000cb52f3d70
Redo pool range [0x0 0x1103e7fb0 0x1103ea7b0]
Undo pool range [0x0 0x1103e57b0 0x1103e7fb0]
----------------------------------------
SO: 700000c9e2aa388, type: 39, owner: 700000cb83c1f78, flag: -/-/-/0x00
(List of Blocks) next index = 4
index itli buffer hint rdba savepoint
-----------------------------------------------------------
0 2 0x70000016fff7c38 0xc96c94d 0x1ae49d
1 22 0x70000066bfa3c28 0x9137721 0x1ae4ba
2 2 0x7000006e8f93e38 0x31e381c 0x1ae4bc
3 3 0x700000117fd6c28 0x19c85f3 0x1ae4c8
----------------------------------------
S