My Oracle Support Banner

EM 13c: SQL Tuning Advisor in Enterprise Manager 13c Cloud Control does not Show Recommendation Results when Clicking on Show Results Radio Button in the SQL Tuning Result Summary Page for AD Global User (Doc ID 2857252.1)

Last updated on MAY 28, 2022

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


In Oracle Enterprise (EM) 13.4 Cloud Control AD (Active Directory), a global user with the DBA role is configured to connect to target databases.
SQL Tuning Advisor on a SQL statement reports it has no recommendations when clicking on the "Show Results" radio button in the SQL Tuning Result Summary page:

Clicking on the radio button in the SQL Tuning Result Summary page shows it has no recommendations:

However, navigating to the path  Performance > Advisors Home > SQL Tunning Advisor task, it does show there are recommendations:




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

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