1Z0-054 · Question #115
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…
The correct answer is D. The system can sustain a maximum of 137 I/O operations per second with a throughput of 12 MB. See the full explanation below for the reasoning.
Question
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?
Options
- AThe actual latency is 10 milliseconds for one disk.
- BThe maximum sustainable I/O for a single process is 12 MB per second.
- CThe system can sustain a maximum of 137 I/O operations per second with a throughput of 6 MB
- DThe system can sustain a maximum of 137 I/O operations per second with a throughput of 12 MB
How the community answered
(37 responses)- A16% (6)
- B8% (3)
- C3% (1)
- D73% (27)
Community Discussion
No community discussion yet for this question.