Oracle锁表的相关处理

SELECT SESS.SID,

       SESS.SERIAL#,

       LO.ORACLE_USERNAME,

       LO.OS_USER_NAME,

       LO.LOCKED_MODE,

       AO.OBJECT_NAME

  FROM V$LOCKED_OBJECT LO, DBA_OBJECTS AO, V$SESSION SESS

 WHERE AO.OBJECT_ID = LO.OBJECT_ID

   AND LO.SESSION_ID = SESS.SID ---查询被锁表

 ALTER SYSTEM KILL SESSION 'sid,serial#'; ----解锁