select inst_id, -- INST_ID NUMBER ksurlmnm, -- RESOURCE_NAME VARCHAR2(30) ksurlmcv, -- CURRENT_UTILIZATION NUMBER ksurlmmv, -- MAX_UTILIZATION NUMBER LPAD(decode(bitand(ksurlmfg, 1), 0, to_char(ksurlmia), 'UNLIMITED'),10),-- INITIAL_ALLOCATION VARCHAR2(10) LPAD(decode(bitand(ksurlmfg, 2), 0, to_char(ksurlmlv), 'UNLIMITED'),10) -- LIMIT_VALUE VARCHAR2(10) from x$ksurlmt