Windows Server 2003 -- Match an ORACLE.EXE to an Oracle Instance

Problem

On a Windows Server 2003 system, you have several running oracle instances.  You need to match each running oracle instance to an oracle.exe. There is no yet Command Line column in the Task Manager.

Solution

On Windows Server 2003, the Task Manager does not yet have the Command Line column, showing the complete command line path along with an instance name. 

So to match an oracle.exe process to a particular Oracle instance, a WMI can be used:

C:\>wmic path win32_process where caption="oracle.exe" get CommandLine, ProcessId
 

CommandLine                                            ProcessId
c:\oracle\product\10.2.0\db_1\bin\ORACLE.EXE DB01      2808
c:\oracle\product\10.2.0\db_1\bin\ORACLE.EXE DB02      624

The CommandLine column also contains the Oracle instance names.

Now having the Process Id value for a particular Oracle instance, further information can be retrieved, by using the Task Manager or by any other means.