I'll refer you to this post //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@xxxxxxxxxxxxxx> 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@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 >