oracle 锁表查询及kill

 --1.查看被锁的表
 select session_t.sid,
        session_t.serial#,
        lock_object.oracle_username,
        lock_object.os_user_name,
        all_object.object_name,
        session_t.username,
        session_t.schemaname,
        session_t.osuser,
        session_t.process,
        session_t.machine,
        session_t.terminal,
        lock_object.locked_mode
   from v$locked_object lock_object,
        all_objects     all_object,
        v$session       session_t
  where all_object.object_id = lock_object.object_id
    and lock_object.session_id = session_t.sid
  order by session_t.sid asc;
  --2.根据sid,serial#查杀，假设 sid,serial# 为 156,3443
  alter system kill session '156,3443' immediate ;

转载于:https://www.cnblogs.com/dayoff/p/9839165.html