oracle锁表与kill session

1、锁表查询

select t2.username,
       t2.sid,
       t2.serial#,
       t3.object_name,
       t2.OSUSER,
       t2.MACHINE,
       t2.PROGRAM,
       t2.LOGON_TIME,
       t2.COMMAND
  from v$locked_object t1, v$session t2, dba_objects t3
 where t1.session_id = t2.sid
   --AND t3.OBJECT_NAME='XXXXX'     (查询指定表是否被锁)    
   and t1.object_id = t3.object_id;

 

2、释放被锁表，kill session

alter system kill session 'sid,serial#';   --该表对应sid与serial#

 

3、提示session已被kill，但表仍然被锁

alter system kill session 'sid,serial#' IMMEDIATE ;