Re: 8i 8.1.7 & win2k --> cpu overload

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 13 May 2002 18:37:44 +0200
Message-ID: <hrqvduk9sla67pcspt47pcjbg2uephcrjo@4ax.com>

On Mon, 13 May 2002 14:53:41 +0200, "Jerome Baton" <jbaton_at_oxymel.com> wrote:

>Hi all,
>
>Does anyone know why the oracle process uses 99 % of the cpu ... sometimes
>This of course without any appearing reason.
>
>I know this is a bit short for a diagnostic but an idea putting me on the
>good path would be great.
>
>The box is a P4 1.8ghz running oracle 8i (v8.1.7) on w2k w/ scsi drives
>
>
>Thank you
>
>Jerome
>

So *which* Oracle process?
v$sesstat show how much processor time a process is consuming.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 13 2002 - 11:37:44 CDT