OCM_Session1_3_Shared Server Configuration

3. Shared Server Configuration

 3.1 Configure the PROD database to support up to 300 sessions, reserving 100 for dedicated connections. 

 3.2 Configure the PROD database to support.

   3.2.1 Default of 3 TCP dispatchers 缺省有3个TCP调度器进程

   3.2.2 Maximum of 10 dispatchers 最大有10个调度器

 3.3 Configure the PROD database to support:

   3.3.1 Minimum of 10 shared server processes 最少10个共享服务器进程

   3.3.2 Maximum of 30 shared server processes最大30个共享服务器进程

参考联机文档：

Reference ==> DISPATCHERS

Reference ==> SESSIONS

Reference ==> SHARED_SERVERS

• 3.1 Configure the PROD database to support up to 300 sessions, reserving 100 for dedicated connections. 

300个session，保留100个专有连接

SQL> show parameter session

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

java_max_sessionspace_size           integer     0

java_soft_sessionspace_limit         integer     0

license_max_sessions                 integer     0

license_sessions_warning             integer     0

logmnr_max_persistent_sessions       integer     1

session_cached_cursors               integer     20

session_max_open_files               integer     10

sessions                             integer     153

shared_server_sessions               integer

SQL> alter system set sessions=300 scope=spfile;

System altered.

SQL> alter system set shared_server_sessions=200;

System altered.

•  3.2 Configure the PROD database to support.

   3.2.1 Default of 3 TCP dispatchers 缺省有3个TCP调度器进程

   3.2.2 Maximum of 10 dispatchers 最大有10个调度器

http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams062.htm#i1126971

SQL> show parameter dis

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

asm_diskgroups                       string

asm_diskstring                       string

disk_asynch_io                       boolean     TRUE

dispatchers                          string      

distributed_lock_timeout             integer     60

max_dispatchers                      integer

SQL> alter system set DISPATCHERS = '(PROTOCOL=TCP)(DISPATCHERS=3)';

System altered.

SQL> alter system set max_dispatchers=10;

System altered.

SQL> show parameter dis

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

asm_diskgroups                       string

asm_diskstring                       string

disk_asynch_io                       boolean     TRUE

dispatchers                          string      (PROTOCOL=TCP)(DISPATCHERS=3)

distributed_lock_timeout             integer     60

max_dispatchers                      integer     10

SQL> 

•  3.3 Configure the PROD database to support:

   3.3.1 Minimum of 10 shared server processes 最少10个共享服务器进程

   3.3.2 Maximum of 30 shared server processes最大30个共享服务器进程

SQL> show parameter shared

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

hi_shared_memory_address             integer     0

max_shared_servers                   integer

shared_memory_address                integer     0

shared_pool_reserved_size            big integer 7130316

shared_pool_size                     big integer 0

shared_server_sessions               integer     200

shared_servers                       integer     0

SQL> alter system set shared_servers=10;

System altered.

SQL> alter system set max_shared_servers=30;

System altered.

SQL> show parameter shared

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

hi_shared_memory_address             integer     0

max_shared_servers                   integer     30

shared_memory_address                integer     0

shared_pool_reserved_size            big integer 7130316

shared_pool_size                     big integer 0

shared_server_sessions               integer     200

shared_servers                       integer     10

SQL> 

关闭重启，让参数生效

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  524288000 bytes

Fixed Size                  1220360 bytes

Variable Size             155189496 bytes

Database Buffers          364904448 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

SQL>