Re: Shadow Process on Dedicated Server

From: joel garry <joel-garry_at_home.com>
Date: Tue, 5 May 2009 09:18:12 -0700 (PDT)
Message-ID: <2542b356-3e09-415d-b27e-edc8963f367c_at_w31g2000prd.googlegroups.com>



On May 5, 5:41 am, ddf <orat..._at_msn.com> wrote:
> On May 4, 5:27 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On May 4, 11:16 am, chris <lazyboy..._at_yahoo.com> 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 asktom.oracle.com.  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.
>
> > jg
> > --
> > _at_home.com 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.- Hide quoted text -
>
> > - Show quoted text -
>
> Which may not provide the desired results if the session is a from a
> remote client; V$PROCESS does provide the SPID column which lists the
> local server process id for the associated Oracle process.  Use the
> PADDR column from V$SESSION and join it to the ADDR column from V
> $PROCESS to associate an Oracle client session with an Oracle server-
> side process:
>
> select sid, serial#, username, osuser, process, terminal, program
> from v$session
> where paddr = (select addr from v$process where spid = &1);
>
> Client sessions will spawn local processes but V$SESSION reports the
> originating process id:
>
> 2784:960  (Windows process:thread format)
>
> where V$PROCESS reports the local server PID:
>
> 19645  (UNIX/Linux process id)
>
> As I said the records are linked by the address value for the
> associated Oracle process.
>
> David Fitzjarrell

Duh, yeah, I'm getting spoiled and stupid forgetting the basics with this GUI stuff. I suspected my brain was in Blue Monday. I've seen quite a bit of app-based variance of things like osuser, terminal and program usage, to the point where I've long given up trying to remember what is supposed to be where and just figure it out when I really need to. Thanks for correcting and clarifying.

jg

--
_at_home.com is bogus.
http://www.readwriteweb.com/archives/mcafee_enabling_malware_distribution_and_fraud.php
Received on Tue May 05 2009 - 11:18:12 CDT

Original text of this message