MTS

[fordikon]

how to find wheather MTS is configured correctly and system in running on MTS instead of Dedicated.

[marist89]

Look at the "SERVER" column from the following query. If the value is "DEDICATED" they those sessions are not using MTS. The "SERVER" column will be "NONE" or "SHARED" if those sessions are using MTS.

set pages 50
col kill_by for a10
col username for a12
col program for a40
col "MACHINE/PID" for a20
set linesize 132
set pages 100
select '''' || s.sid ||','||s.serial# || '''' kill_by,
p.spid server_pid, s.username, s.program,
decode(s.process, NULL, s.machine, s.machine || ' PID: ' || to_char(s.process)) "MACHINE/PID" ,
s.server, s.status
from v$session s, v$process p
where s.username is not null
and s.paddr = p.addr
order by to_number(p.spid)
/