Oracle中的shared server

最新推荐文章于 2025-01-11 09:11:28 发布

原创最新推荐文章于 2025-01-11 09:11:28 发布 · 239 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle培训 #oracle学习 #cuug培训 #ocp #com

本文深入解析了Oracle数据库中Shared Server的概念、配置参数及其与Dedicated Server的区别，包括SHARED_SERVERS、MAX_SHARED_SERVERS、SHARED_SERVER_SESSIONS等关键参数的含义与设置方法。同时，介绍了如何在tnsnames.ora文件中配置Shared Server，并通过V$QUEUE、V$DISPATCHER等视图监控Dispatcher的运行状态。最后，提供了Shared Server的启动与关闭步骤，以及与Dispatcher相关的参数调整建议。

[img]http://dl2.iteye.com/upload/attachment/0094/7104/209e711c-89dd-3946-8666-1c0834ed6b4d.jpg[/img]
与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';