<span id="mktg5"></span>

<i id="mktg5"><meter id="mktg5"></meter></i>

        <label id="mktg5"><meter id="mktg5"></meter></label>
        最新文章專題視頻專題問答1問答10問答100問答1000問答2000關鍵字專題1關鍵字專題50關鍵字專題500關鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關鍵字專題關鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
        問答文章1 問答文章501 問答文章1001 問答文章1501 問答文章2001 問答文章2501 問答文章3001 問答文章3501 問答文章4001 問答文章4501 問答文章5001 問答文章5501 問答文章6001 問答文章6501 問答文章7001 問答文章7501 問答文章8001 問答文章8501 問答文章9001 問答文章9501
        當前位置: 首頁 - 科技 - 知識百科 - 正文

        如何啟用OracleSharedServer

        來源:懂視網 責編:小采 時間:2020-11-09 11:17:57
        文檔

        如何啟用OracleSharedServer

        如何啟用OracleSharedServer:專用服務器連接---(SERVER = DEDICATED)共享服務器連接---(SERVER = SHARED)那么如何配置共享服務器呢?有兩個參數是必須的:DIS 在某些應用中共享服務器還是有獨特的優勢的,從官方描述中可以看到如下優勢:減少實例進程的數目增加對外服務的用戶數目減少
        推薦度:
        導讀如何啟用OracleSharedServer:專用服務器連接---(SERVER = DEDICATED)共享服務器連接---(SERVER = SHARED)那么如何配置共享服務器呢?有兩個參數是必須的:DIS 在某些應用中共享服務器還是有獨特的優勢的,從官方描述中可以看到如下優勢:減少實例進程的數目增加對外服務的用戶數目減少

        專用服務器連接---(SERVER = DEDICATED)共享服務器連接---(SERVER = SHARED)那么如何配置共享服務器呢?有兩個參數是必須的:DIS

        在某些應用中共享服務器還是有獨特的優勢的,從官方描述中可以看到如下優勢:
        減少實例進程的數目
        增加對外服務的用戶數目
        減少無用或者空閑服務器的進程數目
        減少Oracle數據庫對內存占用和os的開銷
        實現負載平衡
        相對于專有服務器模式,一個比較重要的區別是共享服務器要求使用net services來連接,即使用戶經常和服務器進程在同一臺機器上也是如此。
        但是在某些情況下必須使用專用服務器:比如使用sysdba登陸進行管理操作的時候。
        當然,要使用這兩種不同的模式,,重要的還是在服務器進行配置后還要在客戶端的連接串配置有所體現
        專用服務器連接---(SERVER = DEDICATED)
        共享服務器連接---(SERVER = SHARED)
        那么如何配置共享服務器呢?有兩個參數是必須的:
        DISPATCHERS
        SHARED_SERVERS
        可選擇配置的參數:
        MAX_DISPATCHERS
        MAX_SHARED_SERVERS
        CIRCUITS
        SHARED_SERVER_SESSIONS
        大部分情況下我們只要修改DISPATCHERS即可,我們先看下默認的專用服務器情況下參數:
        [oracle@test ~]$ sqlplus "/as sysdba"

        SQL*Plus: Release 10.2.0.5.0 - Production on Tue Aug 14 15:04:26 2012

        Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


        Connected to:
        Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
        With the Partitioning, OLAP, Data Mining and Real Application Testing options

        sys@GT10G> select * from v$version;

        BANNER
        ----------------------------------------------------------------
        Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
        PL/SQL Release 10.2.0.5.0 - Production
        CORE 10.2.0.5.0 Production
        TNS for Linux: Version 10.2.0.5.0 - Production
        NLSRTL Version 10.2.0.5.0 - Production

        sys@GT10G> show parameter disp;

        NAME TYPE VALUE
        ------------------------------------ -------- ------------------------------
        dispatchers string (PROTOCOL=TCP) (SERVICE=gt10gXDB)
        max_dispatchers integer
        共享服務器和專用服務器還可以從監聽程序的信息體現出來,我們先記錄下修改之前的專用服務器的監聽狀態和信息:
        [oracle@test ~]$ lsnrctl status

        LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:03:32

        Copyright (c) 1991, 2010, Oracle. All rights reserved.

        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
        STATUS of the LISTENER
        ------------------------
        Alias LISTENER
        Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
        Start Date 14-AUG-2012 14:52:08
        Uptime 0 days 0 hr. 11 min. 24 sec
        Trace Level off
        Security ON: Local OS Authentication
        SNMP OFF
        Listener Parameter File /u01/oracle/10g/product/10.2.0/db_1/network/admin/listener.ora
        Listener Log File /u01/oracle/10g/product/10.2.0/db_1/network/log/listener.log
        Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
        Services Summary...
        Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Service "gt10g" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Service "gt10gXDB" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Service "gt10g_XPT" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        The command completed successfully

        [oracle@test ~]$ lsnrctl service

        LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:03:39

        Copyright (c) 1991, 2010, Oracle. All rights reserved.

        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
        Services Summary...
        Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0
        LOCAL SERVER
        Service "gt10g" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0 state:ready
        LOCAL SERVER
        Service "gt10gXDB" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Handler(s):
        "D002" established:0 refused:0 current:0 max:1022 state:ready
        DISPATCHER
        (ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=47446))
        Service "gt10g_XPT" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0 state:ready
        LOCAL SERVER
        The command completed successfully

        現在我們要設置一下共享服務器,這里我們只要設置DISPATCHERS參數:
        sys@GT10G> alter system set DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=3)(PROTOCOL=IPC)(DISPATCHERS=1)";

        System altered.

        我們首先從監聽狀態和信息來看下前后的不同:
        [oracle@test ~]$ lsnrctl status

        LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:07:37

        Copyright (c) 1991, 2010, Oracle. All rights reserved.

        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
        STATUS of the LISTENER
        ------------------------
        Alias LISTENER
        Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
        Start Date 14-AUG-2012 14:52:08
        Uptime 0 days 0 hr. 15 min. 28 sec
        Trace Level off
        Security ON: Local OS Authentication
        SNMP OFF
        Listener Parameter File /u01/oracle/10g/product/10.2.0/db_1/network/admin/listener.ora
        Listener Log File /u01/oracle/10g/product/10.2.0/db_1/network/log/listener.log
        Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
        Services Summary...
        Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Service "gt10g" has 1 instance(s).
        Instance "gt10g", status READY, has 2 handler(s) for this service...
        Service "gt10gXDB" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Service "gt10g_XPT" has 1 instance(s).
        Instance "gt10g", status READY, has 2 handler(s) for this service...
        The command completed successfully

        [oracle@test ~]$ lsnrctl service

        LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 14-AUG-2012 15:09:22

        Copyright (c) 1991, 2010, Oracle. All rights reserved.

        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
        Services Summary...
        Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0
        LOCAL SERVER
        Service "gt10g" has 1 instance(s).
        Instance "gt10g", status READY, has 2 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0 state:ready
        LOCAL SERVER
        "D000" established:0 refused:0 current:0 max:1022 state:ready
        DISPATCHER
        (ADDRESS=(PROTOCOL=ipc)(KEY=#19006.1))
        Service "gt10gXDB" has 1 instance(s).
        Instance "gt10g", status READY, has 1 handler(s) for this service...
        Handler(s):
        "D002" established:0 refused:0 current:0 max:1022 state:ready
        DISPATCHER
        (ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=47446))
        Service "gt10g_XPT" has 1 instance(s).
        Instance "gt10g", status READY, has 2 handler(s) for this service...
        Handler(s):
        "DEDICATED" established:0 refused:0 state:ready
        LOCAL SERVER
        "D000" established:0 refused:0 current:0 max:1022 state:ready
        DISPATCHER
        (ADDRESS=(PROTOCOL=ipc)(KEY=#19006.1))
        The command completed successfully

        linux

        聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

        文檔

        如何啟用OracleSharedServer

        如何啟用OracleSharedServer:專用服務器連接---(SERVER = DEDICATED)共享服務器連接---(SERVER = SHARED)那么如何配置共享服務器呢?有兩個參數是必須的:DIS 在某些應用中共享服務器還是有獨特的優勢的,從官方描述中可以看到如下優勢:減少實例進程的數目增加對外服務的用戶數目減少
        推薦度:
        標簽: 使用 啟動 oracle
        • 熱門焦點

        最新推薦

        猜你喜歡

        熱門推薦

        專題
        Top
        主站蜘蛛池模板: 亚洲免费日韩无码系列| 久久亚洲最大成人网4438| 24小时在线免费视频| 日韩亚洲一区二区三区| 9久热这里只有精品免费| 91人人区免费区人人| 久久综合亚洲色一区二区三区| 日韩精品免费视频| 亚洲一区二区三区首页| 看Aⅴ免费毛片手机播放| 全黄a免费一级毛片人人爱| 欧亚一级毛片免费看| 亚洲精品国产品国语在线| 拍拍拍无挡免费视频网站| 免费国产在线观看不卡| 一个人看的在线免费视频| 亚洲s色大片在线观看| 啦啦啦完整版免费视频在线观看| 亚洲伊人久久大香线蕉啊| 成人免费无码精品国产电影| 美女被爆羞羞网站在免费观看| 18国产精品白浆在线观看免费| 国产成人99久久亚洲综合精品| 国产一级在线免费观看| 国产午夜鲁丝片AV无码免费| 一级日本高清视频免费观看 | 日本一区午夜艳熟免费| 久久久综合亚洲色一区二区三区 | 国产黄色片在线免费观看| 黄页网站在线免费观看| 亚洲AV永久精品爱情岛论坛| 91精品免费国产高清在线| 国产偷国产偷亚洲清高APP| 91精品免费在线观看| 视频一区在线免费观看| 亚洲av综合色区| 国产成人免费片在线视频观看| a毛片视频免费观看影院| 国产亚洲玖玖玖在线观看| 亚洲中文字幕久久精品无码APP| 特级做a爰片毛片免费看|