1.
select object_id from dba_objects where object_name = '被锁住的表名';
2.
select 'alter system kill session ''' || SID || ',' || SERIAL# || ''';'
from V$session
where SID in (select sid
from v$enqueue_lock t
where t.type = 'TO'
and id1 = '第一步查出来的ID')
第二步查询出SQL语句,直接粘贴出来执行即可。