René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Dedicated servers in Oracle

A server process is dedicated to one client connection (or session). (Contrast with shared server.) This means: each session has one corresponding server process
v$session allows to find out if a session has a shared or dedicated connection: 
select sid, username, server from v$session where type='USER';

       SID USERNAME                       SERVER
---------- ------------------------------ ---------
        48 RENE                           SHARED
       212 MARTHA                         DEDICATED