Re: Policy on Oracle Versions and Patches
Date: Fri, 10 Oct 2008 05:31:06 -0700 (PDT)
I do have time to read release notes, in fact I read them very
For example, in Release Notes for 18.104.22.168 on Lunix x86:
All databases that use any features of Oracle Streams must be upgraded to release 22.214.171.124 or later. Operation between release 126.96.36.199 and release 188.8.131.52 is not supported for databases using Oracle Streams features.
Beginning with patch set release 184.108.40.206, INSO software is no longer shipped with Oracle Text
In release 220.127.116.11 and earlier, the maximum number of cursors that could be cached for fast lookup by PL/SQL was bounded by the value of the OPEN_CURSORS initialization parameter.
--- This tells me that Oracle introduced new features and what they callReceived on Fri Oct 10 2008 - 07:31:06 CDT
"behaviour" in patch sets.
In fact we installed 10.2.0.4 recently and then had to switch back to 10.2.0.3 it as outer join returned wrong result. I also talk to Oracle Support on a regular basis and they tell me things like
"The problems with subpools (of the shared pool) started around
18.104.22.168" 10.2 does not seem to be stable, we had quite a few crashes (bloom_filter thing, ORA-00600 [kcbget_37], etc). I think stable versions are 22.214.171.124, 126.96.36.199, 188.8.131.52. Regarding "supported" - ask Oracle for password to download patch 2421054 for 184.108.40.206 on AIX 5L - officially this patch has been available since May 2008.