Re: Analyzing queries

Virginia wrote:

> We have a product that runs on Oracle. The version of Oracle I'm
> working with is 8.1.7. I should also note that I'm relatively new to
> Oracle.
>
> I'm troubleshooting one particular database that is having performance
> problems when we try to run various quireies and peform inserts or
> updates.
>
> Unfortunately this particular product "requires" that "OPTIMIZER_MODE
> = RULE".
>
> Of the research I've done on analyzing tables, it seems that analyzing
> queries and tables only effect a database if you're running a Cost
> Basis system vs. Rule.
>
> Given that we have to run RULE, are there any options that will assist
> us in troubleshooting and tuning this database?
>
> Thank you for your time!
>
> Virgina
> Field Engineer
> vleandr_at_nai.com
> ***NO SPAM PLEASE****
Plenty.
No offense, but I'd try to get an expert in; would probably be done within a day. See claims from hotsos.com

-- 

Regards,
Frank van Bortel