Re: Production db server getting freezed

From: William Muriithi <william.muriithi_at_epicadvertising.com>
Date: Sat, 5 Feb 2011 11:15:10 -0600
Message-ID: <CE08CA6A-DE1D-420A-A4FE-FC531C6CDF48_at_epicadvertising.com>

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_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> 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_at_gmail.com<mailto:krish33moorthy_at_gmail.com>>
> Sent: Saturday, February 05, 2011 0:30
> To: oracle Freelists <Oracle-L_at_freelists.org<mailto:Oracle-L_at_freelists.org>>
> 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

Received on Sat Feb 05 2011 - 11:15:10 CST