Re: Oracle stops responding

See below ...

Tore Skogly wrote:
> I am experiencing some problems with an Oracle 9.2.0.1 database on RedHat
> 8.0 (I know it is not a supported plattform by Oracle...)
This could be the problem.

>
> My hardware is a dual Xeon system with 2 GB memory.
>
> The problem is as follows:
> From time to time Oracle stops responding. From what I have seen this can
> occur when I try to delete lot of records (for instance 100000 or more)
> from a table.

So what kind of waits are you experieincing? Look at v$system_event and v$wait. Alternatively, you can set event 10046 at level 8 - see the admin docs or metalink on how to do this.

[ snip ]

--
Ron Reidy
Oracle DBA