Skip to Main Content
  • Questions

  • mapping an oracle.exe process to an instance on NT

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Gert .

Asked: May 02, 2000 - 1:20 pm UTC

Last updated: March 29, 2005 - 8:09 am UTC

Version:

Viewed 1000+ times

You Asked

On NT 4.0 performancemonitor, All Oracleprocesses are
displayed as ORACLE73. Is there a tool that can tell me what
instance in meant by what ORACLE73-process?



and Tom said...



You can use "TLIST.EXE" from the Windows NT Resource Kit to determine
which process ID is associated with which Oracle Instance.

The tool "TLIST.EXE" lists memory usage and commandline information for a
given process. Do the following:

1) Go to the Windows NT task manager and select the processes tab.

2) If the PID column isn't present, go to the View pulldown menu
and choose "Select Columns".

3) Check the box for PID (Process Identifier).

4) Now find your "ORACLExx.EXE" processes and their associated PIDs.

You can also find the PID from the command line as opposed to Task Manager.
To find Oracle Related processes from the command line, using TLIST,
you can do the following:

C:\>tlist | grep -i oracle
269 ORACLE80.EXE
235 ORACLE73.EXE
123 PLUS80W.EXE Oracle SQL*Plus
217 CMD.EXE Command Prompt - grep -i oracle
227 oracle80.exe

Note that the "GREP.EXE" command is also available as part of the
Windows NT Resource Kit. The GREP makes TLIST look for Processes
that have Oracle in their name or in their description.

To find information about a certain PID, just run TLIST and the PID:

C:\>tlist 269 | grep -i CmdLine
CmdLine: d:\ora805\bin\oracle80.exe OR85
C:\>tlist 227 | grep -i CmdLine
CmdLine: d:\ora804\bin\oracle80.exe OR84
^^^^^ there is the SID



Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

"mapping an oracle.exe process to an instance on NT", version

S.Sivakumar, July 09, 2002 - 12:53 pm UTC

Hi Tom,

Can you elaborate more on how to find the memory consumed by
oracle processes (ie. background processes) using tlist or other utility.

Thanks in advance

Regards,
Siva

Tom Kyte
July 10, 2002 - 6:48 am UTC


Task Manager will show you much of this information (there is only one process/instance on NT)

Perfmon can give you more details.

v$sesstat in the database is what I would look at (pga/uga memory) -- that way, no matter the platform, I can tell.

Memory in use

A reader, May 19, 2004 - 10:26 am UTC

Hi Tom,
Well after i restart Oracle it allocates a bit of memnory and it increases as per the processes and as is required by the database. Or does it resereve the entire memory allocated to Oracle at one shot. B'coz at times i see it less and now it is around 1GB. The Shared Pool is configured to be around 1.3GB and PGA is around 525MB. The OS is Windows 2000 Advanced Server and 9iR2. Also presently it shows the SGA is 80% free. So how can it be using 1GB of RAM and also the database was restarted yesterday.
Any ideas.....

Tom Kyte
May 19, 2004 - 11:08 am UTC

the SGA is preallocated -- but the PGA's used by users will be allocated and released "as needed" over time.

the SGA won't be touched, in memory, until needed so, it may well be reserved but not showing as "in use" under windows.

tasklist replaces tlist for 2003

Scott LeBlanc, March 27, 2005 - 1:30 am UTC

Posting this as I don't see any mention of tasklist on AskTom.

At risk of getting shot for 1. running NT, or 2. running multiple dbs on the same server.....

C:\Documents and Settings\oracleadmin>tasklist /svc | grep oracle
oracle.exe 1860 OracleServiceDEV10SE
oracle.exe 1892 OracleServicedev8e
oracle.exe 1932 OracleServicedev9e
oracle.exe 1952 OracleServiceIMPL9E
oracle.exe 1964 OracleServicekcprod
oracle.exe 2012 OracleServicemtracker
oracle.exe 2036 OracleServiceorcl817c
oracle.exe 224 OracleServiceperf8e
oracle.exe 268 OracleServiceperf9e
oracle.exe 300 OracleServicetrain1

C:\Documents and Settings\oracleadmin>tasklist | grep oracle
oracle.exe 1860 Console 0 221,156 K
oracle.exe 1892 Console 0 210,192 K
oracle.exe 1932 Console 0 234,244 K
oracle.exe 1952 Console 0 518,512 K
oracle.exe 1964 Console 0 11,996 K
oracle.exe 2012 Console 0 212,080 K
oracle.exe 2036 Console 0 441,208 K
oracle.exe 224 Console 0 136,704 K
oracle.exe 268 Console 0 236,828 K
oracle.exe 300 Console 0 211,044 K

Tom Kyte
March 27, 2005 - 9:54 am UTC

And from the second edition of expert one on one Oracle under work:

...
On Windows XP Pro, using the pslist tool (</code> http://www.sysinternals.com/ntw2k/freeware/pslist.shtml <code>, I will find only one process, Oracle.exe
..........


maybe i'll switch the example to tasklist since I didn't know about it and it seems to be there. Is it part of all windows distributions?



(that is a lot of oracle instances :)



tasklist.exe

Scott, March 29, 2005 - 12:52 am UTC

Well....you want to select the tool best suiting your requirements, and only after you run tests to proof them out...etc... ;)

I'm willing to bet tasklist.exe is installed on all distributions of XP. This is based on the fact it is available on a fresh install of Server 2003, and my XP Professional install. Unfortunately, and expectedly, 10 minutes of searching the Microsoft site did not find evidence (documentation) to support this conclusion.

However, it did find....
</code> http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/tasklist.mspx 

and ....
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnw2kmag01/html/DiscoverWindowsXPTable_02.asp <code>

Hope that helps. Look forward to your new book and thanks for the perspective.


Tom Kyte
March 29, 2005 - 8:09 am UTC

Thanks, I'll use tasklist

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.