My Oracle Support Banner

OCI Database Management Service : Unable To Create SQL Tuning Advisor tasks (Doc ID 3009987.1)

Last updated on MARCH 12, 2024

Applies to:

OCI Database Management Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Trying to create a SQL Tuning Advisor task from Performance Hub page does not create a Task.

Steps to Reproduce:

1. Navigate to the Main Menu --> Observability & Management --> Database Management
    Administration --> Select the correct compartment & deployment type
    Click on a Database from the Managed Database List.
2. From the Database Management Home Page --> Click on Performance Hub
3. Select one of the SQL from the list, which you would like to tune.
    Click on Tune SQL.
4. Provide the details in "Run SQL Tuning Advisor" page and Submit.
5. The newly created Task does not show up in "SQL Tuning Advisor tasks" page.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.