SQL Tuning Advisor
-
Select Related Links
-
Choose Advisor Central
-
Choose SQL Tuning Advisor
-
Choose SQL Tuning Sets
SQL Tuning Advisor obtains its inputs from
a variety of sources including ADDM, top SQL statements from AWR,
Cursor Cache, SQL Tuning Set and user inputs.
Automatic Database Diagnostic Monitor (ADDM)
runs periodically as explained earlier and analyzes the key
statistics accumulated by AWR over the last hour of operation.
By looking at these statistics, ADDM can identify any
performance-related problem including top SQL statements. Once
it identifies
Another source of input for the SQL Tuning
Advisor is the high load SQL statements captured in the
Automatic Workload Repository. AWR takes regular snapshots of
the database system including top SQL statements ranked by
relevant statistics like CPU consumption and wait time. This
data is retained for seven days,
and
this retention period can be increased as
needed. The user can view these top SQL statements in the AWR
and run the SQL Tuning Advisor on
them.
This implies that
the
top SQL statements that ran during a
specific retention period in the AWR
can be
tracked and tuned
accordingly.
