SQL Query to Get Oracle Blocking Sessions


SELECT DECODE(REQUEST,0,'HOLDER: ','WAITER: ')||SID SESS,ID1,ID2,LMODE,REQUEST,TYPE
FROM   GV$LOCK
WHERE  (ID1, ID2, TYPE) IN(   SELECT ID1,ID2, TYPE
FROM GV$LOCK WHERE REQUEST>0)
 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer