Re: DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 28 Dec 2009 02:44:11 +0000 (UTC)
Message-ID: <hh961r$4ec$3_at_news.eternal-september.org>
On Sat, 26 Dec 2009 17:02:03 -0800, hpuxrac wrote:
>> 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
Date: Mon, 28 Dec 2009 02:44:11 +0000 (UTC)
Message-ID: <hh961r$4ec$3_at_news.eternal-september.org>
On Sat, 26 Dec 2009 17:02:03 -0800, hpuxrac wrote:
> 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
Service Temporarily Unavailable
The server is temporarily unable to service your request due to
maintenance downtime or capacity problems. Please try again later.
Oracle-Application-Server-10g/10.1.2.3.0 Oracle-HTTP-Server Server at
asktom.oracle.com Port 80
-- http://mgogala.byethost5.comReceived on Sun Dec 27 2009 - 20:44:11 CST