Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How do I find top CPU consumers on a windows machine running Oracle 9i (9.2.0.4 Enterprise Edition)?
HP Unix is simple - use a top command.
Solaris is not as friendly - but you can use prstat.
When I use task manager in Windows XP, I can only see CPU being consumed by the Oracle.exe process. I can then perform a "tlist" on the process number to find out which instance of Oracle is consuming the cpu.
I tried a utility called procexp.exe, but it doesn't tie back to any sessions in the database.
Does anyone have a utility to find the top CPU consumers on a windows machine?
I am desperate and just about ready to stop both production instances since I can not find the offenders and a 4-way, dual core machine has been running 100% cpu for a while...
Thanks!
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 03 2007 - 08:08:56 CDT
![]() |
![]() |