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.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
> Cost Based Oracle: Fundamentals
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 29th Nov 2005
>
> ----- Original Message -----
> From: "Jesse, Rich"
> To: "oracle-l"
> Sent: Friday, December 16, 2005 4:40 PM
> Subject: Stats not gathered on all tables with GATHER_STATS_JOB in 10g
>
>
> 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_at_quadtechworld.com QuadTech, Sussex, WI USA
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l