nerdexam
Oracle

1Z0-054 · Question #178

While diagnosing performance problems for a database, you find Buffer Busy wait is the reason from V$ views. But the Automatic Database Diagnostic Monitor (ADDM) report does not reflect the Buffer…

The correct answer is A. because an ADDM filter has been set. See the full explanation below for the reasoning.

Question

While diagnosing performance problems for a database, you find Buffer Busy wait is the reason from V$ views. But the Automatic Database Diagnostic Monitor (ADDM) report does not reflect the Buffer Busy findings. Why does the Buffer Busy finding not appear in the ADDM report?

Options

  • Abecause an ADDM filter has been set
  • Bbecause the he USE_INDIRECT_DATA_BUFFERS parameter has been set to TRUE
  • Cbecause the DBIO_EXPECTED default task parameter for ADDM has been set to zero
  • Dbecause the CONTROL_MANAGEMENT_PACK_ACCESS parameter has been set to

How the community answered

(61 responses)
  • A
    77% (47)
  • B
    3% (2)
  • C
    5% (3)
  • D
    15% (9)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice