Re: Find SID for oracle.exe

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 6 Mar 2007 04:31:36 -0800
Message-ID: <1173184296.465556.294690@t69g2000cwt.googlegroups.com>

On Mar 5, 7:59 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> And that is what the OP was asking - how to see which database was
> opened by which oracle.exe. Several answers have been given, I think
> the tasklist one only applies to XP or something? I don't see it on
> win2kpro. Charles and bdbafh gave other useful replies.
>
> The relationship is created when the exe starts. Right? The instance
> is created by oradim, right? So you can figure out which possible
> SID's there are by looking at oradim.log, as well as system services?
> Too bad the alert log doesn't have the OS id.
>
> jg
> --
> @home.com is bogus.

The task list (Task Manager) on Windoww NT 4, Windows 2000, Windows 2003, and Vista Ultimate Edition is able to show the thread count for each process.

As a test, I created a new SQLPlus connection to the database from the Windows 2003 server that is running the Oracle 10.2.0.2 database. The thread count increased by two when I connected from the server that runs Oracle as soon as I connected. The thread count did not decrease immediately after a disconnect (this is likely due to Oracle trying to minimize the impact of repeated connects and disconnects from the same client).

It is also possible to use ORADEBUG to cause a fake core dump. The header of the core dump might look like this:

Oracle Database 10g Release 10.2.0.2.0 - 64bit Production Process Id: 0x000007ac Thread Id : 0x00000590 Time : Tue Nov 28 05:26:44
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

That Process ID of 0x000007ac very likely refers to PID 1964 in Task Manager.

pslist, whose developer was recently bought out by Microsoft is also able to remotely query the task list on a server, and show the thread count. For instance:
pslist \\my_db_server_name_here oracle

Name                Pid Pri Thd  Hnd   Priv        CPU Time    Elapsed
Time
oracle             1884   8  26  554 1490076     0:03:18.421
37:18:06.835
oracle             1916   8  25  592 653332     0:05:19.000
37:18:06.523
oracle             1936   8  26  574 434808     0:05:14.390
37:18:06.476
oracle             1952   8 447 2843 3630120     3:09:52.984

37:18:06.366

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Mar 06 2007 - 06:31:36 CST