Re: Question for 10g enthusiasts

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Nov 2007 19:06:48 -0700
Message-ID: <1194055604.955080@bubbleator.drizzle.com>

hpuxrac wrote:

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

If you can create a demo that shows the bugginess and inconsistency I'd like to see it.

My guess is that, just like RAC on Mac, you have an opinion on something you've never actually done. Please prove me wrong.

 From my experience those that can't get it to work didn't read the docs.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Nov 02 2007 - 21:06:48 CDT