Why does the Buffer Busy finding not appear in the ADDM report?

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?

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?

A.
because an ADDM filter has been set

B.
because the he USE_INDIRECT_DATA_BUFFERS parameter has been set to TRUE

C.
because the DBIO_EXPECTED default task parameter for ADDM has been set to zero

D.
because the CONTROL_MANAGEMENT_PACK_ACCESS parameter has been set to
DIAGNOSTIC



Leave a Reply 1

Your email address will not be published. Required fields are marked *