Which type of SQL statement would be selected for tuning by the automatic SQL framework?

Question

Options

• ASerial queries that are among the costliest in any or all of the four categories: the past week, any day in
• BSerial queries that have been tuned within the last 30days and have been SQL profiled by the SQL tuning
• CSerial and parallel queries that top the AWR Top SQL in the past week only and have been SQL profiled
• DSerial queries that top the AWR Top SQL in the past week only and whose poor performance can be
• ESerial and parallel queries that are among the costliest in any or all of the four categories: the past week,

• A
  11% (3)
• B
  4% (1)
• C
  7% (2)
• D
  4% (1)
• E
  74% (20)

Explanation

The Automatic Tuning Optimizer is meant to be used for complex and high-load SQL statements that have non-trivial impact on the entire system. The Automatic Database Diagnostic Monitor (ADDM) proactively identifies high-load SQL statements which are good candidates for SQL * When SQL statements are executed by the Oracle database, the query optimizer is used to generate the execution plans of the SQL statements. The query optimizer operates in two modes: a normal mode and a tuning mode. In normal mode, the optimizer compiles the SQL and generates an execution plan. The normal mode of the optimizer generates a reasonable execution plan for the vast majority of SQL statements. Under normal mode, the optimizer operates with very strict time constraints, usually a fraction of a second, during which it must find a good execution plan. In tuning mode, the optimizer performs additional analysis to check whether the execution plan produced under normal mode can be improved further. The output of the query optimizer is not an execution plan, but a series of actions, along with their rationale and expected benefit for producing a significantly superior plan. When running in the tuning mode, the optimizer is referred to as the Automatic Tuning Optimizer.

No community discussion yet for this question.