Databases Reference
In-Depth Information
Viewing and Dropping Tuning Tasks
The prior techniques provide a variety of ways to identify SQL statements to be analyzed by the SQL
Tuning Advisor. Once you've created a tuning task, you can view its details via this query:
select owner, task_name, advisor_name, created
from dba_advisor_tasks
order by created;
If you need to drop the tuning task, you can do so as follows:
SQL> exec dbms_sqltune.drop_tuning_task(task_name => '&&task_name');
Running SQL Tuning Advisor from SQL Developer
If you have access to SQL Developer 3.0 or higher, it's very easy to run the SQL Tuning Advisor for a
query. Follow these simple steps:
1.
Open a SQL worksheet.
2.
Type in the query.
3.
Click the button associated with the SQL Tuning Advisor.
You will be presented with any findings and recommendations. If you have access to SQL Developer
(it's a free download), this is the easiest way to run the SQL Tuning Advisor.
Note
Before running SQL Tuning Advisor from SQL Developer, ensure the user that you're connected to has
the
ADVISOR
system privilege granted to it.
Running SQL Tuning Advisor from Enterprise Manager
You can also run the advisor from within Enterprise Manager. Log into Enterprise Manager and follow
these steps:
1.
From the main database page, click the Advisor Central link (near the bottom).
2.
Under the Advisors section, click the SQL Advisors link.
3.
Click the SQL Tuning Advisor link.
You should be presented with a page similar to the one shown in Figure 9-5.
