FreeLists / oracle-l / Re: How do I find top CPU consumers on a windows machine running Oracle 9i (9.2.0.4 Enterprise Edition)?

["Jeremy Paul Schneider" <jeremy.schneider@xxxxxxxxxxxxxx>]

1. Download the free Sysinternals Process Explorer (there might also be
other utilities, I just know how to do it with this one)

http://www.microsoft.com/technet/sysinternals/utilities/ProcessExplorer.mspx

2. double-click the oracle.exe binary in process explorer

3. click the "threads" tab

4. select the thread that has 100% CPU utilization, get the "thread ID" from
the bottom pane

5. in SQL*Plus query the V$PROCESS table where SPID = "thread ID"

6. query V$SESSION where PADDR = V$PROCESS.ADDR

-Jeremy



On 7/3/07, Johnson, William L (TEIS) <WLJohnson@xxxxxxxxxxxxxxxxxxx> wrote:
>  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!


--
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical