简单表解锁

//此语句用来查询

SELECT OBJECT_ID,

       SESSION_ID,

       SERIAL#,

       ORACLE_USERNAME,

       OS_USER_NAME,

       S.PROCESS

  FROM V$LOCKED_OBJECT A, V$SESSION S

 WHERE A.SESSION_ID = S.SID;

//此句来KIll锁表的SESSION

alter system kill session 'sid,serial#';