VIEW: SYS.INT$DBA_HIST_RESOURCE_LIMIT

Source

View Text - Preformatted

select rl.snap_id, rl.dbid, rl.instance_number, resource_name,
       current_utilization, max_utilization, initial_allocation,
       limit_value,
       decode(rl.con_dbid, 0, rl.dbid, rl.con_dbid),
       0 con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_RESOURCE_LIMIT rl
  where     sn.snap_id         = rl.snap_id
        and sn.dbid            = rl.dbid
        and sn.instance_number = rl.instance_number

View Text - HTML Formatted

SELECT RL.SNAP_ID
, RL.DBID
, RL.INSTANCE_NUMBER
, RESOURCE_NAME
, CURRENT_UTILIZATION
, MAX_UTILIZATION
, INITIAL_ALLOCATION
, LIMIT_VALUE
, DECODE(RL.CON_DBID
, 0
, RL.DBID
, RL.CON_DBID)
, 0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_RESOURCE_LIMIT RL
WHERE SN.SNAP_ID = RL.SNAP_ID
AND SN.DBID = RL.DBID
AND SN.INSTANCE_NUMBER = RL.INSTANCE_NUMBER