Re: Shadow Process on Dedicated Server

From: joel garry <>
Date: Mon, 4 May 2009 15:27:51 -0700 (PDT)
Message-ID: <>

On May 4, 11:16 am, chris <> wrote:
> Hi Gurus,
> I have a simple question:  If I have a dedicated server config on 10g
> & already established a session to db through a terminal (of course,
> I'm running something on this session), would a server spawn another
> shadow process if I open another session on the same machine?  Could
> someone please let me know?  How does oracle dedicated server db know
> & handle multiple sessions on the same machine.
> TIA,
> -Chris

desc v$session, note there is a process id field you can use to probe v $process (if my brain is working correctly today).

Also search for the term spawn process on You can spawn several processes before you even open another session.

The concepts manual explains some of this, but looks unclear and simplistic to the point of wrong on your point. It does correctly point out that the specifics vary by platform. You need things like sysinternals or whatever it is called on Windows platforms to see these things. John gave a reasonable suggestion for unix.


-- is bogus.
"> The main reason behind the question is:

> *) we have performance problems
> => the application-owners prefer bashing the infrastructure (my boss)
> => he is to weak to go the right way = tell them to instrument their code
> and measure it
> => he forces me to do this stupid research instead telling the
> apps-owners how to tune.
> so MY benefit is to tell my boss to get bigger balls AND tell the apps guys
> to write instrumented code.
> THEIR benefit is to KNOW they cannot bash us any longer without the
> drawback of additional work on their side.
> I'm not sure if I can write this on the list in these words, but I can in a
> private fork ;-) " - on a list.
Received on Mon May 04 2009 - 17:27:51 CDT

Original text of this message