Re: DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 26 Dec 2009 18:51:47 -0800 (PST)
Message-ID: <6b06d4e9-7d75-40b6-b88f-2ae1da8500f6_at_j4g2000yqe.googlegroups.com>

On Dec 26, 8:46 pm, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:

snip

> Thanks, but it doesn't work.
> - According to "Oracle Database 10g New Features" by Robert Freeman
> parameter STATTYPE is set to ALL by default (page 22).
> - I collected statistics for one of the tables using
> DBMS_STATS.GATHER_TABLE_STATS with STATTYPE = 'ALL', but columns still
> haven't been populated. This is 10.2.0.4 on Linux

Try testing this stuff in an 11.1.0.7.1 environment perhaps ...

Put additional questions into asktom since you have a starting point perhaps ...

Submit questions into Oracle support via metalink perhaps ... Received on Sat Dec 26 2009 - 20:51:47 CST