Re: Warning: Built in 10g Stats gather is broken

From: <mccmx_at_hotmail.com>
Date: 13 Oct 2006 00:46:13 -0700
Message-ID: <1160725573.131238.176660@m7g2000cwm.googlegroups.com>

> This is precisely why I have a scheduled job to check the stats to see
> how far off target they are. If they are off target, I recalculate
> stats. For me, I compare the number of BLOCKS from DBA_TABLES to the
> number of BLOCKS from DBA_SEGMENTS. I realize this does not address all
> issues where the stats could have diverged too far from reality, but it
> works in my system. To see the script I use, visit my web site (URL
> below). You will find "fix_stats.sql" in the Scripts section.
>

Did you implement that solution because you found that the built in job wasn't working properly or because you prefer to use your own method..?

Matt Received on Fri Oct 13 2006 - 02:46:13 CDT