|
Home > Archive > Oracle Server > July 2005 > COMPATIBLE parameter
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
COMPATIBLE parameter
|
|
| Matthias Hoys 2005-07-29, 8:23 pm |
| 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
| |
| DA Morgan 2005-07-30, 3:23 am |
| 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@x.washington.edu
(replace x with u to respond)
|
|
|
|
|