The PURGE_STATS procedure purges the historical statistics saved before the specified timestamp.
Syntax
DBMS_STATS.PURGE_STATS(
before_timestamp TIMESTAMP WITH TIME ZONE);
Parameters
Statistics saved before the timestamp specified by the before_timestamp parameter will be purged. If the value is set to NULL, the automatic purge strategy is used.
Exceptions
| Error code | Description |
|---|---|
| HY000 |
|
Examples
Manually purge the historical statistics saved before the specified timestamp.
obclient [testUser01]> CALL DBMS_STATS.PURGE_STATS ('2021-09-26 19:02:12.675729');
Query OK, 0 rows affected