AWR is empty

[big]

Hi,
On 11.2.0.4 on AIX
We have as parameteres:

SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access    string   DIAGNOSTIC+TUNING
SQL> show parameter TIMED_STATISTICS
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
timed_statistics           boolean   TRUE
SQL> show parameter statistics_level
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
statistics_level           string   TYPICAL
And in generated  report, we have:

But in it I see:
SQL ordered by Elapsed Time
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
No data exists for this section of the report.



Thanks.

[ErmanArslansOracleBlog]

This sql statistics related things may be related with the hidden parameter named _awr_disabled_flush_tables

Check its value. It should not be set.

As for the version count-related ones, this may be the case where there are nothing to report.. Maybe there are fewer than 20 versions for all cursors..

Here are the references;

SQL Statistics Data is Missing in AWR Report (Doc ID 2270357.1)
SQL Ordered by Version Count : "No Data Exists For This Section Of The Report" (Doc ID 2750390.1)