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

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!
Rich

-----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
10g


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
SYS.STATS_TARGET$ table.
    An interesting clause of this statement is the following:

    NOT (u.NAME = 'SYS' AND o.NAME = 'SUMDELTA$')

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

Cheers,
Tim

>
> 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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: