如下图所示，一目了然。

dedicated server process

shared server process

将shared_servers参数设置为非0既开启了shared_server模式，其他参数oracle自动调节。

以下视图可获取shared server process的状态：
V$DISPATCHER     Provides information on the dispatcher processes, including name, network address, status, various usage statistics, and index number.      
V$DISPATCHER_CONFIG     Provides configuration information about the dispatchers.      
V$DISPATCHER_RATE     Provides rate statistics for the dispatcher processes.      
V$QUEUE     Contains information on the shared server message queues.      
V$SHARED_SERVER     Contains information on the shared servers.      
V$CIRCUIT     Contains information about virtual circuits, which are user connections to the database through dispatchers and servers.      
V$SHARED_SERVER_MONITOR     Contains information for tuning shared server.      
V$SGA     Contains size information about various system global area (SGA) groups. May be useful when tuning shared server.      
V$SGASTAT     Contains detailed statistical information about the SGA, useful for tuning.      
V$SHARED_POOL_RESERVED     Lists statistics to help tune the reserved pool and space within the shared pool.      

dedicated.JPG

shared.JPG