Re: Question for 10g enthusiasts

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_REWRITE
http://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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org