表解锁

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';