On Tue, Sep 13, 2011 at 12:56:44PM -0700, Sanjay Mishra 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. Is it possible to get 'vmstat 1', 'iostat -xnzC 1' and 'prstat' while you get these problems ? If you run them (and log) before these freezes (just try to predict) it would help a lot. Regards Przemyslaw Bak (przemol) -- http://przemol.blogspot.com/ ---------------------------------------------------------------- Skoda Octavia z 2009 roku juz za 11 tys. zl http://linkint.pl/f2a36 -- //www.freelists.org/webpage/oracle-l