数据库锁表查询及释放锁

锁表查询

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

释放锁

--alter system kill session 'sid, serial#'; 
ALTER system kill session '413, 3701';

 查询数据正在运行状态的SQL

SELECT SUBSTR(S.USERNAME, 1, 18) USERNAME,
       S.STATUS,
       S.SID,
       S.SERIAL#,
       S.MACHINE,
       Y.SQL_TEXT
  FROM V$SESSION     S,
       V$PROCESS     P,
       V$TRANSACTION T,
       V$ROLLSTAT    R,
       V$ROLLNAME    N,
       V$SQL         Y
 WHERE S.PADDR = P.ADDR
   AND S.TADDR = T.ADDR(+)
   AND T.XIDUSN = R.USN(+)
   AND R.USN = N.USN(+)
   AND S.USERNAME IS NOT NULL
   AND S.SQL_ADDRESS = Y.ADDRESS
--and s.sid=43
 ORDER BY S.SID, S.SERIAL#, S.USERNAME, S.STATUS;

 

转载于:https://www.cnblogs.com/ycyang/p/6880865.html