Oracle中的sharedserver

與shared server相關(guān)的參數(shù)SHARED_SERVERS: Specifies the initial number of shared servers to start and the minimum number

首頁 → 數(shù)據(jù)庫技術(shù)

背景：

Oracle中的shared server

[日期：2012-08-04] 來源：Linux社區(qū) 作者：icybay [字體：]

與shared server相關(guān)的參數(shù)
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.
如果還不能使用 則要檢查參數(shù)dispatchers.
典型的是 DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
三個相關(guān)的view V$QUEUE V$DISPATCHER V$DISPATCHER_RATE

查看dispatcher
SELECT NAME, NETWORK FROM V$DISPATCHER;
shutdown dispatcher
ALTER SYSTEM SHUTDOWN IMMEDIATE 'D002';

更多Oracle相關(guān)信息見Oracle 專題頁面 ?tid=12

Oracle中的Parallel Execution 和有用的view

Oracle中的kfed和kfod

相關(guān)資訊 Oracle基礎(chǔ)

圖片資訊

本文評論 　　查看全部評論 (0)

評論聲明

最新資訊

本周熱門

Linux公社簡介 - 廣告服務 - 網(wǎng)站地圖 - 幫助信息 - 聯(lián)系我們
本站（LinuxIDC）所刊載文章不代表同意其說法或描述，僅為提供更多信息，也不構(gòu)成任何建議。

Copyright © 2006-2011　Linux公社　All rights reserved 浙ICP備06018118號

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com