DEADLOCKDETECTED(ORA-00060)(三)

2014-11-24 15:45:43 · 作者: · 浏览: 6
eq: 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