Exit 1Z0-182 Oracle Database 23ai Administration Associate
Question 2 of 5
0% complete
Q2 Multiple choice

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?

Select all that apply.

  • A

    Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

  • B

    ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to
    identify potential problems before system performance degrades noticeably.

  • C

    Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

  • D

    Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

  • E

    Automatic Application Tracing used to collect High-Load SQL statements and statistics.