how to find SID from f60webmx OS process ID in multinode environment?
Hi,
I am following the Metalink Note ID 185762.1 to find out the the apps User Using The O/S PID For Forms Users In 11i.
However I am not able to get any database session ID for any f60webmx process from the query mentioned in the note in my multi-node installation:
select
d.user_name "User Name",
b.sid SID,b.serial# "Serial#", c.spid "srvPID", a.SPID "ClPID",
to_char(START_TIME,'DD-MON-YY HH:MM:SS') "STime"
from
fnd_logins a, v$session b, v$process c, fnd_user d
where
b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)
and a.SPID = &PID
Tagged:
0