oracle锁表解决

使用sys登录后执行

 

SELECT /*+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name, 

o.owner,o.object_name,o.object_type,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 

ORDER BY o.object_id,xidusn DESC

 

ALTER SYSTEM KILL SESSION '143,2007';