Shared Server 설정

▣ Shared Server Setting

[oracle@orcl ~]$ sqlplus / as sysdba 

parameter 셋팅

 S SYS> create pfile='/home/oracle/init.ora.090609' from spfile;    파리미터 셋팅값 백업

 S SYS> show parameter dis

NAME                                 TYPE        VALUE

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

asm_diskgroups                       string

asm_diskstring                       string

disk_asynch_io                       boolean     TRUE

dispatchers                          string      (PROTOCOL=TCP) (SERVICE=orclXDB)

distributed_lock_timeout             integer     60

max_dispatchers                      integer

   

S SYS> alter system set DISPATCHERS='' scope=both;

S SYS> alter system set DISPATCHERS="(PROTOCOL=TCP)(SERVICE=orcl)(dispatchers=3)"

   

S SYS> alter system set MAX_DISPATCHERS=3 scope=both;   =>  dispatcher 수

S SYS> alter system set shared_servers=10 scope=both;   =>  share server 수

S SYS> alter system set MAX_shared_servers=20 scope=both;   =>  모자라면 증가되는 shared server 수

S SYS> alter system set circuits=300 scope=both;

S SYS> alter system set shared_server_sessions=20 scope=both;

   

▣ 확인

▣ 윈도우 Netmgr