GV$RESOURCE_LIMIT definition in Oracle Database 11.2
GV$RESOURCE_LIMIT

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

home |  up