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 --

ITPub博客

【实验】【Shared Server Mode】专有服务器连接还是共享服务器连接确认方法

最新文章