Re: Analyzing queries

I have to deal every day with such a ------ product (Siebel). What I found is that pretty much the only "tuning" option that these bastards agree to let us perform is to create new indices when that helps. They won't even allow us to remove the indices containing one single value, that the RBO thinks is useful! Post the query and the execution plan, and we might be able to give more advice.

Daniel

> 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 Wed Jan 07 2004 - 16:25:55 CET