I'm running 11.2.0.2 on Solaris x86-64.
This is really strange... AWR report on this database has always worked fine and always shows top queries, etc.
Suddenly, this morning, I ran an AWR report in the usual method (using SQL*Plus @?/rdbms/admin/awrrpt) and it creates the report normally, except that when I review the report, it doesn't include any of the queries information that is normally found under SQL Statistics.
Instead, I see:
SQL ordered by Elapsed Time
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
and the same message for all other SQL Statistics.
What could be causing this? I don't know of any changes to the system that might have caused this.