Re: AWR is empty

Posted by ErmanArslansOracleBlog on Dec 20, 2021; 1:07pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/AWR-is-empty-tp10525p10526.html

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)