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