View Background Processes Description on Win 2000

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 24 Mar 2003 08:58:31 -0800
Message-ID: <1b061893.0303240858.42b19acb@posting.google.com>

Hi everyone,

I'd like to know exactly which background processes are running in my Oracle 9.2 on my laptop running Windows 2000 Server Pro. v$process gives me only this info:

SQL> select pid, username,program from v$process;

PID USERNAME PROGRAM

---------- --------------- -------------------------------------
         1                 PSEUDO
         2 SYSTEM          ORACLE.EXE
         3 SYSTEM          ORACLE.EXE
         4 SYSTEM          ORACLE.EXE
         5 SYSTEM          ORACLE.EXE
         6 SYSTEM          ORACLE.EXE
         7 SYSTEM          ORACLE.EXE
         8 SYSTEM          ORACLE.EXE
         9 SYSTEM          ORACLE.EXE
        10 SYSTEM          ORACLE.EXE
        11 SYSTEM          ORACLE.EXE
        12 SYSTEM          ORACLE.EXE
        13 SYSTEM          ORACLE.EXE
        14 SYSTEM          ORACLE.EXE

14 rows selected.

Is there a way to see which one is DBWR, LGWR, ARCH , ...?

Thanx

Daniel Received on Mon Mar 24 2003 - 10:58:31 CST