2022年2月7日星期一

Oracle Session Locked Check and unlock

-- SELECT LOCKED INFO'
SELECT SID
      ,SERIAL#
      ,SADDR
      ,MACHINE
      ,USERNAME
      ,PROGRAM 
FROM   V$SESSION 
WHERE  SID = ANY(SELECT SID 
                 FROM V$LOCK 
                 WHERE TYPE IN ('TX','TM') 

                 );  

-- UNLOCK SESSION

ALTER SYSTEM KILL SESSION 'SID, SERIAL#'; 

没有评论: