oracle dedicated 和shared server process的区别

如下图所示，一目了然。

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11946422/viewspace-667962/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11946422/viewspace-667962/