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 execute this procedure, the user must have the SUPER privilege or be the root user.

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 cpu_speed parameter to 5000. This value 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 a measure of CPU speed.
    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 a measure of disk speed.
    DBMS_STATS.SET_SYSTEM_STATS('disk_seq_read_speed', 200);
END;
/