DELETE_SYSTEM_STATS

The DELETE_SYSTEM_STATS procedure is used to delete system statistics.

Syntax

DBMS_STATS.DELETE_SYSTEM_STATS();

Exceptions

Error Code	Description
HY000	The name of the system statistics is incorrect.

Usage notes

• To run this procedure, you must connect as the specified 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;
/