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

Now why didn't I just do a trace?

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Hopkins Sent: Monday, December 19, 2005 4:53 AM
To: jonathan_at_jlcomp.demon.co.uk
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