VIEW: SYS.DBA_ROLLING_STATISTICS

Source

View Text - Preformatted

select name,
         decode(type, 1, valuestr,
                      2, to_char(valuenum),
                      3, to_char(valuets),
                      4, to_char(valueint),
                      NULL) value, update_time
        from system.rolling$statistics
      where bitand(attributes, 1) = 0
   order by rdbid, statid

View Text - HTML Formatted

SELECT NAME
, DECODE(TYPE
, 1
, VALUESTR
, 2
, TO_CHAR(VALUENUM)
, 3
, TO_CHAR(VALUETS)
, 4
, TO_CHAR(VALUEINT)
, NULL) VALUE
, UPDATE_TIME
FROM SYSTEM.ROLLING$STATISTICS
WHERE BITAND(ATTRIBUTES
, 1) = 0 ORDER BY RDBID
, STATID