Re: hint injection in 10g??

"Andrey" <adm_at_mlm.ru> wrote in message news:<butdq6$6ia$1_at_gavrilo.mtu.ru>...
> "Venkat" <0002_eveev_at_oohay.moc> wrote in message
> news:YqiQb.21$jN5.340_at_news.oracle.com...
> > on 1/23/2004 3:19 PM Daniel Morgan said the following:
> >
> > > Domenic G. wrote:
> > >
> > >> Someone was telling me that there's a new feature in 10g, similar to
> > >> stored outlines that does something like this:
> > >>
> > >> Suppose you have a query coming in to the database that you simply
> > >> can't change, and suppose you have cursor sharing set so that oracle
> > >> substitutes bind variables in place of literals.
> > >>
> > >> Now, let's say you want to alter the execution plan using any hint,
> > >> but cannot inject that hint into the original application source code,
> > >> apparently there is some feature that now lets you substitute a very
> > >> specific "cooked" execution plan in place of the one the optimizer
> > >> generates using a text match.
> > >>
> > >> I know this is very much like stored outlines, but with stored
> > >> outlines, you can only switch between the high level optimizer modes
> > >> ... first_rows, rule, all_rows, and generate the outline.
> > >>
> > >> Does this make sense, or was I misinformed? Can this type of
> > >> fine-grained control be done with stored outlines?
> > >>
> > >> Example ...
> > >>
> > >> You want to inject a /*+ INDEX(...) */ or /*+ DRIVING_SITE ... */ at
> > >> the back end because you can't access the compiled application code to
> > >> stick it in there.
> > >
> > >
> > > Check out the 10g features at http://otn.oracle.com.
> > >
> > Particularly,
> >
> http://otn.oracle.com/products/manageability/database/pdf/twp03/TWP_manage_automatic_SQL_tuning.pdf
>
>
> Really, Oracle must revert back to rule-base optimizer and do not mess with
> stupid outlines and something-horrible-injection. Very simple to make -
> user-written pre-sql-parsing, where with simple SQL-code user can alter
> statments, passed to server. This can return to Oracle it's former
> reputation as managable and predictable server.

Andrey,

do you use babelfish to write this stuff?

Pd Received on Sat Jan 24 2004 - 09:37:58 CST