| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> How to tell which Oracle process goes with which instance on a Windows box
I have two NT boxes with multiple database instances each (up to 20
each at times) for non-production testing (performance is not a
concern). One box has 8.0.4 & 8.1.5 and the other has 8.0.5 & 8.1.7.
The issue is this, one of the boxes suddenly get pegged at 100% CPU
(they are both dual CPU w/1GB ram) and I need to figure out which
insatnces as getting hit?
In the process list I have many Oracle80.exe and some Oracle.exe, the later being the 8.1.x and the prior being 8.0.x. Lets say that there is one of each (an oracle.exe and an oracle80.exe) at 50% CPU - how do I tell which database instance they represent?
Currently I start looking through the directories for each instance
(they are always in their own sub-folders under an oracle dir) for one
with a recent time stamp on the data files, when I find one I look at
the active sessions in that DB to see if that is the one - sometimes
it is and sometimes it is not.
Any suggestions (not about running 20 Oracle instances on a Windows box - that part works fine) on how to track the process name in the process list to an actual instance?
Wayne. Received on Tue Apr 09 2002 - 11:10:19 CDT
![]() |
![]() |