The GATHER_SYSTEM_STATS process is used to collect system statistics.
Syntax
DBMS_STATS.GATHER_SYSTEM_STATS();
Exceptions
Error Code |
Description |
|---|---|
| HY000 | The system statistics name entered is incorrect. |
Usage instructions
- To run this procedure, you must be connected as the specified user or have the
SYSDBAprivilege.
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;
/