SELECT * FROM v$locked_object
select object_name, machine, s.sid, s.serial#
from v$locked_object l, dba_objects o, v$session s
where l.OBJECT_ID = o.OBJECT_ID
and l.SESSION_ID = s.SID;
alter system kill session '1738:47083';