Re: Stored Outlines in 10gR1

At 10:46 AM 12/26/2006, A Joshi wrote:
>Have you considered setting hidden parameter :
>
>_OPTIM_PEEK_USER_BINDS=FALSE
>The default it true. for details metalink : 387394.1
>when googling also do metalinking,askoming.
>Do you have gather statistics using histograms? You can think of
>changing that since that will not involve much changes and will not
>need bounce. Thanks

I second the call to verify that the histogram is needed. Problems with plan differences due to BV peeking are usually due to inappropriate histograms. Changing _OPTIM_PEEK_USER_BINDS should be the last resort even after trying the stored_oulines. Unless there are very many stored outlines to create. Then setting _OPTIM_PEEK_USER_BINDS=false, perhaps by session in an after logon trigger, could be the lesser "evil" (not that stored outlines are evil).

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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