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!