复制idle> show parameter shared_server mts_servers NAME_COL_PLUS_SHOW_PARAM TYPE ------------------------------------------------------------ VALUE_COL_PLUS_SHOW_PARAM ------------------------------------------------------------ max_shared_servers integer 20 shared_server_sessions integer 165 shared_servers integer 1 --如果VALUE_COL_PLUS_SHOW_PARAM大于0为dedicated模式 idle> select p.program,专用
s.server from v$session s , v$process p 2 where s.paddr = p.addr 3 ; PROGRAM SERVER ------------------------------------------------ --------- oracle@infa (PMON) DEDICATED oracle@infa (DBW0) DEDICATED oracle@infa (LGWR) DEDICATED oracle@infa (CKPT) DEDICATED oracle@infa (SMON) DEDICATED oracle@infa (RECO) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED oracle@infa (TNS V1-V3) DEDICATED 15 rows selected. 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.
