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 | Google