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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |