Date: Sat, 26 Dec 2009 16:21:59 -0800 (PST)
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:
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