Re: Analyzing queries

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 06 Jan 2004 16:57:51 -0800
Message-ID: <eQIKb.53075$BQ5.30816@fed1read03>

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".
This sounds like Siebel.

>
> 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?

Enable SQL_TRACE & use TKPROF for troubleshooting. You may have limited options for "tuning". Received on Tue Jan 06 2004 - 18:57:51 CST