Re: Analyzing queries

From: Ryan <rgaffuri_at_cox.net>
Date: Tue, 6 Jan 2004 21:27:15 -0500
Message-ID: <68KKb.69838$hf1.62205_at_lakeread06>


see my replies inline...

"Virginia" <vleandr_at_nai.com> wrote in message news: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".
>

common with off the shelf products. they were made a while ago and never tested against CBO. so they tell you not to use it.

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

dont analyze in rule mode.

>
> Given that we have to run RULE, are there any options that will assist
> us in troubleshooting and tuning this database?
>

yes, learn how to use the explain plan. go to metalink and otn.oracle.com and do a search on that and 'autotrace'. this gives you a chart of your query.

you can install it by running the script in ORACLE_HOME/rdbms/admin/utlxplan.sql

> Thank you for your time!
>
> Virgina
> Field Engineer
> vleandr_at_nai.com
> ***NO SPAM PLEASE****
Received on Wed Jan 07 2004 - 03:27:15 CET

Original text of this message