DB: Stats Purge

To check the stats information:

PROMPT Stats usage

SELECT space_usage_kbytes 
FROM    V$SYSAUX_OCCUPANTS
WHERE occupant_name LIKE 'SM/OPTSTAT';

PROMPT Stats retention in days
select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual;

PROMPT Stats cutoff date
select DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY from dual;

PROMPT Stats purge example
PROMPT exec DBMS_STATS.PURGE_STATS(systimestamp -7)