Re: hint injection in 10g??

"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.

>
> - read about "SQL Profiles".
>
> Yes, they could be used on packaged apps without modifying the source
> SQL, and No, they don't do "hint injection" to say the least.
>
> -V
Received on Sat Jan 24 2004 - 03:27:11 CST