GET_STATS_HISTORY_RETENTION

The GET_STATS_HISTORY_RETENTION function is used to obtain the retention period of the current historical statistics.

Syntax

DBMS_STATS.GET_STATS_HISTORY_RETENTION
  RETURN NUMBER;

Example

Obtain the retention period of the current historical statistics.

SELECT DBMS_STATS.GET_STATS_HISTORY_RETENTION() FROM DUAL;
+------------------------------------------+
| DBMS_STATS.GET_STATS_HISTORY_RETENTION() |
+------------------------------------------+
|                                       15 |
+------------------------------------------+
1 row in set