select
  RESOURCE_NAME,                           -- RESOURCE_NAME VARCHAR2(30)
  CURRENT_UTILIZATION,                     -- CURRENT_UTILIZATION NUMBER
  MAX_UTILIZATION,                         -- MAX_UTILIZATION NUMBER
  INITIAL_ALLOCATION,                      -- INITIAL_ALLOCATION VARCHAR2(10)
  LIMIT_VALUE                              -- LIMIT_VALUE VARCHAR2(10)
from
  GV$RESOURCE_LIMIT
where
  inst_id = USERENV('Instance')