Re: Oracle/Solaris

  • From: przemolicc@xxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 14 Sep 2011 09:13:07 +0200

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.

Przemyslaw Bak (przemol)

Skoda Octavia z 2009 roku juz za 11 tys. zl

Other related posts: