当前位置:Gxlcms > mysql > Oracle中的sharedserver

Oracle中的sharedserver

时间:2021-07-01 10:21:17 帮助过:49人阅读

与shared server相关的参数SHARED_SERVERS: Specifies the initial number of shared servers to start and the minimum number

Linux公社

首页 → 数据库技术

背景:

阅读新闻

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

linux

  • 0
  • Oracle中的Parallel Execution 和有用的view

    Oracle中的kfed和kfod

    相关资讯 Oracle基础

    图片资讯

    本文评论   查看全部评论 (0)

    评论声明

    最新资讯

    本周热门

    Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
    本站(LinuxIDC)所刊载文章不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。


    Copyright © 2006-2011 Linux公社 All rights reserved 浙ICP备06018118号

    人气教程排行