Stats not gathered on all tables with GATHER_STATS_JOB in 10g

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 Dec 2005 10:40:53 -0600

Hey all,

In 10.1.0.3.0, the GATHER_STATS_JOB has been running for almost a year
now.  Everything seems to be running smoothly, except one table has
never has stats gathered -- SYS.SUMDELTA$.  I don't see any reason why
stats have never been gathered on this table -- it's a standard table
(e.g. not fixed or secondary, etc).

This is the only table in this DB that has no stats.  Thoughts???

Rich

Rich Jesse                        System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA
--
//www.freelists.org/webpage/oracle-l


Other related posts: