The GET_STATS_HISTORY_AVAILABILITY function obtains the time of the earliest 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
Obtain the time of the earliest available historical statistics.
obclient> 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