GET_STATS_HISTORY_AVAILABILITY

The GET_STATS_HISTORY_AVAILABILITY function returns the earliest time of the available historical statistics. You cannot restore historical statistics that are earlier than this time.

Syntax

DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY
  RETURN TIMESTAMP WITH TIMEZONE;

Examples

Return the earliest time of the available historical statistics.

SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY() FROM DUAL;
+---------------------------------------------+
| DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY() |
+---------------------------------------------+
| 2022-12-06 22:00:01.007146                  |
+---------------------------------------------+
1 row in set