Re: Weird database hanging

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Wed, 19 Sep 2007 04:31:37 -0400
Message-ID: <c2213f680709190131sf6784bfr170b8a3a53a0cea9@mail.gmail.com>

Vishal, do you think that this would cause instance hangs and inability to connect locally via bequeath protocol?

On 9/19/07, Vishal Gupta <vishal_at_vishalgupta.co.uk> wrote:
>
>
>
>
> It could be that your database is having too many incoming connection. On
> Solaris default for listener is to accept 5 concurrent connection request.
> Try increasing QUEUE_SIZE in listener.ora and reload the listener. Verify
> that changes have taken place by verifying in lsnrctl status.
>
>
>
> http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/listener.htm#sthref781
>
>
>
> Cheers,
>
> Vishal Gupta

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 19 2007 - 03:31:37 CDT