GATHER_SYSTEM_STATS

The GATHER_SYSTEM_STATS procedure is used to collect system statistics.

Syntax

DBMS_STATS.GATHER_SYSTEM_STATS();

Exceptions

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

Usage Notes

• You must connect as the specified user to run this procedure.

Examples

Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure to collect system statistics such as CPU speed, disk I/O performance, and network throughput:

BEGIN
    -- Collect system statistics
    DBMS_STATS.GATHER_SYSTEM_STATS();
END;
/