Re: Policy on Oracle Versions and Patches

From: <>
Date: Fri, 10 Oct 2008 05:31:06 -0700 (PDT)
Message-ID: <>


I do have time to read release notes, in fact I read them very carefully.
For example, in Release Notes for on Lunix x86:

Section 5.1.5:
All databases that use any features of Oracle Streams must be upgraded to release or later. Operation between release and release is not supported for databases using Oracle Streams features.

Section 5.2
Beginning with patch set release, INSO software is no longer shipped with Oracle Text

Section 10.4
In release 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 call

"behaviour" in patch sets.
In fact we installed recently and then had to switch back to 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" 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,, Regarding "supported" - ask Oracle for password to download patch 2421054 for on AIX 5L - officially this patch has been available since May 2008.
Received on Fri Oct 10 2008 - 07:31:06 CDT

Original text of this message