Exit 1Z0-054 Oracle Database 11g: Performance Tuning
Question 3 of 5
0% complete
Q3 Single choice

After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit.

What is the significance of the Benefit(%) column in the Exhibit?

  • A

    It produces better query plans if the recommendation is implemented.

  • B

    It gives the maximum reduction in the number of input/output (I/O) operations.

  • C

    It gives the maximum reduction in resource usage if the recommendation is implemented.

  • D

    It gives the maximum reduction in database elapsed time if the recommendation is implemented.

Previous Next