Re: optimizer_ ???

Robyn,

that's how I remember it too.
I don't deny that some people have had success lowering oica or raising oic - and for individual sql I have used them too ( I remember one case where I deliberately set oica to 1 so that differences in index costs would disappear and the index be determined by the tie-breaking rule which was the index I needed) but I really don't like the idea of setting them system-wide.

Robyn wrote:
> I attended Wolfgang's presentation on oica and oic at hotsos, and
> towards the end of the presentation, he said using system statistics
> would provide better results than adjusting oica and oic. This was

>
> Of course, if I've misremembered the presentation, someone please let me kn=
> ow.
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l