Re: Which oracle.exe process in Windows?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 Apr 2003 15:33:13 -0700
Message-ID: <92eeeff0.0304161433.1d7120@posting.google.com>

Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<i3qq9v4jqk01mbifi0cgoj7p02r4ejblnf_at_4ax.com>...
> I have been using Oracle on UNIX for long time, and just now started
> using Oracle on Windows. Here is one question. When you run more
> than one instance of Oracle database on Windows, each instance shows
> up in Task Manager as "oracle.exe". How can I find out which
> "oracle.exe" process maps to a specific Oracle database instance? For
> example, when you have Oracle instances named Ora1 and Ora2, how can I
> find which "oracle.exe" process belongs to "Ora1", among two
> "oracle.exe" processes? Thank you in advance.

You can use NT resource kit utility called tlist.exe.

Usage:
C:\>tlist <PID> | find /i "CmdLine:"
Absolute last token of the displyed string (After space) will be your SID.

If you don't have tlist.exe on your system, email me and I can send you one.

Regards
/Rauf Sarwar Received on Wed Apr 16 2003 - 17:33:13 CDT