Re: DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO
Date: Sat, 26 Dec 2009 18:51:47 -0800 (PST)
On Dec 26, 8:46 pm, vsevolod afanassiev
> 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 126.96.36.199.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