Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.242.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!69.16.185.21.MISMATCH!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!w31g2000prd.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Shadow Process on Dedicated Server Date: Tue, 5 May 2009 09:18:12 -0700 (PDT) Organization: http://groups.google.com Lines: 100 Message-ID: <2542b356-3e09-415d-b27e-edc8963f367c@w31g2000prd.googlegroups.com> References: <72ff9a90-469d-4840-a59d-96e571d4b7ae@i28g2000prd.googlegroups.com> <1341d4ee-3832-4572-a052-82a90610533e@n4g2000vba.googlegroups.com> NNTP-Posting-Host: 12.232.112.189 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1241540292 30596 127.0.0.1 (5 May 2009 16:18:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 5 May 2009 16:18:12 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: w31g2000prd.googlegroups.com; posting-host=12.232.112.189; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On May 5, 5:41=A0am, ddf wrote: > On May 4, 5:27=A0pm, joel garry wrote: > > > > > > > On May 4, 11:16=A0am, chris wrote: > > > > Hi Gurus, > > > > I have a simple question: =A0If I have a dedicated server config on 1= 0g > > > & 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? =A0Coul= d > > > someone please let me know? =A0How does oracle dedicated server db kn= ow > > > & 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. =A0You 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. =A0It does correctly > > point out that the specifics vary by platform. =A0You need things like > > sysinternals or whatever it is called on Windows platforms to see > > these things. =A0John gave a reasonable suggestion for unix. > > > jg > > -- > > @home.com is bogus. > > "> The main reason behind the question is: > > > > *) we have performance problems > > > =3D> the application-owners prefer bashing the infrastructure (my bos= s) > > > =A0 =3D> he is to weak to go the right way =3D tell them to instrumen= t their code > > > and measure it > > > =A0 =A0 =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 app= s 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 ca= n 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. =A0Use 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 =3D (select addr from v$process where spid =3D &1); > > Client sessions will spawn local processes but V$SESSION reports the > originating process id: > > 2784:960 =A0(Windows process:thread format) > > where V$PROCESS reports the local server PID: > > 19645 =A0(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 -- @home.com is bogus. http://www.readwriteweb.com/archives/mcafee_enabling_malware_distribution_a= nd_fraud.php