The DELETE_SYSTEM_STATS procedure is used to delete system statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_STATS.DELETE_SYSTEM_STATS();
Exceptions
| Error code | Description |
|---|---|
| ORA-20001 | The name of the system statistics is invalid. |
Considerations
To execute this procedure, the user must have the SYSDBA privilege or be the SYS user.
Examples
Using the DBMS_STATS.DELETE_SYSTEM_STATS stored procedure to delete all system statistics is very simple because it does not require any parameters.
BEGIN
-- Delete all system statistics
DBMS_STATS.DELETE_SYSTEM_STATS();
END;
/