AWR is empty

Posted by big on Dec 20, 2021; 8:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/AWR-is-empty-tp10525.html

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.