Re: Oracle/Solaris

From: ~Jeff~ <jifjif_at_gmail.com>
Date: Wed, 14 Sep 2011 09:43:57 +1200
Message-ID: <CANz7uMbVjR-6ee5CwnL2gwCSrsqwZKhfMeaiX1HjCRGqwvfP4A_at_mail.gmail.com>

Sanjay -
It sounds like the problem is not in the DB, if existing connections function ok.

Since "ls" works but "ls -ltr" hangs as do new dedicated? connections (both require process creation), I would ask the SysAdmins - are you hitting the OS process limit ?

-Jeff

On 14 September 2011 07:56, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> i had one big OLTP environment running on Solaris 10 with 256G RAM and 30+
> CPU. There are sometime in a day when all OS command are totally freezed.
> Even ls command take several minute. CPU was showing more than 60% idle. If
> I am connected to database, then call to check Db like locks or other query
> works fine. What can be the issue to be checked more closely. Also
> Application trying to connect from outside are affected.
> TIA
> Sanjay
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 13 2011 - 16:43:57 CDT