Re: CKPT process deadlock in gv$ges_blocking_enqueue
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2011 06:04:40 -0700
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@xxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
