RE: Stats not gathered on all tables with GATHER_STATS_JOB in 10g

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxxxxxxx>, <jonathan@xxxxxxxxxxxxxxxxxx>
  • Date: Mon, 19 Dec 2005 12:35:42 -0600

Now why didn't I just do a trace?  <blush>

And I noticed that both the GLOBAL_STATS and USER_STATS column from
DBA_TABLES (bit masked column from TAB$) for that table are both "NO".

Now the question is "why?".  :)  Seems like a bug workaround to me...

Thanks all!  Merry Christmas!

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Hopkins
Sent: Monday, December 19, 2005 4:53 AM
To: jonathan@xxxxxxxxxxxxxxxxxx
Cc: oracle-l
Subject: Re: Stats not gathered on all tables with GATHER_STATS_JOB in

Hi Rich,

    It seems SYS.SUMDELTA$ is explicitly excluded from automatic
statistics collection.

    If you turn on SQL tracing for the GATHER_STATS_JOB session, you'll
find a statement which writes a list of target objects into the
    An interesting clause of this statement is the following:


    So, there's the answer - the table is explicitly excluded.


> Sorry about the empty email - I managed to hit send
> a bit too soon.
> 10g gives you ability to lock stats on an object by
> calling a new procedure in the dbms_stats package.
> Is it possible that this object's stats have been locked
> while empty ?
> Regards
> Jonathan Lewis

Other related posts: