Re: Production db server getting freezed

From: William Muriithi <william.muriithi@xxxxxxxxxxxxxxxxxxx>

To: "howard.latham@xxxxxxxxx" <howard.latham@xxxxxxxxx>

Date: Sat, 5 Feb 2011 11:15:10 -0600

Is the storage for this system external? SAN to NAS I mean? It may be the
storage connectivity is getting lost once in a while.
There could be other reasons like cron job that is taking all resources or a
failing hardware. You will have to poke around until you can find it. It help
if you are graphing the system's statistics with for example cacti as you can
identify a trend, or interaction of different system's statistics.
William
On 2011-02-05, at 11:09 AM, Howard Latham wrote:
> how long does the freeze last? we have this too.
>
> On 5 February 2011 15:58, Andrew Kerber
> <andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>> wrote:
> Get a look at disk, swap, and cpu usage and open a sev 1 sr with mos. We
> really cant tell anything with the information you have provided.
>
> Sent from my HTC Tilt™ 2, a Windows® phone from AT&T
>
> ________________________________
> From: KRISHNA MOORTHY
> <krish33moorthy@xxxxxxxxx<mailto:krish33moorthy@xxxxxxxxx>>
> Sent: Saturday, February 05, 2011 0:30
> To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx<mailto:Oracle-L@xxxxxxxxxxxxx>>
> Subject: Production db server getting freezed
>
>
> Hi
>
> Our production database server is getting frrezed suddenly yesterday..There
> is no deadlock or any unknown errors in alert log file.
>
> Oracle database version : 10.0.2.0
> OS : RedHatLinux 5.2
>
> Please share your thoughts to analyze the issue.What kind of logs or settings
> i need to look in to this issue at OS level and db level.
>
> Regards
> Krishna
>
>
>
> --
> Howard A. Latham
>
> Sent from my Nokia N97
>
--
http://www.freelists.org/webpage/oracle-l