Re: DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sat, 26 Dec 2009 17:46:35 -0800 (PST)
Message-ID: <92e59a29-7f3a-453d-acb3-a14789db3fd9_at_r33g2000prh.googlegroups.com>



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 Received on Sat Dec 26 2009 - 19:46:35 CST

Original text of this message