SELECT view_definition
FROM v$fixed_view_definition
WHERE view_name='GV$RESOURCE_LIMIT';

SELECT view_definition
FROM v$fixed_view_definition
WHERE view_name='GV$INSTANCE';



SELECT chr(bitand(p1,-16777216)/16777215)||
       chr(bitand(p1, 16711680)/65535) "Lock",
       bitand(p1, 65536) "Mode"
FROM v$session_wait
WHERE event = 'enqueue'


SELECT SID, TYPE, LMODE, REQUEST, ID1, ID2, BLOCK
FROM V$LOCK WHERE SID IN ( XX, YY, ZZ )
AND BLOCK = 0
AND LMODE = 0
AND ROWNUM < 100
/