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?

Question

Exhibit

Options

• AIt produces better query plans if the recommendation is implemented.
• BIt gives the maximum reduction in the number of input/output (I/O) operations.
• CIt gives the maximum reduction in resource usage if the recommendation is implemented.
• DIt gives the maximum reduction in database elapsed time if the recommendation is implemented.

• A
  4% (1)
• B
  4% (1)
• C
  12% (3)
• D
  81% (21)

No community discussion yet for this question.