EM 13c: ATPD Optimizer Statistics Diff Report Returns There Is No Data To Compare. Check Privileges
(Doc ID 2675149.1)
Last updated on MAY 30, 2020
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
In Enterprise Manger (EM) Cloud Control, When comparing with multiple sql plan hash values, when the optimizer statistics diff report is chosen- the following error is returned :
"There is no data to compare. Check that your ID has enough privileges"
Run a sql that can create multiple plan hash values
Now go to the sql details page for this sql via ash analytics
on the sql details page click on optimizer stats diff report
select two different plans and click on compare
A report comparing the 2 plans should show up
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