DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sat, 26 Dec 2009 16:21:59 -0800 (PST)
Message-ID: <28724345-dad7-44bf-a504-03d6e17e444d_at_f18g2000prf.googlegroups.com>



Hi All,

In 10g Oracle introduced view DBA_TAB_STATISTICS. Many columns are identical to those available
in DBA_TABLE (NUM_ROWS, LAST_ANALYZED), but there are new columns, in particular:
- AVG_CACHED_BLOCKS

  • AVG_CACHE_HIT_RATIO
I checked a few databases and these columns don't get populated. It should be possible to get
this information from somewhere else - number of blocks from V$BH, V $CACHE and hit ratio from
object statistics. Still it would be nice to get these columns populated. Anyone know how to do it?
There is nothing in documentation.

Thanks Received on Sat Dec 26 2009 - 18:21:59 CST

Original text of this message