Shared Server Mode 확인 및 Dedicate Mode로 전환

▣ Shared Server Mode Setting

   

alter system set DISPATCHERS='' scope=both;

alter system set DISPATCHERS="(PROTOCOL=TCP)(SERVICE=orcl)(dispatchers=3)" scope=both;

alter system set MAX_DISPATCHERS=3 scope=both;

alter system set shared_servers=10 scope=both;

alter system set MAX_shared_servers=20 scope=both;

alter system set circuits=300 scope=both;

alter system set shared_server_sessions=20 scope=both;

   

▣ Shared Server Mode 확인 및 Dedicate Mode로 전환

   

[oracle@orcl ~]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2009 14:57:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

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 "orcl.oracle.com" has 1 instance(s).

  Instance "orcl", status READY, has 4 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:149 refused:0 state:ready

         LOCAL SERVER

      "D002" established:34 refused:0 current:0 max:972 state:ready

         DISPATCHER <machine: orcl.oracle.com, pid: 10849>

         (ADDRESS=(PROTOCOL=tcp)(HOST=orcl.oracle.com)(PORT=63236))

      "D001" established:12 refused:0 current:3 max:972 state:ready

         DISPATCHER <machine: orcl.oracle.com, pid: 10847>

         (ADDRESS=(PROTOCOL=tcp)(HOST=orcl.oracle.com)(PORT=63235))

      "D000" established:18 refused:0 current:2 max:972 state:ready

         DISPATCHER <machine: orcl.oracle.com, pid: 10845>

         (ADDRESS=(PROTOCOL=tcp)(HOST=orcl.oracle.com)(PORT=63234))

Service "orcl_XPT.oracle.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:149 refused:0 state:ready

         LOCAL SERVER

The command completed successfully

   

▣ 연결 테스트

   

        

S SYS> select * from v$circuit;    =>     연결 리스트

CIRCUIT  DISPATCH SERVER   WAITER   SADDR    STATUS           QUEUE             MESSAGE0   MESSAGE1

-------- -------- -------- -------- -------- ---------------- ---------------- ---------- ----------

  MESSAGE2   MESSAGE3   MESSAGES      BYTES     BREAKS

---------- ---------- ---------- ---------- ----------

PRESENTATION

--------------------------------------------------------------------------------------------------------------

PCIRCUIT

--------

2E988934 30A1ACB0 30A1C380 00       30AE5344 NORMAL           SERVER                 366           0

         0          0        599     147983        212

TTC

00

2E98974C 30A1A6FC 00       00       30AE65F8 NORMAL           NONE             0   0

         0          0      16798     835414          0

TTC

00

2E989E58 30A1ACB0 00       00       30AEB0C8 NORMAL           NONE             0   0

         0          0       5367     927622        221

TTC

00

   

S SYS> select * from v$shared_server;     =>     서비스 리스트

NAME PADDR    STATUS             MESSAGES      BYTES     BREAKS CIRCUIT        IDLE       BUSY   REQUESTS

---- -------- ---------------- ---------- ---------- ---------- -------- ---------- ---------- ----------

S000 30A1B818 WAIT(COMMON)          10665    1068526        213 00           365657     511621       5335

S001 30A1BDCC WAIT(COMMON)          20831    4128110       1673 00           756245     121159      10128

S002 30A1C380 EXEC                  16570    3413096       1522 2E988934     718754     158615       8249

S003 30A1C934 WAIT(COMMON)           4208     569201        141 00           770885     106247       2100

S004 30A1CEE8 WAIT(COMMON)            588      74554         16 00           831574      45478        291

S005 30A1D49C WAIT(COMMON)             68      18410          2 00           877024         18         29

S006 30A1DA50 WAIT(COMMON)             12       3164          0 00           876993         40          6

S007 30A1E004 WAIT(COMMON)              0          0          0 00           877027          0          0

S008 30A1E5B8 WAIT(COMMON)              0          0          0 00           877023          0          0

S009 30A1EB6C WAIT(COMMON)              0          0          0 00           877019          0          0

10 rows selected.

   

             

▣ Shared Server Mode 중단 (Dedicate Mode로 전환)

  => 9i 이전 버전은 db 설치시만 결정 가능, 10g 이후는 향후 파라미터 수정으로 셋팅 가능

S SYS> alter system set dispatchers='' scope=both

S SYS> alter system set dispatchers='' scope=both;

System altered.

S SYS> alter system set shared_servers=1 scope=both;

System altered.

S SYS> alter system set max_shared_servers=0 scope=both;

System altered.

S SYS> alter system set max_dispatchers=0 scope=both;

System altered.

S SYS> alter system set shared_server_sessions=0 scope=both;

System altered.

S SYS> shutdown immediate

S SYS> startup 

[oracle@orcl ~]$ lsnrctl stop

[oracle@orcl ~]$ lsnrctl start

            

   

▣ 확인

[oracle@orcl ~]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2009 15:10:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

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

The command completed successfully 

S SYS> select * from v$circuit;

no rows selected

S SYS> select * from v$shared_server;

NAME PADDR    STATUS             MESSAGES      BYTES     BREAKS CIRCUIT        IDLE       BUSY   REQUESTS

---- -------- ---------------- ---------- ---------- ---------- -------- ---------- ---------- ----------

S000 3021ACB0 WAIT(COMMON)              0          0          0 00             6796          0   0