SET_SYSTEM_STATS

The SET_SYSTEM_STATS procedure is used to set system statistics.

Syntax

DBMS_STATS.SET_SYSTEM_STATS (
   pname          VARCHAR2,
   pvalue         NUMBER);

Parameters

Exceptions

Considerations

• To run this procedure, you must connect as the specified user or have the SYSDBA privilege.

Examples

Here is an example of using the DBMS_STATS.SET_SYSTEM_STATS stored procedure to set system statistics. In this example, we set the system statistics parameter named cpu_speed. The pvalue is set to 5000, which should be based on actual measurements or estimates and represents the number of CPU cycles that can be executed per second in the current hardware environment.

BEGIN
    -- Set the CPU speed to 5000. The value 5000 is illustrative and represents the CPU speed in a certain unit of measurement.
    DBMS_STATS.SET_SYSTEM_STATS('cpu_speed', 5000);
END;
/

If you want to set the sequential read speed of the disk (disk_seq_read_speed), you can execute the following call:

BEGIN
    -- Set the disk sequential read speed to 200. The value 200 is illustrative and represents the disk speed in a certain unit of measurement.
    DBMS_STATS.SET_SYSTEM_STATS('disk_seq_read_speed', 200);
END;
/