Re: Weird database hanging

  • From: "Alex Gorbachev" <ag@xxxxxxxxxxxx>
  • To: vishal@xxxxxxxxxxxxxxxxx
  • Date: Wed, 19 Sep 2007 04:31:37 -0400

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@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: