Re: Oracle/Solaris
From: <przemolicc_at_poczta.fm>
Date: Wed, 14 Sep 2011 09:13:07 +0200
Message-ID: <20110914071307.GC14845_at_host.pgf.com.pl>
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.
Date: Wed, 14 Sep 2011 09:13:07 +0200
Message-ID: <20110914071307.GC14845_at_host.pgf.com.pl>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 14 2011 - 02:13:07 CDT