I checked several 11g version databases
here
(we still don´t have a 12c database in production, shame)
querying
both
AVG_CACHE_HIT_RATIO and AVG_CACHED_BLOCKS
columns
from DBA_TAB_STATISTCS, which I was not aware since few minutes ago (shame
2).
In none of them I could find any info. These columns has always NULL values.
Is there a setting to be enabled to have fill data filled?
1 select OWNER, TABLE_NAME, AVG_CACHE_HIT_RATIO, AVG_CACHED_BLOCKS
2 from DBA_TAB_STATISTICS
3 where
4 AVG_CACHE_HIT_RATIO is not null
5 or
6* AVG_CACHED_BLOCKS is not null
no rows selected
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production