The GET_STATS_HISTORY_RETENTION function obtains the retention period of historical statistics.
Syntax
DBMS_STATS.GET_STATS_HISTORY_RETENTION
RETURN NUMBER;
Examples
Obtains the retention period of the historical statistics.
obclient> SELECT DBMS_STATS.GET_STATS_HISTORY_RETENTION() FROM DUAL;
+------------------------------------------+
| DBMS_STATS.GET_STATS_HISTORY_RETENTION() |
+------------------------------------------+
| 15 |
+------------------------------------------+
1 row in set