Re: How to tell which Oracle process goes with which instance on a Windows box

On 9 Apr 2002 09:10:19 -0700, surooot_at_hotmail.com (Wayne) wrote:

>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.

I know you are not going to like this, however: anyone running 20 instances on a single server with only 1G of memory clearly doesn't have the faintest idea what he is doing. A database in Oracle is not identical to a database in sqlserver. Did you ever check Oracle's performance statistics? Did you ever determine the fault rate of your windows server? If they are adequate we are discussing toy databases and I don't see what we are talking about, and your databases may be well converted back to sqlserver or access. However, you still seem to be amazed that you are reaching 100 percent, which confirms my suspicions. Your statement 'that part works fine' is clearly rubbish. If your server is reaching 100 percent, 'that part' doesn't work 'fine'
That all said, as Oracle is implemented multithreaded you have no other choice than to show the indidvidual thread numbers, and to connect to every individual instance and to verify whether any spid column of your v$process is showing up the thread id identified by NT tools.
Yes, running 20 instances on a single server is working fine, you have just demonstrated yourself it is completely unmanageable.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 09 2002 - 15:15:54 CDT