Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tuning Question: Can 'rule based' optimizer enforced on a tablespace

Tuning Question: Can 'rule based' optimizer enforced on a tablespace

From: Helen <hhjin_at_yahoo.com>
Date: 6 Sep 2001 07:33:34 -0700
Message-ID: <ebcac1e2.0109060633.6b2cafba@posting.google.com> 





We are running Oracle EE 8.1.6.0.0 on Solaris 2.6




We currently set the optimizer to be 'choose'.



My understanding is that one can change the optimizer on session
level, instance level or statement leve.



But our product vendor suggested to use 'rule based' for a certain
tablespace. Can this be done and how?



Thank you very much!
Received on Thu Sep 06 2001 - 09:33:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US