Databases Reference
In-Depth Information
Figure 9-4. The SQL Tuning Advisor archiecture
Let's focus first on running the SQL Tuning Advisor through the
DBMS_SQLTUNE
PL/SQL package. To
execute the SQL Tuning Advisor from PL/SQL, follow these steps:
1.
Create a tuning task.
2.
Execute
DBMS_SQLTUNE
and view the advice.