I've got some issues on a 3 node RAC system (12c) with TT enqueues. I have
a few ideas, but to confirm I need to see the order of the enqueues in the
linked list with respect to my resource. The problem does not exist at the
moment but I have system state dumps (level 266) from all three nodes. It
looks like I can go to the enqueue State Object and then reference the slk
(some kind of lock?) parameter to get to what looks like a linked list for
a single node. But I am not sure how to traverse that or to get other node
info. Anyone else ever try this?
----------------------------------------
SO: 0x5291c6090, type: 10, owner: 0x83ce7d18, flag:
INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x558ccce60, name=enqueue, file=ksq1.h LINE:447, pg=0
conuid=0
(enqueue) TT-0000000E-00000000-00000000-00000000 DID:
0001-00B2-00001E15
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res_flag: 0x3
req: S, lock_flag: 0x10, lock: 0x5291c6108, res: 0x5496ab788
own: 0x538e80fd0, sess: 0x538e80fd0, proc: 0x558ccce60, prv:
0x5291c5600
slk: 0x532220d50
----------------------------------------
SO: 0x532220d50, type: 35, owner: 0x5515aa1e8, flag: INIT/-/-/0x00
if: 0x1 c: 0x1
proc=0x558ccce60, name=ges enqueues, file=kjl.h LINE:657, pg=0
conuid=0
----------enqueue 0x532220d50------------------------
.
.
.
GRANTED_Q:
lp 0x532221718 gl KJUSERPR rp 0x54a066170 [0xe][0x0],[TT][ext 0x0,0x0]
master 1 gl owner 0x538e80fd0 possible pid 16277 xid
B2000-0001-00001E15 rseq 3063 mseq 0 bast none
history REF_RES > LOC_AST > CLOSE > FREE > REF_RES > LOC_AST
open opt KJUSERDEADLOCK KJUSERIDLK sec since grant 38010
lp 0x4f24145d0 gl KJUSERPR rp 0x54a066170 [0xe][0x0],[TT][ext 0x0,0x0]
master 1 owner 2 rseq 2553 mseq 0x20004 bast fired 37997 sec ago
history REM_BAST > MSGSENT > REM_AST > MSGSENT > REM_BAST > MSGSENT
open opt KJUSERNO_XID sec since grant 41404
CONVERT_Q:
lp 0xdabad7c8 gl KJUSERNL rl KJUSEREX rp 0x54a066170
[0xe][0x0],[TT][ext 0x0,0x0]
master 1 owner 3 rseq 2509 mseq 0x10001 bast armed
history FREE > REF_RES > REM_AST > REM_AST > MSGSENT > GR2CVT
convert opt KJUSERGETVALUE
lp 0x552886980 gl KJUSERNL rl KJUSERPR rp 0x54a066170
[0xe][0x0],[TT][ext 0x0,0x0]
master 1 gl owner 0x540f96888 possible pid 16303 xid
B7000-0001-00007620 rseq 3063 mseq 0 bast none
history REF_RES > LOC_AST > CLOSE > FREE > REF_RES > GR2CVT
Thanks.
Henry