Re: Analyzing queries
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