Analyzing queries
Date: 6 Jan 2004 10:22:45 -0800
Message-ID: <84c080d3.0401061022.614d8a20_at_posting.google.com>
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".
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