Is there any difference in setting the Compatible Parameter to vs ? Are there any advantages / dis-advantages ?


The parameter is described in the Upgrade Guide. You cannot downgrade a database to a version that is below the version of the COMPATIBLE parameter. The COMPATIBLE parameter controls how data is written to disk. But it does not control the usage of optimizer features. There are a lot of parameter to control the oprimizer features. The OPTIMIZER_FEATURES_ENABLED is a parameter that you have to set appropriately to enable the optimizer features of the Oracle version. Tom Kytes discusses the difference of these two parameter in this article.

| improve this answer | |

Check the below from Oracle 11G R2 Compatibility document:

Databases from different releases of Oracle Database software are compatible if they support the same features and those features perform the same way. When you upgrade to a new release of Oracle Database, certain new features might make your database incompatible with your earlier release.

Your upgraded database becomes incompatible with your earlier release under the following conditions:

A new feature stores any data on disk (including data dictionary changes) that cannot be processed with your earlier release.

An existing feature behaves differently in the new environment as compared to the old environment.

The Compatible parameter change is not critical if you are not hitting any bugs related with an earlier version, but is sometimes required to unlock new features released as part of the new release.

| improve this answer | |
  • I think the compatible paramter is not related to bugfixes. – miracle173 Jul 12 '15 at 8:32

Generally only the first 3 digits are taken into account for the compatible parameter, so either one is fine.

| improve this answer | |
  • Not true. Give me time to lookup the view that holds the relevant info that the flag looks at. – Philᵀᴹ Mar 29 '14 at 1:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.