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

来源：互联网发布：程序员代码图片编辑：程序博客网时间：2024/05/22 03:34

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

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

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

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

SQL>