Re: CKPT process deadlock in gv$ges_blocking_enqueue

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Wed, 5 Oct 2011 06:04:40 -0700
Message-ID: <CAHDOOG4qE8iXyGt9GPJ2OdC+4tUYoQdsLOA_fm9FMJVTgDi=iQ_at_mail.gmail.com>

I see this in all rac databases. This looks like expected behavior. - Kumar

On Wed, Oct 5, 2011 at 5:33 AM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:

> 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 - 08:04:40 CDT