The SET_SYSTEM_STATS procedure is used to set system statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
DBMS_STATS.SET_SYSTEM_STATS (
pname VARCHAR2,
pvalue NUMBER);
Parameters
Parameter |
Description |
|---|---|
| pname | The parameter name. Valid values: cpu_speed, disk_seq_read_speed, disk_rnd_read_speed, and network_speed. |
| pvalue | The value of the parameter. |
Exceptions
Error Code |
Description |
|---|---|
| OBE-20001 | The name of the system statistics is invalid. |
Considerations
- To run this procedure, you must connect as the specified user or have the
SYSDBAprivilege.
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 value of pvalue is 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 a certain 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 disk sequential read speed to 200. The value 200 is illustrative and represents the disk speed in a certain unit.
DBMS_STATS.SET_SYSTEM_STATS('disk_seq_read_speed', 200);
END;
/