Re: How can you know if your Oracle 10gr 2 (RAC-10.2.0.4) has a particular bug fixed in there - [[ Bug# 4519477 - AQ dequeue by correlation id is extremely expensive ]]

http://www.freelists.org/post/oracle-l/patch-source,4

• Karl Arao http://karlarao.wordpress.com

On Wed, May 20, 2009 at 12:47 AM, Pradeep Chetal < Pradeep.Chetal_at_mformation.com> wrote:

>
>
> Hi,
>
>
>
> How can you know if your Oracle 10gr 2 (RAC-10.2.0.4) has a particular bug
> fixed in there.
>
>
>
> The bug is - Bug# 4519477 - AQ dequeue by correlation id is extremely
> expensive
>
>
>
> The opatch lsinventory is shown below…
>
>
>
>
>
> *oracle_at_mfbmdata02:log [662] opatch lsinventory*
>
> Invoking OPatch 10.2.0.4.3
>
>
>
> Oracle Interim Patch Installer version 10.2.0.4.3
>
> Copyright (c) 2007, Oracle Corporation. All rights reserved.
>
>
>
>
>
> Oracle Home : /oradata/oracle10g1
>
> Central Inventory : /export/home/oracle/oraInventory
>
> from : /var/opt/oracle/oraInst.loc
>
> OPatch version : 10.2.0.4.3
>
> OUI version : 10.2.0.4.0
>
> OUI location : /oradata/oracle10g1/oui
>
> Log file location :
> /oradata/oracle10g1/cfgtoollogs/opatch/opatch2009-05-19_11-56-21AM.log
>
>
>
> Lsinventory Output file location :
> /oradata/oracle10g1/cfgtoollogs/opatch/lsinv/lsinventory2009-05-19_11-56-21AM.txt
>
>
>
>
> --------------------------------------------------------------------------------
>
> Installed Top-level Products (2):
>
>
>
> Oracle Database 10g
> 10.2.0.1.0
>
> Oracle Database 10g Release 2 Patch Set 3
> 10.2.0.4.0
>
> There are 2 products installed in this Oracle Home.
>
>
>
>
>
> Interim patches (1) :
>
>
>
> Patch 5457450 : applied on Wed May 13 16:26:47 EDT 2009
>
> Created on 19 Aug 2008, 08:52:51 hrs PST8PDT
>
> Bugs fixed:
>
> 5457450
>
>
>
>
> --------------------------------------------------------------------------------
>
>
>
> OPatch succeeded.
>
>
>
>
>
> Thanks,
>
>
>
> -- Pradeep
>
>
>
> *Pradeep Chetal*
> Sr. Director - Infrastructure Architecture
> ------------------------------
> *Mformation Technologies Inc.*
> *Switchboard:* +1 732 692 6200
>
>
> Visit
> *WWW.MFORMATION.COM* and see how the MFORMATION SERVICE MANAGER can help
> you to transform your business
>
> Please consider the environment before printing
>

--
http://www.freelists.org/webpage/oracle-l