Post date: Nov 09, 2010 1:44:57 PM
SELECT dbo.object_name, vse.lockwait, ffs.SID, ffs.serial#, ffs.user_name,
ffs.responsibility_name, vse.logon_time
FROM v$locked_object vlo,
dba_objects dbo,
fnd_form_sessions_v ffs,
v$session vse
WHERE vlo.object_id = dbo.object_id
AND ffs.SID = vlo.session_id
AND vse.SID = ffs.SID
alter system kill session 'SID, SERIAL#'
contoh :
alter system kill session '2882,1198'