GV$RESOURCE
select inst_id, -- INST_ID NUMBER addr, -- ADDR RAW(4) ksqrsidt, -- TYPE VARCHAR2(2) ksqrsid1, -- ID1 NUMBER ksqrsid2 -- ID2 NUMBER from x$ksqrs where bitand (ksqrsflg, 2) !=0

home |  up  |  mailbox