Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Sessions hanging
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>
-- 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_at_rogers.com http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 27 2006 - 14:40:33 CST
![]() |
![]() |