Re: cpu pegged, need cause

CPU is usually logical I/O

Start with v$sess_io for the sid doing most logical I/O

Then go to v$session to check the sql_hash_value for that SID if it keeps changing that's a bit of a pain, but you can then go to v$sql with the hash_value to find the guiltySQL.

NB Best to do it in 3 steps rather than one big SQL when CPU is thrashing - see the notes on my web site

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

aaronurbain_at_bigfoot.com wrote in message <7td7tp$4l5$1_at_nnrp1.deja.com>...
>7.3.3 on nt40sp3.
>
>The cpu has been pegged for two hours. Top Sessions cpu report shows 20
>users, most idle and the rest using minimal cpu. Task manager shows
>Oracle using 99% cpu.
>
>The last time this happened, I had all users log off. One remained and
>I killed the session, and only then did cpu usage fall which makes me
>think something was amiss with the session. Alert log contained
>nothing.
>
>How can I determine where Oracle is spending all this cpu? V$?
>
>-Aaron
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Oct 05 1999 - 11:24:18 CDT