Sessions hanging
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Nov 2006 15:40:33 -0500
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 ?
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
