Use the below query to find the sid and other details of specifice database module running(programs)

Use the below query to find the sid and other details of specifice database module running(programs)

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.module = '%&Module_name%';