Re: Analyzing queries

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0401070725.5ebb3c7a_at_posting.google.com>...
> 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****
Daniel, what about using the outline feature to provide optimizer hints without touching the vendor code?

HTH -- Mark D Powell -- Received on Thu Jan 08 2004 - 14:43:14 CET