DBA_TAB_STATISTICS.AVG_CACHED_BLOCKS, AVG_CACHE_HIT_RATIO
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Sat, 26 Dec 2009 16:21:59 -0800 (PST)
Message-ID: <28724345-dad7-44bf-a504-03d6e17e444d_at_f18g2000prf.googlegroups.com>
Hi All,
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.
Date: Sat, 26 Dec 2009 16:21:59 -0800 (PST)
Message-ID: <28724345-dad7-44bf-a504-03d6e17e444d_at_f18g2000prf.googlegroups.com>
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
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 Received on Sat Dec 26 2009 - 18:21:59 CST