Oracle数据库10.2.0.5的PSU补丁修复的BUG汇总，可以从中找到可能遇到BUG的问题。
Database Control
| 10.2.0.5.2 | 8350262 | Database Control Certificates Expire After 180 Days |
| 10.2.0.5.9 | 14269955 | Unix: kfd.o missing from PSU versions 10.2.0.5.6 10.2.0.5.7 and 10.2.0.5.8 - affects ASM |
| 10.2.0.5.6 | 11066597 | Diskgroup dismounted when storage cable pulled out on the other node |
| 10.2.0.5.3 | 7602341 | 10gr2 instance crash OERI [kffmunlock_3] with 11g ASM |
| 10.2.0.5.8 | 13916709 | Fix for bug 13916709 |
| 10.2.0.5.7 | 8822531 | RAC hang possible |
| 12748240 | Fix for bug 12748240 | |
| 12780098 | Fix for bug 12780098 | |
| 13503598 | Fix for bug 13503598 | |
| 10.2.0.5.5 | 10208905 | "WARNING:Could not increase the asynch I/O limit ..." messages in trace file |
| 10.2.0.5.4 | 7612454 | More "direct path read" operations / OERI:kcblasm_1 |
| 10.2.0.5.2 | 9772888 | Needless "WARNING:Could not lower the asynch I/O limit to .. for SQL direct I/O It is set to -1" messages |
Enterprise Manager Database Control
| 10.2.0.5.12 | 14459552 | Fix for bug 14459552 |
| 16279211 | Fix for bug 16279211 | |
| 16279401 | Fix for bug 16279401 | |
| 10.2.0.5.10 | 11856395 | For resource manager, switch action should only list consumer groups in the plan |
| 14023636 | Fix for bug 14023636 | |
| 14205448 | Fix for bug 14205448 | |
| 14258925 | Fix for bug 14258925 | |
| 14469008 | Fix for bug 14469008 | |
| 14546638 | Fix for bug 14546638 | |
| 14546673 | Fix for bug 14546673 |
| 10.2.0.5.11 | 9821321 | ORA-600 [kqlrelod:2] on DDL |
| 10.2.0.5.8 | 7710224 | Problem with choosing a child cursor with binds |
| 14040433 | Cursors not shared due to DIFF_CALL_DURN even though they should share | |
| 10.2.0.5.7 | 7115910 | Dump [kqlchg] intermittently during REFRESH of MV |
| 9689310 | Excessive child cursors / high VERSION_COUNT / OERI:17059 due to bind mismatch | |
| 9694101 | Hang / deadlock between "cursor: pin S wait on X" and "library cache lock" involving dictionary objects | |
| 11858315 | Bind related memory corruption / ORA-600 (near kxs-heap-b heap) | |
| 10.2.0.5.6 | 8528171 | High shared pool use due to frequent ADD/EXCHANGE partition operations |
| 8650138 | PMON dump [koklcom] | |
| 9032322 | Fast split of LIST subpartition with COMPRESS KEY index produces corrupt index | |
| 9072105 | Shared cursor graduated bind array can become inconsistent (ORA-1460) | |
| 9171933 | False ORA-54 from concurrent EXCHANGE partitio and SPLIT partition on same table | |
| 9586877 | The fix for bug 7526851 / bug 8494071 can get false ORA-904 errors or Wrong Results | |
| 9824435 | ORA-600 [kokegPinLob1] from aggregate returning a LOB | |
| 10092858 | Wrong results / bad materialized view content after fast refresh if MV has an OUTER join | |
| 10139235 | ORA-600[kokcup:05] / ORA-600 [KGHFRE3] during session cleanup with MAX_IDLE_TIME set | |
| 10165083 | Wrong child cursor may be executed - SQL executes in a wrong schema | |
| 11076894 | ALTER INDEX [no]PARALLEL requires unneccessary X-lock | |
| 11814891+ | ORA-600 [7999] [9] [1] [<lob block rdba>] / ORA-1555 double allocated LOB block | |
| 13349665 | ORA-600 [kkslmtl-valnotfound] with fix for bug 9767674 (eg After applying PSU 10.2.0.5.5) | |
| 10.2.0.5.5 | 6011045 | DBMS_STATS causes deadlock between 'cursor: pin S wait on X' and 'library cache lock' |
| 7509714 | Rebuild index of a subpartitioned index fails with ORA-1 or produces a corrupt index | |
| 8666117 | High row cache latch contention in RAC | |
| 9499302 | Improve concurrent mutex request handling | |
| 9735237+ | Dump [under kxspoac] / ORA-1722 as SQL uses child with mismatched BIND metadata | |
| 9767674 | Dump [kkslmtl] using CURSOR_SHARING - superceded | |
| 10214450 | ORA-600 [kcbo_unlink_q_1] / ORA-600 [504] from Ctrl-C / interrupt | |
| 10306945 | Process spin querying V$OPEN_CURSOR - causes "latch: library cache" waits | |
| 12890243+ | Internal errors in 10.2.0.5.4 in HP TRU64 | |
| 10.2.0.5.4 | 6651220 | Dump [ttcfopr] from PLSQL using a database link with SESSION_CACHED_CURSORS |
| 9184754 | SGA corruption / ORA-600 [ktcccenxt] / dump using Lobs | |
| 9360157 | Wrong results using ORA_ROWSCN pseudocolumn with ANSI join | |
| 9469117+ | Corrupt index after PDML executed in serial. Wrong results. OERI[kdsgrp1]/ORA-1499 by analyze | |
| 10017048 | Parallel query / DML does not run in parallel in deep nesting of a DBMS_JOB and PLSQL procedure | |
| 11737047 | Excessive PQ slaves spawned for parallel query in 10.2.0.5 | |
| 10.2.0.5.3 | 8865718 | Recursive cursors for MV refresh not shared |
| 9020537 | DBMS_LOB.SUBSTR truncates LOBs > 8191 in multibyte - superceded | |
| 9150282 | ORA-600[kksfbc-reparse-infinite-loop] can occur | |
| 9320130 | ORA-4031 for "temporary tabl" using temporary table transformations (STAR / WITH) | |
| 9337325 | OERI [kqlidpfgr: depobpo] on drop partition | |
| 9548269 | ABORT_REDEF_TABLE can be slow for rowid based redefinition | |
| 9770451 | ORA-600 [20022] with bitmap indexes | |
| 10091698I | Upgrade to 10.2.0.5 gets ORA-600 [17069] when running catupgrd.sql with MultiMedia (intermedia) installed | |
| 10157402 | LOB segment has null data after long to lob conversion in parallel mode (eg DBMS_REDEFINITION). | |
| 10.2.0.5.2 | 8277300 | Dump [xtyqbcb] / OERI:17147 from SQL with > 32000 OR predicates. SGA memory corruption, instance may crash |
| 8394351 | ORA-32696 from a parallel GROUP BY with no aggregates or COUNT(DISTINCT) | |
| 9726739 | ORA-997 from SQL with CONNECT BY and UNION | |
| 10.2.0.5.1 | 8546356+ | ORA-8102/ORA-1499/OERI[kdsgrp1] Composite Partitioned Index corruption after rebuild ONLINE in RAC |
| 8664189 | OERI [kdiss_uncompress: buffer length] on key compressed index |
| 10.2.0.5.7 | 9448311 | RAC instance crash "TIMEOUT in DRM FREEZE step" |
| 11674645 | "gcs drm freeze in enter server mode" waits in RAC | |
| 13554409 | Fix for bug 13554409 | |
| 10.2.0.5.6 | 7119382 | V$DATAGUARD_STATS may return misleading or inconsistent results |
| 7361418 | ORA-600 querying V$LOGMNR_CONTENTS for logs without supplemental logging | |
| 8224558 | Excessive archive logging when required logfile deleted | |
| 8966823 | LMON dump ORA-7445 [kjrchc] / ORA-600 [504] | |
| 9532911* | LOB showing incorrect data on standby database or after recovery. This bug is alerted in Note:1206814.1 | |
| 10076669 | RAC instance crash with ORA-600 [kjmchkiseq:!seq] after ORA-4031 | |
| 11693109 | ORA-481 during DRM results in LMS communication issues between nodes / hang | |
| 11893577 | LMD crashes the instance with ORA-600 [kjccgmb:1] | |
| 10.2.0.5.5 | 6694396 | V$ARCHIVE_DEST_STATUS STANDBY_LOGFILE_COUNT incorrect |
| 7450366 | RMAN Autobackup fails with unable to obtain snapshot enqueue (ORA-230) | |
| 8354642 | ORA-19883 ORA-1115/ORA-27091/ORA-27069 in alert log while running RMAN backup | |
| 8488233 | OERI[kfioTranslateIO01] / OERI[kffSendMap_2] by RMAN Block Change Tracking file | |
| 9322219 | Session dump with stack memcpy <- kjzhgigblk in RAC env | |
| 10162036 | ORA-600 [kcrruli.3] / ORA-600 [kcrrpsrl.7] after COMMIT TO SWITCHOVER TO PRIMARY | |
| 10.2.0.5.4 | 8882576 | GES resource increases continuously in RAC |
| 10173237 | Cross instance archival fails in 10.2.0.5 | |
| 10.2.0.5.1 | 6402302 | Streams table and schema rules not consistently applied for DDL on view/synonym |
| 9713537 | Message file change for ORA-600 | |
| 9714832 | Message file change for ORA-7445 |
| 10.2.0.5.9 | 13775862 | Database Vault Administrator UI gets "500 internal error" after apply PSU |
| 10.2.0.5.6 | 9842573 | Dump from materialized view refresh or procedure call over DB link with Audit enabled |
| 10.2.0.5.5 | 9323583 | EUS connections get OERI [kzldsearch2] [rdbms to ldap characterset conversion failed] |
| 10.2.0.5.7 | 6076890 | ORA-600[16622] when synonym is specified in DBMS_SPACE.UNSUSED_SPACE |
| 11790175 | SMON spins in rollback of LOB due to double allocated block like bug 11814891 | |
| 10.2.0.5.5 | 8970313 | GV$FILESPACE_USAGE returns invalid entry for dropped file in RAC |
| 9145204 | ASSM search for free space may revisit blocks if HWM is raised | |
| 10.2.0.5.4 | 9308296 | ASSM_TABLESPACE_VERIFY reports false inconistency messages |
| 10132870 | Index leaf block corruption possible after plugging in transportable tablespace | |
| 10324526 | ORA-600 [kddummy_blkchk] [6106] / corruption on COMPRESS table in TTS | |
| 10.2.0.5.3 | 9024850 | Wrong results of ORA_ROWSCN in a full scan of table with ROWDEPENDENCIES enabled |
| 9109487 | DBMS_SPACE.ISDATAFILEDROPPABLE_NAME throws ORA-1426 | |
| 9390484 | OERI [kdimstart:kdignbk-loop] during ALTER INDEX COALESCE | |
| 9659614 | Large trace file for ORA-8103 | |
| 10.2.0.5.1 | 7519406 | Larger trace than needed for ORA-8103 under kteinicnt1 |
| 8544696 | Table segment growth (blocks are not reused) with ASSM | |
| 9711859* | ORA-600 [ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent allocation caused by bug 8198906. This bug is alerted in Note:1229669.1 |
| 10.2.0.5.11 | 13561951 | Fix for bug 13561951 |
| 10.2.0.5.10 | 14035825 | Fix for bug 14035825 |
| 10.2.0.5.8 | 14076510 | ORA-600 [ktrgcm_3] in 10.2.0.5.3 - 10.2.0.5.7 |
| 10.2.0.5.6 | 6157713 | Wrong result from ORA_ROWSCN |
| 9399589 | "WITH" subqueries cannot be materialized inside a global transaction | |
| 10.2.0.5.3 | 8771916 | OERI [kdsgrp1] during CR read |
| 10.2.0.5.4 | 7026523 | Dump [kdblailb] from impdp direct_path of a COMPRESSed table |
Oracle Virtual Operating System Services
| 10.2.0.5.7 | 10326338 | High "resmgr:cpu quantum" but CPU has idle time |
| 10.2.0.5.6 | 7111619 | PQ slaves may get stuck or abort |
| 8636407 | OERI:kgskexitsch / crash from Resource Manager | |
| 9672816 | ORA-7445 [ksldclt_cln] using Resource Manager | |
| 10.2.0.5.4 | 8660422 | "unspecified wait event" and/or "ksfd: async disk IO" after applying patches that include fix for Bug 7510766 |
| 10.2.0.5.3 | 8211733 | Shared pool latch contention when shared pool is shrinking |
| 8412426 | "WARNING:Could not lower the asynch I/O limit" messages | |
| 10010310 | ORA-27300 / ORA-27302 killing a non existing session | |
| 10.2.0.5.2 | 9949948P | Linux: Process spin under ksfdrwat0 if OS Async IO not configured high enough |
| 10.2.0.5.4 | 10068982 | PLSQL concatenation (||) slow with mixed VARCHAR2/NVARCHAR2 arguments |
| 10269717 | DBMS_SQL.PARSE leaks session heap memory in 10.2.0.5 |
| 10.2.0.5.11 | 14841558 | Fix for bug 14841558 |
| 10.2.0.5.8 | 12880299 | TCP handlers block if listener registration is restricted to IPC with COST |
| 10.2.0.5.7 | 13257247 | AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS. |
| 10.2.0.5.5 | 10159846 | ORA-1 on SYS.WRH$_TEMPSTATXS_PK when collecting AWR snapshot - superceded |
| 10.2.0.5.11 | 14220725 | Fix for bug 14220725 |
| 10.2.0.5.5 | 12565867 | XML parser may fail with LPX-287 |
| 10.2.0.5.12 | 6690853 | Fix for bug 6690853 |
| 12710774 | Fix for bug 12710774 | |
| 13015379 | Fix for bug 13015379 | |
| 13561750 | Fix for bug 13561750 | |
| 13596521 | Fix for bug 13596521 | |
| 13791364 | Fix for bug 13791364 | |
| 16306019 | Fix for bug 16306019 | |
| 16382448 | Fix for bug 16382448 | |
| 16703112 | Fix for bug 16703112 | |
| 16817117 | Fix for bug 16817117 | |
| 10.2.0.5.4 | 12774686P | Solaris-X86-64 and IBM Linux System Z: 10.2.0.5.4 before 22/Jul/11 contains wrong lib32/libnnz10.so |
| 10.2.0.5.2 | 10235783PI | AIX: "no message file for product=rdbms" after installing PSU 10.2.0.5.1 on AIX |
| 11718087P | Solaris-X86: Patch Set Update re-released on 3-Mar-2011 |