1.为比较干净的演示这个过程,先重启一下数据库sys@ora10g> startup force;ORACLE instance started.Total System Global Area 562036736 bytesFixed Size 2022312 bytesVariable Size 176161880 bytesDatabase Buffers 377487360 bytesRedo Buffers 6365184 bytesDatabase 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) ACTIVEDEDICATED oracle@testdb (PSP0) ACTIVEDEDICATED oracle@testdb (MMAN) ACTIVEDEDICATED oracle@testdb (DBW0) ACTIVEDEDICATED oracle@testdb (PMON) ACTIVEDEDICATED oracle@testdb (q000) ACTIVEDEDICATED oracle@testdb (QMNC) ACTIVEDEDICATED oracle@testdb (ARC2) ACTIVEDEDICATED oracle@testdb (ARC0) ACTIVEDEDICATED oracle@testdb (ARC1) ACTIVEDEDICATED oracle@testdb (J000) ACTIVEDEDICATED sqlplus@testdb (TNS V1-V3) ACTIVEDEDICATED oracle@testdb (MMNL) ACTIVEDEDICATED oracle@testdb (MMON) ACTIVEDEDICATED oracle@testdb (CJQ0) ACTIVEDEDICATED oracle@testdb (RECO) ACTIVEDEDICATED oracle@testdb (SMON) ACTIVEDEDICATED oracle@testdb (CKPT) ACTIVEDEDICATED oracle@testdb (LGWR) ACTIVENONE OMS INACTIVENONE OMS INACTIVENONE OMS INACTIVESHARED emagent@testdb (TNS V1-V3) ACTIVE23 rows selected.这里可以看到,所有oralce的后台进程都是以专有服务器连接的方式连接数据库的三个OMS的状态都是非活动状态3.使用共享服务器连接连接一次后,再次查看一次连接状态sys@ora10g> conn sec/sec@ora10gConnected.sec@ora10g> select server,program,status from v$session order by 1;SERVER PROGRAM STATUS--------- ------------------------------------------------ --------DEDICATED oracle@testdb (J000) ACTIVEDEDICATED oracle@testdb (PSP0) ACTIVEDEDICATED oracle@testdb (MMAN) ACTIVEDEDICATED oracle@testdb (DBW0) ACTIVEDEDICATED oracle@testdb (LGWR) ACTIVEDEDICATED oracle@testdb (CKPT) ACTIVEDEDICATED oracle@testdb (SMON) ACTIVEDEDICATED oracle@testdb (q001) ACTIVEDEDICATED oracle@testdb (q000) ACTIVEDEDICATED oracle@testdb (QMNC) ACTIVEDEDICATED oracle@testdb (ARC2) ACTIVEDEDICATED oracle@testdb (ARC0) ACTIVEDEDICATED oracle@testdb (ARC1) ACTIVEDEDICATED oracle@testdb (PMON) ACTIVEDEDICATED oracle@testdb (MMNL) ACTIVEDEDICATED oracle@testdb (MMON) ACTIVEDEDICATED oracle@testdb (CJQ0) ACTIVEDEDICATED oracle@testdb (RECO) ACTIVENONE OMS INACTIVENONE OMS INACTIVENONE OMS INACTIVENONE emagent@testdb (TNS V1-V3) INACTIVESHARED sqlplus@testdb (TNS V1-V3) ACTIVESHARED OMS ACTIVESHARED emagent@testdb (TNS V1-V3) ACTIVE25 rows selected.这里面的这一条信息:SHARED sqlplus@testdb (TNS V1-V3) ACTIVE就能够看到已经使用共享服务器方式连接到数据库中了,同时一个OMS进程的状态已经是活动状态。SHARED OMS ACTIVE-- The End --
oracle share server mode,【实验】【Shared Server Mode】专有服务器连接还是共享服务器连接确认方法...
最新推荐文章于 2022-10-09 10:51:40 发布