What do you infer from the output?

You are working on a single node database. The storage for the database was recently upgraded
to new, faster hard disks and new disk controllers. You ran the I/O calibration procedure to check
the I/O metrics for the upgraded storage. The details for the execution of the I/O calibration
procedure are given below:
SQL>DECLARE
2l_latency INTEGER;
3l_iops INTEGER;
4l_mbps INTEGER;
5 BEGIN
6dbms_resource_manager.calibrate_io (1,10,l_iops,l_mbps,l_latency);
7 END;/
You queried the DBA_RSRC_IO_CALIBRATE data dictionary view to check the results of the I/O
calibration. The output for the query is given as follows:
SQL> SELECT max_iops, max_mbps, max_pmbps, latency
FROM DBA_RSRC_IO_CALIBRATE;
MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY
———- ———- ———- ———-
137 12 6 64
What do you infer from the output?

You are working on a single node database. The storage for the database was recently upgraded
to new, faster hard disks and new disk controllers. You ran the I/O calibration procedure to check
the I/O metrics for the upgraded storage. The details for the execution of the I/O calibration
procedure are given below:
SQL>DECLARE
2l_latency INTEGER;
3l_iops INTEGER;
4l_mbps INTEGER;
5 BEGIN
6dbms_resource_manager.calibrate_io (1,10,l_iops,l_mbps,l_latency);
7 END;/
You queried the DBA_RSRC_IO_CALIBRATE data dictionary view to check the results of the I/O
calibration. The output for the query is given as follows:
SQL> SELECT max_iops, max_mbps, max_pmbps, latency
FROM DBA_RSRC_IO_CALIBRATE;
MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY
———- ———- ———- ———-
137 12 6 64
What do you infer from the output?

A.
The actual latency is 10 milliseconds for one disk.

B.
The maximum sustainable I/O for a single process is 12 MB per second.

C.
The system can sustain a maximum of 137 I/O operations per second with a throughput of 6
MB per second.

D.
The system can sustain a maximum of 137 I/O operations per second with a throughput of 12
MB per second.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong
B is wrong. PMPS 6, not 12
C is wrong. MPS is 12, not 6
D is right.