【實驗】【Shared Server Mode】取消共享伺服器模式
【實驗目標】
共享伺服器模式 ---> 專有伺服器模式
Shared Server Mode ---> Dedicatied Server Mode
【方法一】需要重新啟動資料庫
中心思想:註釋掉shared_servers、max_shared_servers、dispatchers和max_dispatchers四個引數,重啟資料庫
1.生成待修改的PFILE
sys@ora10g> create pfile from spfile;
File created.
2.修改PFILE,將shared_servers、max_shared_servers、dispatchers和max_dispatchers四個引數刪除掉或註釋掉
ora10g@testdb /home/oracle$ vi $ORACLE_HOME/dbs/initora10g.ora
3.關閉資料庫
sys@ora10g> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
4.透過上面的PFILE生成SPFILE
NotConnected@> create spfile from pfile='$ORACLE_HOME/dbs/initora10g.ora';
File created.
5.重啟資料庫(這時預設使用的引數檔案已經是剛剛生成的SPFILE)
NotConnected@> startup;
ORACLE instance started.
Total System Global Area 562036736 bytes
Fixed Size 2022312 bytes
Variable Size 163578968 bytes
Database Buffers 390070272 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
6.OK,修改成功。
sec@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED OMS INACTIVE
DEDICATED OMS ACTIVE
DEDICATED OMS INACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED OMS INACTIVE
DEDICATED OMS INACTIVE
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED sqlplus@testdb (TNS V1-V3) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED emagent@testdb (TNS V1-V3) ACTIVE
25 rows selected.
【方法二】不需要重新啟動資料庫
中心思想:線上將shared_servers、max_shared_servers兩個引數修改為零(0)。
1.當前共享伺服器程式情況
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2330 501830
S001 000000008165F4D8 EXEC 111 16136
S002 000000008165FCC0 WAIT(COMMON) 12677 2929774
2.先看一下修改shared_servers引數為0的效果
sys@ora10g> alter system set shared_servers=0 scope=both;
System altered.
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2356 505158
S001 000000008165F4D8 EXEC 187 24957
S002 000000008165FCC0 WAIT(COMMON) 14770 3309104
3.是不是效果不明顯呢?那再看看將max_shared_servers引數修改為0的效果
sys@ora10g> alter system set max_shared_servers=0 scope=both;
System altered.
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2386 508998
S001 000000008165F4D8 EXEC 191 26155
S002 000000008165FCC0 QUIT 14966 3318519
到這裡,所有的伺服器程式都被強制終止。
4.OK,在不能重新啟動的資料庫系統中就可以使用這樣的方法進行修改。
-- The End --
共享伺服器模式 ---> 專有伺服器模式
Shared Server Mode ---> Dedicatied Server Mode
【方法一】需要重新啟動資料庫
中心思想:註釋掉shared_servers、max_shared_servers、dispatchers和max_dispatchers四個引數,重啟資料庫
1.生成待修改的PFILE
sys@ora10g> create pfile from spfile;
File created.
2.修改PFILE,將shared_servers、max_shared_servers、dispatchers和max_dispatchers四個引數刪除掉或註釋掉
ora10g@testdb /home/oracle$ vi $ORACLE_HOME/dbs/initora10g.ora
3.關閉資料庫
sys@ora10g> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
4.透過上面的PFILE生成SPFILE
NotConnected@> create spfile from pfile='$ORACLE_HOME/dbs/initora10g.ora';
File created.
5.重啟資料庫(這時預設使用的引數檔案已經是剛剛生成的SPFILE)
NotConnected@> startup;
ORACLE instance started.
Total System Global Area 562036736 bytes
Fixed Size 2022312 bytes
Variable Size 163578968 bytes
Database Buffers 390070272 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
6.OK,修改成功。
sec@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED OMS INACTIVE
DEDICATED OMS ACTIVE
DEDICATED OMS INACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED OMS INACTIVE
DEDICATED OMS INACTIVE
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED sqlplus@testdb (TNS V1-V3) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED emagent@testdb (TNS V1-V3) ACTIVE
25 rows selected.
【方法二】不需要重新啟動資料庫
中心思想:線上將shared_servers、max_shared_servers兩個引數修改為零(0)。
1.當前共享伺服器程式情況
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2330 501830
S001 000000008165F4D8 EXEC 111 16136
S002 000000008165FCC0 WAIT(COMMON) 12677 2929774
2.先看一下修改shared_servers引數為0的效果
sys@ora10g> alter system set shared_servers=0 scope=both;
System altered.
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2356 505158
S001 000000008165F4D8 EXEC 187 24957
S002 000000008165FCC0 WAIT(COMMON) 14770 3309104
3.是不是效果不明顯呢?那再看看將max_shared_servers引數修改為0的效果
sys@ora10g> alter system set max_shared_servers=0 scope=both;
System altered.
sys@ora10g> select NAME,PADDR,STATUS,MESSAGES,BYTES from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES
---- ---------------- ---------------- ---------- ----------
S000 000000008165ECF0 EXEC 2386 508998
S001 000000008165F4D8 EXEC 191 26155
S002 000000008165FCC0 QUIT 14966 3318519
到這裡,所有的伺服器程式都被強制終止。
4.OK,在不能重新啟動的資料庫系統中就可以使用這樣的方法進行修改。
-- The End --
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/519536/viewspace-610026/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Shared Server Mode】“專有伺服器模式”調整為“共享伺服器模式”Server伺服器模式
- oracle實驗記錄 (SHARED server MODE)OracleServer
- 【實驗】【Shared Server Mode】專有伺服器連線還是共享伺服器連線確認方法Server伺服器
- 如何基於共享伺服器模式shared server mode配置大池large pool之二伺服器模式Server
- 共享伺服器模式(shared server)和專用伺服器模式(dedicated server)伺服器模式Server
- 【實驗】【Shared Server Mode】手工關閉某一個特定排程程式Server
- oracle 10g在共享伺服器模式shared server如何配置大池large poolOracle 10g伺服器模式Server
- 【Shared Server Mode】測試調整shared_servers引數對資料庫的影響Server資料庫
- Shared ServerServer
- 專用伺服器模式(MTS)和共享伺服器模式伺服器模式
- shared Server 分片Server
- 配置Shared ServerServer
- Dedicated and Shared Server ProcessesServer
- Oracle共享伺服器的連線模式Oracle伺服器模式
- 7、共享模式的檔案伺服器模式伺服器
- Oracle dedicated server process and shared server processOracleServer
- configure shared serverServer
- dispatcher & shared server小結Server
- Restricted Operations of the Shared Server (132)RESTServer
- zt_Oracle shared pool internals_共享池_shared_poolOracle
- ORACLE專用伺服器模式(DEDICATED)與共享伺服器模式(SHARE)的區別Oracle伺服器模式
- PHP實現多伺服器session共享之memcache共享PHP伺服器Session
- MySQL 共享鎖 (lock in share mode),排他鎖 (for update)MySql
- Oracle shared server 配置詳解OracleServer
- Shared Server Architecture (128)Server
- Shared Server Processes (Snnn) (131)Server
- oracle實驗記錄 (oracle 分析shared pool(1))Oracle
- oracle實驗記錄 (oracle 分析shared pool(2))Oracle
- Oracle Shared Cursor問題的幾個實驗Oracle
- 如何檢視資料庫是專有伺服器模式還是共享伺服器模式資料庫伺服器模式
- Oracle Shared Server(OSS)筆記 (zt)OracleServer筆記
- 共享模式 & 專有模式模式
- SSH Server CBC Mode Ciphers Enabled漏洞修復Server
- eclipse取消JS驗證EclipseJS
- ShardingSphere Mode 模式新起航:執行模式詳解模式
- 實驗6:原型模式原型模式
- Go 1.18:工作區模式workspace modeGo模式
- Sphinx Ranking Mode(排序模式) (翻譯)排序模式