column "User Name" format a10
column "ClPID" format a8
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"
fnd_logins a, v$session b, v$process c, fnd_user d
b.paddr = c.addr
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
"This note can help in case that your f60webmx process id very intense or high CPU usage / memory and you want to identify who has created that session. The script output can also help to determine the apps user that used Ctrl-Alt-Del to close an Oracle Applications 11i session and that session hung on the Forms-tier/DB-tier."