plsql 锁表查询 解除

2019独角兽企业重金招聘Python工程师标准>>>

1、查询锁表语句

select l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, s.user#,
       l.os_user_name, s.machine, s.terminal, a.sql_text, a.action
  from v$sqlarea a, v$session s, v$locked_object l
 where l.session_id = s.sid
   and s.prev_sql_addr = a.address
 order by sid, s.serial#;

或者

SELECT object_name, machine, s.sid, s.serial#,user#,username 
FROM gv$locked_object l, dba_objects o, gv$session s 
WHERE l.object_id　= o.object_id 
AND l.session_id = s.sid; 

2、删除锁表

alter system kill session 'sid, serial#'; 

 

转载于:https://my.oschina.net/schuppe/blog/1503233