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 ==> DISPATCHERSReference ==> SESSIONSReference ==> 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 0java_soft_sessionspace_limit integer 0license_max_sessions integer 0license_sessions_warning integer 0logmnr_max_persistent_sessions integer 1session_cached_cursors integer 20session_max_open_files integer 10sessions integer 153shared_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 stringasm_diskstring stringdisk_asynch_io boolean TRUEdispatchers string distributed_lock_timeout integer 60max_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 stringasm_diskstring stringdisk_asynch_io boolean TRUEdispatchers string (PROTOCOL=TCP)(DISPATCHERS=3)distributed_lock_timeout integer 60max_dispatchers integer 10SQL>
[*] 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 0max_shared_servers integershared_memory_address integer 0shared_pool_reserved_size big integer 7130316shared_pool_size big integer 0shared_server_sessions integer 200shared_servers integer 0SQL> 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 0max_shared_servers integer 30shared_memory_address integer 0shared_pool_reserved_size big integer 7130316shared_pool_size big integer 0shared_server_sessions integer 200shared_servers integer 10SQL>
关闭重启，让参数生效SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area524288000 bytesFixed Size 1220360 bytesVariable Size 155189496 bytesDatabase Buffers 364904448 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SQL>
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]