升级到18.104.22.168后，会存在一系列的Performance or Wrong Results，根据metalink文档ID 1392633.1说明，修复情况如下：
ScopeThis note concerns itself with highly desirable patches in 22.214.171.124 that are not included in PSU updates, either because they contain optimizer layer fixes or because the PSU that will contain them has not yet been released.
Things to Consider Before Upgrading to 126.96.36.199 to Avoid Poor Performance or Wrong ResultsWhile we try and include important fixes in the PSUs that are released on a quarterly basis, there are restrictions as to what can go into a PSU. One of the restrictions is fixes that may change execution plans, i.e. optimizer layer fixes. The reason for this is that it reduces the amount of testing required to go from one PSU to another. Other fixes may not yet have been released in a PSU.
Please consider applying the following patches, in addition to the latest PSU, to avoid certain performance, ORA-600/ORA-7445, and wrong results issues.
Patches relevant for all platforms Patch:13656236 Merge patch fixing the following two bugs:
[*]Document:13004894.8 Wrong results with SQL_TRACE / 10046
[*]Document:13370330.8 Bug 13370330 - ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
Patch:13831007 MERGE REQUEST ON TOP OF 188.8.131.52.0 FOR BUGS 12797420 13588248
This merge includes 3 fixes in the area of Mutex Contention plus addresses a regression created by one of them. This merge can be used on either 184.108.40.206.0 or 220.127.116.11.1. We are hoping to have them included in the 18.104.22.168.2 PSU.
Patches specific to IBM AIXPatch:12412983 AIX: "asynch descriptor resize" wait not necessary on AIX
Patch:12596494 GENERALLY HIGHER CPU USAGE IN 22.214.171.124 THAN 10.2.0.4
Patch:13443029 MEMORY LEAK FIX FOR ONLINE PATCHING / HOT PATCHING
This reduces memory usage associated with the online patching feature.
[*]AIX 6.1 TL7 or above (such as AIX 7.1) must be installed before either installing the patch or relinking the Oracle binary for it to be effective. If you are on an earlier version of AIX, then you may wish to consider installing Patch:10190759 instead, but keep in mind that doing so will disable online patching.
在测试环境aix6106中，安装Patch:10190759后，数据库启动会产生ORA-07445: exception encountered: core dump [PC:0x0] [SIGILL] [ADDR:0x0] [PC:0x0] [Illegal opcode] ，后来安装Patch:13443029就没问题了，可能与我的系统环境有关吧......
Please see this note from IBM for more information.
[oracle@p520 p13348650]$ /oracle/app/oracle/product/126.96.36.199/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13348650/custom/server/13348650 -oh /oracle/app/oracle/product/188.8.131.52
Oracle Interim Patch Installer version 184.108.40.206.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/oracle/product/220.127.116.11
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/18.104.22.168/oraInst.loc
OPatch version : 22.214.171.124.0
OUI version : 126.96.36.199.0
Log file location : /oracle/app/oracle/product/188.8.131.52/cfgtoollogs/opatch/opatch2012-04-01_14-50-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
Conflicts/Supersets for each patch are:
Patch : 13343438
Conflict with 12412983
/oracle/app/oracle/product/184.108.40.206/OPatch/opatch rollback -local -oh /oracle/app/oracle/product/220.127.116.11 -id 12412983