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
2 l_latency INTEGER;
3 l_iops INTEGER;
4 l_mbps INTEGER;
5 BEGIN
6 dbms_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.