The GATHER_SYSTEM_STATS procedure collects system statistics.
Syntax
DBMS_STATS.GATHER_SYSTEM_STATS();
Exceptions
| Error code | Description |
|---|---|
| HY000 | The entered name of the system statistical item is incorrect. |
Considerations
- To call this procedure, you must connect to the database as the specified user, or have the
SYSDBAprivilege.
Examples
Call the DBMS_STATS.GATHER_SYSTEM_STATS procedure to collect system statistics, such as the CPU speed, disk I/O performance, and network throughput.
BEGIN
-- Collect system statistics.
DBMS_STATS.GATHER_SYSTEM_STATS();
END;
/