Re: COMPATIBLE parameter

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Jul 2005 23:09:29 -0700
Message-ID: <1122703741.608135@yasure>

Matthias Hoys wrote:
> 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

Yes if CBO behaviour was modified.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sat Jul 30 2005 - 01:09:29 CDT