Re: Shadow Process on Dedicated Server

Giganews Newsgroups
Subject: Re: Shadow Process on Dedicated Server
Posted by:  joel garry (joel-gar…
Date: Mon, 4 May 2009

On May 4, 11:16=A0am, chris <lazyboy.…> wrote:
> Hi Gurus,
> I have a simple question: =A0If 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? =A0Could
> someone please let me know? =A0How 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
> =3D> the application-owners prefer bashing the infrastructure (my boss)
>  =3D> he is to weak to go the right way =3D tell them to instrument thei=
r code
> and measure it
>    =3D> 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 gu=
> 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=
> private fork ;-) " - on a list.


In response to

Shadow Process on Dedicated Server posted by chris on Mon, 4 May 2009