Columns AVG_CACHE_HIT_RATIO and AVG_CACHED_BLOCKS from DBA_TAB_STATISTCS
Date: Thu, 2 Mar 2017 10:57:14 -0300
Message-ID: <CAPWdmV-OAdG=qEYH2JXctWowYSFuVNSpHQ6kDbcdqDSVEtpthQ_at_mail.gmail.com>
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
>
*--*
*Att*
*Luis Santos*
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 02 2017 - 14:57:14 CET