Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HAnging ORACLE database
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
Nathan Hughes wrote:
>
> > Vikas Gautam (gautam_at_sequent.com) wrote:
> >: Hi,
> >: I am having a consistent problem in my 7.3.2.3 ORACLE database on
> >: a UNIX machine (Sequent). The problem is that the database seems to
> >: hang at non-deciphered times and the hanging is not due to a consistent
> >: set of jobs.
> [...]
>
> I've had a similar problem, that I troubleshooted down to database corruption
> in a system/data dictionary table. Do full database exports work? Does