The DELETE_SYSTEM_STATS procedure deletes system statistics.
Syntax
DBMS_STATS.DELETE_SYSTEM_STATS();
Exceptions
| Error code | Description |
|---|---|
| HY000 | The entered name of the system statistical item is incorrect. |
Considerations
To execute this procedure, you must have the SUPER privilege or use the root account.
Examples
Call the DBMS_STATS.DELETE_SYSTEM_STATS stored procedure to delete all system statistics without setting any parameters.
BEGIN
-- Delete all system statistics.
DBMS_STATS.DELETE_SYSTEM_STATS();
END;
/