oracle@rhel6是dblink连过来的
sqlplus@rhel6是远程sqlplus等陆
sqlplus@rhel5 本地的
（module不同）
SQL> /
SID PROGRAM MODULE MACHINE
---------- ------------------------------------------------ ---------------------------------------------------------------- ----------------------------------------------------------------
2 oracle@rhel5 (PMON) rhel5
3 oracle@rhel5 (PSP0) rhel5
4 oracle@rhel5 (VKTM) rhel5
5 oracle@rhel5 (GEN0) rhel5
6 oracle@rhel5 (DIAG) rhel5
7 oracle@rhel5 (DBRM) rhel5
8 oracle@rhel5 (DIA0) rhel5
9 oracle@rhel5 (MMAN) rhel5
10 oracle@rhel5 (DBW0) rhel5
11 oracle@rhel5 (LGWR) rhel5
12 oracle@rhel5 (CKPT) rhel5
13 oracle@rhel5 (SMON) rhel5
14 oracle@rhel5 (RECO) rhel5
15 oracle@rhel5 (MMON) rhel5
16 oracle@rhel5 (MMNL) rhel5
17 oracle@rhel5 (CJQ0) rhel5
18 oracle@rhel5 (ARC0) rhel5
20 oracle@rhel5 (ARC1) rhel5
21 oracle@rhel5 (ARC2) rhel5
23 oracle@rhel5 (ARC3) rhel5
25 oracle@rhel5 (QMNC) Streams rhel5
29 oracle@rhel5 (Q002) Streams rhel5
31 oracle@rhel5 (SMCO) KTSJ rhel5
36 oracle@rhel5 (W000) KTSJ rhel5
38 oracle@rhel5 (Q004) Streams rhel5
40 sqlplus@rhel5 (TNS V1-V3) sqlplus@rhel5 (TNS V1-V3) rhel5
43 sqlplus@rhel6 (TNS V1-V3) SQL*Plus rhel6
47 oracle@rhel6 (TNS V1-V3) oracle@rhel6 (TNS V1-V3) rhel6
48 sqlplus@rhel5 (TNS V1-V3) sqlplus@rhel5 (TNS V1-V3) rhel5
v$session中不同连接方式module,program的区别
原文：https://www.cnblogs.com/nadian-li/p/12774176.html
