how to find a session id based on query

[tomate]

hi,

take this i havn't test it, but i think it helps you

select
s.osuser,
p.spid "PID",
s.sid "SID",
s.terminal,
s.program,
s.status,
to_char(logon_time, 'DD-MON HH24:MI:SS') "Login Time"
from
v$session s,
v$process p
where p.addr = s.paddr
and s.osuser != 'oracle'
order by pid;