RE: Is the fifth digit revelevant in 12c and 11.2.0.4 to the optimizer?

  • From: "Deas, Scott" <Scott.Deas@xxxxxxx>
  • To: "cdunscombe@xxxxxxxxx" <cdunscombe@xxxxxxxxx>, "jcdrpllist@xxxxxxxxx" <jcdrpllist@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Jan 2014 14:17:58 +0000

You are correct, based on Eleanor Meritt's presentation at Open World 2013 
(Oracle Database Patching Best Practices), PSU's are:


-          a quarterly collection of fixes for proven high impact bugs 
encountered in the field

-          includes security content

-          guaranteed not to contain any changes to the optimizer or fixes 
which change application behavior

-          may span multiple stack components, for example: Grid Infrastructure 
and database

Thanks,
Scott

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Chris Dunscombe
Sent: Wednesday, January 15, 2014 3:52 AM
To: jcdrpllist@xxxxxxxxx; ORACLE-L
Subject: Re: Is the fifth digit revelevant in 12c and 11.2.0.4 to the optimizer?

Hi,

My understanding is that the 5th digit is for Patch Set Updates (PSUs) and 
Oracle states that there won't be any optimizer changes in PSUs. Unfortunately 
I can't remember where I heard/read that.

Cheers,

Chris

On Tuesday, 14 January 2014, 18:41, Juan Carlos Reyes Pacheco 
<jcdrpllist@xxxxxxxxx<mailto:jcdrpllist@xxxxxxxxx>> wrote:
I remember in 11g you could set  but was not releveant and in the future was 
going to be.

Starting from 11,2,0.4 and 12c the patch number had changed.
in

<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>

<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>

Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms (Doc 
ID 
161549.1)<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>

 
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
 
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
12.1.0.1.4        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
12.1.0.1.3        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.4.2        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.4.1        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.4.0        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.3.0 Patch 29     
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.3.0 Patch 28     
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.3.0        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.2.0 Patch 28     
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.2.0 Patch 27     
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.2.0        
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
11.2.0.1.0 Patch 16     
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
 
<https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qit5x3nhc_9&_afrLoop=19808982606772>
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, 
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or 
entity to
which it is addressed. If you are not the intended recipient of this E-mail, 
you are
hereby notified that any dissemination, distribution, copying, or action taken 
in
relation to the contents of and attachments to this E-mail is strictly 
prohibited
and may be unlawful. If you have received this E-mail in error, please notify 
the
sender immediately and permanently delete the original and any copy of this 
E-mail
and any printout. Thank You.**

Other related posts: