My Oracle Support Banner

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 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 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"

Steps :
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

Expected
A report comparing the 2 plans should show up

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
References


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