Re: A single dedicated server shared between multiple sessions?

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