From: chrise@shore.net (Chris Eastland)
Subject: Re: HAnging ORACLE database
Date: 1997/07/07
Message-ID: <5pr23v$j86@shell2.shore.net>#1/1
References: <5pb7bi$f5m@scel.sequent.com> <5pbk6u$9jj@nntp.interaccess.com> <5pcmcu$qrt@cerberus.umd.umich.edu> <33BABE0A.126A@sequent.com>
Organization: Chris Eastland
Newsgroups: comp.databases.oracle,comp.databases.oracle.server,comp.databases.oracle.tools



Vikas Gautam <gautam@sequent.com> writes:

>Nathan,
>	Thanks for your email. The problem is that after the database hangs, I
>cannot read the locks tables or do any kind of checking. Thats the
>tricky thing. It seems to be very random. 
 
>Vikas


What is the load on the system as a whole when this happens? Are you hitting
process limits. Do you have free memory. Are you at 100% on any of the disks.