ALTER_STATS_HISTORY_RETENTION

The ALTER_STATS_HISTORY_RETENTION procedure is used to modify the retention period for historical statistics. The default retention period is 31 days.

Syntax

DBMS_STATS.ALTER_STATS_HISTORY_RETENTION (
    retention       IN     NUMBER);

Parameters

The retention parameter specifies the retention period for historical statistics in days.

Errors

The error code HY000 indicates insufficient privileges.

Examples

Modify the retention period for historical statistics to 15 days.

CALL DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(15);
Query OK, 0 rows affected