Locked objects
Return information on locked objects.
Last updated:
Warning: Review and test in a non-production environment before running.
select object_name, s.sid, s.serial#, p.spid
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr;
select * from v$session where osuser = 'user name';
ALTER SYSTEM KILL SESSION 'sid,serial#';