Re: ORACLE.EXE takes 100% of CPU

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Jul 2002 20:00:48 +0200
Message-ID: <c1ioju8bn609a6cgk84nrhcrrdukponmf8@4ax.com>

On Mon, 22 Jul 2002 19:38:18 +0200, "Ivek" <ivek_at_kliet.com> wrote:

>Windows 2000 Server, SP1
>Oracle 8.1.6.0.0 EE
>
>My ORACLE.EXE suddenly started to take 100% of CPU time which suffocates
>other vital processes on the server and
>prevents the system from functioning.
>
>This happened after a crash today early in the morning. Recovery process
>completed successfully (I can that see it in logs).
>
>What else could be the cause of ORACLE.EXE hogging the system?
>
>
>
>

1 sql statements resulting in a merge join cartesian 2 excessive parsing
3 excessive sorting

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 22 2002 - 13:00:48 CDT