Oracle中的shared server

与shared server相关的参数
SHARED_SERVERS: Specifies the initial number of shared servers to start and the minimum number of shared servers to keep. This is the only required parameter for using shared servers.MAX_SHARED_SERVERS: Specifies the maximum number of shared servers that can run simultaneously.SHARED_SERVER_SESSIONS: Specifies the total number of shared server user sessions that can run simultaneously. Setting this parameter enables you to reserve user sessions for dedicated servers.DISPATCHERS: Configures dispatcher processes in the shared server architecture.MAX_DISPATCHERS: Specifies the maximum number of dispatcher processes that can run simultaneously. This parameter can be ignored for now. It will only be useful in a future release when the number of dispatchers is auto-tuned according to the number of concurrent connections.CIRCUITS: Specifies the total number of virtual circuits that are available for inbound and outbound network sessions使用shared server
alter system set shared_servers=5;不使用shared server
alter system set shared_server=0;
ALTER SYSTEM SET DISPATCHERS = "";当使用shared servers时仍可以使用Dedicated mode, 只需要在tnsnames.ora中添加servers=dedicated即可.当为shared时说明使用shared server.
如果还不能使用则要检查参数dispatchers.
典型的是 DISPATCHERS="（PROTOCOL=TCP）（DISPATCHERS=2）"
三个相关的view V$QUEUE V$DISPATCHER V$DISPATCHER_RATE查看dispatcher
SELECT NAME, NETWORK FROM V$DISPATCHER;
shutdown dispatcher
ALTER SYSTEM SHUTDOWN IMMEDIATE "D002";更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle中的Parallel Execution 和有用的viewOracle中的kfed和kfod相关资讯 Oracle基础

Oracle基础介绍及常用相关SQL*PLUS （03月11日）
Oracle 角色的两个特性和误区（09/04/2012 05:56:16）
Oracle rac11.2.0.3.0的vip在重启（09/02/2012 10:00:39）

Oracle中删除用户遇到的问题（09/08/2012 20:01:42）
IMP-00008: unrecognized （09/02/2012 10:03:25）
在Oracle数据库上设置限制ip地址访（09/02/2012 09:59:55）

本文评论查看全部评论（0）