Re: DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 26 Dec 2009 17:02:03 -0800 (PST)
Message-ID: <646d844e-ea13-4e22-bf97-8d4eed0077c4_at_a32g2000yqm.googlegroups.com>

On Dec 26, 7:21 pm, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:

snip

> 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

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:27658118048105 Received on Sat Dec 26 2009 - 19:02:03 CST