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

Subject: 9.2.0.7 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:308894.1 Type: README
  Last Revision Date: 21-JUL-2006 Status: PUBLISHED

Bugs fixed in the 9.2.0.7 Patch Set

This note lists the bugs fixed in the 9.2.0.7 Patch Set over and above those fixed in 9.2.0.6. The 9.2.0.7 Patch Set itself is cumulative and includes all fixes in 9.2.0.2 , 9.2.0.3 , 9.2.0.4, 9.2.0.5 and 9.2.0.6 in addition to the fixes listed in this document. 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 9.2.0.7 Patch Set

Fixed Bug# Security Alert# Document Summary
9.2.0.7 - - Note 301040.1 Critical Patch Update (Apr 2005)
9.2.0.7 - - Note 311034.1 Critical Patch Update (Jul 2005)

9.2.0.7 Bug Categories



9.2.0.7 Bug Fixes by Category



Symptom


Code Improvement
2720661 CBO enhancement to break tie based on NDK when cost is same
3264021 New DBMS_LDAP interface needed for large binary attributes
3493017 Enhanced diagnostics for active transaction count maintenance
3697152 Diagnostic to dump memory when a bad KGHU magic number is seen
3747032 Enhancement: Ensure CATALOG/CATPROC are run as SYS
3881099 ORA-1280 diagnostic enhancement
3903913 Streams spill data hard to decode
3906687 Diagnostic enhancement for latch wait scenarios
3991417 Diagnostic enhancement - add KGHU checking event 10509
4028979 Add support for codepoint semantics in shared-cursors
4072376 Enhancement: Write diagnostics for block change callback errors
4110284 Enhanced diagnostics for send timeout problems
4122045 Enhanced diagnostic for kghfrmrg errors
4131045 Add DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY

Corrupt/Bad Backup
4074603+ RMAN backup of primary with a standby using FAL may omit archivelogs
3575797 XMLSchemas and types are not exported in table and tablespace mode export
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"
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up
3861505 RMAN does not resync archivelogs produced before switchover
4015652 Nested Table export fails with ORA-1007
4047608 Export/import can loose the LOGGING attribute of LOB columns
4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses

Corruption
3022968 Serializable transaction is not properly isolated
3879787 OERI [kcoapl_blkchk] during multi-block undo for CR
3966709 Range/object reuse prematurely (ORA-8103)
4121673 DBMS_SPACE_ADMIN.assm_segment_verify does not detect certain corruptions
4131045 Add DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY

Corruption (Corrupt Export)
4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses

Corruption (Dictionary)
2597763 SPLIT of a COMPOSITE PARTITION can corrupt the dictionary (duplicate DATAOBJ#)
3172957 OERI[ktadrprc-1] / ORA-955 during DDL
4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation

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)
4030374 Parallel DML into partitioned table may produce index corruption

Corruption (Logical)
2670601 MERGE does not work correctly for HASH clusters (wrong result)
3419707 Varying width CLOB data padded with blanks over database link
3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data
3682068 MV log changes not recorded with complex statement
3720988 Wrong values after OCCI setNull of number varray / vector values
3743437 Corrupt packed decimal data loaded by SQLLDR conventional path
3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
3798351 Importing a pre-existing table may DROP the table on an error
3823608 Conventional path load may load incorrect scale/precision for numbers
3824149 Missing data possible from Insert as SELECT over database link
3880405 DBMS_XMLDOM.setnodevalue does not change the nodes value
3908083 SQLPLUS COPY truncates long data with gateway connections
3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
3957590 Corruption from failed distributed transaction in RAC environment
3960844 Switch to logical standby may not see active PLSQL changes (data missing)
4019844 AQ notifications triggered for rolled back messages on single consumer queues
4156695 Values of XML 'long' element are stored incorrectly in schema based table
4157832 SQLLDR direct path SQL expressions can load NULLs into NOT NULL columns
4159827 PLSQL concatenation (||) involving a CASE statement may be corrupted
4187593 NULL data is not inserted correctly using a PLSQL table via JDBC

Corruption (Physical)
3440689 Block corruption possible inserting large row piece to empty block
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3779310 OERI[kcoapl_blkchk] / block corruption on update of IOT
3785333 DROP COLUMN may drop wrong columns in an IOT with OVERFLOW
3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
3859298 Block corruption with high INITRANS or rapid ITL growth.
4000840 Update can cause block corruption

Deadlock
2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL
3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table
3314850 DROP SUMMARY can deadlock with query rewrite sessions
3641819 Undetected deadlock possible in RAC
3777178 TA / US enqueue deadlock during transaction recovery in RAC
3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously
3992847 Deadlocks are not detected in rac when one node rebooted more recently than the rest
4220161 Deadlock between SMON processes on different instances

Excessive CPU Usage
2785957 Streams CPU overhead for LCRs with non-final ADTs and collections
3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
3898338 High parse time with USE_CONCAT and inlists
4088212 DBMS_OBFUSCATION_TOOLKIT.DES3GetKey performance problem
4098102 High CPU consumption by AQ listen
4114759 Poor performance with DBMS_OBFUSCATION_TOOLKIT.des3getkey (part 2)

Hang (Involving Shared Resource)
2530125 Hang possible with "enqueue hash chains" latch held during deadlock detection
3187730 Various hangs possible if process expecting SIGALRM does not get it
3397983 Sessions may hang waiting for TT enqueue
3778541 Queries against V$SQL_PLAN may spin holding "library cache latch"
3801483 Instance hang possible in RAC
3835429 OERI[kqrfrpo] / DB hang after killing a user process
3870235 Hang waiting for "enqueues" latch when using Resource Manager
3929984 'session idle bit' latch may be held by non-existant process
3930063 'name-service namespace bucket' latch may be held by no-one
3936150 'name-service request queue' latch may be held by non-existant process
3946832 Latch may be held by non-existant process
3952276 Corrupt latch state / database hang after ORADEBUG command
3992847 Deadlocks are not detected in rac when one node rebooted more recently than the rest
4220161 Deadlock between SMON processes on different instances
4241125 Sessions may block on "transaction branch allocation" latch

Hang (Process Hang)
2818054 LDAP C client may hang in ldap_result() after a modifying an entry
2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL
3046975 LDAP connect/bind slow and can hang when executed in multiple threads
3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table
3796939 Hang on rebind/reexecute of SQL with more than on LOB column over 4K long
3833893 SMON may hold the TT enqueue preventing alter of TEMPORARY TABLESPACE
3843318 OERI[ksxpwait10] / hang possible in RAC
3852108 Concurrent truncates on global temporary table cause library cache lock waits
3928153 "alter database [stop | abort] logical standby apply" hangs
3941059 JDBC OCI connections hang if NAMES.NO_PERSISTENT_RESOURCES enabled
3966722 Concurrent RMAN backups wait on TM enqueue on CKP table
3969563 Hang possible waiting for 'ges inquiry response'
4028364 EMN0 may hang holding library cache pin if notification recipient does not respond
4063582 setQueryTimeout() method does not work for resultSet.insertRow()
4065905 Oracle shadow can hang if interrupted
4134706 Ctrl-C can cause a session to hang when executing an RPC
4201369 Database hang possible if process dies at inopportune moment
4315020 Shutdown hangs with PMON waiting for process allocation latch

Hang (Process Spins)
3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
3778541 Queries against V$SQL_PLAN may spin holding "library cache latch"
3796771 Server spin in multibyte from DESCRIBE operation
3898338 High parse time with USE_CONCAT and inlists
4022708 Spin under OCIMultiByteStecmp with nls_sort=generic_m
4100479 Dump / spin when querying v$logmnr_content.
4168407 Dispatcher and server processes may spin with expire_time set

Install Is Not Performed Correctly
4063079PI Linux: Installing 9.2.0.6 Patch Set installs old "oracm" version
3936668 Ultrasearch validation procedure schema incorrect
4192421 OPATCH can hang applying some LDAP patches

Instance May Crash
4059639* ORA-7445 SKGXPDMPCTX Instance Crash with 9.2.0.5 or 9.2.0.6 Patchset
This bug is alerted in Note 297306.1
3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
2620058 Async write error may be ignored then crash the instance at the next checkpoint
3223344 OERI[kclswrite_3] possible in RAC environment with multiple DBW processes
3377476 OERI[ksmals] / instance crash after changing PGA_AGGREGATE_TARGET
3664248 OERI[kclfusfake_3] / instance crash possible in RAC
3671867 OERI[kclchkinteg_2] possible in RAC environment
3684871 Corrupt UDP packets can cause instance crash
3703478 OERI[kclchkinteg_1] possible in RAC
3799470 RAC LMD crashes instance with dump in kjddgmak
3906669 LMS may fail with OERI[kjbmpclo:cvt]
3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
3940412 PMON dump (kgllccl) cleaning up a killed process
3948384 ORA-4031 possible using LGWR ASYNC for archiving
3961045 SGA memory corruption from STAR transformation with UNION view
3966982 Dump [kcbbscan] followed by instance crash
3996802 "alter system kill session" can crash the instance if IO slaves used
3998408 RAC instance may crash with OERI:kcsbcscn13
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
4132013 OERI[4036] / DB crash possible using SMU
4204954 OERI[kjbcrtpi:piscn] / RAC instance crash
4262830 OERI:4036 / OERI:4078 / instance crash using SMU
4332141 Instance may crash with Dataguard when too few ARCH configured

Latch Contention
3650599 "row cache objects" latch contention for dc_segments with many space operations
3778541 Queries against V$SQL_PLAN may spin holding "library cache latch"
3885860 Latch contention form concurrent reconfiguration and SYSTEMSTATE dump
3929984 'session idle bit' latch may be held by non-existant process
3930063 'name-service namespace bucket' latch may be held by no-one
3936150 'name-service request queue' latch may be held by non-existant process
3946832 Latch may be held by non-existant process
4063046 Latch contention due to leaked CR pins for LOB data
4241125 Sessions may block on "transaction branch allocation" latch

Leak (Memory Leak / Growth)
2421661 Small memory leak per execution of ROW TRIGGER
2886098 Listener and oracle private memory grows on each SSL connect/disconnect
2887209 UGA memory leak / OERI:729 with failed shared database link connection
3218825 Memory leak when Java Stored Procedure executed from PLSQL
3583686 Memory allocation error during spatial query with local partitioned index
3679149 OCISessionRelease not releasing memory for invalid connections
3701730 Memory leak executing PLSQL or Java calls repeatedly in a single user call
3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
3808670 Private memory leak from INSERT INTO over Database link
3836164 ORA-4030 / high memory use from SQL with many views/branches
3853332 OCCI client memory leak using statement::setString()
3854034 OERI[733] optimizing SQL using bitmap indexes
3857050 LMON leaks memory when another instance leaves or join the cluster
3898338 High parse time with USE_CONCAT and inlists
3908058 Memory leak when using protocol.ora validnode_checking
3910149 Very small SGA memory leak in RAC environments
3948384 ORA-4031 possible using LGWR ASYNC for archiving
3964817 Memory leak in external procedure for OBJECT arguments
3965969 JDBC statement caching uses lots of memory
4093818 Memory leak using DBMS_XMLDOM.newdomdocument and DBMS_XMLDOM.freedocument
4147836 EXEC SQL ENABLE THREADS leaks memory in the Pro client
4168725 High pga consumption by 'alloc environm' chunks
4285294 Memory leak in AQ messaging

Leak (Resources Eg: File Handles)
3647829 Cursor is not always closed when database link closed (ORA-1000)
3679149 OCISessionRelease not releasing memory for invalid connections
3940410 Cursor leak (ORA-1000) from DML if concurrent session is creating a Text index ONLINE
4007026 Accessing an external table can leak file descriptors

Memory Corruption
2712376 DIAG process suffers PGA memory corruption / OERI[17182]
3277361 Memory corruption possible from certain DDLs
3600206 Priviate memory corruption possible from UNISTR()
3868423 Memory corruption when extending internal qkk key structure
3879787 OERI [kcoapl_blkchk] during multi-block undo for CR
3949307 SGA memory corruption / OERI:KGHALO4 with high concurrency
3961045 SGA memory corruption from STAR transformation with UNION view
3964487 Java stored procedure can corrupt memory in MTS
3990826 Library cache recovery structures are not cleaned up properly (SGA corruption)
4033656 Dump [kghssc_writebuf] / SGA corruption if DBURI terminated
4051326 Mass memory corruption possible if kghalp is passed a negative number
4258706 State object corruption possible (rare) with XA

Performance Affected (General)
3894096+ Poor MView refresh performance in ASSM tablespaces
1985605 GRANT operations can be very slow (compared to Oracle7)
3650599 "row cache objects" latch contention for dc_segments with many space operations
3857903 LMS not posted by LGWR when hot current block requires a log flush during BAST
3893567 Concurrent SYSTEMSTATE dumps can impact performance
3948711 XA with database links may dump or perform slowly (link closed)
4104368 Arch processes not scheduled properly

Performance Of Certain Operations Affected
4055881 CREATE_SNAPSHOT_REPOBJECT can be slow
4369117 OCI direct path out-of-line LOB insert slow

Performance Of Query/ies Affected
2484583 FIRST_ROWS(K) not applied to view query block
2492766 Predicates in OR chains not evaluated as part of index scan
2535150 Executing stored procedure using "CALL" does not use parallelism
2684114 CBO does not consider ROWNUM predicate for optimal access path
3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize
3241979 Multiblock reads do not occur when using ODM
3285454 Temp table transformation may produce unused TEMP tables
3359905 CONNECT BY much slower in 9.2 than 8.1
3436577 View merge does not occur for CTAS when it does for the SELECT
3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats
3498977 Poor performance handling VARRAY / ADTs from JDBC
3533996 Using transportable tablespaces disables intra-partition PDML
3537749 HW enqueue contention when loading lob data
3537765 SET queries with DISTINCT in query branch may have poor performance
3566843 Optimizer may not choose best index
3624684 Remote subquery not unnested when expected
3649372 No partition pruning using SYSDATE predicate against partition keys
3653586 DBMS_METADATA.GET_DDL performance very slow
3663924 Bad cardinality for out-of-range range predicates
3672985 No bind peeking for equality predicates can give poor plan choice
3695092 Optimize of a text index may be slow
3737955 Long parse times for long inlists / many AND/OR terms
3751131 Wrong cardinality with range predicate value matching histogram endpoint value
3777256 Functional indexes on CASE expressions may not be used
3823191 Unnecessary sort when access made through a local index
3830853 DELETE during REFRESH of MJV can have poor execution plan
3834770 CBO may not unnest an EXISTS() subquery with a view in the FROM clause
3859342 Sort is not parallelised in a view query with MINUS (or INTERSECT)
3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
3889123 DB_FILE_MULTIBLOCK_READ_COUNT higher than 16 blocks has no effect in RAC
3896254 CBO used with default statistics used when DB2STATS = FALSE
3898338 High parse time with USE_CONCAT and inlists
3906520 NULLs cause poor index range scan performance
3913909 SELECT .. AS OF SCN with nested loops to an index scan can be very slow
3921999 User-defined function is called more than needed for nested loop join with index access
3929805 Slow execution for insert as Select over DB Link with NULL in select list
3940803 Functional indexes not always considered NULL safe
3950045 Wrong cardinality (CDN) with functional indexes
3953483 Complex view merging does not occur for Insert as Select
3960423 AQ enqueue to large number of queues can be slow
3986614 XA client with database links repeatedly closes the database links
3996053 Inefficient dynamic partition pruning SQL
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
4068311 Functional indexes may not be used to avoid sorts
4074953 Insert performance problems with ASSM in RAC environments
4112254 CBO may not choose best index for single table access with unpeeked bind/function
4131301 Star transformation can affect dynamic pruning (subquery)
4137433 Logminer queries against logmnr_log$ may be slow
4157426 A suboptimal plan can be used for queries with nested disjuncts
4229830 Wrong cardinality estimate comparing CHAR to VARCHAR2 literals / peeked binds

Security Or Service Denial Vulnerability
No Bug#* Critical Patch Update (Jul 2005)
This bug is alerted in Note 311034.1
No Bug#* Critical Patch Update (Apr 2005)
This bug is alerted in Note 301040.1

Shared Pool Affected
4157713* OERI[KGHPIH:DS] can occur when shared pool under load
This bug is alerted in Note 310939.1
3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
3869563 Cursors not shared for certain SQL with SQL_TRACE enabled and fix for bug 2228280
3910149 Very small SGA memory leak in RAC environments
4102493 Dump (kxsDump) possible when ORA-4031 attempting to be signalled
4204326 Cursors with TABLE() expressions no shared when USE_STORED_OUTLINES set

Storage Space Usage Affected
3687210 SUMDELTA$ rows never purged
3790371 Parallel domain index creation can use excessing TEMP space
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

Wrong Results
4080972+ Wrong results from RBO range predicate on concatenated index with NULLs
2055862 OracleCachedRowSet.getRow() returns wrong value after last()
2339943 Query using OR between two subtypes returns a wrong number of rows
2562253 Wrong results due to lost join predicate with predicate move around
2628526 Wrong results from outer join to inline view in SELECT list
2859498 Incorrect sort order when ORDER BY DESC against a view with PQ
2925619 JDBC Thin always default timezone to +00:00
2960012 Incorrect (large) 'logons current' in GV$SYSSTAT in RAC
2974848 GetElementsByTagName in DBMS_XMLDOM returns nodes in wrong order
3017095 ALTER MVIEW COMPILE does not update LAST_DDL_TIME in DBA/ALL/USER_OBJECTS
3023121 Wrong results possible from CASE expression
3041932 JDBC string to number conversion incorrect when precision specified
3081127 View for remote table with CHECK OPTION never reports ORA-1402
3100625 A view involving a collection (CAST/MULTISET) may return wrong results
3136807 Wrong results querying against snapshots with ANSI outer join
3175661 Query rewrite can give wrong results for "NOT IN"
3298019 Unreliable results with new_german_spelling enabled
3430105 Parallel full scan of an external table may "SKIP" more rows than defined
3507740 Wrong results possible with inlist iterator on DATE columns
3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918
3600190 UNISTR does not error for invalid escape sequences in its input
3605121 Wrong results from UNISTR() in multibyte
3624708 Select with SAMPLE clause returns all rows with FGA policy
3632450 TO_MULTI_BYTE/TO_SINGLE_BYTE do not work on a UTF8 database
3632504 Wrong results from EXEC SQL LOB READ from NCLOB
3637267 Varchar2 is blank padded when local DB charset is different from remote site
3650346 Public synonym resolution fails under certain circumstances
3652356 Wrong GMT offset using TO_CHAR with TZD or TZH:TZM
3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
3668084 Wrong results from nested FULL OUTER JOIN
3669074 Some V$SHARED_POOL_RESERVED contain incorrect data
3688320 Wrong result with parallel query having SMJ and inequality join
3742674 Wrong results possible from ROWID access of single partition
3753308 NLS_SORT not applied implicitly to window functions
3754340 FLOAT values loose precision when selecting against a view with a UNION
3754628 Wrong results from illegal query with OUTER joined column in BETWEEN clauses
3756943 Corrupt date when SYSDATE is defined as TIMESTAMP
3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables
3768069 Wrong results in subquery unnesting with semi/anti joins
3792845 MODE=ANSI client may get error 100 instead of correct error
3801102 Column values missing in SELECT with correlated scalar subquery in outer join
3815921 Wrong results possible from predicate move around
3823887 Dump / wrong results from NVL expansion
3831897 No rows from query against nested table view column when multiply referenced
3837903 wrong results from complex view merging with correlated subquery in select list
3847585 Wrong results with view not merged and function based index
3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
3855809 Parallel query with OUTER JOIN and ORDER BY returns results unsorted
3858017 Array insert with "EXEC SQL FOR" gets wrong value for SQLERRD[2]
3892220 Wrong results from OUTER join to VIEW on literal in view select list
3896119 CURRENT_UTILIZATION of V$RESOURCE_LIMIT may be too high
3897065 Wrong results with CASE predicates with constants
3897407 Wrong results from OUTER JOIN with FUNCTIONAL INDEX when the OUTER is negated
3911544 Wrong results from select with "OR" expansion on composite partitioned table
3924156 SDO_WITHIN_DISTANCE returns false positive comparing polygons
3924711 Wrong results for CHAR-CHAR join with transitive predicates over database link
3925069 Wrong COLUMN_TYPE returned by getProcedureColumns for a Date parameter
3956826 Wrong result order from ORDER BY with inlist and partition iterator
3960118 Wrong results from uncorrelated scalar subquery and NL OUTER join
3963167 Wrong results / dump (KKOGTP) from JOIN between CHAR and VARCHAR2
3965060 DBA_LMT_USED_EXTENTS still shows extents for DROPPED segment in READ ONLY tablespace
3976165 Wrong results from star transformation with semijoin
3994909 Wrong numeric data from TO_CHAR() over a gateway
3999212 Wrong results with NLS_SORT / NLS_COMP=ANSI and binds in CHAR predicate
4006711 GROUPING SET SQL may return fewer rows than expected
4007071 Wrong results selecting from TABLE() collection
4020449 Wrong results or OERI[15160] from star transformation
4025594 updatexml adds extra whitespace with each update
4031093 Wrong results from DISTINCT view joined to single row table
4039237 No rows returned from HASH join of CHAR columns containing only blanks
4057458 SDO_GEOM.SDO_CONVEXHULL gives wrong results
4057523 Wrong results with CASE expressions in GROUP BY / HAVING clause
4093187 Wrong results from complex view merge with unnesting
4097762 Explain PLAN show wrong plan for DML with a subquery
4109971 Wrong results using IOT and bitmap index
4117122 Wrong results from MERGE JOIN CARTESIAN with subquery predicate on right
4121712 SDO_INTERSECTION gives null result if linestring with circ. arcs involved
4121868 Wrong results from SQL using CASE with IN clauses
4130230 Wrong results with OR-expansion and multi-column inlist
4134227 Selects from V$LOGMNR_CONTENTS do not work if query cancelled
4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation
4143213 Intermittent wrong results from VPD policy not based on application context
4149579 Wrong result with star transformation with predicate simplification
4154591 Wrong results from single table joinback elimination
4156131 SQLSTATE errorcode wrong when RELEASE_CURSOR=YES
4156916 Dump / wrong results from TO_DATE without a full date format mask
4188078 Native mode RAISE_APPLICATION_ERROR does not replace all previous errors
4230880 Wrong result with parallel query and NL OUTER join
4258719 SDO_RELATE can return wrong result with a point inside a polygone
4306147 Wrong number of rows returned from table in hash cluster

Error May Occur
2375764 Export fails with ORA-1455 if leaf_blocks or distinct_keys >= 2^31
2380561 "DRG-10817" from CATSEARCH with stemmed stopwords
2391697 ORA-235 doing backup with RMAN in nocatalog mode
2412991 ORA-12533 while resolving (duplicate) net services from names server
2672986 SET CONSTRAINT DEFERRED sometimes errors out with ORA-1031
2857330 ORA-1008 from Binds in CURSOR subqueries using WITH
2858082 False ORA-1652 in alert log when there is free space in RAC environment
2902077 Adding TEMP files with no size specified gives an error with ODM
2966778 Intermittent ORA-904 errors during heavy load
3026474 ORA-20000 from DBMS_STATS importing table stats with missing column
3039517 Query rewrite of OUTER joins can result in ORA-1468 / ORA-1417
3040464 Views defined as selecting ALIAS.* should be expanded
3083673 ORA-942 when selecting from another users view which uses WITH
3116865 Various dumps can occur using XML clonenode
3202079 ORA-1044 binding large buffer using a dedicated connectionf
3277927 Unexpected ORA-2070 possible when using a SYS_CONTEXT function
3301573 ORA-1555 error may report nonsense query start time
3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
3447792 Multi-table insert can fail with ORA-24335
3567953 RMAN connect fails with ORA-7607 with AUDIT_SYS_OPERATIONS set
3591564 ORA-1756 importing functional index with CHR(0) in its expression
3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
3639361 ORA-3106 passing oversized VARCHAR2 ADT attributes between SQL <-> PLSQL
3650346 Public synonym resolution fails under certain circumstances
3672565 ORA-1461 when binding data larger than 4k through a database link
3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
3726694 First update with a new OLS label gets ORA-28115
3732747 False ORA-1007 using DBMS_SQL.DEFINE_COLUMN
3738705 Incorrect CREATE TABLE SQL written to DMP file for "not substitutable at all levels"
3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
3787344 ORA-32321 occurs when executing fast refresh
3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
3854478 ORA-935 executing SQL with analytic functions over a database link
3858625 Insert of long over DB link with NULL binds may ORA-24343
3875506 ORA-2019 executing PLSQL block over a private database link
3903530 UTL_HTTP HTTPS via proxy server requiring user authentication fails with ORA-29268
3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
3941862 ORA-16132 during regular graceful failover
3944226 ORA-1801 if NLS_DATE_FORMAT is changed in the session
3946544 EXP-62 if the header of a wrapped TYPE contains a comment
3946694 XA recover throws ArrayIndexOutOfBoundsException
3953131 Altering first_scn of Streams capture results in ORA-30036 / ORA-1562
3965265 ORA-29902 for some Text queries with composite indexes
3973403 ORA-1562 / ORA-1581 using system managed Undo
3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
3992072 ORA-1461 / ORA-2005 inserting a column after setNull() in OCCI
4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
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
4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911
4063081 JDBC through HS returns ORA-3001 with inserting data over 1000 bytes long
4078970 ORA-907 using nested FULL OUTER JOIN in PLSQL
4112035 ORA-972 on XmlType view if identifier greater than 30 characters long
4115175 ORA-17510 doing backup to disk using veritas odm and large files
4116896 ORA-932 using extractValue() in SQL inside PLSQL
4126826 ORA-1031 may occur intermittently
4130852 ORA-6502 using DBMS_SQL with a RETURNING INTO clause
4140264 ORA-3117 can occur during replication push for NULL BLOB columns
4195175 Create MVIEW with large WHERE clause may dump / ORA-4031
4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode
4229466 Unusable indexes not skipped during EXCHANGE PARTITION

Internal Error May Occur (ORA-600)
4157713* OERI[KGHPIH:DS] can occur when shared pool under load
This bug is alerted in Note 310939.1
3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
2307997 OERI [kolaHashFind:hash table] from SELECT xmltypeview over a database link
2489130 OERI:1112 can occur while dumping PROCESSSTATE informatio
2707302 OERI[KSSRMP1] in PMON during shutdown
2736591 OCI-21500 [KGHALO2] with large value_sz values for OCIDefineByPos
2783333 OERI[voprsla1] can occur when running a query
2818800 OERI[kjzcwaitX] may occur in RAC
2847303 OERI:kkofkrMarkK with FIRST_ROWS_N from GROUP BY
2881246 Incorrect OERI[kcblibr_1] / OERI[kxttdropobj-1] can occur
2887209 UGA memory leak / OERI:729 with failed shared database link connection
2924135 False OERI:6074 can occur
2972961 OERI[ktcdso-1] during refresh on commit of materialized view
3032886 OERI[kjatioc:!ver] possible in RAC
3048658 OERI [ksires_1] [BADOPTIONS] in RAC
3116865 Various dumps can occur using XML clonenode
3133359 OERI[nconumcrsr-1] selecting from V$DBLINK
3172957 OERI[ktadrprc-1] / ORA-955 during DDL
3192364 OERI:[kwqidgpchdl: chdl] in job queue process for a buffered queue with no remote subscribers
3202151 Dump (kkqsgen) / OERI:KGHALO2 possible
3210747 SHUTDOWN IMMEDIATE can fail with OERI[1402]
3223344 OERI[kclswrite_3] possible in RAC environment with multiple DBW processes
3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
3231200 OERI[kokqaguco1] possible using OBJECTS
3258674 QMN process may dump or raise an internal error during DML
3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables
3365439 OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH
3390566 OERI / dump from functional indexes on TIMESTAMP columns
3411348 OERI[kksfbc-reparse-infinite-loop] / dump [kksfbc] after ALTER TABLE .. UPGRADE
3467866 Triggers performing DDL in autonomous transactions may dump / OERI
3469121 OERI from MERGE statement with database link and sequence
3495448 OERI[ksxpcncl3] possible in RAC
3502260 OERI[12813] from concurrent insert direct load and ONLINE create index
3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
3565660 OERI[kclrinit_3] from parallel recovery in RAC
3598358 Streams propagation may fail (OERI:kwqpbqdeqr: deq)
3598604 OERI[12262] during EXPLAIN of SQL with very large inlist
3607694 OERI:[15805] using PDML with array binds
3610343 OERI:[ktbdchk1: bad dscn] in RAC
3614008 OERI[kjcs_m:2]
3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
3631915 Logical apply errors with OERI:kdogsli1 and ORA-1332
3635302 OERI[12762] possible executing PLSQL
3671867 OERI[kclchkinteg_2] possible in RAC environment
3679892 Create partitioned bitmap index in parallel reports "Bad cvl" to the trace
3684871 Corrupt UDP packets can cause instance crash
3703478 OERI[kclchkinteg_1] possible in RAC
3711772 OERI 15440 from PLSQL RPC which raises an unhandled exception
3714207 OERI[5021] trying to migrate system tablespace to local
3731315 CREATE IOT with PK constraint may throw OERI [15803]
3752329 OERI[525] on [kjct flow control latch] in RAC
3757136 OERI:3050 during BMR (Block Media Recovery) through a RESETLOGS
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3771508 OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server
3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
3772528 OERI[534] possible if ORADEBUG is used to dump a processes ERRORSTACK
3788530 OERI[kohdtf048] with sqlldr direct load with a PLSQL function
3799433 OERI[1402] when running a global hanganalyze or dumping SYSTEMSTATE
3817705 OERI[18301] / OERI[4415] from XA
3817792 OERI[6100] while coalescing an index
3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group
3832099 OERI[kcbgtcr_13] can occur in RAC
3832696 OERI[kkfdpushgd1] on select which tried to go parallel
3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification
3833809 Direct load with code conversion can fail with OERI[klaevc_01]
3835429 OERI[kqrfrpo] / DB hang after killing a user process
3839202 OERI[kpndsci-11] using XA with database links
3842889 loadjava may fail with OERI[26599] with over 500 named references
3843318 OERI[ksxpwait10] / hang possible in RAC
3854034 OERI[733] optimizing SQL using bitmap indexes
3859298 Block corruption with high INITRANS or rapid ITL growth.
3859671 OERI [qctginf : opncsfrm] on INSERT AS SELECT with a window function
3865157 OERI [kkzumco2:4] using DBMS_REDEFINITION with more than 10 constraints
3872147 OERI[qmxsqloadns] on insert into XML table with empty default namespace
3872410 Corrupt PLSQL collection after copying empty collection
3893571 OERI[kope2_readstr232] during multibyte character conversion
3900237 OERI[25012] changing length of indexed column for a global temporary table
3901170 False OERI [kghiexchk:ds] with event 10235 or 10501 set
3903575 OERI[kolaslRead-2] during LOB read of XML
3906305 PLSQL Execute of SQL using extract() gives OERI [koksghds1]
3906669 LMS may fail with OERI[kjbmpclo:cvt]
3912435 OERI[kokegpinlob1] / OracleXMLSQLException from DBMS_XMLSLAVE
3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
3915343 OERI [25012] on COMMIT with refresh ON-COMMIT Materialized view over cluster
3917476 OERI[2652] in LMS process
3925815 OERI[kjccfmb:x!] possible in a RAC environment
3928478 OERI[kkchbyt : bfc] using extractValue() and substr()
3930499 AQ propagation of XMLType throws OERI[kolahashfind:hash table]
3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
3938376 OERI[15160] accessing via a bitmap join index
3949307 SGA memory corruption / OERI:KGHALO4 with high concurrency
3975816 OERI[kjbrref:!ini] in RAC
3996802 "alter system kill session" can crash the instance if IO slaves used
3998408 RAC instance may crash with OERI:kcsbcscn13
4000840 Update can cause block corruption
4014485 OERI:KSMASG1 when attempting to signal ORA-4031 for the Java pool
4020449 Wrong results or OERI[15160] from star transformation
4030913 OERI[1418] possible from DIAG
4033656 Dump [kghssc_writebuf] / SGA corruption if DBURI terminated
4036717 Truncate table in exception handler can causes OERI:kcbzwb_4
4058160 OERI[KGHALO2] accessing earlier version Gateway
4058532 OERI[17183] from kjxgfhc in RAC
4068333 OERI[kcllrem_2] can occur crashing the instance
4075231 OERI[kssrmp2] / startup fails
4081624 OERI[qksmmadjuststatistics1] possible on SQL against partitioned objects
4104619 DIAG may fail with OERI[17182] during dumping of information
4112324 OERI[16608] possible from some queries with pushed join predicates
4122757 OERI:knacsrb4406 on logical Standby
4131721 Process may fail with OERI:kjsmbesmi1 in RAC
4132013 OERI[4036] / DB crash possible using SMU
4172065 OERI[kjbmperr:1] possible in LMS in RAC environments
4175224 PLS-801 [79110] when subtype is based on cursor%rowtype
4204954 OERI[kjbcrtpi:piscn] / RAC instance crash
4258706 State object corruption possible (rare) with XA
4262830 OERI:4036 / OERI:4078 / instance crash using SMU
4305391 OERI[25012] with kditalp can occur during a temporary LOB operation
4314484 AQ Java transformations may fail to propogate with OERI:[kwqptlud:kopa]
4352928 Java LOB locators are pickled incorrectly

Process May Dump (ORA-7445) / Abend / Abort
4059639* ORA-7445 SKGXPDMPCTX Instance Crash with 9.2.0.5 or 9.2.0.6 Patchset
This bug is alerted in Note 297306.1
3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
2000938 A process may dump in kjrgpar in OPS/RAC if an ORA-4031 occurs
2314193 Dump from SELECT with query rewrite which uses MVIEW with functional index
2363758 Returning NULL from an EXTPROC callout may dump
2484985 Dump from anti or semi joins involving collections
2487943 Bulk insert in PLSQL may dump (kprcdt / memcpy)
2630783 Dump occurs inserting a VARRAY with 65535 elements
2718235 Dump (evacnt) when query uses WINDOW NOSORT over an aggregation
2763625 Some function pointers are stored in the SGA
2768251 Query against composite partitioned table fails with ORA-900 or dumps
2892189 Dump updating columns in a nested table with a trigger on the table
2953897 Dump (kkqucpon) can occur during semantic analysis
3066357 Parallel DML on partitioned IOT fails (slave dumps in kxfqpackrow)
3116865 Various dumps can occur using XML clonenode
3182188 Dump [qximgaop] from SQL using Text index
3228560 OERI[qkebValidateOpn:2] / dump under qkngbAllocate from FULL OUTER JOIN
3256015 Dump under qecgoc -> ... -> kkqs... -> kgl functions parsing a query
3258674 QMN process may dump or raise an internal error during DML
3277361 Memory corruption possible from certain DDLs
3283667 Dump (vopscv) from insert as select with INSTEAD OF trigger
3332184 Session using objects may dump [kocdsgt]
3339088 Dump (qmtGetSqlTypeInfo) creating schema based XMLType view
3386901 Dump (kcllwr) using VLM
3390566 OERI / dump from functional indexes on TIMESTAMP columns
3396792 Dump (qmxtrRewriteOpn) using XDB
3398060 The SSL Net layer may dump due to an uninitialized variable
3402188 Dump [kkslpbp] possible when shared pool is stressed
3406609 Improved trace file dumping resilience to corruptions
3417936 Client may dump / error (kpuhhfre)
3449866 Dump (opitca) from SQL with select list subquery inside a simple view
3453969 Dump (ttcc2u) with with array / null binds
3463926 Dump (evaopn2) possible from UNNEST of a subquery column
3486283 Dump (rwocmf) from SQL involving subqueries accessing remote databases
3506641 Dump [kcbhfake] possible during STARTUP in RAC
3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())
3516231 SELECT from a view with a TABLE function may dump
3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS
3554248 Dump [nsoexc] from CTAS with more than one TABLE operator
3583686 Memory allocation error during spatial query with local partitioned index
3584486 Client dump possible using SNS
3626323 JavaVM race condition in threads subsystem on some platforms
3626425 Export of schema based XMLType may dump
3628622 Dump possible selecting from V$RESOURCE_LIMIT
3659827 Dump (kkoeqv) when LATERAL view optimized
3678149 Direct SQLLOAD may dump (klctrx)
3680704 Dump (eoref_resolve_xdesc) in Java Stored Procedure
3697218 Dump (qecvco) from SQL referencing ROWID from a view which is key preserved
3703176 OERI[evapth : unexpected evaluation] selecting from set view using SYS_CONNECT_BY_PATH
3730394 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery
3736181 HANGANALYZE may dump in kjiwtacbk
3738557 SELECT with 2 LAG operations dumps (qkswcColRefWqbc)
3742371 Dump (kkpapUsedInSum) possible from query on partitioned table with subquery
3759147 Dump in koksfoc from import of CREATE VIEW with opaque types
3765931 ALTER TABLE ... SPLIT PARTITION may dump in msqtnm()
3771508 OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server
3774546 OCILobRead may dump in kghalo() if there is character set conversion
3775570 Dump [memcpy] ORA-12805 during Logical Standby apply
3799696 Dump under kxibDoFinish on some platforms
3810088 Cannot drop a table with a TYPE with associated user statistics
3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
3819834 Dump (kkslflb) with literal replacement
3823887 Dump / wrong results from NVL expansion
3834163 CREATE OUTLINE may dump (kkssct) when QUERY_REWRITE_ENABLED=true
3839540 Dump (drepadd) from Text index create/sync
3842253 Dump (kgghash) using literal replacement
3845698 Dump (kkxmgifa) possible with user defined function in complex SQL
3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS
3849323 LMD may dump [kjddgpop] during deadlock detection in RAC
3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail
3889303 Dump under sprintf from JavaVM
3895546 Capture may dump after certain DDLs
3901424 Dump [kghxfrcnt] possible
3909951 Dump *kpobav) possible
3921848 Dump (vopscv) when more than one RLS policy is defined on a table
3934729 Random dumps (nstimexp) using DCD with shared servers
3940412 PMON dump (kgllccl) cleaning up a killed process
3940774 Shared server may dump (in opiexe)
3948711 XA with database links may dump or perform slowly (link closed)
3949188 Dump (kopxccc) when calling a procedure over database link
3954056 Dump possible accessing remote site in NESTED LOOPS query
3962643 Dump / corruption using user defined operators
3963167 Wrong results / dump (KKOGTP) from JOIN between CHAR and VARCHAR2
3965425 Dump / OERI selecting from DB2/400 with ISOLATION_LEVEL=RR
3966982 Dump [kcbbscan] followed by instance crash
3974856 Dump (skdsttpcs) if diagnostics in bug 3797523 enabled
3986614 XA client with database links repeatedly closes the database links
3988801 Dump (ldxsto or lxhasc) in Logical standby apply
4001799 Dump from complex Text query
4004225 Dump possible (kkpapbDCopy2) for SQL against a composite partitioned table
4006142 SQLLDR may dump in ulfdck
4008202 Dump can occur in kglpim
4018783 OERI [12333] on import of table with a LONG column
4057523 Wrong results with CASE expressions in GROUP BY / HAVING clause
4073796 OCI client may dump under OCISessionGet when a network error occurs
4098853 Dump (qerixGetKey->evaopn2) using COUNT(NOT_NULL_COLUMN) with a view
4100479 Dump / spin when querying v$logmnr_content.
4102345 Dump from CTAS with parallel clause when select has a sequence
4102426 Dump (in upidpr) during socket write errors
4106565 DMON may dump executing a DISABLE command
4120094 PQ slave may dump in kxibFinish executing recursive SQL
4122236 9.2 fix for bug 2540003 is incomplete
4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition
4132901 Dump selecting from schema based table
4145827 Dump (skgxpdmpctx) possible in RAC after communication error
4147870 Dump possible (in kjccdel) during shutdown or process abort
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
4167403 Dump (kglobcl) using PGA_AGGREGATE_TARGET with SESSION_CACHED_CURSORS
4178560 Complex view merge of DISTINCT view may dump
4197878 Dump in msqopnws for some SQL
4237009 Dump (kkooqb) with star transformation
4245958 Dump (pirg2bi) with zero length raw input to UTL_RAW.cast_to_binary_integer



Task Related


Instance Startup
2817261 Startup may dump in ktuuon
3345155 Hang reopening standby database
3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
3506641 Dump [kcbhfake] possible during STARTUP in RAC
3752301 OERI:16305 at startup if unresolvable node in invited nodes list
3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail
4075231 OERI[kssrmp2] / startup fails

Migration / Upgrade / Downgrade
3883156I ORA-6502 from DBMS_XDBZ0.MIGRATE_PITRIG when patching to 9.2.0.5
2884318 ORA-4021 possible upgrading XMLType / XMLTypePI
3970412 XDB downgrade to 9.2 may dump

Performance Monitoring
2696924 Missing "STAT" lines in raw trace file produced by SQL_TRACE
2960012 Incorrect (large) 'logons current' in GV$SYSSTAT in RAC
3043373 Malformed execution plans in V$SQL_PLAN
3669074 Some V$SHARED_POOL_RESERVED contain incorrect data
4097762 Explain PLAN show wrong plan for DML with a subquery
4233255 Instance locks do not show up in [G]V$GES_ENQUEUE

Recovery
3565660 OERI[kclrinit_3] from parallel recovery in RAC
3757136 OERI:3050 during BMR (Block Media Recovery) through a RESETLOGS
3996456 ALLOW 1 CORRUPTION may not corrupt the block / may OERI
4047608 Export/import can loose the LOGGING attribute of LOB columns



SQL Commands / Features Used


ANSI Joins
3136807 Wrong results querying against snapshots with ANSI outer join
3228560 OERI[qkebValidateOpn:2]