与shared server相关的参数shared_servers: specifies the initial number of shared servers to start and the minimum number
首页 → 数据库技术
背景：
阅读新闻
oracle中的shared server
[日期：2012-08-04]来源：linux社区 作者：icybay [字体：]
与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 专题页面 ?tid=12
0
oracle中的parallel execution 和有用的view
oracle中的kfed和kfod
相关资讯       oracle基础
图片资讯
本文评论查看全部评论 (0)
评论声明
最新资讯
本周热门
linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站（linuxidc）所刊载文章不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。
copyright © 2006-2011　linux公社　all rights reserved 浙icp备06018118号
，