From: fvanbortel@netscape.net   
      
   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".   
   >   
   > 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@nai.com   
   > ***NO SPAM PLEASE****   
      
   Plenty.   
   No offense, but I'd try to get an expert in; would probably be done   
   within a day. See claims from hotsos.com   
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)