五、Usage and Configuration of the Oracle Shared Server
1、Processing a Request
2、The SGA and PGA
3、Configuring Shared Server
(1)Required initialization parameters
--DISPATCHERS
--SHARED_SERVERS
(2)Optional initialization parameters
--MAX_DISPATCHERS
--MAX_SHARED_SERVERS
--CIRCUITS
--SHARED_SERVER_SESSIONS
(3)
alter system set dispatchers='(protocol=tcp)(dispatchers=3)' ;
alter system set max_dispatchers=5;
alter system set max_shared_servers=20;
alter system set shared_servers=5;
(4) Related Parameters
--LARGE_POOL_SIZE
--SESSIONS
4、Dynamic Views
v$circuit
v$shared_server
v$dispatcher
v$shared_server_monitor
v$queue
v$session