Sokrates on Oracle

Archive for October, 2011

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

Advertisements

Posted in Allgemein | Leave a Comment »