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

Subject: 10.1.0.5 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:335869.1 Type: README
  Last Revision Date: 14-JUL-2006 Status: PUBLISHED

Bugs fixed in the 10.1.0.5 Patch Set

This note lists the bugs fixed in the 10.1.0.5 Patch Set. 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.1.0.5 Patch Set

Fixed Bug# Security Alert# Document Summary
10.1.0.5 - - Note 333953.1 Critical Patch Update (Oct 2005)

10.1.0.5 Bug Categories



10.1.0.5 Bug Fixes by Category



Symptom


Code Improvement
3493017 Enhanced diagnostics for active transaction count maintenance
3747032 Enhancement: Ensure CATALOG/CATPROC are run as SYS
3991417 Diagnostic enhancement - add KGHU checking event 10509
3995396 Diagnostic enhancement to help try to detect memory corruptions
4028979 Add support for codepoint semantics in shared-cursors
4029799 Generate alert messages for enqueue timeouts
4051321 Enhancement: Add oracle.jdbc.ReadTimeout for JDBC Thin
4067168 Poor table scan PQ performance possible for ASSM segments
4072376 Enhancement: Write diagnostics for block change callback errors
4110284 Enhanced diagnostics for send timeout problems
4116052 Diagnostic enhancement to raise an ORA-600
4122045 Enhanced diagnostic for kghfrmrg errors
4183830 Enhancement to diagnostic dump routine (add ksxpdmp)
4204014 Enhancement to help reduce library cache latch contention
4307033 Multi-column partition pruning needs leading columns

Corrupt/Bad Backup
4074603+ RMAN backup of primary with a standby using FAL may omit archivelogs
3685659 Export of DOMAIN INDEXes can write truncated CREATE INDEX information to the DMP file
3738705 Incorrect CREATE TABLE SQL written to DMP file for "not substitutable at all levels"
3861505 RMAN does not resync archivelogs produced before switchover
4015652 Nested Table export fails with ORA-1007
4125093 OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses
4226845 RMAN does not backup archivelogs on logical standby

Corruption
4401119P+ AIX: Crash possible on AIX (ORA-206)
3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
3836790 RMAN cross-platform conversion does not recognise Oracle7 format datablocks
3896377 SQL from PLSQL over HS may not seen new bind values
4046842 Table level export/import can produce corrupt TYPE metadata
4121673 DBMS_SPACE_ADMIN.assm_segment_verify does not detect certain corruptions
4275862 updateXML() may delete text elements
4355659 Data corruption in OracleXMLUtil.getStructFromXML
4466502 Spatial topology - remove edge does not work if the edge is a loop

Corruption (Corrupt Export)
3983923 Export of a partition with a nested table column exports all nested table rows
4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses
4186247 Bad export / IMP-8/IMP-9 when importing long user defined types

Corruption (Dictionary)
3936576 Dictionary corruption modifying ADT column to NOT SUBSTITUTABLE
4156858 After "open resetlogs" V$TABLESPACE includes tablespace group names
4203874 Dictionary corruption after DROP partition (can cause OERI:17059)
4212516 Incorrect view definition in DBA_VIEWS for "SELECT x.*" type views

Corruption (Incorrect / Missing Corruption Checks)
3823550 False ORA-1499 validating a table CASCADE ONLINE with a bitmap index
3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103

Corruption (Index)
3780505 OERI[6302]/corrupt index creating functional index from existing local index
4209183 Text MDATA optimize can corrupt the $I table
4246090 IOT corruption from buffered INSERT with function based index (ORA-8102)
4258825 R-TREE index may get corruptioned (may contain orphan ROWIDs)
4274669 Bitmap index may be corrupted during REBUILD
4409977 Insert into a partition with bitmap indexes can corrupt the index (ORA-1499)

Corruption (Logical)
3241932 OCI array bind to PLSQL with OCI_COMMIT_ON_SUCCESS does not process all array elements
3253462 PK enforced with non-unique index rolls back for errors on array insert with trigger
3494853 Unrelated triggers may be incorrectly dropped when dropping tables/views
3636847 Data corruption from setClob using temporary oracle.sql.clob with NCLOB column
3765119 ALTER TABLE ADD <col> with foreign key constraint does not validate existing rows
3957590 Corruption from failed distributed transaction in RAC environment
3983762 Audit followed by noaudit corrupts failure value in audit$
4019844 AQ notifications triggered for rolled back messages on single consumer queues
4044730 commit using oracle JDBC update batching may cause data loss
4099676 JDBC cannot update via OracleCachedRowSet if rows contain NULL column value/s
4112717 CTAS of an EXTERNAL TABLE from remote table with LOBS gets wrong data
4156695 Values of XML 'long' element are stored incorrectly in schema based table
4183195 Calling commit during "standard batching" incorrectly discards pending batches
4187258 Node with over 64k is truncated (should report ORA-31167) on insert
4216437 Bulk insert from OCI allows duplicate records with non-unique index PK
4243853 Clob data is corrupted after import of cross platform produced 9i export file
4246090 IOT corruption from buffered INSERT with function based index (ORA-8102)
4251633 OracleCachedRowset does not delete a row inserted without a commit
4307126 Load from view over database link does not load rows
4336787 Wrong output from Georaster load / unload world file when using scientific notation
4338390 setDouble on an inserted number value produces corrupt number
4430238 Columns are interchanged when connecting to AL32UTF8 database with JDBC

Corruption (Physical)
3440689 Block corruption possible inserting large row piece to empty block
4054640 Block corruption / OERI [kddummy_blkchk] at physical standby
4137714 Object image may become corrupt
4177800 Update on a compress table to set a column to NULL can corrupt the table

Deadlock
3987280 Concurrent GRANT / SET ROLE can hang / deadlock
4008775 Self deadlock calling DBMS_SPACE / DBMS_STATS in same user call
4029101 Concurrent CREATE TABLE can deadlock (ORA-60)
4137000 Concurrent SPLIT PARTITION can deadlock / hang
4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process
4220161 Deadlock between SMON processes on different instances
4275733 Deadlock between library cache lock and row cache lock from concurrent rename partition
4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
4329748 ORA-4020 / deadlock quiescing a replication group
4371923 SMON may deadlock on TX enqueue waits for updates to COL_USAGE$ in RAC
4382653 Deadlock / ORA-4020 gathering statistics on indices
4416907 ORA-4020 from DO_DEFERRED_REPCAT_ADMIN with concurrent SQL
4439540 Close of ScrollableResultset may deadlock at Java level
4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
4579381 Deadlock on DC_USERS in RAC (ORA-4020)

Excessive CPU Usage
4098102 High CPU consumption by AQ listen
4111602 SMON / LMD can consume 100% CPU requesting TA / US enqueue
4224765 REPLACE on a CLOB spins in kole_simple_string_match

Feature Unusable
3849766 UTL_MAIL.SEND does not work when recipients parameter 61 or more characters

Hang (Involving Shared Resource)
3187730 Various hangs possible if process expecting SIGALRM does not get it
3985182 RAC cluster hang (waits for 'undo segment extension')
4158957 Startup of a RAC instance may hang
4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE
4220161 Deadlock between SMON processes on different instances
4275733 Deadlock between library cache lock and row cache lock from concurrent rename partition
4312871 SMON deadlock in RAC cleaning non-existant objects

Hang (Process Hang)
3332578 Refresh of materialized view hangs refresh / results in OERI[kkzgajgd_of2]
3643460 OCI connection pool may hang after DB restart
3644964 Net hang nioqtsd ... ntpread
3812089 Hang during RAC recovery if several memory regions used
3838679 Starting second RAC instance can hang
3839501 OCCI TAF hangs when session failover is attempted in multithreaded mode
3966722 Concurrent RMAN backups wait on TM enqueue on CKP table
3987280 Concurrent GRANT / SET ROLE can hang / deadlock
4063582 setQueryTimeout() method does not work for resultSet.insertRow()
4087284 CRS can be slow to start up after a reboot
4100749 ASM may spin retrying a failed IO
4105639 Recompilation may hang / error with objects (ADTs) involved
4134706 Ctrl-C can cause a session to hang when executing an RPC
4137000 Concurrent SPLIT PARTITION can deadlock / hang
4177549 Hang when executing a JDBC batch with large stream bind
4201369 Database hang possible if process dies at inopportune moment
4304231 Mounting ASM diskgroup may hang in a cluster
4313246 PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
4332858 Death of the oldest CRSD can causa a cluster hang
4371923 SMON may deadlock on TX enqueue waits for updates to COL_USAGE$ in RAC
4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$
4396718 RAC session may hang for global enqueue requested NOWAIT
4402255 Hang / dump possible using database link
4446011 Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
4579381 Deadlock on DC_USERS in RAC (ORA-4020)

Hang (Process Spins)
4100479 Dump / spin when querying v$logmnr_content.
4153401 Spin possible (kkpamFList2) with long inlist on partitioning column
4168407 Dispatcher and server processes may spin with expire_time set
4203874 Dictionary corruption after DROP partition (can cause OERI:17059)
4217849 Text type optimize can miss tokens or spin
4224765 REPLACE on a CLOB spins in kole_simple_string_match
4226260 MMON spinning with no AWR snapshots taken / OERI:ktte_verify_tsth
4247779 Oracle process spins trying to dump an UNDO block
4261984 CURSOR_NAME%FOUND may cause a PLSQL spin

Install Is Not Performed Correctly
4557674PI Solaris: "genoccish" corrupts lib32/libocci.so.10.1
4051359 "relink all" fails to relink racg
4237884 XDB upgrade may dump

Instance May Crash
4401119P+ AIX: Crash possible on AIX (ORA-206)
3377476 OERI[ksmals] / instance crash after changing PGA_AGGREGATE_TARGET
3684871 Corrupt UDP packets can cause instance crash
3738117 LMS may dump followed by instance crash
3961045 SGA memory corruption from STAR transformation with UNION view
3967296 OERI[kfncfileunidentify] if ASM instance dies
4033656 Dump [kghssc_writebuf] / SGA corruption if DBURI terminated
4051326 Mass memory corruption possible if kghalp is passed a negative number
4068333 OERI[kcllrem_2] can occur crashing the instance
4117219 OERI[16467] possible in RAC
4132013 OERI[4036] / DB crash possible using SMU
4164021 OERI [2103] during BACKUP CONTROLFILE to TRACE
4173484 OERI[17131] / instance crash with NUMA using SGA_TARGET
4191731 OERI[GPGA_MISMATCH] / crash can occur on some platforms
4202347 ASM may crash with OERI:525
4204954 OERI[kjbcrtpi:piscn] / RAC instance crash
4262830 OERI:4036 / OERI:4078 / instance crash using SMU
4384672 SMON may fail with ORA-27103 during recovery of failed RAC instance

Latch Contention
3650599 "row cache objects" latch contention for dc_segments with many space operations
4204014 Enhancement to help reduce library cache latch contention
4238592 High pseudo-cursor version count

Leak (Memory Leak / Growth)
3910149 Very small SGA memory leak in RAC environments
3965969 JDBC statement caching uses lots of memory
4055603 OCCI cache usage keeps on increasing assigning Ref types
4060287 Memory leak in OCCI object column with object attribute
4093818 Memory leak using DBMS_XMLDOM.newdomdocument and DBMS_XMLDOM.freedocument
4100130 Object level statistics may leak SGA memory on errors
4147836 EXEC SQL ENABLE THREADS leaks memory in the Pro client
4176732 OCI INSERT using OCI_BATCH_ERROR_MODE leaks client memory
4188472 Memory leak using DOMAIN indexes
4194190 Client memory leak opening/closing sessions
4213922 OCIStmtExecute() memory leak/iteration in PLSQL external routine
4244083 PLSQL memory leak
4290149 OCCI getCursor leaks memory for SELECT CURSOR() statements
4303873 ORA-4030 for THEME index on large document
4319529 REPLACE calls for CLOB variables can leak temporary LOBs
4350208 PGA memory leak associated with bitmap indexes
4375655 Large in-list consumes excessive memory with zero length string in the inlist

Leak (Resources Eg: File Handles)
3065696 setSesionTimeZone leaks cursors
4007026 Accessing an external table can leak file descriptors
4319529 REPLACE calls for CLOB variables can leak temporary LOBs

Memory Corruption
3600206 Priviate memory corruption possible from UNISTR()
3630523 Memory corruption / OERI from logminer handling of CTAS operations
3684772 DBMS_XMLGEN.CONVERT can cause memory corruption
3744289 Memory corruption / dump can occur using DBMS_SQL if SQL reloaded
3844195 OERI [17112] registering XML schemas with AnyTypes
3961045 SGA memory corruption from STAR transformation with UNION view
4033656 Dump [kghssc_writebuf] / SGA corruption if DBURI terminated
4051326 Mass memory corruption possible if kghalp is passed a negative number
4061532 OERI [17182] / memory corruption from ANY_PATH predicate
4121749 ORA-21779 / dump using TABLE functions / BULK collect
4148420 Wrong results / dump with table prefetch enabled
4157342 Query with multiple unprepared nested cursors corrupts private memory
4258706 State object corruption possible (rare) with XA
4398475 Memory corruption from replicated table with self referencing FK constraints

Performance Affected (General)
4103409P HPUX: Performance degradation observed in 9206 than in 9204
3650599 "row cache objects" latch contention for dc_segments with many space operations
3653933 Streams replication to heterogeneous target can be very slow
3840866 Parallel query enqueue is not released
4185270 PMON "failed to acquire row cache enqueue" cleaning a dead process
4303205 Excessive REDO in hot backup mode
4333839 Poor performance with audit_trail=db_extended
4390868 Contention on DC_SEGMENTS due to small cache size on SYS.AUDSES$

Performance Of Certain Operations Affected
3763572 Concurrent "alter tablespace read only" may be slow
3857781 ASSM tablespace index branch split/relocate generates huge amount of undo
4055881 CREATE_SNAPSHOT_REPOBJECT can be slow
4110489 RMAN skip read only tablespace can be slow skipping tablespaces
4113930 Space reclaimation shows HW enqueue contention with concurrent insert of LOBs
4118493 System.gc is invoked from RowSet
4181122 Text index optimization slow
4241787 Concurrent ASM file access in RAC can be slow
4280096 High buffer gets for insert into lob
4288876 Excessive redo / undo generation from insert/update with ASSM indexes
4432906 PMON slow to clean locked rows from rolled back XA transaction
4446528 PMON can be slow to clear row locks for rolled back XA transaction
4486753 DMLS contention with ASSM segments

Performance Of Query/ies Affected
3339845 Performance of insert with remote SELECT can be slow in 10g
3435371 OCCI statement->setPrefetchRowCount() required for each execute
3488546 Subquery in GROUP BY HAVING clause not merged
3536027 Wrong cardinality estimation because of wrong histogram type
3628118 Index range scan chosen for LIKE '%a%' predicate with a hint
3645694 Poor plan from SQL with literal replacement and LIKE .. ESCAPE ..
3672985 No bind peeking for equality predicates can give poor plan choice
3751131 Wrong cardinality with range predicate value matching histogram endpoint value
3784687 Use of BigInteger can be slow
3802789 Update on table with CTXCAT index can be slow
3865608 Optimizer does not eliminate outer-join based on join predicate
3975758 INLIST ITERATOR not used if column part of DESC index
3986614 XA client with database links repeatedly closes the database links
4018868 Clients enabling PREFETCHING during fetch may still use scalar fetches
4047545 DBA_SEGMENTS slow for 8i migrated segments (follow on to bug 2948717)
4050226 Index skip scan may not be chosen when it is a good choice
4054222 Parallel CTAS may be slow
4067168 Poor table scan PQ performance possible for ASSM segments
4068311 Functional indexes may not be used to avoid sorts
4074953 Insert performance problems with ASSM in RAC environments
4078236 Optimizer may not push join predicates
4112254 CBO may not choose best index for single table access with unpeeked bind/function
4127058 Optimizer uses pushing even if indexes are not promoted
4130446 ROWNUM predicate may not cause FIRST_ROWS(K) optimization
4131301 Star transformation can affect dynamic pruning (subquery)
4132671 Poor plan as INLIST ITERATOR costing too low
4142674 Bad plan possible if CBO use a guess for one access path
4149653 Bad plan possible with UNION ALL subquery
4157426 A suboptimal plan can be used for queries with nested disjuncts
4196039 Inefficient plan causing poor incremental refresh for Materialized View
4198156 Index-only retrieval not chosen with IOT and function based index
4206331 CBO may make bad choices with FIRST_ROWS(k) optimization (or ROWNUM)
4215125 Poor plan for distributed query on object view or VPD policy
4216065 SQL query using ANSI outer join may get poor execution plan / wrong results
4229830 Wrong cardinality estimate comparing CHAR to VARCHAR2 literals / peeked binds
4275716 Bad selectivity for predicates using functions over binds
4294948 Cardinality estimation can be wrong first_rows(k) mode
4298625 Non SELECT SQL with INLIST may be slow
4307318 No anti-join optimization for INSERT as SELECT with NOT IN subquery over db link
4308414 Join predicate push may not occur for UNION [ALL] views
4322391 Incorrect cardinality estimate for ANTI join
4322477 Consecutive runs of Spatial query on partition table progressivly get slower
4336997 Queries against GV$SQL_PLAN slow
4405930 DBMS_STATS collects wrong statistics for composite partitioned index
4418361 _SORT_ELIMINATION_COST_RATIO is not effective

Security Or Service Denial Vulnerability
No Bug#* Critical Patch Update (Oct 2005)
This bug is alerted in Note 333953.1

Shared Pool Affected
2730704 OUT binding in "call" slower than OUT binding in "begin ... end"
3519807 ORA-4031 querying V$SEGSTAT
3910149 Very small SGA memory leak in RAC environments
4007764 Auditing can cause excess shared pool memory use
4102493 Dump (kxsDump) possible when ORA-4031 attempting to be signalled
4184298 Subpool imbalance for "session parameters" can lead to ORA-4031
4201664 EXECUTE IMMEDIATE of anonymous PLSQL may be reparsed unnecessarily
4201684 Excess shared pool usage when CURSOR_SPACE_FOR_TIME set
4204014 Enhancement to help reduce library cache latch contention
4204326 Cursors with TABLE() expressions no shared when USE_STORED_OUTLINES set
4238592 High pseudo-cursor version count
4249345 Shared cursor sizes larger than earlier releases
4359367 High version_count with cursor sharing
4458226 High version count with cursor_sharing=force

Storage Space Usage Affected
3532977 Space in source$ is not reused when objects are recreated
3794969 BFILE locator takes up maximum length rather than actual length
4052219 LOB segment may leak space when ASSM managed
4069484 ASSM segments waste space with heavy concurrent inserts
4070480 Unexpired extents used when there is free space available in the UNDO tablespace
4112580 DROP of a disk can leave unused space in a failure group
4128156 ASM with many small files has unbalanced disk use
4163265 LOB segment may waste space in RAC
4195693 LOB segment space in an ASSM tablespace is not reused effectively
4288876 Excessive redo / undo generation from insert/update with ASSM indexes

Wrong Results
4080972+ Wrong results from RBO range predicate on concatenated index with NULLs
4333548+ Wrong results from SELECT which use 10g row shipping
2762561 Incorrect daylight savings time when DBTIMEZONE set
2874433 Inline ANSI outer join view may give wrong results
3033572 Wrong results possible from hash join
3270428 Difference between bytes in DBA_SEGMENTs and DBA_EXTENTs
3281310 All policies are applied in global context
3369744 ALL_SYNONYMS view does not show synonym for a synonym
3396162 Wrong results possible after cursor rebuilt with different describe information
3407570 SCORE of an MDATA text operator is sometimes wrong
3463540 V$SGASTAT has 0 for buffer cache size if DB_BLOCK_BUFFERS specified
3466980 ORA-942 / wrong results compiling views with ansi-joins as user other than the view owner
3483988 DBMS_METADATA.GET_DDL misses REVERSE keyword for PK index
3509844 Wrong result if single-byte japanese character used in a CONTAINS clause
3600190 UNISTR does not error for invalid escape sequences in its input
3605121 Wrong results from UNISTR() in multibyte
3859482 SDO_UTIL.SIMPLIFY - geodetic geometry simplified more than threshold
3859606 Wrong results when a join predicate is pushed into a UNION view
3919931 Wrong results from query rewrite
3922154 wrong results with star transformation and DECODE in a predicate
3924711 Wrong results for CHAR-CHAR join with transitive predicates over database link
3926058 V$SYSSTAT "opened cursors current" can be incorrect
3929215 Query with inlist can produce duplicate rows
3942889 DBMS_METADATA.GET_DDL can output garbage characters in multibyte
3945188 SDO validate does not report when an interior ring is not inside anything
3956826 Wrong result order from ORDER BY with inlist and partition iterator
3960118 Wrong results from uncorrelated scalar subquery and NL OUTER join
3965060 DBA_LMT_USED_EXTENTS still shows extents for DROPPED segment in READ ONLY tablespace
3972453 NEXT / PRIOR give wrong value for PLSQL collection used as IN OUT parameter
3976165 Wrong results from star transformation with semijoin
3984506 XML extract() truncates large XML CDATA
3994270 Flashback query wrong results / dumps for upgraded 9i database
3994909 Wrong numeric data from TO_CHAR() over a gateway
4006203 PLSQL local variables may show a stale value
4006624 OERI [20084] from a CATSEARCH query that uses wildcards
4006711 GROUPING SET SQL may return fewer rows than expected
4020449 Wrong results or OERI[15160] from star transformation
4030950 Wrong results / dump (ttcfour) if rowshipping can occur
4031093 Wrong results from DISTINCT view joined to single row table
4034746 Wrong results when using hash join with parallel execution
4040934 Wrong results with query rewrite when an RLS policy is involved
4047618 UTL_MAIL may encode the addr-spec in the TO/FROM/CC/BCC header fields
4057458 SDO_GEOM.SDO_CONVEXHULL gives wrong results
4057523 Wrong results with CASE expressions in GROUP BY / HAVING clause
4072481 Date values are incorrect using 10g JDBC
4073695 NLS_SORT unicode setting causes string comparison discrepancy
4091504 Position of argument is reversed after revoke any procedure privileges
4102499 Corrupted data selecting CHAR(255) over gateway to multibyte database
4121712 SDO_INTERSECTION gives null result if linestring with circ. arcs involved
4130230 Wrong results with OR-expansion and multi-column inlist
4133884 wrong results with temporary table, parallel execution and function
4134227 Selects from V$LOGMNR_CONTENTS do not work if query cancelled
4143213 Intermittent wrong results from VPD policy not based on application context
4147186 CTX_DOC.MARKUP may produce wrong tag positions
4148420 Wrong results / dump with table prefetch enabled
4149579 Wrong result with star transformation with predicate simplification
4149779 10g Logminer does not show correct ROW_ID if log created by COMPATIBLE<10
4151388 V$ARCHIVE_DEST_STATUS does not reflect correct value for APPLIED_SEQ#
4155824 Wrong result with JDBC OCI call to PLSQL procedure with IN OUT table
4156131 SQLSTATE errorcode wrong when RELEASE_CURSOR=YES
4156916 Dump / wrong results from TO_DATE without a full date format mask
4157584 Wrong results with temp table star transformation and semi join
4165070 Wrong result possible with INDEX FULL SCAN of nullable column
4182351 Wrong length returns from UNION ALL in a PLSQL block
4197602 PLSQL TIMESTAMP(x) variables ignore precision (x)
4202009 Invalid non-sequence XML data can be inserted, but not queried
4203626 DBA_TABLESPACE_USAGE_METRICS / V$FILESPACE_USAGE may be wrong
4203993 SDO_MIGRATE.TO_CURRENT may produce an incorrect rotation on polygon that spans 180
4209183 Text MDATA optimize can corrupt the $I table
4216065 SQL query using ANSI outer join may get poor execution plan / wrong results
4217930 Wrong result returns HASH semi join
4230236 Wrong result with first_rows(k) for bitmap access path
4230880 Wrong result with parallel query and NL OUTER join
4234928 Wrong results from query rewrite with anti join
4247457 No error from select which calls PLSQL function should throw ORA-1422
4258719 SDO_RELATE can return wrong result with a point inside a polygone
4259955 Wrong results from subquery unnesting with COUNT() functions
4299008 Extra white space in extracted XHTML attribute area
4299620 Wrong results from PQ with HASH join
4306147 Wrong number of rows returned from table in hash cluster
4308710 Wrong results from temp table star transformation
4329431 DBMS_XMLPARSER ignores errors while parsing invalid XML document
4331352 Wrong results with nested tables and outer queries
4335177 ROW_SCN does not always show the correct value
4336881 Wrong results from subquery elimination with WINDOW operations
4343848 INSTRB can return wrong result on multibyte data
4345994 V$SHARED_POOL_ADVICE.ESTD_LC_TIME_SAVED_FACTOR column always 0
4360941 Column contents not displayed if HS query contains explict NULL
4375405 PLSQL may assign wrong variable value
4375458 OCCI isNull() returns false for null object returned from procedure
4383610 application info attributes are not translated correctly in utf16 environment
4390125 JDBC update count is wrong with batching
4405471 SDO_GEOM.SDO_INTERSECTION returns NULL on geometries that intersect
4455919 Wrong results on query with event 19027 set
4459467 Formatting "0" returns incorrect value if format mask does not have any decimal
4466869 ORA-14403 from bulk PLSQL operations after truncate operation
4483414 WITHIN-DISTANCE may miss rows following an uncommitted INSERT
4483951 Wrong results from MERGE JOIN with subquery predicate on right table with ROWID
4493256 Wrong result possible from complex view merging of ALL/ANY/[NOT]IN subquery

Error May Occur
4458790+ ORA-6502 selecting MAX/MIN into a CHAR variable in PLSQL
4401119P+ AIX: Crash possible on AIX (ORA-206)
2873837 ORA-3106 / dump calling a stored procedure with CLOB IN OUT parameter from client PLSQL
3324962 ORA-31083 registering valid XML schema
3368245 Setting FIXED_DATE to NONE with SPFILE causes ORA-65 on STARTUP
3384512 ORA-1 during fast refresh of ROWID based MVIEW after TRUNCATE PARTITION on base table
3413826 ORA-904 from MERGE SQL across database link
3423720 ORA-2268 / ORA-1756 connecting from JDBC with non US7ASCII Locale
3461263 False PLS-114 calling XMLElement() from PLSQL with >30 characters
3466980 ORA-942 / wrong results compiling views with ansi-joins as user other than the view owner
3478459 DBMS_ADVISOR.TUNE_MVIEW does not work with multibyte DB
3489195 Import errors for job object with isubmit and instance
3519807 ORA-4031 querying V$SEGSTAT
3547585 Using CONNECT BY over a database link to 8i can fail with ORA-1472
3554494 ALTER TABLE SPLIT PARTITION fails with ORA-604 / ORA-933
3578226 ORA-22814 when using XMLtype.toObject with empty XML elements
3738705 Incorrect CREATE TABLE SQL written to DMP file for "not substitutable at all levels"
3771352 Connections with a login timeout may fail with an IO Exception
3842518 "MMON encountered error 1426, clearing the error"
3854478 ORA-935 executing SQL with analytic functions over a database link
3876507 False ORA-932 from extractValue() in PLSQL
3929301 ORA-14642 on exchange partition
3936808 ORA-26082 from SQLLOAD of multiple partitions with DIRECT=Y
3944226 ORA-1801 if NLS_DATE_FORMAT is changed in the session
3964338 EXPDP fails with ORA-31672 for compressed tables
3965265 ORA-29902 for some Text queries with composite indexes
3981329 DBV-102 accessing file being written in O_DIRECT mode by DBWR
4011231 SDO_WITHIN_DISTANCE reports ORA-13364 for 3D data with sdo_indx_dims=2 index
4015652 Nested Table export fails with ORA-1007
4016802 Incorrect export produced for transport of composite partitioned table
4031272 ORA-6502 using collection tables in PLSQL
4032320 Insert of valid XML document fails with ORA-30930 error
4032583 ORA-1733 from SQL with a subquery on a partitioning column
4036330 RMAN-6091 from RMAN delete / change commands
4038854 ORA-322,ORA-312 when using a multiple standby log members
4053129 EXPDP fails with ORA-39125 ORA-6502 on large list of table names
4063081 JDBC through HS returns ORA-3001 with inserting data over 1000 bytes long
4064362 ORA-12408 "unsupported operation" from MTI with no RLS policy on target table
4071549 ORA-911 from EXPLAIN PLAN with query rewrite enabled
4075120 DDL referencing non-existent TEMP table not skipped by SQL Apply
4078970 ORA-907 using nested FULL OUTER JOIN in PLSQL
4083461 UTL_SMTP.OPEN_CONNECTION in shared server fails with ORA-29278
4084017 ORA-3001 when using DBMS_SQLTUNE
4092060 DRG-50857 / ORA-29902 from complex Text query
4094108 RMAN backup tries to normalize a backup file handle (ORA-4101)
4111420 ORA-12850 on GV$ queries in RAC
4112035 ORA-972 on XmlType view if identifier greater than 30 characters long
4121749 ORA-21779 / dump using TABLE functions / BULK collect
4126826 ORA-1031 may occur intermittently
4127518 ORA-928 / ORA-2063 or dump (qkswcInlineQBC) when SET expression over a database link
4130852 ORA-6502 using DBMS_SQL with a RETURNING INTO clause
4134033 ORA-904 from DBMS_STATS.GATHER_TABLE_STATS
4134141 ORA-1801 during data pump export of database upgraded from pre-10g
4140264 ORA-3117 can occur during replication push for NULL BLOB columns
4145130 False ORA-4091 error (mutating error)
4146890 ORA-31000 using XMLAttributes() for namespace information for SQL/XML functions
4147322 File creation may fail with ORA-19504 ORA-27056 (RMAN)
4153256 SQLException PLS-418 binding IN OUT PLSQL TABLE from JDBC
4153846 OERI:OERI:kmgs_getgran_from_comp_1 / ORA-822
4171194 PRKO-2120 if Service same as Database name
4173513 CTX_DDL.SYNC_INDEX error ORA-24801
4174463 ProCobol - COPY in a PROCEDURE division causes PCB-S-00400
4182918 ORA-1591 while inserting on a table having unique index
4183086 SMON not freeing expired extents to undo tablespace
4186247 Bad export / IMP-8/IMP-9 when importing long user defined types
4195175 Create MVIEW with large WHERE clause may dump / ORA-4031
4200702 Block change tracking may report ORA-19694 when using direct load
4203324 ORA-1031 or ORA-942 from direct path loaded
4212516 Incorrect view definition in DBA_VIEWS for "SELECT x.*" type views
4216194 DBMS_XMLPARSER.getdoctype()/setDocType not implemented
4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode
4217184 ORA-24027 from AQ HTTP propogation with multibyte payload
4219175 Create outline with bind variable causes ORA-1790
4221789 ORA-14642 during EXCHANGE PARTITION after DROP/ADD column
4225325 UTLRP fails with ORA-27477 if previous run aborted
4239221 ORA-19634 filename required for this function during restore validate
4242804 EXPDP fails with ORA-1426,ORA-31693, ORA-2354 for > 256 partitions
4242878 DRG-50857 / ORA-6502 from CTX_REPORT.CREATE_INDEX_SCRIPT
4257473 ORA-920 can occur for SQL over a database link
4262254 NZE-28860 / NZE-28862 connecting to Apache in SSL
4278912 ORA-24852 if cursor selecting BLOB is rebuilt
4291110 Continuous AQ errors in ALERT log after upgrade to 10.1.0.4 (ORA-25228)
4292233 ORA-928 can occur from star transformation with SET operation
4304759 ORA-14297 can occur on ALTER TABLE EXCHANGE [sub]partition
4329748 ORA-4020 / deadlock quiescing a replication group
4333601 ORA-904 during MVIEW fast refresh
4345270 ORA-1733 with partition pruning and index join
4350995 ORA-17503 / ORA-15001 / ORA-15055 with ASM
4369235 ANSI joins may fail with ORA-1445
4376276 ORA-16401 can occur on standby
4386766 IMPDP with compressed indexes fails with ORA-14071 and ORA-39083
4387452 ORA-22922 trying to DEREF an object view
4388999 Multithreaded JDBC gets NetException accessing LONG RAW
4389376 ORA-30004 using SYS_CONNECT_BY_PATH
4414296 csscan reports ORA-1455
4430427 ORA-604 / ORA-903 from SQL against partitioned table with subquery partition pruning
4434249 ORA-2051 at non-native XAresource.end() when other branch is prepared
4486020 ORA-932 using SYSDATE in a TO_CHAR
4498443 ORA-979 from SQL with HAVING
4733787 ORA-328 during standby recovery - thread number in checkpoint is wrong

Internal Error May Occur (ORA-600)
4601462P Win: OERI:OSDEP_INTERNAL can occur on startup at sssxcpttcs1
2972961 OERI[ktcdso-1] during refresh on commit of materialized view
3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
3231200 OERI[kokqaguco1] possible using OBJECTS
3279497 Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
3328558 OERI[729] ... [space leak] can occur if EXPDP aborted
3332578 Refresh of materialized view hangs refresh / results in OERI[kkzgajgd_of2]
3344331 OERI[504] can occur using INSTR on a LOB column
3390566 OERI / dump from functional indexes on TIMESTAMP columns
3466980 ORA-942 / wrong results compiling views with ansi-joins as user other than the view owner
3469992 Flashback versions query can fail with OERI[15201]
3474387 OERI[504]...[osm map operation hash table] when shutdown an ASM instance
3502260 OERI[12813] from concurrent insert direct load and ONLINE create index
3630523 Memory corruption / OERI from logminer handling of CTAS operations
3635474 OERI [12442] while doing select with a CAST() operation
3641059 OERI[qkaInitGrpFns.3] generating explain-plan with star transformation
3655948 OERI:kcbgcur_9 during disconnect with distributed transaction
3668164 OERI[12333] / ORA-1461 when reloading cursor with long datatype bind
3669229 OERI[kkqsrre:4] from group_id() in query rewrite
3684772 DBMS_XMLGEN.CONVERT can cause memory corruption
3684871 Corrupt UDP packets can cause instance crash
3711772 OERI 15440 from PLSQL RPC which raises an unhandled exception
3730166 OERI [qctcte1] / [kghssgcop2] from ANSI outer joins with binds
3738117 LMS may dump followed by instance crash
3780505 OERI[6302]/corrupt index creating functional index from existing local index
3788530 OERI[kohdtf048] with sqlldr direct load with a PLSQL function
3844195 OERI [17112] registering XML schemas with AnyTypes
3854134 OERI:KGHALP1 with JDBC clients accessing HS datasource
3859606 Wrong results when a join predicate is pushed into a UNION view
3865814 OERI:kghalo2 from INSERT APPEND to composite partitioned table
3870045 ORA-31020 or dump when using XMLTransform
3883059 ORA-822 / OERI errors when changing SGA size
3893571 OERI[kope2_readstr232] during multibyte character conversion
3897915 Dump (koklmifrdht) manipulating LOBS with supplemental logging
3902513 OERI[KSSADP2] using ASM from shared server/s
3915343 OERI [25012] on COMMIT with refresh ON-COMMIT Materialized view over cluster
3917001 OERI:qkaPIdsqkn1 from PQ of partitioned table
3917476 OERI[2652] in LMS process
3930499 AQ propagation of XMLType throws OERI[kolahashfind:hash table]
3931536 ORA-600 [kjmupdqseq_1] can occur in RAC
3939241 OERI[opiexe0] can occur in RAC
3963135 OERI[kcbgcur_3] / OERI:25027 during bitmap index updates
3967296 OERI[kfncfileunidentify] if ASM instance dies
3986388 OERI:qcsalcd1 using ANSI join/s with pipelined function/s
4006624 OERI [20084] from a CATSEARCH query that uses wildcards
4008200 OERI[15001] running a query which uses DBMS_SESSION.IS_ROLE_ENABLED
4011643 OERI [kkojocol:2] can occur
4014485 OERI:KSMASG1 when attempting to signal ORA-4031 for the Java pool
4014898 OERI:15554 for parallel UNION ALL query
4020195 OERI 25027 can occur in RAC accessing transported tablespace
4020449 Wrong results or OERI[15160] from star transformation
4028276 OERI[kfgbdriver02] during ASM diskgroup operation
4030913 OERI[1418] possible from DIAG
4033656 Dump [kghssc_writebuf] / SGA corruption if DBURI terminated
4037599 OERI:12262 from SQL with may nested CURSORs
4044738 OERI:qkaPIdsqkn1 adding referential constraint to partitioned table
4054640 Block corruption / OERI [kddummy_blkchk] at physical standby
4056886 OERI[1872] using dbms_file_transfer.get_file on > 4096m files
4058160 OERI[KGHALO2] accessing earlier version Gateway
4058532 OERI[17183] from kjxgfhc in RAC
4060356 OERI[kccdebug_check_1] trying to start capture process after upgrade
4061532 OERI [17182] / memory corruption from ANY_PATH predicate
4068333 OERI[kcllrem_2] can occur crashing the instance
4075231 OERI[kssrmp2] / startup fails
4081624 OERI[qksmmadjuststatistics1] possible on SQL against partitioned objects
4108213 OCCI dumps creating a Ref for an object type on an object view
4112324 OERI[16608] possible from some queries with pushed join predicates
4117219 OERI[16467] possible in RAC
4131788 OERI[ksfdchkfob1] reported by LGWR after access to log removed
4132013 OERI[4036] / DB crash possible using SMU
4134776 OERI:kfkOsmRqError02 after IO error using ASMLIB
4140603 OERI[kjpcre2] can occur in RAC
4142453 OERI[12426] from CONNECT BY query
4153846 OERI:OERI:kmgs_getgran_from_comp_1 / ORA-822
4163908 OERI[kews_call_init - call] during instance startup
4166405 SQL apply may stop with OERI:[krvxgirp]
4172065 OERI[kjbmperr:1] possible in LMS in RAC environments
4173484 OERI[17131] / instance crash with NUMA using SGA_TARGET
4178290 OERI[kghstack_underflow_internal_3]/OERI:711 on UPDATE with UNIQUE constraints
4182639 OERI[qctfrc : csform] from SELECT with correlated subquery
4191731 OERI[GPGA_MISMATCH] / crash can occur on some platforms
4192534 AQ propagation fails with OERI[kwqpsddv:inv dst]
4197704 OERI:7005 from queries involving partitions and TIMESTAMPs
4202347 ASM may crash with OERI:525
4203874 Dictionary corruption after DROP partition (can cause OERI:17059)
4204954 OERI[kjbcrtpi:piscn] / RAC instance crash
4206413 OERI[kdourp_inorder] during update statement
4214213 OERI[2130] can occur when recovering a standby database
4215207 Process may fail with OERI[kcrfro_rnenq_2] in RAC
4216266 OERI[12333] from INSERT .. RETURNING from 8.0 client
4226260 MMON spinning with no AWR snapshots taken / OERI:ktte_verify_tsth
4235842 OERI[krvxbpns] using Logminer on multiple archives from different threads
4240596 DBMS_SQLTUNE can fail with OERI:kestsagetoptesthint-1
4243359 OERI[qolsth:1] from DBMS_SQLTUNE
4252999 OERI:12333 from JDBC MERGE SQL with a batch size > 1
4254770 OERI:kzaSqlBindLob1 can occur with AUDIT_TRAIL = DB_EXTENDED for sql using binds
4258706 State object corruption possible (rare) with XA
4259963 OERI/dump during query rewrite
4260205 OERI:voprvl1 in query having an outer join and WITH
4262830 OERI:4036 / OERI:4078 / instance crash using SMU
4275993 OERI[kopp2upic#329] / OERI[kopp2pic661] using collections in RPC over a dblink
4305391 OERI[25012] with kditalp can occur during a temporary LOB operation
4308123 OERI[18117] on PREPARE if branch has updated remote site
4308839 OERI:qkaffsindex3 from index FFS with ORDER BY
4345035 OERI:3619 on startup with transported read only tablespace
4346773 OERI[qerNSrowp] from parallel query with MINUS and GROUP BY/DISTINCT
4357181 OERI[6002] from transported IOT created with COMPATIBLE < 10.0
4358322 OERI [15448] in a query using ctxsys.CONTAINS
4359111 OERI [17281] can occur on session switch in UPI mode
4359849 OERI[16608] executing a query while using VPD
4362281 OERI[expcmo_strdef1] can occur with CONNECT BY queries
4377352 OERI [ksfdrfms2] during instance recovery of second thread
4384780 OERI[qkaOrderByPD 3] from parallel distinct outer join with ROWNUM
4387399 OERI[17018] signalled by logon trigger
4398475 Memory corruption from replicated table with self referencing FK constraints
4401000 OERI[16608] during import of transportable tablespace
4401437 CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4
4413010 OERI[kffdmove01] selecting from V$ASM_ALIAS in ASM instance
4439465 OERI [kdtdelrow-2] / ORA-604 from BULK inserts
4442372 OERI [ktspshsp-1] after aborted TRUNCATE
4456478 OERI:[qerrmObnd] from remote mapped queries
4457034 OERI:qkaffsindex3 can occur from CONNECT BY on IOT
4478323 OERI[kfcDeadlockAvoid01] on SQL against V$ASM_ALIAS

Process May Dump (ORA-7445) / Abend / Abort
2487943 Bulk insert in PLSQL may dump (kprcdt / memcpy)
2692323 Dispatcher may dump in/under ntexppst when under load
2873837 ORA-3106 / dump calling a stored procedure with CLOB IN OUT parameter from client PLSQL
2901149 Dump (opiomc) in killed / idle time sniped session
3004824 Dump possible from ANSI joins with many columns
3182188 Dump [qximgaop] from SQL using Text index
3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
3249318 A query using UNION ALL with multiple mergable views may dump in evaopn2
3390566 OERI / dump from functional indexes on TIMESTAMP columns
3417936 Client may dump / error (kpuhhfre)
3427809 Dump (inserr) on insert into sorted hash cluster
3441620 Dump updating characeterset for schema based XML
3563379 Dump (qmxInsertNodeBefore) using DBMS_XDB.DELETERESOURCE
3614276 Dump (xplGenXpl) from SQL with inline cursor statement over a database link
3626425 Export of schema based XMLType may dump
3636930 Dump (under pdy8M50_Fill_Agent_Extension) using AGENT IN without default agent
3644634 PLSQL cursor using LOBs or collections may dump
3659827 Dump (kkoeqv) when LATERAL view optimized
3686843 Client side dump calling PLSQL with CURSOR OUT parameter on OracleOCIConnectionPool connection
3720352 Select INTO returning more than one row dumps rather than giving ORA-1422
3732413 Multi table insert dumps (kkogbro)
3738117 LMS may dump followed by instance crash
3799696 Dump under kxibDoFinish on some platforms
3826329 Direct path load dumps in klaprs loading object table with SQL strings
3839540 Dump (drepadd) from Text index create/sync
3845698 Dump (kkxmgifa) possible with user defined function in complex SQL
3855374 Dump (qcpircx) parsing SQL which uses WINDOW operations
3859028 Dump when bringing rollback segment online
3869959 Dump (evaopn2) if SQL has an XMLType column as a correlated variable of a subquery
3897915 Dump (koklmifrdht) manipulating LOBS with supplemental logging
3901424 Dump [kghxfrcnt] possible
3917907 Dump accessing collections/pipelined function in a Parallel query
3924916 Dump (SIGFPE in ktfbfgini) during recovery
3936576 Dictionary corruption modifying ADT column to NOT SUBSTITUTABLE
3940774 Shared server may dump (in opiexe)
3943654 Export can dump exporting DDL for hash partitioned index
3949188 Dump (kopxccc) when calling a procedure over database link
3954056 Dump possible accessing remote site in NESTED LOOPS query
3965246 RMAN-10038 / Dump (kcckal) during RMAN backup
3974164 Dump in PLSQL during compilation if reference function has errors
3980673 Literal replacement may dump (kkslpbp) if user binds have names like SYS_B_xx
3986614 XA client with database links repeatedly closes the database links
3994270 Flashback query wrong results / dumps for upgraded 9i database
4030950 Wrong results / dump (ttcfour) if rowshipping can occur
4036921 Dump (knipbains) can occur during bluk update of replicated table
4044798 Dump (kkdcgkc) from DML dereferencing scoped REFs
4057523 Wrong results with CASE expressions in GROUP BY / HAVING clause
4073796 OCI client may dump under OCISessionGet when a network error occurs
4074710 Dump (ddfnet7restore) getting SYNONYM details from 8i DB link
4077470 SIGFPE in kdglfi using segment advisor on compressed table
4092592 Dump (ktspfupdst) with shared servers
4096288 Dump (nsoexc) parsing ANSI outer join with functional indexes
4098853 Dump (qerixGetKey->evaopn2) using COUNT(NOT_NULL_COLUMN) with a view
4100412 Dump (in kwqbcresetcorr) during capture from non-owner instance
4100479 Dump / spin when querying v$logmnr_content.
4102426 Dump (in upidpr) during socket write errors
4116787 Dump (def_ub2) can occur on 64bit platforms executing PLSQL
4116981 Import may dump when importing triggers
4119264 Dump kgldmp during a SYSTEMSTATE dump
4121749 ORA-21779 / dump using TABLE functions / BULK collect
4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition
4127518 ORA-928 / ORA-2063 or dump (qkswcInlineQBC) when SET expression over a database link
4129905 Dump (appopd) from pushed join predicate
4132901 Dump selecting from schema based table
4139540 Dump (atbupg) during upgrade to 10g
4156916 Dump / wrong results from TO_DATE without a full date format mask
4161498 SDO.COMPARE may dump
4165093 Dump (in kkocpr) for SQL over database link
4178560 Complex view merge of DISTINCT view may dump
4182639 OERI[qctfrc : csform] from SELECT with correlated subquery
4190024 JavaVM may dump in joe_activate_stack()
4197078 Dump (in qerilcil) with correlated variable in multi-column inlist
4197943 Dump (kpodpls) can occur using direct path load
4205102 JVM may dump in joni_set_static_object_field using javax.Image.ImageIO.write()
4212516 Incorrect view definition in DBA_VIEWS for "SELECT x.*" type views
4216666 Dump (kkownfog) optimizing query with window functions with cost based transformation
4230939 Dump (kkoajt) from anti/semi join with view merge
4237009 Dump (kkooqb) with star transformation
4245958 Dump (pirg2bi) with zero length raw input to UTL_RAW.cast_to_binary_integer
4248629 Star transformation may dump (in kkojnp)
4252920 Dump (koksiptt) inserting to object table
4259963 OERI/dump during query rewrite
4261258 Dump (kkoijg) parsing a query
4274133 Dump (OCIKNSECA) selecting a REMOTE sequence
4277281 OCSSD / CSSD / EVMD dump due to memory corruptions
4282228 Dump executing complex view merged query with subquery and DISTINCT
4284362<