The GET_STATS_HISTORY_RETENTION function obtains the retention period of historical statistics.
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_RETENTION
RETURN NUMBER;
Examples
Obtain 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
