oracle的idle模式,oracle专用模式修改为共享模式

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

SQL> select * from v$dispatcher;

未选定行

SQL> show parameter shared_ser

NAME TYPE VALUE

max_shared_servers integer

shared_server_sessions integer

shared_servers integer 0

在线修改共享服务器进程的数量

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

系统已更改。

SQL> show parameter shared_servers

NAME TYPE VALUE

max_shared_servers integer

shared_servers integer 5

SQL>

配置dispatchersDispatchers参数用于配置共享模式架构中dispatcher进程，共享模式只少需要一个dispatcher进程。

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

系统已更改。

再次查看

SQL> select * from v$dispatcher;

NAME

----

NETWORK

PADDR STATUS ACC MESSAGES BYTES BREAKS

---

OWNED CREATED IDLE BUSY LISTENER CONF_INDX

D000

(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-G7Q6ORP7VGQ)(PORT=49432))

000007FF22CC3238 WAIT YES 0 0 0

0 0 20107 0 0 0

NAME

----

NETWORK

PADDR STATUS ACC MESSAGES BYTES BREAKS

---

OWNED CREATED IDLE BUSY LISTENER CONF_INDX

D001

(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-G7Q6ORP7VGQ)(PORT=49437))

000007FF22CC97A8 WAIT YES 0 0 0

0 0 532 0 0 0

NAME

----

NETWORK

PADDR STATUS ACC MESSAGES BYTES BREAKS

---

OWNED CREATED IDLE BUSY LISTENER CONF_INDX

D002

(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-G7Q6ORP7VGQ)(PORT=49438))

000007FF22CCA890 WAIT YES 0 0 0

0 0 526 0 0 0

SQL>