View/modify stats retention - Oracle Database Script. -- View current stats retention select dbms_stats.get_stats_history_retention from dual; -- Modify the stats retention exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(60);
-- View current stats retention select dbms_stats.get_stats_history_retention from dual; -- Modify the stats retention exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(60);