SQL Tuning Advisor
SQL Tuning Advisor provides advice based on
optimizing the execution plan, the rationale for the new plan,
estimated performance benefit, and commands for the changes. As
explained earlier, the
DBA or developer has
To access the SQL Tuning Advisor through
the Oracle Enterprise Manager, go to
the Advisor Central - SQL Tuning Advisor
link as shown below.
Figure 7.2 - SQL Tuning Advisor - OEM
The SQL Tuning Advisor can also be invoked
through the dbms_sqltune package by anyone with DB role
and ADVISOR privilege.
Next,
invoking
the SQL
Tuning Advisor through OEM
will be examined.
Using SQL Tuning Advisor through OEM
To access the SQL Tuning Advisor through
the Enterprise Manager, do the following steps:
-
Go to Advisor Central and click
the SQL Tuning Advisor link as explained above.
-
In the SQL Tuning Advisor page, the advisor
gives the choice of running from the following sources:
