oracle专用模式修改为共享模式

 没有返回值，说明处于专用模式：

SQL> select * from V$dispatcher;

no rows selected

修改相关参数：

SQL> alter system set shared_servers=5 scope=both;

System altered.

SQL> alter system set dispatchers='(PROTOCOL=TCP) (dispatchers=3)' scope=both;

System altered.

SQL> alter system register;

System altered.

再次查看：

SQL> select * from V$dispatcher;

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

D000

(ADDRESS=(PROTOCOL=tcp)(HOST=dbsun01)(PORT=32800))

6293B56C WAIT                                             YES                0

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

         0          0          0          0       6284         46          0

         0

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

D001

(ADDRESS=(PROTOCOL=tcp)(HOST=dbsun01)(PORT=32801))

6293E8E4 WAIT                                             YES                0

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

         0          0          0          0       2916          0          0

         0

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

D002

(ADDRESS=(PROTOCOL=tcp)(HOST=dbsun01)(PORT=32802))

6293EE9C WAIT                                             YES                0

NAME

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

NETWORK

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

PADDR    STATUS                                           ACCEPT      MESSAGES

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

     BYTES     BREAKS      OWNED    CREATED       IDLE       BUSY   LISTENER

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

CONF_INDX

----------

         0          0          0          0       2882          0          0

         0

SQL>