【實驗】【Shared Server Mode】手工關閉某一個特定排程程式

secooler發表於2009-07-23
Server
1.列出系統中的排程程式
sys@ora10g> col NETWORK for a50
sys@ora10g> select NAME,NETWORK,STATUS from v$dispatcher;

NAME NETWORK                                            STATUS
---- -------------------------------------------------- ----------------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=23377))  WAIT
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=63510))  WAIT
D002 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=22876))  WAIT
D003 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=24477))  WAIT
D004 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=47889))  WAIT
D005 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=33295))  WAIT

6 rows selected.

2.【任務】手工殺死D003
sys@ora10g> alter system shutdown immediate 'D003';

System altered.

3.確定D003已經被殺死掉了
sys@ora10g> select NAME,NETWORK,STATUS from v$dispatcher;

NAME NETWORK                                            STATUS
---- -------------------------------------------------- ----------------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=23377))  WAIT
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=63510))  WAIT
D002 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=22876))  WAIT
D004 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=47889))  WAIT
D005 (ADDRESS=(PROTOCOL=tcp)(HOST=testdb)(PORT=33295))  WAIT

-- The End --

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/519536/viewspace-610014/，如需轉載，請註明出處，否則將追究法律責任。

相關文章