dispatcher

来源：互联网发布：windows 10 pe官方下载编辑：程序博客网时间：2024/05/01 23:07

SQL> select name,network from v$dispatcher;

NAME NETWORK
---- --------------------------------------------------------------------------------------------------------------------------------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=34574))
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.100.4)(PORT=34809))
D002 (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.100.4)(PORT=34810))

SQL> !ps -ef | grep ora_
oracle   10061     1 0 09:05 ?        00:00:01 ora_pmon_stone
oracle   10063     1 0 09:05 ?        00:00:01 ora_psp0_stone
oracle   10065     1 0 09:05 ?        00:00:00 ora_mman_stone
oracle   10067     1 0 09:05 ?        00:00:05 ora_dbw0_stone
oracle   10069     1 0 09:05 ?        00:00:03 ora_lgwr_stone
oracle   10071     1 0 09:05 ?        00:00:11 ora_ckpt_stone
oracle   10073     1 0 09:05 ?        00:00:05 ora_smon_stone
oracle   10075     1 0 09:05 ?        00:00:00 ora_reco_stone
oracle   10077     1 0 09:05 ?        00:00:08 ora_cjq0_stone
oracle   10079     1 0 09:05 ?        00:00:06 ora_mmon_stone
oracle   10081     1 0 09:05 ?        00:00:03 ora_mmnl_stone
oracle   10083     1 0 09:05 ?        00:00:00 ora_d000_stone
oracle   10087     1 0 09:05 ?        00:00:00 ora_arc0_stone
oracle   10089     1 0 09:05 ?        00:00:00 ora_arc1_stone
oracle   10093     1 0 09:05 ?        00:00:00 ora_qmnc_stone
oracle   10101     1 0 09:05 ?        00:00:00 ora_q000_stone
oracle   10103     1 0 09:05 ?        00:00:00 ora_q001_stone
oracle   10105     1 0 09:06 ?        00:00:00 ora_s000_stone
oracle   10107     1 0 09:06 ?        00:00:00 ora_s001_stone
oracle   10109     1 0 09:06 ?        00:00:00 ora_s002_stone
oracle   10365     1 0 11:02 ?        00:00:00 ora_d001_stone
oracle   10367     1 0 11:02 ?        00:00:00 ora_d002_stone
oracle   11106     1 0 17:21 ?        00:00:00 ora_j000_stone
oracle   11107 11096 0 17:22 pts/2    00:00:00 /bin/bash -c ps -ef | grep ora_
oracle   11109 11107 0 17:22 pts/2    00:00:00 grep ora_

SQL>