GV$RESOURCE_LIMIT

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