Oracle笔记1（Fundamentals II）

五、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