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!
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
