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 -> COMPATIBLE parameter

COMPATIBLE parameter

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 29 Jul 2005 21:21:06 +0200
Message-ID: <42ea81a2$0$12015$ba620e4c@news.skynet.be> 





All,



Is it recommended to set the COMPATIBLE initialization parameter always to 
the installed patch version ? After upgrading an Oracle 9i db to version 
9.2.0.6.0, I noticed that it's still set to 9.2.0.0.0, couldn't this lead to 
less optimal CBO behaviour ?



Thanks


Matthias 
Received on Fri Jul 29 2005 - 14:21:06 CDT












Original text of this message













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