Re: Dbms_stats giving OA-06512 error

On 01/05/2007 10:23:31 PM, Wolfgang Breitling wrote:
> At 05:36 PM 1/5/2007, Mladen Gogala wrote:
> 
> >First of all, your method_opt is erroneous. You should specify something like
> >'FOR ALL COLUMNS SIZE SKEWONLY' or 'FOR ALL COLUMNS SIZE AUTO' or Wolfgang's
> >favorite option 'FOR ALL INDEXED COLUMNS SIZE <histogram size>'.
> 
> Mladen,
> 
> Not quite correct. method_opt=>'for all columns' gathers histograms 
> on all columns with the default size of 75:

Hmmmm, you live and learn. I still like to specify my histogram size.
I stand corrected, it's not wrong, but it's wrong from the aesthetic
point of view. William, I didn't mislead you on purpose.


> 
> William,
> I am convinced your error has nothing to do with your change to the 
> gathering procedure. It has more likely to do with a change to table 
> "EDRS"."AMENDMENT". Did someone create a function-based index?


Now, I'm really interested. Why would you suspect a function based index?
To me, William's case looks like a case of bug 5558878, described in the note 
5558878.8. Fortunately, there is a patch for that. Of course, my recommendation
to contact Oracle Support, just to verify, still stands. They'll probably love
the trace you produced by setting the event 979.



-- 
Mladen Gogala
http://www.mladen-gogala.com

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


Other related posts: