Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Optimizer Statistics Diff Report error

edited Jun 24, 2015 12:42PM in Managing Databases using Enterprise Manager (MOSC) 15 commentsAnswered ✓

I am running 12cR4 and logged into a RAC cluster with DBA privileges. While monitoring this database, I drilled down into a SQL ID. This SQL ID has many hash values (another issue for later). I noticed a button next to the plan hast value drop down called "Optimizer Statistics Diff Report", it's not always there. Clicking on the button takes you to a screen with a list of hash values with times and check boxes. I have a couple of the items checked off. When I click on Compare, I get a message There is no data to compare. Check that your ID has enough privileges

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center