<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
        主站蜘蛛池模板: 亚洲中文无韩国r级电影| 日本免费网站观看| 亚洲精品国精品久久99热一| 青娱乐在线免费观看视频| 日韩特黄特色大片免费视频| 亚洲精品久久久久无码AV片软件| 久久综合AV免费观看| 亚洲七久久之综合七久久| 全免费a级毛片免费看无码| 亚洲gay片在线gv网站| 永久免费无码网站在线观看| 亚洲国产成人久久精品软件| 看全色黄大色大片免费久久| 国产精品国产亚洲区艳妇糸列短篇| 四虎永久在线精品免费影视 | 日本人的色道免费网站| 亚洲色偷偷偷网站色偷一区| 美丽的姑娘免费观看在线播放 | 亚洲视频免费在线观看| 色播亚洲视频在线观看| 免费黄色福利视频| 亚洲精华国产精华精华液| 亚洲AV成人精品日韩一区18p| 五月婷婷免费视频| 伊人久久综在合线亚洲2019| 国产在线观看片a免费观看 | 美女视频黄免费亚洲| 国产精品免费一级在线观看| 四虎国产精品永免费| 亚洲一区二区三区电影| 啦啦啦在线免费视频| 五月天婷婷免费视频| 久久久久亚洲av无码专区| 免费看片免费播放| 三级黄色在线免费观看| 亚洲欧洲高清有无| 亚洲人成国产精品无码| 日本人的色道免费网站| 一级白嫩美女毛片免费| 亚洲精品在线不卡| 亚洲男人的天堂在线va拉文|