Re: Sessions hanging

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Mon, 27 Nov 2006 16:42:55 -0500
Message-id: <1164663775l.2694l.0l@medo.noip.com>

On 11/27/2006 03:40:33 PM, Ranko Mosic wrote:
> Hi List,
> This is hanganalyze dump file:
>
> Found 15 objects waiting for <cnode/sid/sess_srno/proc_ptr/ospid/wait_event>
> <0/190/6488/0xdb6bde98/12701/library cache lock>
> Open chains found:
> Chain 1 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
> <0/79/27/0xdb6dc6a0/15367/No Wait>
> -- <0/190/6488/0xdb6bde98/12701/library cache lock>
> -- <0/185/318/0xdb6dad78/23551/library cache lock>
> -- <0/12/144/0xdb6d2fb0/1666/library cache pin>
> Other chains found:
> Chain 2 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
> <0/16/66/0xdb6dc198/23559/library cache lock>
> Chain 3 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
> <0/17/100/0xdb6c5c60/23962/library cache pin>
> Chain 4 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
> <0/32/12/0xdb6dcba8/15369/No Wait>
> Chain 5 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
> <0/39/1075/0xdb6e0d10/22710/library cache pin>
>
> --
>
> shared_pool_size is 160M. sga is 1.7g.
>
> Would increase help ?

Ranko, what do V$SGASTAT and V$RESOURCE_LIMIT tell you? What is the name space (P3) of that pin/lock? May be pinning it in the SGA would help? Your shared pool size is very small compared to the rest of the SGA. What is the rest of the SGA being used for?

-- 
Mladen Gogala
http://www.mladen-gogala.com

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

Received on Mon Nov 27 2006 - 15:42:55 CST