Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A single dedicated server shared between multiple sessions?

Re: A single dedicated server shared between multiple sessions?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 10 Aug 2003 22:05:23 -0700
Message-ID: <1a75df45.0308102105.9d1c8b@posting.google.com>


vafanassiev_at_aapt.com.au
>
> I noticed that while we have 500 - 700 sessions the number of
> dedicated server processes is much lower. It appears that
> a single dedicated server (a process with name "oracleSID")
> is shared between all sessions started by the same user (from
> the same parent form).

That does not sound correct. Every session that is opened requires its own shadow process when using dedicated server mode.

Look at v$process - that is a distinct reflection of the Oracle o/s processes. The SPID column contains the Unix PID. Now if what you are saying is true, you will not have a 1:1 relationship between a user v$process and v$session. The SERVER column in v$session will tell you whether or not it is a dedicated.

Oh yeah - and make pretty sure that you do ps and grep correctly when looking for the list of shadows. Not all of these will necassarily run as the Unix Oracle user.

--
Billy
Received on Mon Aug 11 2003 - 00:05:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US