没有返回值,说明处于专用模式:
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>