Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question for 10g enthusiasts
On Nov 2, 12:44 am, DA Morgan <damor..._at_psoug.org> wrote:
> Rick Denoire wrote:
> > After migration I found out that some SQL queries generated by the use
> > of the application are being executed diferently depending on the DB
> > account used. This is an Oracle based commercial application with its
> > own client, no way to tune the text of SQL queries. I would like to
> > force Oracle to use the better execution plan for all users.
>
> You made one huge assumption that is not valid when you wrote:
> "This is an Oracle based commercial application with its own client, no
> way to tune the text of SQL queries"
>
> There are numerous ways to tune those queries or, in fact, replace them.
>
> There are, of course, histograms and stored outlines, but if those don't
> work consider using advanced rewrite.
>
> DBMS_ADVANCED_REWRITEhttp://www.psoug.org/reference/dbms_adv_rewrite.html
>
> Try my demo and if you like what it does ... read the docs at tahiti.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
The DBMS_ADVANCED_REWRITE is buggy, inconsistent, and at a minimum hard to apply in the simplest of cases.
Not sure if something has gone wrong with qa in oracle where this package is concerned. Received on Fri Nov 02 2007 - 20:07:59 CDT