GV$LOCK_TYPEselect rest.inst_id, -- INST_ID NUMBER rest.resname, -- TYPE VARCHAR2(64) rest.name, -- NAME VARCHAR2(64) rest.id1, -- ID1_TAG VARCHAR2(64) rest.id2, -- ID2_TAG VARCHAR2(64) decode -- IS_USER VARCHAR2(3) (bitand (eqt.flags, 1), 1, 'YES', 'NO'), rest.expl -- DESCRIPTION VARCHAR2(4000) from X$KSIRESTYP rest, X$KSQEQTYP eqt where (rest.inst_id = eqt.inst_id) and (rest.indx = eqt.indx) and (rest.indx > 0)