Re: Dedicated or Shared Server

Prasath wrote:
> How would I know the mode of server process, shared or dedicated, set
> on a Oracle 9i R2 database instance?
>
> These are the parameters set in my dev. instance
>
> SQL> show parameter server
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> fal_server string
> max_shared_servers integer 20
> mts_max_servers integer 20
> mts_servers integer 0
> parallel_max_servers integer 5
> parallel_min_servers integer 0
> parallel_server boolean FALSE
> parallel_server_instances integer 1
> rdbms_server_dn string
> shared_server_sessions integer 0
> shared_servers integer 0
> SQL> show parameter work
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> workarea_size_policy string AUTO
> SQL> show parameter pga
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> pga_aggregate_target big integer 2000000000
>

Seems, shared server is switched off:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1196.htm#1024199

IIRC correctly Oracle 10g will create shared server processes if DISPATCHERS is configured. Might be that Ora 9 behaves similar.

Note also, that the client can determine whether he wants a shared or dedicated server process. If you want to know mode of individual processes you can query system view V$PROCESS - I think column "progran" gives an indication about the task.

HTH         robert Received on Mon Jul 03 2006 - 08:39:08 CDT