Tips: DBA Tools | Oracle DUL? | AUL License | AUL Example | DBDiff | Text Unload | DB Monitor

Subject: 10.2.0.4 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:401436.1 Type: README
  Last Revision Date: 05-NOV-2007 Status: PUBLISHED

Bugs fixed in the 10.2.0.4 Patch Set

Please note that 10.2.0.4 has not been released on any platform , and does not have release dates available.

This note lists some of the customer bugs expected to be fixed in the 10.2.0.4 Patch Set. This is not a definitive list and inclusion in this list does not guarantee that a fix will be in the final 10.2.0.4 Patch Set when it is released. This list is provided to help customers know what issues affect the current 10.2.0.3 release broken out by category.

Bugs are listed by product. RDBMS (Server) bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a Support Bug Description.

Notable exceptions and omissions

Security Alert Issues fixed in the 10.2.0.4 Patch Set

Fixed Bug# Security Alert# Document Summary

10.2.0.4 Bug Categories



10.2.0.4 Bug Fixes by Category



Oracle Server


ANSI Joins
4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
4702830 OERI[kkoljt1] when using star transformation with an ANSI outer join
4901291 Wrong results with left outer joins on view with a function
5188321 wrong results (no rows) from ANSI outer join
5590396 Dump or Wrong Results with ANSI JOINS and CONNECT BY
5765958 OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
5964193 OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
5988085 Dump [kkodsel] from STAR transformation with ANSI view

ASSM Space Management (Bitmap Managed Segments)
5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
5401876 wrong results when optimizer uses 'bitmap conversion'
5530583 ASSM managed INDEX updates can be slow compared to non-ASSM
5557421 Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
5637976 ORA-8103/ORA-1410 from concurrent INSERT / export on ASSM tables
5695131 HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
5728380 DML may spin under ktspffc searching for space in ASSM segment

Advanced / Secure Networking
5079968 SSL auth client connections create erroneous trace files in udump
5527753 ESM errors and does not show global role, which is added by ESM cmdline
5584798 Unnecessary trace files using EUS with LDAP_DIRECTORY_PASSWORD='PASSWORD'

Advanced Queuing
4478139 ORA-28031 "maximum of 148 enabled roles" when creating queue table
4618808 AQ operation requiring exclusive lib cache lock may hang
4715375 OERI[kwqmtdel] in q00 process in RAC when any instance goes down
4719848 Streams DELETE_ERROR does not maintain AQ$_QTABLE_I
4733582 Upgrade to 10.2 deletes statistics on AQ tables
4745691 OERI[kghufree_06] from AQ propogation of XML payload
5018886 OERI:[kwqitnmptme:wait] in Qnnn during propagation of delayed messages
5092843 Dump (kpceclose) in EMON
5225596 AQ propogation does not work after failover
5358598 EMN0 not posted for ha notification
5408664 Messages not marked as undeliverable after transformation failure
5415506 ORA-4020 when dbms_aqadm.purge_queue_table and select are run
5439588 Notifications not delivered when client machine has multiple NICs
5452715 OERI[kwqbgqc: bad state] reported after restart of database
5494866 PLS-302 'dbver_10i' importing 10g export into 9i with AQ
5506702 Dequeue delay experienced after reconfiguration
5523578 DBMS_AQADM.add_subscriber fails with ORA-1925 "maximum of x roles exceeded"
5526245 "ksxplookup: warning cnh incarnation number" messages in QMNC trace
5545530 EMON may spin in kpcopen
5561130 Performance of long running transaction using AQ degrades over time
5580871 AQ bytes message <= 2000 bytes incompatible between PLSQL and Java
5590163 Message dequeued more than once from single consumer queue
5594352 JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
5605319 Cursor leak from QMON coordinator exceptions
5608198 Memory leak by advanced queuing XML transformation
5648610 ORA-25235 during AQ propagation
5654680 JMS worker thread does not end if exception thrown in onMessage() method
5655612 AQ$_PENDING_MESSAGES table can grow indefinitely
5666374 FIFO does not occur when multiple listens are followed by dequeues
5717536 Dequeue can suffer from a memory leak
5734276 Queue slave process may spin in kwqitptm
5751016 AQ messages enqueued at non-owner instance not moved from WAIT to READY
5758963 UGA memory leak possible from AQ dequeue
5852253 ORA-25316 from AQ after rollback to savepoint with loopback database link
5857313 OERI[kwqbmcrcpts101] after drop propagation
5941601 TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
5955596 DBMS_AQ.LISTEN hangs after datapump has executed
6044513 Cannot dequeue a message with a correlation padded with spaces

Analytic SQL (Windowing etc..)
4436832 False ORA-979 "not a group by expression" with literal replacement
4587572 ORA-12801/ORA-60 possible from parallel DML with grouping sets
4597871 ORA-904 from query using CUBE
5162852 Dump from FIRST / LAST aggregations on a NULL table
5196061 Dump in evaopn2() from WITH query using WINDOW functions
5216642 Dump from SQL using window functions
5286826 Wrong results from complex view merge with windowing
5302124 Join Predicates are not push inside window functions -- superceded fix
5641873 ORA-904 using a WITH clause that includes a UNION
5670585 OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
5847881 ORA-3001 from GROUPING SET query against a view containing a function
5906937 Wrong result using ROW_NUMBER in SQL using a WITH query block
5942097 OERI:qernsRowP from SQL with GROUP BY , ROLLUP and DISTINCT aggregates
6012053 OERI [qctcte1] from GROUPING SETs query
6026281 OERI[qeshCloseHTI.2] from spreadsheet query

Application Context
4902585 OERI[510] and ORA-28106 using application context over 30 bytes long

Automatic SGA Memory Management
5702177 Instance crash from OERI[kghchoose_grow_1]

Automatic Storage Management (ASM)
6051728P* HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note 434500.1
4319031 Wrong header_status in V$ASM_DISK when disk is offline
4380450 Unbalanced space usage if diskgroup has only two disks, both of different size
4431215 "backup archivelog all delete input" from RMAN removes ASM directory
4489948 ASM hangs during a parallel mount and shutdown in RAC
5081798 Additional diagnostics for OERI[2103] when ASM involved
5230765 LGWR spins while waiting for 'log file parallel write' using ASM
5471453 OERI[kfkfilrqarr01] using ASM
5472917 DBVERIFY may error if ASM disk disconnected
5483613 OERI [kfgscAcquireLcl_6] in ASM
5502365 OERI [kfcDel20] in ASM
5526987 ASM instance hang / OERI [2103] on DB instance
5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5556674 V$ASM* dynamic views leak cursors (ORA-01000)
5575584 Failure of an entire failure group is detected one disk at a time
5682184 OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file
5743325 ASM instance fails with OERI[kfaDropCOP04]
5757711 ORA-15080 during file creation / resize on ASM with HARD
5761185 ORA-15041 diskgroup space exhausted after adding disks to a diskgroup
5893614 Full table scan very slow on ASM
5899033 SMON dump (kfrCheckCtx) diskgroup instance recovery
5909894 ASM datafile lost after rename (ORA-1157)
5922733 ASM dump in kfkdumprq with event=15199 level=1050631
5939241 Inconsistent diskgroup configuration after rejected DISK OFFLINE
6013983 ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM
6453944 ORA-15196 with ASM disks larger than 2TB using ASMLIB

Bitmap Indexes
4596807 OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
4697632 OERI[atbbjie2] from exchange partition with bitmap join indexes
5063279 OERI[kdibllockrange:not validated] updating a partitioned bitmap index
5113934 PQ slave dump in qerixGetKey() when using bitmap index access
5262017 Query on partitioned table with bitmap index gives OERI[qernsRowP]
5331374 OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
5449488 Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
5667683 Parse of query can spin in kkosbn
5960268 Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index

Change Data Capture
5165904 Materialized View DDL may execute when it should wait
5252389 CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
5533982 Updated columns set to null show old not-null values in change table using async CDC
5693948 ORA-31466 error when setting up CDC with table names using multibyte characters
5881493 CDC ordered sequence causes large performance degradation on RAC

Cluster Ready Services / Parallel Server Management
5667023P+ Linux: CRS does not start after applying 10.2.0.3
5495242PI HPUX: CRS may not install
5845104PI Win64: 10.2.0.3 OPMD.EXE does not work
4440013 CRS startup of RAC fails when FSFO enabled
4566428 cluvfy displays duplicate names in the output
4574574 crs_start opens a physical standby database as opposed to mounting the instances
4587300 Improve CRS shutdown sequence
4598992 "Action script for resource 'ora.xxx.vip' stdout redirection" errors in crsd.log
4930431 Failure of 1 CSSD can hang starting CSSD on other nodes
4996577 CVU does not recognise long device names
5003881 Value of restart_attempts wrong after DB policy is changed
5101517 VIP does not failover with auto_start=2
5125957 Cannot start CRS after CRS ugprade
5131219 CSS shuts down the node when disk IO is suspended momentarily
5137401 oprocd logfile is cleared after a reboot
5168043 VIPCA silent mode cannot handle upper case characters in hostnames
5188493 crsd.bin can use excess CPU on reboot
5192194 CSS does not start on one of the nodes ("takeover aborted due to unknown nodes")
5278777 CRSD version is 10.2.0.1 after applying 10.2.0.2 patchset
5297925 Disabling one instance disables restart of all the instances in the node
5334170 racgevtf can dump in lmmstfree
5338035 PRKR-1008 using DBCA to create RAC instance
5365683 CRS repeatedly stops and restarts VIPs while recovering multiple nodes
5388818 cluvfy should not use remote shell for local node
5442229 VIP does not failover when public LAN disconnected pulled (crsd communicating on public LAN)
5446160 RLB information cannot be forwarded
5448707 Better tolerance of CRS init scripts to low system resource conditions
5454388 OPROCD dumps with fix for bug 5015469
5467456 Directory $ORA_CRS_HOME/crs/auth was unexpectedly removed
5487604 CRSD core dump
5503111 racgimon startd <dbname> uses a lot of CPU
5549682 High CPU usage by srvctl
5568399 CRS upgrade can corrupt OCR
5651085 Session disconnection blocks service resource stop action
5679560 Unexpected node reboot on death of "init.cssd fatal"
5698321 Wrong return code from srvctl from failed "modify nodeapps" operation
5735768 killed ocssd.bin on a node causes other nodes's crsd restart
5843485 Unnecessary VIP failback trial makes VIP unavailable for 14s on network down
5853909 CSSD permission problems (skgxninit errors in CSSD log)
5854172 VIPCA fails with exception thread main error
5861703 CSSD failure 139 and node reboot if nfs mounted voting disk is remounted
5862719 init.crsd does not set a high file limit on all platforms (notable Linux)
6005526 CSS will not shutdown evmd.bin with fix for bug 5442229

Code Improvement
5238255 Timezone changed data in CSV format
5245494 Improved control over whether star transformation is performed
5614566 Enh: Allow library cache heaps to be purged manually

Compressed Data Storage
4061534 OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
4600946 Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
5496041 OERI[6006] / index corruption on compressed index
5577788 Block corruption / OERI:6585 updating row in compressed block
5599596 Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
5912350 Dump (kdr9ir2f0rst4srp0) on select of compressed table having > 255 columns

Compressed Key Index / IOT
4545196 Corrupt index leaf from cross platform transport of compress-key indexes
5034323 Dictionary corruption when adding a subpartition to a table with a key compressed local index

Constraint Related
4580190 Bulk insert to partitioned table can insert constraint violating rows
4618715 Dump inserting into a view with OLS policy on tables
4620832 Dump in kzrtppg with multiple referential constraints and OLS policy
4771851 Dump (kxccsrw) from INSERT .. AS SELECT
5324773 Constraints using LTRIM() may fail for valid data
5462687 CHECK constraint can cause wrong results
5472523 Non violated deferred CHECK constraint fails (ORA-2290) at commit
5579055 Dump (kxccres) updating view with instead of trigger
5766196 ORA-942 on schema level import of table with foreign key and XMLSchema
5923497 Select with constraints fails with OERI[12863]

Corruption
4201573 ALTER SYSTEM RESET of an spfile parameter can corrupt the SPFILE
4344935 OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
5690593 Datafile corrupt for ASM datafiles copied using xdb/ftp
6453944 ORA-15196 with ASM disks larger than 2TB using ASMLIB

Corruption (Dictionary)
5034323 Dictionary corruption when adding a subpartition to a table with a key compressed local index
5632050 OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
5936058 Corrupt metadata from tablespace transport

Corruption (Incorrect / Missing Corruption Checks)
3569503 PQ may signal a false ORA-8103 under load

Corruption (Index)
4545196 Corrupt index leaf from cross platform transport of compress-key indexes
5179313 INSERT /*append parallel*/ can corrupt an index
5181547 Index corruption after insert-only merge /*+ append */ into table
5496041 OERI[6006] / index corruption on compressed index

Corruption (Logical)
5686711+ Wrong cursor may be executed if schemas have objects with same names
3419260 Silent truncation on insert via DB link from single to multibyte charset
4193047 Sequences / synonyms / indexes not created in logical standby database
4580190 Bulk insert to partitioned table can insert constraint violating rows
4714295 It is possible to drop an OLS group which is still in use in an existing label
4883635 MERGE (with delete) can produce wrong results
4904743 ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
4933222 Apply update of clob in multibyte charset double spaces characters
4959294 DBMS_XMLSTORE does not follow CHAR based semantics
5019803 Wrong data inserted for INSERT INTO .. SELECT DISTINCT with DEFAULT values
5087369 logical standby potential data loss during failover
5104257 SQLLoader truncates nested table columns
5165904 Materialized View DDL may execute when it should wait
5182679 INSERT as remote SELECT using CASE can produce wrong data
5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5256791 Trigger "UPDATING('col')" clause can return TRUE when column not updated
5352587 Triggers not working correctly with timestamp datatype
5436371 Image corruption / spin loading multiple nested objects in multibyte
5515703 Streams table diverges after partial rollback on primary
5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5567934 NCHAR literal replacement can produce corrupt N literals
5577788 Block corruption / OERI:6585 updating row in compressed block
5588615 Single source streams with DML handler duplicates CLOB column value
5616820 Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
5621677 Logical corruption with parallel update on compressed partition
5936058 Corrupt metadata from tablespace transport
6038412 OCI7 clients using "CALL" SQL may execute wrong shared cursor

Corruption (Physical)
4450606+ LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
5363584+ Array insert into partitioned table can corrupt redo
4592596 Corruption (ORA-1410) from multi-table insert with direct load
4899479 Undo/redo corruption if distributed transactions used
5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
5599596 Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
5609096 MERGE / UPDATE to IOT can cause corruption
5636728 LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
5909894 ASM datafile lost after rename (ORA-1157)

DBVerify Utility
5031712 DBV reports blocks "soft corrupted" blocks as bad
5472917 DBVERIFY may error if ASM disk disconnected

Database Link / Distributed
3419260 Silent truncation on insert via DB link from single to multibyte charset
4311273 ORA-2064 using MERGE statement over a database link
4351422 Dump from CREATE TABLE AS SELECT (CTAS) over DB link
4373687 SET_SCHEMA_INSTANTIATION_SCN does not error if database link unavailable
4490782 Unparse operations give wrong date for BC TO_DATE literals
4491223 Dump selecting ROWID with a remote join
4581334 Cursors accessing remote tables may be repeatedly rebuilt and not used
4624183 ORA-1017 reported using DB links with IDENTIFIED EXTERNALLY accounts
4648039 PLSQL hangs with database links and autonomous_transaction
4658456 ORA-920 from distributed query using CASE against remote table/s
4701527 Cursors not shared when executing procedures over a dblink
4768022 ALTER TABLE can fail with ORA-60
4865959 Wrong results / exception from Java Stored Procedure accessing data over DBLINK
4889807 False ORA-904 from co-located join (over database link)
4899479 Undo/redo corruption if distributed transactions used
4913460 Soft parsing re-occurs for select using database link
5015321 OERI[qerrmObnd1] [932] using binds with some functions over a DBLINK
5015547 Cannot create a materialized view over a database link (ORA-942)
5128933 Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5182679 INSERT as remote SELECT using CASE can produce wrong data
5216523 OERI[16608] from create materialize view on remote table with objects / types
5245451 Intermittent ORA-904 referencing remote objects columns
5246372 OERI[opidsii1] accessing remote database accessing 3rd remote database
5299546 ORA-942 from create materialized view with join between local and remote tables
5327132 Wrong results from colocated OUTER join over DBLINK with TO_DATE
5354469 Poor performance of remote fetch with high fetch counts
5405345 OERI[kkofkrMarkK] when running a query using a database link
5455632 Dump accessing tables over a database link
5467520 PLSQL errors accessing synonym to remote object
5509293 Query with subquery across DB link has poor performance
5852253 ORA-25316 from AQ after rollback to savepoint with loopback database link
6145525 Dump selecting > 34 columns from HS (FDS)

Datapump Export/Import
4352110 ORA-39125 from expdp/impdp of triggers with nulls in WHEN clause
4517481 ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
4595736 ORA-6502 during impdp due to wrong logging_level put in export dump
4660745 TABLESPACE GROUP clause not generated by DBMS_METADATA.GET_DLL
4996004 EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
5027003 ORA-39068 from EXPDP if parallel > 1
5071931 Datapump import with remap tablespace and schema is very slow
5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5135951 ORA-22337 on import if database schema has been evolved
5152232 EXPDP loses global index parameters for local domain indexes
5157602 Datapump export/import modifies the chains created with dbms_scheduler
5220845 Large packages imported via data pump are not shipped to logical standby
5292551 IMPDP slow when importing a table with initialized column of type varray
5352426 Data pump import dumps (lxinitc)
5464834 ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
5472417 EXPDP on RAC fails with ORA-39014 / ORA-12801 (error signaled in parallel query server)
5502124 ORA-39096 importing 10.1 EXPDP file with 10.2 data pump
5515882 ORA-1427 from EXPDP
5548895 OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column
5550618 Dump [nszgclient] from EXPDP
5576865 Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
5590185 Consistent export data pump job (flashback_time) has poor performance
5620375 PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
5632683 EXPDP / IMPDP may error for DDL modified tables
5680970 ORA-39001 when attempting to export partition defined as an object type
5713912 ORA-39125 / ORA-6502 from datapump import via network
5714205 EXPDP / IMPDP do not support long lists for parameters
5718757 ORA-31693 / ORA-6502 during datapump net import
5857884 EXPDP fails with ORA-39125 / ORA-6502
5875568 IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
5910237 EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
5972794 EXPDP via network_link with parallel > 1 fails with KUP-4038
6080303 Datapump export does not unload data until all metadata unloaded with PARALLEL > 1

Datatypes (AnyData)
4531589 ORA-22370 when passing sys.anydata containing collection to a method
5307199 OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
5350076 Anydata and timestamp can loose precision
5548895 OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column

Datatypes (LOBs/CLOB/BLOB/BFILE)
4450606+ LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
4559728 Select lob from view loops / OERI [17059] if synonym dropped
4583442 ORA-22877 during move hash partition with LOB
4680009 Insert LOB data fails with ORA-3106 or ORA-8176
4745114 OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
4865755 OERI[9999] during DBMS_LOB operation
4933222 Apply update of clob in multibyte charset double spaces characters
5176017 Exp/imp loses "RETENTION" settings of LOB columns
5196175 OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
5374820 Client side dump on import of table with more than one LOB column into 32k block size
5396550 Spin in ktsplbfmb holding HW enqueue during LOB segment management
5413989 OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
5442534 Dump in kokscold assigning NULL to CLOB
5447395 Shared server tied to session when BFILE used
5500044 ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5510345 ORA-22282 with LOB buffering enabled
5549410 Inconsistent characters read returned from OCILobRead
5560256 Multi threaded OCI program hang when calling OCILobLocatorAssign
5588615 Single source streams with DML handler duplicates CLOB column value
5636728 LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
5644951 OERI[rworupo.2] querying outline LOB with ORDER BY clause
5654094 ORA-3106 for SQL with RETURNING clause with indicator binds
5666733 LOB segment does not use free space from freelist in RAC database
5674184 ORA-22282 when using LOB buffering
5676637 OERI[17114] using EMPTY_CLOB() in a trigger
5682121 Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
5721994 Unexpected errors from non blocking OCI LOB calls
5723140 Temp LOB space not released after commit
5870781 DBMS_LOB.INSTR() function does not find patterns across the 4gig boundary
5926074 OERI [12333] on update of more than one CLOB column
5941355 "Split partition" does not move LOB to correct tablespace
5974207 Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL

Datatypes (Objects/Types/Collections)
4583492 Dump possible using ADT columns when table has many columns
4643723 After type evolution extracting attributes gets OERI[17280]
4691237 High "library cache" latch gets from SQL using objects in PLSQL
4726702 ALTER TYPE may dump (koktupd_dplvl) due to a REF dependency
4895068 Dump [kopxccc] during pickling
5022188 Direct SQLLOAD of partitioned object table of non final types fails
5076729 OERI[pmucitnxt] doing type manipulation
5104257 SQLLoader truncates nested table columns
5135951 ORA-22337 on import if database schema has been evolved
5182299 Dump on grant / revoke of privileges on a TYPE
5192858 DROP TABLE with object type column with statistics can dump (kknerd)
5216523 OERI[16608] from create materialize view on remote table with objects / types
5225836 DROP TYPE .. VALIDATE dumps for large partitioned table
5292551 IMPDP slow when importing a table with initialized column of type varray
5368266 ORA-904 using multiple TABLE() objects in the FROM clause
5436371 Image corruption / spin loading multiple nested objects in multibyte
5577046 ADD or DROP attribute causes UNION query to fail with ORA-1790
5721821 SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5725761 Objects with debug privilege are not shown in the ALL_OBJECTS view
5763434 Spin in kokes2q when sorting on VARRAY column over 4k long
5841624 OERI[kokeicadd2] accessing object with embedded substitutable attributes
5910237 EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625

Datatypes (TIMESTAMP)
4992603 TIMESTAMP.timestampValue(Calendar) does not exist
5126270 Version 3 TIMEZONE check script (utltzuv2.sql)
5128933 Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5238255 Timezone changed data in CSV format
5350076 Anydata and timestamp can loose precision
5350339 ORA-979 using TIMESTAMP in triggers and GROUP BY clause
5352587 Triggers not working correctly with timestamp datatype
5417281 oracle.sql.DATE looses a year when constructed from BC Timestamp
5468695 TIMESTAMPTZ wrong near daylight switch
5616820 Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
5632264 Version 4 TIMEZONE files
5688685 JVM timezone changes for Western Australia December 2006 (superceeded)
5726033 timezdif.csv for version 4 timezone files
5865568 JVM timezone changes (version 4 timezone data for JVM)
5885079 Incorrect output from INTERVALDS.stringValue() for negative intervals
5910187 No bind peeking for implicit string bind to timestamp
5961654 ldiinterfromtz returns wrong offset during DST fallback
5973217 OCCI::intervalds object attribute uses day precision for fractional seconds

Deadlock
5907779+ Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
4441119 Not enough information dumped when RAC detects a deadlock
4587572 ORA-12801/ORA-60 possible from parallel DML with grouping sets
4768022 ALTER TABLE can fail with ORA-60
5334733 Deadlock resolution can be slow in RAC
5415506 ORA-4020 when dbms_aqadm.purge_queue_table and select are run
5454831 RAC deadlock possible on working set latches
5470095 Self deadlock should provide more targeted diagnostics
5485914 Mutex self deadlock after DBMS_MONITOR.session_trace_enable
5557421 Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
5604698 Deadlock between 'library cache lock' and 'library cache pin' using Streams
5685189 Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
5695131 HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
5883112 False deadlock in RAC
5941601 TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
5983020 MMON deadlock with user session executing ALTER USER
5998048 Performance degradation when FGA is enabled / deadlock on COMMIT updating AUD$
6057351 AWR deadlock between Mxxx processes during snapshot purging process

Direct Path Operations
5022188 Direct SQLLOAD of partitioned object table of non final types fails
5179313 INSERT /*append parallel*/ can corrupt an index
5181547 Index corruption after insert-only merge /*+ append */ into table
5228136 ORA-26065 from SQLLDR direct path load of objects containing a LOB and constraints
5386204 Block corruption / OERI[kddummy_blkchk] after direct load of ASSM segment
5953355 OERI[klaprs_30] / OERI[klaprs_10] during SQLLOADER direct path load
5973648 ORA-54 during concurrent parallel direct SQLLOAD in RAC

Domain Indexes
4566516 Transportable tablespace does not handle domain indexes
4644425 SGA corruption on UPDATE with functional domain index
5136863 OERI from join between partitioned table and domain index
5152232 EXPDP loses global index parameters for local domain indexes
5228074 OERI[12455] raised from SQL with DOMAIN index when FOR UPDATE option is used
5307199 OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
5370332 ODCITableFetch fails with ORA-28579
5403398 Dump when costing user defined operators / functions
5530761 ORA-1031 from EXP of domain index
5656948 Dump returning collection from ODCIAggregate

Excessive CPU Usage
6455161+ Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
4605569 LCK may accumulate CPU time on one instance
4697189 High CPU usage for large sorts
5362897 Non linear CPU increase when adding more shared server sessions
5399325 Mutex latch spin causes high CPU on non-CAS platforms
5471994 LCK may accumulate CPU time when SMON does Serial Transaction recovery
5530958 Larger SGAs and SQL in long running transactions can use excess CPU in ktaifm
5734276 Queue slave process may spin in kwqitptm
5896963 High LGWR CPU and longer "log file sync" with fix for bug 5065930
6001617 LCK may accumulate CPU time / ORA-4031 possible

Export/Import
3370858 Import fails (ORA-932) using FROMUSER / TOUSER for schema based xmltype
4038803 IMP-3 / ORA-1722 when using nls_numeric_characters != '.,'
4328909 Resource plans and resource groups not imported during full import
4559546 Cannot used exp/imp of MVIEW with XMLTYPE column
4912371 Dump possible in kohrsmc()
5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5176017 Exp/imp loses "RETENTION" settings of LOB columns
5349808 IMP-60 hit when importing a table with an XML schema based XMLType column
5374820 Client side dump on import of table with more than one LOB column into 32k block size
5391326 ORA-942 importing functional indexes as SYS
5402151 ORA-439 when importing into Standard Edition db using streams_instantiation=y
5494866 PLS-302 'dbver_10i' importing 10g export into 9i with AQ
5530761 ORA-1031 from EXP of domain index
5664206 ORA-6502 during export of functional index expression over 4k
5766196 ORA-942 on schema level import of table with foreign key and XMLSchema

External Tables
4644351 OERI[15819] / wrong results from parallel select
5195356 Dump (memcpy) under kudmprcbk() when accessing external table
5600425 wrong results from select on external table
5676948 OERI [qxxmslSelectLocator_10] from SQL*Loader

Flashback
4459574 FLASHBACK_TRANSACTION_QUERY shows multi row INSERT as SELECT as only one row
5209867 ORA-38777 is thrown by MRP when flashback through resetlogs
5225733 After flashback operation, new logs are not applied in logical standby
5385614 Select using BETWEEN SCN / TIMESTAMP fails (OERI [ktrviupk_4])
5949116 Flashback logs are not purged when archiver is out of disk space
6010833 Recovery following flashback does not utilize changes in online redo log

Function Based Index (Including DESC Indexes)
4619997 Function based index may not be used for INLIST predicate
4916783 Wrong results from query using INLIST predicate if FUNCTION BASED index
5377092 Wrong results from FAST FULL SCAN of an index on a CASE expression
5391326 ORA-942 importing functional indexes as SYS
5513123 DUmp [kkfies] from SQL using functional indexes with subqueries
5526851 Wrong Results (missing rows) on CONNECT BY when using function-based index
5574966 Dump (evaopn2) or Wrong Results with views and function-based index
5619833 Dump (qerixGetKey) from query rewrite on join including functional index
5664206 ORA-6502 during export of functional index expression over 4k
5686412 Dump (evaopn2) from query using functional index
5796376 Dump [kkobrak] from index join with a FUNCTION based index
5843316 Wrong results with index join and function-based index
5860221 Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
5889331 Dump from cost based optimization of INSERT .. SELECT with function based index

Gateways / Heterogeneous Services
4767996 Dump in HS with very long TNS connect string
4998706 Gateway agent trace does not work
5175364 Data truncation / null data selecting NVARCHAR2 over TG4MSQL
5229137 PLS-201 compiling program units referencing tables on RDB
5601756 HS does not supply size for large objects (ORA-28500)
5877437 TG4DRDA gets sqlcode=-102, sqlstate=54002 using concat function
5898868 SELECT FOR UPDATE errors over HS to Teradata
5900857 ORA-23619 from HS log based replication
5935527 Cursor leak with fix for bug 5260266
6145525 Dump selecting > 34 columns from HS (FDS)

Gateways / ODBC
5385973 ODP.NET gets truncated char/varchar data in HSODBC environment

Gateways / Transparent Gateway For SQL Server
4552393 Heterogenous apply fails for updates with WHERE .. IS NULL
5733637 Select for update fails against TG4MSQL
5844876 ORA-28550 from TG4SYBS

Global Temporary Tables
4344935 OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
4736557 ORA-1466 on read only transaction
5081271 PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
5689991 ORA-8176 fetching from global temporary table with INSERTS between fetches
5696474 Diagnostic enhancement for ORA-600 errors on global temporary tables

Globalization Support (NLS)
3419260 Silent truncation on insert via DB link from single to multibyte charset
3945156 ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
4346448 NLS_COMP = ANSI gives wrong results comparing CHAR with VARCHAR2
4517481 ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
4730249 Logical Standby or Adhoc query fails with ORA-1801 when using a different characterset
4904743 ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
4905638 Wrong results / errors in session that opens the database for certain NCHAR characterset
4933222 Apply update of clob in multibyte charset double spaces characters
4959294 DBMS_XMLSTORE does not follow CHAR based semantics
4996004 EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
5017909 V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
5120476 No blank padding with multibyte charset if no character set conversion
5126270 Version 3 TIMEZONE check script (utltzuv2.sql)
5128625 OERI[17147] / OERI [17182] / NULL result from NLSSORT
5175364 Data truncation / null data selecting NVARCHAR2 over TG4MSQL
5252496 Wrong result when using a LIKE predicate with NLS_COMP = LINGUISTIC
5259741 DBMS_XMLGEN.CONVERT trims output for multibyte database
5285966 Dump [lxhlod] on select passing NULL for NLS parameter to a function
5326327 OERI[qctbyt : bfc] using NLS_LENGTH_SEMANTICS=CHAR
5436371 Image corruption / spin loading multiple nested objects in multibyte
5444175 glb files created in gdk_custom.zip by ginstall are ignored by Java
5494008 Wrong results from LIKE in multibyte when NLS_COMP=linguistic and NLS_SORT=binary_ci(ai)
5526851 Wrong Results (missing rows) on CONNECT BY when using function-based index
5567934 NCHAR literal replacement can produce corrupt N literals
5576865 Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
5594352 JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
5604120 Performance problems after applying calendar deviation
5632264 Version 4 TIMEZONE files
5685296 Logical apply stops with PLS-103 due to NLS_NUMERIC_CHARACTERS setting
5693948 ORA-31466 error when setting up CDC with table names using multibyte characters
5712086 OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
5757315 Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
5875568 IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
5903706 ISO2022-JP-OUTLOOK has no mapping for the katakana middle dot character
5985257 Wrong results from UTL_I18N.TRANSLITERATE using 'hwkatakana_fwkatakana'

Hang (Involving Shared Resource)
4489948 ASM hangs during a parallel mount and shutdown in RAC
5057695 SHUTDOWN IMMEDIATE can be slow
5079641 Switchover hangs attempting to recover a log file from a previous primary
5188493 crsd.bin can use excess CPU on reboot
5230765 LGWR spins while waiting for 'log file parallel write' using ASM
5387017 Primary hang when physical standby "shutdown immediate"
5526987 ASM instance hang / OERI [2103] on DB instance
5688403 'IPC Send timeout' error just after 'flush_cache' event in RAC
5955955 DWB may spin when collecting object level statistics with concurrent DDL
6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM

Hang (Process Hang)
5907779+ Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
3140249 Data guard broker hangs when standby listener is down
4618808 AQ operation requiring exclusive lib cache lock may hang
4648039 PLSQL hangs with database links and autonomous_transaction
4927753 GRANT / ALTER USER can hang
4930431 Failure of 1 CSSD can hang starting CSSD on other nodes
5023410 QC can wait on "PX Deq: Join ACK" when slave is available
5166735 DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
5225733 After flashback operation, new logs are not applied in logical standby
5378806 xa_rollback cannot interrupt a long running SELECT branch
5382088 Fast start failover can hang on broker MIV mismatch
5392993 DDL can hang if EXPLAIN PLAN issued previously for the same DDL statement
5396550 Spin in ktsplbfmb holding HW enqueue during LOB segment management
5444539 Database connections not released after database failover or recycle
5454831 RAC deadlock possible on working set latches
5500044 ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5503590 Logminer Adhoc can hang or error mining logs from a RAC database
5560256 Multi threaded OCI program hang when calling OCILobLocatorAssign
5567141 OERI[526] / hang with fix for bug 5508574 installed with > 31 CPUs
5602452 Capture gets stuck in 'dictionary initialization' after recovery
5604698 Deadlock between 'library cache lock' and 'library cache pin' using Streams
5654680 JMS worker thread does not end if exception thrown in onMessage() method
5746223 Old primary hangs after a FSFO and prevents automatic reinstatement
5955596 DBMS_AQ.LISTEN hangs after datapump has executed
5983020 MMON deadlock with user session executing ALTER USER
6013968 Hang / OERI:504 with patch for bug 5863519 installed
6057351 AWR deadlock between Mxxx processes during snapshot purging process

Hang (Process Spins)
3551896 Dump / spin from SELECT on V$SESSTAT
4387531 Spin running XPATH on SB table with IOT structured varrays
4553025 Large inserts into hash clustered tables can spin
4605569 LCK may accumulate CPU time on one instance
4697189 High CPU usage for large sorts
5369855 OERI:733 or Spin (qksopLogSame) from star transformation
5417292 Query compilation may spin in kkogtp
5436371 Image corruption / spin loading multiple nested objects in multibyte
5471994 LCK may accumulate CPU time when SMON does Serial Transaction recovery
5484652 QMNC process spin in Streams
5545530 EMON may spin in kpcopen
5631915 Select from V$ views using X$KGLLK can spin
5667683 Parse of query can spin in kkosbn
5670585 OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
5718007 Spin (in qcopxla / qcopx0la) with OR predicates on PARTITION key columns
5728380 DML may spin under ktspffc searching for space in ASSM segment
5734276 Queue slave process may spin in kwqitptm
5757315 Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
5763245 Parse may spin in kkpapRTPRuningSetup
5763434 Spin in kokes2q when sorting on VARRAY column over 4k long
5952530 Spin / hang after cluster reconfiguration
5955955 DWB may spin when collecting object level statistics with concurrent DDL
6001617 LCK may accumulate CPU time / ORA-4031 possible
6041084 Spin during parse of query with INLIST against list partition key
6069360 DBW can spin in kfcRunnableWaiter holding a latch in ASM

Hash Join
5383936+ Wrong results from Parallel Query with OUTER join and HASH join
4540971 Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
4566991 Hash group-by is not reported in v$sql_workarea_active
5376015 Wrong results with hash semijoin when build rows do not fit in memory
5759075 Wrong results from PQ with HASH on ANSI CHAR join
5947623 Excess PGA memory used by hash joins

Index Only Tables (IOT)
4387531 Spin running XPATH on SB table with IOT structured varrays
4725385 DBMS_STATS on partitioned IOT with additional indexes can be slow
4770292 Wrong results from CONNECT BY query on IOT with secondary index/es
5236908 Primary key index not used for IOT
5255455 DML error logging not working for primary key violation with insert on IOT table
5494240 OERI[15201] during select from an IOT
5558244 OERI[kcbnew_3] can occur
5609096 MERGE / UPDATE to IOT can cause corruption
5741044 Query performing fast full scan on partitioned IOT
5847521 Hierarchical (CONNECT BY) query on IOT returns wrong results
5924538 Logical standby apply fails with ORA-1427 for operations on IOTs

Install Is Not Performed Correctly
6051728P* HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note 434500.1
5495242PI HPUX: CRS may not install
5845104PI Win64: 10.2.0.3 OPMD.EXE does not work

Instance May Crash
5605370* Various dumps / instance crash possible. This bug is alerted in Note 454464.1
4422686 LMD/LMS cannot be frozen during reconfig
4433838 Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
4744529 OERI:kclpred_1 / crash possible in RAC
5081271 PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
5118012 Instance crash with OERI[kclswrite_3] with multiple DBW processes
5118272 Instance crash with ORA-600 [1433], [60] due to lgwr filling up msg blocks. (Messages could be for LGWR or ARCH).
5131219 CSS shuts down the node when disk IO is suspended momentarily
5190596 LMON dumps LMS0 too often during DRM leading to IPC send timout
5324905 nsprecv() can corrupt the SGA when using shared servers
5375583 LMS process dies with OERI[kclexpandlock_1]
5377099 Dump [kksfreeheap] / OERI:504 / SGA corruption / crash possible
5384248 OERI[k2gtelock: !k2gtca] / instance crash cleaning up distributed transaction
5412994 Dump in ksrchconnect_ctx leading to instance crash
5476873 Instance crash due to PMON ORA-601 / OERI[ksudlp1]
5512921 Instance crash caused by SMON OERI[kcblus_1] / dump
5554692 Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5578157 Instance crash with ORA-600 [1433] (RSM has all message blocks)
5587421 LMS fails with OERI [kjmpmsg_1]
5600050 LMON may fails with OERI [kjbrref:pkey] during DRM
5690100 RAC instance crash with OERI[kjbmpwrite:wip2]
5702177 Instance crash from OERI[kghchoose_grow_1]
5721821 SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5730717 OERI:kclchkinteg_18 / LMS crashes the instance
5762514 DBWR crashes instance with OERI[kcbbctsc_3]
5863519 Instance crash due to LMS dump (in kclcsr)
5899033 SMON dump (kfrCheckCtx) diskgroup instance recovery
5962344 Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
5983403 PMON may crash the instance with OERI[kksStatsRecovery-Bad-Opcode]
6005113 OERI[kclrwrite_7] in DBWn process followed by instance crash in RAC
6013983 ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
6018125 Instance crash during dynamic remastering or instance reconfiguration
6035614 Instance crash / dump [kghunphy] with fix for bug 5922239

Instance Startup
5752399P+ Sol: Mandatory Patch to use Oracle with Veritas or Solstice Disk Suite on Solaris
4440013 CRS startup of RAC fails when FSFO enabled
5247609 RMAN slow performance during register database/open resetlogs
5572026 ORA-942 / ORA-1031 in tracefile when starting the database as SYSOPER
5855896 Reconfiguration takes a long time restarting instance in active/standby RAC
5857949 Startup may fail due to dump [rfmsoexinst] from DMON

Interoperability (Between Releases)
5933477* Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database. This bug is alerted in Note 455832.1
5245451 Intermittent ORA-904 referencing remote objects columns

JDBC
4308334 OERI[12314] during XA commit/rollback/prepare while attached to different transaction
4992603 TIMESTAMP.timestampValue(Calendar) does not exist
5190543 Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5417281 oracle.sql.DATE looses a year when constructed from BC Timestamp
5468695 TIMESTAMPTZ wrong near daylight switch
5734901 JDBC Thin XMLType.getDOM fails with SQLException
5885079 Incorrect output from INTERVALDS.stringValue() for negative intervals

JavaVM / JSP / Corba etc..
4865959 Wrong results / exception from Java Stored Procedure accessing data over DBLINK
5074285 Dump [eorealize_xref] from stored Java using reflective methods
5258410 Dump [eoa_scan_mark_object] using stored Java threads
5372831 OERI:26599 / dumps in JVM after database has been closed for recovery / opened
5400158 OERI[17078] / dump running Java DDL (loadjava) concurrently
5688685 JVM timezone changes for Western Australia December 2006 (superceeded)
5862057 Oracle JVM incorrectly returns true for "x instanceof object[]" when "x" is a class
5865568 JVM timezone changes (version 4 timezone data for JVM)
5963041 Socket.shutdownOutput() closes the socket in the Oracle JVM
6065183 A dump in AccessControlContext methods in the Oracle JVM
6065728 Oracle JVM performance enhancement
6120084 Dump (eoistrnrep->strncpy) in Oracle JVM

Job Queues
4552696 DBMS_Scheduler is suppressing no_data_found exceptions in jobs
5111250 DBMS_SCHEDULER jobs fail silently with OLS / OID
5120780 Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5140631 V$SESSION.sql_address not set by DBMS_SCHEDULER
5157602 Datapump export/import modifies the chains created with dbms_scheduler
5166735 DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
5377153 DBMS_SCHEDULER call heap memory leak when changing attributes of a job
5593617 Job scheduler cannot be used on logical standby (ORA-16224)
5620375 PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
5928612 V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs

LDAP / Oracle Internet Directory
5111250 DBMS_SCHEDULER jobs fail silently with OLS / OID

Latch Contention
6455161+ Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
4691237 High "library cache" latch gets from SQL using objects in PLSQL

Leak (Memory Leak / Growth)
5108234P Win: High memory (virtual bytes) consumption per connection in 10.2
4475206 Excess PGA memory use with many hash joins
4540971 Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
4587117 ORA-384 can occur even if there is free space in some pool/s
5058318 Memory leak (in "koh-kghu" heap of type "kolccst obj")
5089522 Memory leak in niotns in MRP process
5220562 ORA-4030 (sort subheap,sort key) on insert a partitioned table with concurrent DDL
5377153 DBMS_SCHEDULER call heap memory leak when changing attributes of a job
5377973 Register schema fails with ORA-4031
5382621 OCCI memory leak in getColumnListMetaData()
5408970 Memory leak using XMLType() constructor on ADT in a loop
5464834 ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
5477912 Memory leak parsing DTD
5482555 Shared server does not release memory
5485417 Memory leak of "blockers api immd" during global hang analyze
5516917 Excessive mermory usage when running a query using nested loops
5529797 PGA leak / OERI KWQPCBK179 during Streams propogation
5548510 _FIX_CONTROL parameter leaks memory in the shared pool
5556674 V$ASM* dynamic views leak cursors (ORA-01000)
5573238 Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
5608198 Memory leak by advanced queuing XML transformation
5618049 "mvobj part des" leaked memory after partition DDL (ORA-4031)
5629416 Client memory leak after switching schema
5668025 XMLParser.Parse() can leak memory
5717536 Dequeue can suffer from a memory leak
5758963 UGA memory leak possible from AQ dequeue
5947623 Excess PGA memory used by hash joins
6011182 Parsing of large query takes long time / memory leak / ORA-4030 /4031
6043052 Leak in perm allocations with library cache comments. ora-4031 generated

Leak (Resources Eg: File Handles)
4584641 Cursor leak using DBMS_XMLGEN with a PLSQL function returning sys_refcursor
4918946 OCCI terminateEnvironment can leave threads
5141429 "skgspawn 27142" errors and defunct Oracle processes
5166745 Excessive redo generation with auditing enabled
5252389 CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
5557660 ORA-20 / process group leak from OCI Connection Pool connections
5605319 Cursor leak from QMON coordinator exceptions
5935527 Cursor leak with fix for bug 5260266
6043052 Leak in perm allocations with library cache comments. ora-4031 generated

Literal Replacement (CURSOR_SHARING)
5146740+ Wrong results with bind variables/CURSOR_SHARING
2837580 Dump if SQL has > ~35000 literals