DEADLOCK DETECTED ( ORA-00060 )(二)

2014-11-24 17:28:18 · 作者: · 浏览: 2
O: 700000cd3571ce8, type: 11, owner: 700000cd0334588, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 700000cd0334588,
event: 452466, last message event: 452466,
last message waited event: 452466, next message: 0(0), messages read: 0
channel: (700000cd18604d8) system events broadcast channel
scope: 2, event: 462728, last mesage event: 29,
publishers/subscribers: 0/533,
messages published: 1
heuristic msg queue length: 0
----------------------------------------
SO: 700000cafcccfd8, type: 3, owner: 700000cd0334588, flag: INIT/-/-/0x00
(call) sess: cur 700000cd047d060, rec 0, usr 700000cd047d060; depth: 0
----------------------------------------
SO: 700000cd14fbbb0, type: 5, owner: 700000cafcccfd8, flag: INIT/-/-/0x00
(enqueue) TX-0056002B-00033647 DID: 0001-0208-00024147
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x6
req: X, lock_flag: 0x0, lock: 0x700000cd14fbbd0, res: 0x700000cd05f3608
own: 0x700000cd047d060, sess: 0x700000cd047d060, proc: 0x700000cd0334588, prv: 0x700000cd14fb748
----------------------------------------
SO: 700000caeec89e0, type: 54, owner: 700000cafcccfd8, flag: INIT/-/-/0x00





lock.............lk@

handle...........Address of object handle for this lock.

mode.............Lock mode held. Same format as pin mode held.

request..........Lock mode requested. Same format as mode.

call pin.........Address of pin that is pinning this object for the call.

session pin......Address of pin that is pinning this object for the session.

user.............Address of user session holding this lock.

session..........Address of session holding this lock.

count............Reference count.

flags............Status flags. Format is %s[%02x].

0x01 - This lock is broken. [BRO]

0x02 - This lock can be broken. [CBB]

@@ only certain types can be broken. See KGLLKCBB

0x04 - The call pin is a valid pin for the call [PNC]



lock.............Current lock mode (0, N, S or X).

pin..............Current pin mode (0, S or X).

latch............Associated child latch identifier.

lwt..............latch address[nxt,prv] @@ kglhdlwt, kgglknxt, kgglkprv

ltm..............As above but with kglhdltm @@

pwt..............As above but with kglhdpwt @@

ptm..............As above but with kglhdptm @@

ref..............@@@


0x08 - The session pin is a valid pin for the session [PNS]

0x10 - This lock is in CGA memory. [CGA]

+ flag dumped in the brackets [02x]

savepoint........Savepoint number when this was acquired