From: anacedent@hotmail.com   
      
   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".   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)