Re: AWR Sample Report

On Nov 18, 6:48 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Nov 18, 1:36 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
> > Also, why did you set these ?
>
> > init.ora Parameters
> > Parameter Name                value
>
> > >> _newsort_enabled              FALSE
> > >> _optim_peek_user_binds        FALSE
>
> Can't speak for the OP, but at least one vendor of mine is magic-
> bulleting _optim_peek_user_binds
>
> jg
> --
> @home.com is bogus.http://www.rottenneighbors.com

We actually used it once for Oracle Text queries that would misbehave. We *always* wanted to use the Text index, but sometimes the optimizer would build a different cursor based on the bind that was peeked. We literally had over 10,000 child cursors for a given statement. The soft parsing killed us. We turned off bind peeking, and the problem went away.

Six months later, it bit us in the rear for something else, though.

Regardless, that would still be the first question I would ask, though. Received on Tue Nov 18 2008 - 20:52:50 CST