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>