Saturday, August 16, 2008

Find the forms session holding a lock

SELECT to_char(start_time,'HH:MI'),SUBSTR(d.user_name,1,30) "User Name"
, a.pid
, b.sid
, b.serial#
FROM v$process a, v$session b, fnd_logins c, fnd_user d
WHERE a.pid = c.pid
AND d.user_id = c.user_id
AND a.addr = b.paddr
AND c.end_time IS NULL
and to_char(c.start_time,'DD-MON-YYYY') = '11-MAR-2007'
and b.sid = 28
order by start_time;