GV$DLM_RESS
select inst_id, -- INST_ID NUMBER kjirftrp, -- RESP RAW(4) kjirftrn, -- RESOURCE_NAME VARCHAR2(30) kjirftcq, -- ON_CONVERT_Q NUMBER kjirftgq, -- ON_GRANT_Q NUMBER kjirftpr, -- PERSISTENT_RES NUMBER kjirftmn, -- MASTER_NODE NUMBER kjirftncl, -- NEXT_CVT_LEVEL VARCHAR2(9) kjirftvs, -- VALUE_BLK_STATE VARCHAR2(32) kjirftvb -- VALUE_BLK VARCHAR2(64) from x$kjirft union all select inst_id, -- INST_ID NUMBER kjbrresp, -- RESP RAW(4) kjbrname, -- RESOURCE_NAME VARCHAR2(30) decode -- ON_CONVERT_Q NUMBER (kjbrcvtq, '00', 0, 1), decode -- ON_GRANT_Q NUMBER (kjbrgrantq, '00', 0, 1), 1, -- PERSISTENT_RES NUMBER kjbrmaster, -- MASTER_NODE NUMBER kjbrncvl, -- NEXT_CVT_LEVEL VARCHAR2(9) 'KJUSERVS_NOVALUE', -- VALUE_BLK_STATE VARCHAR2(32) '0x0' -- VALUE_BLK VARCHAR2(64) from x$kjbr

home |  up  |  mailbox