1.为比较干净的演示这个过程,先重启一下数据库
sys@ora10g> startup force;
ORACLE instance started.
Total System Global Area 562036736 bytes
Fixed Size 2022312 bytes
Variable Size 176161880 bytes
Database Buffers 377487360 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
sys@ora10g>
2.使用v$session中的server字段就可以看出连接方式了
sys@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED sqlplus@testdb (TNS V1-V3) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
SHARED emagent@testdb (TNS V1-V3) ACTIVE
23 rows selected.
这里可以看到,所有oralce的后台进程都是以专有服务器连接的方式连接数据库的
三个OMS的状态都是非活动状态
3.使用共享服务器连接连接一次后,再次查看一次连接状态
sys@ora10g> conn sec/sec@ora10g
Connected.
sec@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE emagent@testdb (TNS V1-V3) INACTIVE
SHARED sqlplus@testdb (TNS V1-V3) ACTIVE
SHARED OMS ACTIVE
SHARED emagent@testdb (TNS V1-V3) ACTIVE
25 rows selected.
这里面的这一条信息:
SHARED sqlplus@testdb (TNS V1-V3) ACTIVE
就能够看到已经使用共享服务器方式连接到数据库中了,同时一个OMS进程的状态已经是活动状态。
SHARED OMS ACTIVE
-- The End --
sys@ora10g> startup force;
ORACLE instance started.
Total System Global Area 562036736 bytes
Fixed Size 2022312 bytes
Variable Size 176161880 bytes
Database Buffers 377487360 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
sys@ora10g>
2.使用v$session中的server字段就可以看出连接方式了
sys@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED sqlplus@testdb (TNS V1-V3) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
SHARED emagent@testdb (TNS V1-V3) ACTIVE
23 rows selected.
这里可以看到,所有oralce的后台进程都是以专有服务器连接的方式连接数据库的
三个OMS的状态都是非活动状态
3.使用共享服务器连接连接一次后,再次查看一次连接状态
sys@ora10g> conn sec/sec@ora10g
Connected.
sec@ora10g> select server,program,status from v$session order by 1;
SERVER PROGRAM STATUS
--------- ------------------------------------------------ --------
DEDICATED oracle@testdb (J000) ACTIVE
DEDICATED oracle@testdb (PSP0) ACTIVE
DEDICATED oracle@testdb (MMAN) ACTIVE
DEDICATED oracle@testdb (DBW0) ACTIVE
DEDICATED oracle@testdb (LGWR) ACTIVE
DEDICATED oracle@testdb (CKPT) ACTIVE
DEDICATED oracle@testdb (SMON) ACTIVE
DEDICATED oracle@testdb (q001) ACTIVE
DEDICATED oracle@testdb (q000) ACTIVE
DEDICATED oracle@testdb (QMNC) ACTIVE
DEDICATED oracle@testdb (ARC2) ACTIVE
DEDICATED oracle@testdb (ARC0) ACTIVE
DEDICATED oracle@testdb (ARC1) ACTIVE
DEDICATED oracle@testdb (PMON) ACTIVE
DEDICATED oracle@testdb (MMNL) ACTIVE
DEDICATED oracle@testdb (MMON) ACTIVE
DEDICATED oracle@testdb (CJQ0) ACTIVE
DEDICATED oracle@testdb (RECO) ACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE OMS INACTIVE
NONE emagent@testdb (TNS V1-V3) INACTIVE
SHARED sqlplus@testdb (TNS V1-V3) ACTIVE
SHARED OMS ACTIVE
SHARED emagent@testdb (TNS V1-V3) ACTIVE
25 rows selected.
这里面的这一条信息:
SHARED sqlplus@testdb (TNS V1-V3) ACTIVE
就能够看到已经使用共享服务器方式连接到数据库中了,同时一个OMS进程的状态已经是活动状态。
SHARED OMS ACTIVE
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-610018/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-610018/