Oracle鎖表處理操作筆記

標籤：Owner   語句   oracle鎖   資料庫   name   ssi   dba   pre   blog   

--查看鎖表進程SQL語句1：

SELECT sess.sid,       sess.serial#,       lo.oracle_username,       lo.os_user_name,       ao.object_name,       lo.locked_mode  FROM v$locked_object lo, dba_objects ao, v$session sess WHERE ao.object_id = lo.object_id AND lo.session_id = sess.sid;

或者

SELECT b.owner,       b.object_name,       a.session_id,       a.locked_mode  FROM v$locked_object a, dba_objects b WHERE b.object_id = a.object_id;

---查看鎖表進程SQL語句2：

SELECT *  FROM v$session t1, v$locked_object t2 WHERE t1.sid = t2.SESSION_ID;

或者

 SELECT b.username,         b.sid,         b.serial#,         logon_time    FROM v$locked_object a, v$session b   WHERE a.session_id = b.sidORDER BY b.logon_time;

--查看資料庫連接進程

SELECT sid, serial#, username,osuser FROM v$session; 

--殺掉鎖的進程 sid,serial#

ALTER SYSTEM KILL SESSION ‘sid,serial‘;

 

Oracle鎖表處理操作筆記