The DELETE_SYSTEM_STATS procedure is used to delete system statistics.
Syntax
DBMS_STATS.DELETE_SYSTEM_STATS();
Exceptions
| Error code | Description |
|---|---|
| HY000 | The system statistics name is incorrect. |
Considerations
- To run this procedure, you must connect as the specified user or have the
SYSDBAprivilege.
Examples
Using the DBMS_STATS.DELETE_SYSTEM_STATS stored procedure to delete all system statistics is very simple because it requires no parameters.
BEGIN
-- Delete all system statistics
DBMS_STATS.DELETE_SYSTEM_STATS();
END;
/