Analyzing queries

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**** Received on Tue Jan 06 2004 - 19:22:45 CET