Oracle查询和解除锁表

Oracle查询和解除锁表

1. 查询锁表的语句

SELECT P.SPID,
       A.SERIAL#,
       C.OBJECT_NAME,
       B.SESSION_ID,
       B.ORACLE_USERNAME,
       B.OS_USER_NAME
  FROM V$PROCESS P, V$SESSION A, V$LOCKED_OBJECT B, ALL_OBJECTS C
 WHERE P.ADDR = A.PADDR
   AND A.PROCESS = B.PROCESS
   AND C.OBJECT_ID = B.OBJECT_ID;

1. 2.将锁表的进程杀掉

alter   system     kill   session   'sid,serial#'; -- （其中sid=l.session_id）