Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sessions hanging

Sessions hanging

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Mon, 27 Nov 2006 15:40:33 -0500
Message-ID: <367369f10611271240g512a792bufaa94f89ff12d6a8@mail.gmail.com>


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-l
Received on Mon Nov 27 2006 - 14:40:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US