查看锁表
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name, ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id=lo.object_id and lo.session_id=sess.sid;
主要是v$locked_object 这个表
解锁
alter system kill session '1460,65520';--分别为ID和ERIAL#号
完