pros/cons of setting COMPATIBLE parameter 11.2.0 or

From: Syed Jaffar Hussain <>
Date: Mon, 13 Feb 2012 10:05:41 +0300
Message-ID: <>

Good day list,
Very recently we have upgraded our 10gR2 ( databases to 11gr2 and applied latest PSU patch ( However, for some concerns, the COMPATIBLE parameter value was kept to Now we need to change the COMPATIBLE parameter value reflecting to 11gR2. Therefore, I need an advice over setting the parameter to 11.2.0 OR What are the pros and cons do you foresee.

Thanks in advance.

Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
Oracle Certified Master
Co-author Oracle 11gR1/R2 RAC Essentials <>
*Oracle Magazine DBA of year (2011)*
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
ITIL V3 foundation certified
Oracle RAC SIG Representative for Saudi Arabian

Advisory & Governance Council for
I blog at  :
LinkedIn :
Follow me on twitter :!/sjaffarhussain
"Winners don't do different things. They do things differently."

Received on Mon Feb 13 2012 - 01:05:41 CST

Original text of this message