From: rgaffuri@cox.net   
      
   see my replies inline...   
      
      
   "Virginia"  wrote in message   
   news:84c080d3.0401061022.614d8a20@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@nai.com   
   > ***NO SPAM PLEASE****   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)