Dedicated or Shared Server

From: Prasath <prasath.rao_at_gmail.com>
Date: 3 Jul 2006 06:14:27 -0700
Message-ID: <1151932467.365631.4890@75g2000cwc.googlegroups.com>

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

Received on Mon Jul 03 2006 - 08:14:27 CDT