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 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 some measurement unit.
    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 sequential read speed of the disk to 200. The value 200 is illustrative and represents the disk speed in some measurement unit.
    DBMS_STATS.SET_SYSTEM_STATS('disk_seq_read_speed', 200);
END;
/