Re: Stats not gathered on all tables with GATHER_STATS_JOB in 10g
- From: "Tim Hopkins" <oracle-l@xxxxxxxxxxxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Mon, 19 Dec 2005 10:52:33 -0000 (GMT)
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" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
