数据库表锁查询与解锁

查询当前表的状态：

 

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
ORDER BY sess.SID

 

 

解锁：

 

ALTER SYSTEM KILL SESSION "SID,SERIAL#";

 

其中SID、SERIAL#为查询得到的值