Estimating database storage IO performance based on Dbms_resource_manager packet under Oracle

Estimating Database Storage IO performance based on Dbms_resource_manager packet under Oracle 1.calibrate_ioUse calibrate_io stored procedures to estimate database storage IO performance. The input and output of the stored procedure is as follows.

Parameter name	Parameter type	Parameter description
Num_physical_disks	Inch	Approximate number of physical disks in the database storage
Max_latency	Inch	Maximum tolerable latency in milliseconds for database-block-sized IO Requests
max_iops	out	maximum number of i/o requests per  Second that can be sustained. the i/o  Requests
max_mbps	out	maximum throughput of i/o that can  be sustained, expressed in megabytes per second.  the i/o requests are randomly-distributed, 1  megabyte reads.
Actual_latency	Out	Average Latency of database-block-sized I/O requests at Max_ IOPS rate, expressed in milliseconds

The test statements are similar to the following. Sql>set time onSet Timing onSET serveroutput onDECLARElat INTEGER;ioPS INTEGER;Mbps INTEGER;BEGINDbms_resource_manager. Calibrate_io (+, IOPS, Mbps, LAT); Dbms_output. Put_Line (' max_iops = ' | | iops); Dbms_output. Put_Line (' latency = ' | | | lat); dbms_output.put_line (' max_mbps = ' | | mbps);end;/ Note: Num_physical_disksParameters can be set large, if set too small, will affect the test results. When the value exceeds a certain limit, the estimated IO performance value will no longer change. Note:Only one estimate can be performed at the same time (single calibration can run at a. If Another calibration is initiated at thesame time, it'll fail.) Note:For Oracle RAC, the load is balanced to the individual nodes (for the Oracle Real application Clusters (Oracle RAC) database, the workload issimultaneously generated from all instances.)  Reference Documentation:"Plsql Packages and Types Reference"

Estimating database storage IO performance based on Dbms_resource_manager packet under Oracle