Re: oracle cpu usage

Take the windows performance monitor and monitor cpu usage on all oracle threads. The process number of the thread escalating is the pid in v$process. Join the spid from this row to v$session and get sid, serial# and further to v$sql, v$sqlarea, v$open_cursors,..... and you will be able to find what you are looking for.

rgds
/Svend Jensen

Pinto wrote:

> Hello,
> In our testbed where we are testing our application, i can notice
> periodic spikes in oracle cpu usage. the spikes happen rougly once
> every 1 hour. i have monitored the cpu usage of all the applications
> that are accessing this database and found no corresponding increase
> in any of them.
> how can i identify what is causing this spike ?
> os is win2k and oracle version is 8.1.7
> Thanks and regards,
> Pinto.
>
Received on Thu Oct 03 2002 - 15:53:50 CDT