CKPT process deadlock in gv$ges_blocking_enqueue

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Wed, 5 Oct 2011 05:33:59 -0700
Message-ID: <CAHDOOG4tSw=ZXVcgW1o2KTnfm-vcnvYs7h6+PbMuaLeiP0+5cA_at_mail.gmail.com>

Hello
Can anyone help me understand why this happens. select inst_id, handle, grant_level, request_level, resource_name1, resource_name2, pid , transaction_id0, transaction_id1  ,owner_node, blocked, blocker, state from gv$ges_blocking_enqueue;

        INST_ID HANDLE           GRANT_LEV REQUEST_L
RESOURCE_NAME1                 RESOURCE_NAME2

PID TRANSACTION_ID0

--------------- ---------------- --------- ---------
------------------------------ ------------------------------
--------------- ---------------
TRANSACTION_ID1      OWNER_NODE         BLOCKED         BLOCKER STATE

--------------- --------------- --------------- ---------------

---

              1 0000000951E49BC8 KJUSEREX  KJUSEREX


[0x19][0x2],[RS]               25,2,RS

11190               0
              0               0               0               1 GRANTED

              2 0000000951E49BC8 KJUSERNL  KJUSEREX


[0x19][0x2],[RS]               25,2,RS

1915               0
              0               1               1               0 OPENING

node 1

oracle 11190 1 0 Sep04 ? 01:12:02 ora_ckpt_OF1PRD1 node2
oracle 1915 1 0 Sep04 ? 01:04:39 ora_ckpt_OF1PRD2

Thank you
Kumar

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 05 2011 - 07:33:59 CDT