Which setting enables the baselines by default in Oracle Database 11g?

Which setting enables the baselines by default in Oracle Database 11g?

Which setting enables the baselines by default in Oracle Database 11g?

A.
setting the STATISTICS_LEVEL parameter to TYPICAL

B.
adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C.
enabling Automated Maintenance Task using Oracle Enterprise Manager

D.
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE



Leave a Reply 1

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


Magwai

Magwai

Gathering database statistics using the AWR is enabled by default and is controlled by the STATISTICS_LEVEL initialization parameter. The STATISTICS_LEVELparameter should be set to the TYPICAL or ALL to enable statistics gathering by the AWR. The default setting is TYPICAL. Setting STATISTICS_LEVEL to BASICdisables many Oracle Database features, including the AWR, and is not recommended. If STATISTICS_LEVEL is set to BASIC, you can still manually capture AWR statistics using the DBMS_WORKLOAD_REPOSITORY package. However, because in-memory collection of many system statistics—such as segments statistics and memory advisor information—will be disabled, the statistics captured in these snapshots may not be complete. For information about the STATISTICS_LEVELinitialization parameter