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 > -- //www.freelists.org/webpage/oracle-l