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.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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