How to View System Statistics History
Posted by Matthias Rogel on 11. October 2011
DBMS_STATS.RESTORE_SYSTEM_STATS allows us to restore system stats to a timestamp before.
In order to view them historically, you have to query SYS.WRI$_OPTSTAT_AUX_HISTORY