Oracle 1z0-182 Question Answer
Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?
The Automatic SQL Access Advisor task, which is used to manage an application SQL load.
The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.
The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.
The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.
The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.
Automatic Maintenance Tasks (AMTs) in 23ai optimize database performance. Let’s explore:
A.False. SQL Access Advisor exists but isn’t an AMT; it’s manual or invoked separately.
B.False. SQL Performance Analyzer assesses change impacts but isn’t part of AMTs.
C.False. No “Automatic Index Advisor” exists as an AMT; Auto Index is a separate feature.
D.True. The SPM Evolve Advisor task (part of ORA$AUTOTASK) automatically evolves SQL plan baselines, testing and accepting new plans.
Mechanics:Runs in maintenance windows, managed by DBMS_SPM.
E.True. SQL Tuning Advisor (STA) runs automatically via AMTs, tuning high-load SQL.
Mechanics:Identifies candidates from AWR and suggests indexes, profiles, etc.
TESTED 16 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved