Can't delete last SQL tuning task in Oracle Tuning Advisor as the drop button is disabled (4311885)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Can't delete last SQL tuning task in Oracle Tuning Advisor as the drop button is disabled
Description

In the Oracle Tuning Advisor (OEM), when there is only one SQL Tuning Advisor Task listed, the Delete task icon is disabled i.e. dimmed out. I execute DBMS_SQLTUNE.DROP_TUNING_TASK to delete the last task.
Resolution

WORKAROUND #1:
Execute DBMS_SQLTUNE.DROP_TUNING_TASK to delete last task.

WORKAROUND #2:
In Toad, run a quick 'limited' task and highlight both tasks for deletion.

STATUS:
This issue is fixed in Toad for Oracle 12.0. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

105548

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title