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

See Note 189908.1 for Support Status and Alerts affecting 9.2.0 releases.
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.

For fixes added in 9.2.0.6 see Note 283897.1
For fixes added in 9.2.0.5 see Note 263791.1
For fixes added in 9.2.0.4 see Note 245758.1
For fixes added in 9.2.0.3 see Note 245939.1
For fixes added in 9.2.0.2 see Note 246017.1
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.

'*' against a bug indicates that an alert exists for that issue.
'+' indicates a particularly notable bug.
'P' indicates a port specific bug.
"OERI:nnnnn is used as shorthand for ORA-600 [nnnnn].

Notable exceptions and omissions

Most port specific issues are not listed

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 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 **PARE 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] / dump under qkngbAllocate from FULL OUTER JOIN

3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918

3668084 Wrong results from nested FULL OUTER JOIN

3730394 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery

4078970 ORA-907 using nested FULL OUTER JOIN in PLSQL

Analytic SQL (Windowing etc..)

2718235 Dump (evacnt) when query uses WINDOW NOSORT over an aggregation

3083373 ORA-905 when using an analytic clause in SQL within PLSQL

3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables

3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing

3738557 SELECT with 2 LAG operations dumps (qkswcColRefWqbc)

3753308 NLS_SORT not applied implicitly to window functions

3854478 ORA-935 executing SQL with analytic functions over a database link

3859671 OERI [qctginf : opncsfrm] on INSERT AS SELECT with a window function

4006711 GROUPING SET SQL may return fewer rows than expected

Application Context

3277927 Unexpected ORA-2070 possible when using a SYS_CONTEXT function

Constraint Related

2672986 SET CONSTRAINT DEFERRED sometimes errors out with ORA-1031

2972961 OERI[ktcdso-1] during refresh on commit of materialized view

3397761 DBMS_METADATA does not put a SQL terminator in CONSTRAINT definitions

3675530 Concurrent enable of CONSTRAINTS against same base table may dump

3731315 CREATE IOT with PK constraint may throw OERI [15803]

4065814 JDBC driver using XA returns XA_RMERR when a deferred constraint is violated

Datatypes (LOBs/CLOB/BLOB/BFILE)

2649958 Analyze table with functional index on LOB column gets no statistics for the index column

3419707 Varying width CLOB data padded with blanks over database link

3537749 HW enqueue contention when loading lob data

3632504 Wrong results from EXEC SQL LOB READ from NCLOB

3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize

3774546 OCILobRead may dump in kghalo() if there is character set conversion

3794969 BFILE locator takes up maximum length rather than actual length

3795386 Insert as select of LOBS / XMLType across DB Link can leak memory

3796939 Hang on rebind/reexecute of SQL with more than on LOB column over 4K long

3903575 OERI[kolaslRead-2] during LOB read of XML

4047608 Export/import can loose the LOGGING attribute of LOB columns

4052219 LOB segment may leak space when ASSM managed

4063046 Latch contention due to leaked CR pins for LOB data

4096261 Missing direct loaded LOB data in Streams

4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition

4140264 ORA-3117 can occur during replication push for NULL BLOB columns

4305391 OERI[25012] with kditalp can occur during a temporary LOB operation

4352928 Java LOB locators are pickled incorrectly

4369117 OCI direct path out-of-line LOB insert slow

Datatypes (Objects/Types/Collections)

2339943 Query using OR between two subtypes returns a wrong number of rows

2484985 Dump from anti or semi joins involving collections

2630783 Dump occurs inserting a VARRAY with 65535 elements

2892189 Dump updating columns in a nested table with a trigger on the table

3100625 A view involving a collection (CAST/MULTISET) may return wrong results

3231200 OERI[kokqaguco1] possible using OBJECTS

3332184 Session using objects may dump [kocdsgt]

3411348 OERI[kksfbc-reparse-infinite-loop] / dump [kksfbc] after ALTER TABLE .. UPGRADE

3498977 Poor performance handling VARRAY / ADTs from JDBC

3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())

3516231 SELECT from a view with a TABLE function may dump

3554248 Dump [nsoexc] from CTAS with more than one TABLE operator

3744836 ORA-4043 on SYS_PLSQL_%s_%c from DROP of a versioned object

3810088 Cannot drop a table with a TYPE with associated user statistics

3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group

3831897 No rows from query against nested table view column when multiply referenced

3895546 Capture may dump after certain DDLs

3946544 EXP-62 if the header of a wrapped TYPE contains a comment

3984620 Dump if type name identifier undergoes character set conversion

4007071 Wrong results selecting from TABLE() collection

4015652 Nested Table export fails with ORA-1007

4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs

4204326 Cursors with TABLE() expressions no shared when USE_STORED_OUTLINES set

Datatypes (TIMESTAMP)

2616238 Unparse of TIMESTAMP conversions not supported

2925619 JDBC Thin always default timezone to +00:00

3390566 OERI / dump from functional indexes on TIMESTAMP columns

3756943 Corrupt date when SYSDATE is defined as TIMESTAMP

3906221 JDBC binds as a TIMESTAMP when V8Compatibility is true for NULL bind values

3957791 getObject() shows TIMESTAMP column as DATE (ORA-1483)

Direct Path Operations

3369324 Snapshot remains stale on complete refresh after direct load on master

3502260 OERI[12813] from concurrent insert direct load and ONLINE create index

3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS

3678149 Direct SQLLOAD may dump (klctrx)

3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data

3788530 OERI[kohdtf048] with sqlldr direct load with a PLSQL function

3833809 Direct load with code conversion can fail with OERI[klaevc_01]

3866720 SQL*Loader-709 occurs during direct load on multi-CPU machine

3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103

4085785 OERI[6191] on compressed partition direct export

4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode

4369117 OCI direct path out-of-line LOB insert slow

Global Temporary Tables

2678196 ORA-8177 inserting into temporary index in SERIALIZABLE transaction

3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table

3852108 Concurrent truncates on global temporary table cause library cache lock waits

3900237 OERI[25012] changing length of indexed column for a global temporary table

4633194 9.2.0.6 Patch for bug 3852108 can cause PQ slave dump in kxttPut

Globalization Support (NLS)

3600190 UNISTR does not error for invalid escape sequences in its input

3600206 Priviate memory corruption possible from UNISTR()

3605109 UNISTR optimization

3605121 Wrong results from UNISTR() in multibyte

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

3692370 UNISTR builtin function produces incorrect results when given NCHAR input

3695061 UNISTR function does not deal with NCHARs encoded using AL16UTF16

3753308 NLS_SORT not applied implicitly to window functions

3774546 OCILobRead may dump in kghalo() if there is character set conversion

3893571 OERI[kope2_readstr232] during multibyte character conversion

3944226 ORA-1801 if NLS_DATE_FORMAT is changed in the session

3957152 ORA-1401 inserting data over 444 multi-byte characters via a database link

3984620 Dump if type name identifier undergoes character set conversion

3999212 Wrong results with NLS_SORT / NLS_COMP=ANSI and binds in CHAR predicate

4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics

4022708 Spin under OCIMultiByteStecmp with nls_sort=generic_m

4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs

4060997 ORA-26689 in Streams Apply if NLS_SORT is not set to binary

4122805 With NLS_COMP=ANSI then NLS_LENGTH_SEMANTICS=CHAR sometimes changes to BYTE

4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode

Hash Join

4039237 No rows returned from HASH join of CHAR columns containing only blanks

Literal Replacement (CURSOR_SHARING)

3402188 Dump [kkslpbp] possible when shared pool is stressed

3818541 CURSOR_SHARING=force does not work if SQL has an NVL or DECODE predicate

3819834 Dump (kkslflb) with literal replacement

3842253 Dump (kgghash) using literal replacement

Merge SQL (MERGE .. USING)

2670601 MERGE does not work correctly for HASH clusters (wrong result)

3447792 Multi-table insert can fail with ORA-24335

3469121 OERI from MERGE statement with database link and sequence

Online DDL

3502260 OERI[12813] from concurrent insert direct load and ONLINE create index

3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS

Optimizer

4080972+ Wrong results from RBO range predicate on concatenated index with NULLs

2484583 FIRST_ROWS(K) not applied to view query block

2492766 Predicates in OR chains not evaluated as part of index scan

2562253 Wrong results due to lost join predicate with predicate move around

2649958 Analyze table with functional index on LOB column gets no statistics for the index column

2684114 CBO does not consider ROWNUM predicate for optimal access path

2720661 CBO enhancement to break tie based on NDK when cost is same

2847303 OERI:kkofkrMarkK with FIRST_ROWS_N from GROUP BY

2942560 In IO cost model functional domain index invocation uses bad costing

3023121 Wrong results possible from CASE expression

3026474 ORA-20000 from DBMS_STATS importing table stats with missing column

3202151 Dump (kkqsgen) / OERI:KGHALO2 possible

3229934 DBMS_STATS.DELETE_INDEX_STATS does not invalidate index stats previously collected

3256015 Dump under qecgoc -> ... -> kkqs... -> kgl functions parsing a query

3436577 View merge does not occur for CTAS when it does for the SELECT

3463926 Dump (evaopn2) possible from UNNEST of a subquery column

3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats

3507740 Wrong results possible with inlist iterator on DATE columns

3566843 Optimizer may not choose best index

3659827 Dump (kkoeqv) when LATERAL view optimized

3663924 Bad cardinality for out-of-range range predicates

3672985 No bind peeking for equality predicates can give poor plan choice

3737955 Long parse times for long inlists / many AND/OR terms

3751131 Wrong cardinality with range predicate value matching histogram endpoint value

3768069 Wrong results in subquery unnesting with semi/anti joins

3777256 Functional indexes on CASE expressions may not be used

3801102 Column values missing in SELECT with correlated scalar subquery in outer join

3810088 Cannot drop a table with a TYPE with associated user statistics

3815494 ORA-701 from DBMS_STATS .alter_database_tab_monitoring(true, sysobjs => true)

3815921 Wrong results possible from predicate move around

3823191 Unnecessary sort when access made through a local index

3823887 Dump / wrong results from NVL expansion

3834770 CBO may not unnest an EXISTS() subquery with a view in the FROM clause

3867374 Zero cost possible for nested loops access to table with single bitmap semijoin

3879082 Performance improvements for DBMS_STATS running in auto sample mode

3879494 Dumps during execution when both OR expansion and PQ used

3892220 Wrong results from OUTER join to VIEW on literal in view select list

3911544 Wrong results from select with "OR" expansion on composite partitioned table

3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references

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

3963167 Wrong results / dump (KKOGTP) from JOIN between CHAR and VARCHAR2

4050226 Index skip scan may not be chosen when it is a good choice

4068311 Functional indexes may not be used to avoid sorts

4093187 Wrong results from complex view merge with unnesting

4098853 Dump (qerixGetKey->evaopn2) using COUNT(NOT_NULL_COLUMN) with a view

4099777 IO costing affected by having used CPU cost model

4112254 CBO may not choose best index for single table access with unpeeked bind/function

4112324 OERI[16608] possible from some queries with pushed join predicates

4154591 Wrong results from single table joinback elimination

4157426 A suboptimal plan can be used for queries with nested disjuncts

4178560 Complex view merge of DISTINCT view may dump

4229830 Wrong cardinality estimate comparing CHAR to VARCHAR2 literals / peeked binds

4306147 Wrong number of rows returned from table in hash cluster

Parallel Query (PQO)

2535150 Executing stored procedure using "CALL" does not use parallelism

2859498 Incorrect sort order when ORDER BY DESC against a view with PQ

3033448 OERI:[504] under kxfpbgtc()

3066357 Parallel DML on partitioned IOT fails (slave dumps in kxfqpackrow)

3261205 Hang / OERI[kxttdropobj-1] on parallel direct load to temporary table

3430105 Parallel full scan of an external table may "SKIP" more rows than defined

3533996 Using transportable tablespaces disables intra-partition PDML

3607694 OERI:[15805] using PDML with array binds

3688320 Wrong result with parallel query having SMJ and inequality join

3731315 CREATE IOT with PK constraint may throw OERI [15803]

3790371 Parallel domain index creation can use excessing TEMP space

3855809 Parallel query with OUTER JOIN and ORDER BY returns results unsorted

3859342 Sort is not parallelised in a view query with MINUS (or INTERSECT)

3879494 Dumps during execution when both OR expansion and PQ used

3962614 OERI[rworupo.1] during parallel IOT operations

4027360 ORA-903 from PQ with UNION ALL

4030374 Parallel DML into partitioned table may produce index corruption

4102345 Dump from CTAS with parallel clause when select has a sequence

4120094 PQ slave may dump in kxibFinish executing recursive SQL

4230880 Wrong result with parallel query and NL OUTER join

4633194 9.2.0.6 Patch for bug 3852108 can cause PQ slave dump in kxttPut

Query Rewrite (Including Materialized Views)

3894096+ Poor MView refresh performance in ASSM tablespaces

2314193 Dump from SELECT with query rewrite which uses MVIEW with functional index

2972961 OERI[ktcdso-1] during refresh on commit of materialized view

3017095 ALTER MVIEW COMPILE does not update LAST_DDL_TIME in DBA/ALL/USER_OBJECTS

3039517 Query rewrite of OUTER joins can result in ORA-1468 / ORA-1417

3102211 DBMS_METADATA does not recognise materialized view logs

3136807 Wrong results querying against snapshots with ANSI outer join

3175661 Query rewrite can give wrong results for "NOT IN"

3314850 DROP SUMMARY can deadlock with query rewrite sessions

3369324 Snapshot remains stale on complete refresh after direct load on master

3419707 Varying width CLOB data padded with blanks over database link

3669454 Unexpected ORA-12034 on FAST REFRESH of MVIEW

3682068 MV log changes not recorded with complex statement

3687210 SUMDELTA$ rows never purged

3787344 ORA-32321 occurs when executing fast refresh

3794402 Dump during query rewrite with a LIKE operator

3810779 PCT REWRITE is not allowed after CONSIDER FRESH

3824149 Missing data possible from Insert as SELECT over database link

3830853 DELETE during REFRESH of MJV can have poor execution plan

3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification

3834163 CREATE OUTLINE may dump (kkssct) when QUERY_REWRITE_ENABLED=true

3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously

3915343 OERI [25012] on COMMIT with refresh ON-COMMIT Materialized view over cluster

4195175 Create MVIEW with large WHERE clause may dump / ORA-4031

Star Transformation

2927071 Unnesting does not work with star transformation

3269826 ORA-918 on complex query with star transformation

3277927 Unexpected ORA-2070 possible when using a SYS_CONTEXT function

3803479 ORA-928 possible from STAR transformation

3961045 SGA memory corruption from STAR transformation with UNION view

4131301 Star transformation can affect dynamic pruning (subquery)

4237009 Dump (kkooqb) with star transformation

Star Transformation With Temp. Tables

2546446 Star transformation may generate superfluous temp tables

3285454 Temp table transformation may produce unused TEMP tables

3976165 Wrong results from star transformation with semijoin

3992539 OERI[kkotr2:jcolmis] with star transformation

4020449 Wrong results or OERI[15160] from star transformation

4149579 Wrong result with star transformation with predicate simplification

Triggers

2421661 Small memory leak per execution of ROW TRIGGER

2892189 Dump updating columns in a nested table with a trigger on the table

3283667 Dump (vopscv) from insert as select with INSTEAD OF trigger

3467866 Triggers performing DDL in autonomous transactions may dump / OERI

Truncate

3852108 Concurrent truncates on global temporary table cause library cache lock waits

3966709 Range/object reuse prematurely (ORA-8103)

4036717 Truncate table in exception handler can causes OERI:kcbzwb_4

4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition

4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation

How Things Are Stored / Defined

ASSM Space Management (Bitmap Managed Segments)

3894096+ Poor MView refresh performance in ASSM tablespaces

3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used

3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103

4052219 LOB segment may leak space when ASSM managed

4069484 ASSM segments waste space with heavy concurrent inserts

4074953 Insert performance problems with ASSM in RAC environments

4121673 DBMS_SPACE_ADMIN.assm_segment_verify does not detect certain corruptions

4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation

Bitmap Indexes

3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize

3617574 Transport of bitmap index gives errors at transported to site

3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES

3823550 False ORA-1499 validating a table CASCADE ONLINE with a bitmap index

3854034 OERI[733] optimizing SQL using bitmap indexes

3867374 Zero cost possible for nested loops access to table with single bitmap semijoin

3938376 OERI[15160] accessing via a bitmap join index

4109971 Wrong results using IOT and bitmap index

Compressed Data Storage

4085785 OERI[6191] on compressed partition direct export

Domain Indexes

2682426 OERI:13013 from "bitmap AND" of DOMAIN index scans

2942560 In IO cost model functional domain index invocation uses bad costing

3225530 DBMS_METADATA fails to generate complete definition for a domain index

3685659 Export of DOMAIN INDEXes can write truncated CREATE INDEX information to the DMP file

3790371 Parallel domain index creation can use excessing TEMP space

3962643 Dump / corruption using user defined operators

External Tables

3430105 Parallel full scan of an external table may "SKIP" more rows than defined

4007026 Accessing an external table can leak file descriptors

Function Based Index (Including DESC Indexes)

2314193 Dump from SELECT with query rewrite which uses MVIEW with functional index

2649958 Analyze table with functional index on LOB column gets no statistics for the index column

3390566 OERI / dump from functional indexes on TIMESTAMP columns

3591564 ORA-1756 importing functional index with CHR(0) in its expression

3777256 Functional indexes on CASE expressions may not be used

3847585 Wrong results with view not merged and function based index

3897407 Wrong results from OUTER JOIN with FUNCTIONAL INDEX when the OUTER is negated

3940803 Functional indexes not always considered NULL safe

3950045 Wrong cardinality (CDN) with functional indexes

4068311 Functional indexes may not be used to avoid sorts

Index Only Tables (IOT)

2855241 Transport of a tablespace with a HASH partitioned IOT fails during import

3066357 Parallel DML on partitioned IOT fails (slave dumps in kxfqpackrow)

3731315 CREATE IOT with PK constraint may throw OERI [15803]

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

3962614 OERI[rworupo.1] during parallel IOT operations

4109971 Wrong results using IOT and bitmap index

Oracle Disk Manager

2902077 Adding TEMP files with no size specified gives an error with ODM

3241979 Multiblock reads do not occur when using ODM

Partitioned Tables

2597763 SPLIT of a COMPOSITE PARTITION can corrupt the dictionary (duplicate DATAOBJ#)

2768251 Query against composite partitioned table fails with ORA-900 or dumps

2855241 Transport of a tablespace with a HASH partitioned IOT fails during import

3066357 Parallel DML on partitioned IOT fails (slave dumps in kxfqpackrow)

3649372 No partition pruning using SYSDATE predicate against partition keys

3742371 Dump (kkpapUsedInSum) possible from query on partitioned table with subquery

3742674 Wrong results possible from ROWID access of single partition

3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES

3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables

3765931 ALTER TABLE ... SPLIT PARTITION may dump in msqtnm()

3823191 Unnecessary sort when access made through a local index

3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification

3845457 Mining redo for parallel partition maintenance slow

3848724 Dump [kdapblkcntt] rebuilding indexes with ONLINE or COMPUTE STATISTICS

3911544 Wrong results from select with "OR" expansion on composite partitioned table

3956826 Wrong result order from ORDER BY with inlist and partition iterator

3996053 Inefficient dynamic partition pruning SQL

4004225 Dump possible (kkpapbDCopy2) for SQL against a composite partitioned table

4016802 Incorrect export produced for transport of composite partitioned table

4030374 Parallel DML into partitioned table may produce index corruption

4081624 OERI[qksmmadjuststatistics1] possible on SQL against partitioned objects

4085785 OERI[6191] on compressed partition direct export

4096261 Missing direct loaded LOB data in Streams

4121216 Default storage parameters for partitioned objects are incorrect

4122275 Update of partitioned table with LOB may dump with concurrent TRUNCATE of partition

4229466 Unusable indexes not skipped during EXCHANGE PARTITION

Read Only Tablespace/s

3965060 DBA_LMT_USED_EXTENTS still shows extents for DROPPED segment in READ ONLY tablespace

4037606 REPORT OBSOLETE does not report archives when a tablespace is read-only

4057347 Switchover fails with ORA-1113 read only tablespace

Space Management

2858082 False ORA-1652 in alert log when there is free space in RAC environment

Space Management (Locally Managed Tablespaces)

3714207 OERI[5021] trying to migrate system tablespace to local

3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize

3965060 DBA_LMT_USED_EXTENTS still shows extents for DROPPED segment in READ ONLY tablespace

4047545 DBA_SEGMENTS slow for 8i migrated segments (follow on to bug 2948717)

4142932 DBA_SEGMENTS.EXTENTS wrong for locally managed segment after TRUNCATE operation

System Managed Undo (SMU)

3422329 Lots of alert messages for online/offline of SMU rollback segments

3493017 Enhanced diagnostics for active transaction count maintenance

3973403 ORA-1562 / ORA-1581 using system managed Undo

4132013 OERI[4036] / DB crash possible using SMU

4262830 OERI:4036 / OERI:4078 / instance crash using SMU

Net / Connectivity / Authentication / Distributed

Advanced / Secure Networking

2886098 Listener and oracle private memory grows on each SSL connect/disconnect

3243343 Dump (nzos_deinitialize) while closing an SSL connection

3398060 The SSL Net layer may dump due to an uninitialized variable

3584486 Client dump possible using SNS

Database Link / Distributed

2307997 OERI [kolaHashFind:hash table] from SELECT xmltypeview over a database link

2887209 UGA memory leak / OERI:729 with failed shared database link connection

3081127 View for remote table with CHECK OPTION never reports ORA-1402

3133359 OERI[nconumcrsr-1] selecting from V$DBLINK

3419707 Varying width CLOB data padded with blanks over database link

3469121 OERI from MERGE statement with database link and sequence

3486283 Dump (rwocmf) from SQL involving subqueries accessing remote databases

3624684 Remote subquery not unnested when expected

3637267 Varchar2 is blank padded when local DB charset is different from remote site

3647829 Cursor is not always closed when database link closed (ORA-1000)

3672565 ORA-1461 when binding data larger than 4k through a database link

3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets

3795386 Insert as select of LOBS / XMLType across DB Link can leak memory

3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063

3808670 Private memory leak from INSERT INTO over Database link

3824149 Missing data possible from Insert as SELECT over database link

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

3924711 Wrong results for CHAR-CHAR join with transitive predicates over database link

3929805 Slow execution for insert as Select over DB Link with NULL in select list

3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references

3949188 Dump (kopxccc) when calling a procedure over database link

3954056 Dump possible accessing remote site in NESTED LOOPS query

3957152 ORA-1401 inserting data over 444 multi-byte characters via a database link

3957590 Corruption from failed distributed transaction in RAC environment

3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i

4030117 Revised fix for bug 3076160

4154611 ORA-22992 can occur for distributed XML queries

4165093 Dump (in kkocpr) for SQL over database link

4172303 In-doubt transaction may be left PREPARED at a remote site

Gateways / Heterogeneous Services

3880708 ORA-3001 / ORA-3115 inserting in gateway table from 8i -> 9i -> gateway

3896254 CBO used with default statistics used when DB2STATS = FALSE

3922882 SQL with CASE expressions may error when a gateway (HS) is involved

3994909 Wrong numeric data from TO_CHAR() over a gateway

4058160 OERI[KGHALO2] accessing earlier version Gateway

4063081 JDBC through HS returns ORA-3001 with inserting data over 1000 bytes long

4170365 Attunity bug fixes collection for 9.2.0.7

Gateways / Transparent Gateway For DRDA

3130329 TG4DRDA spins if QRWTSRVR job killed while gateway is in gdjcrcv

3965425 Dump / OERI selecting from DB2/400 with ISOLATION_LEVEL=RR

Interoperability (Between Releases)

3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets

3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i

Network

3177264 Small performance improvement for transfer of data

3592772 ORA-12699 / client cannot connect with NTS authentication

3752301 OERI:16305 at startup if unresolvable node in invited nodes list

3908058 Memory leak when using protocol.ora validnode_checking

3934729 Random dumps (nstimexp) using DCD with shared servers

4114966 TNSPING dumps when names.no_persistent_resources=true is set in sqlnet.ora

4181421 Net does not support an outbound connection timeout

Network (Connection Manager)

3224546 ORA-12564 from CMAN in a RAC with listener load balancing

3545374 CMAN rules incorrectly reject connections with ORA-12564

Oracle Names

2412991 ORA-12533 while resolving (duplicate) net services from names server

3941059 JDBC OCI connections hang if NAMES.NO_PERSISTENT_RESOURCES enabled

Security ( Authentication / Privileges / Auditing )

3450991 FGA does not work if SQL is run by the SYS user

3567953 RMAN connect fails with ORA-7607 with AUDIT_SYS_OPERATIONS set

3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE

3786271 Audit DML not working with DBMS_JOB / DBMS_SCHEDULER

3864444 Multiple aud$ records are inserted when regular audit and FGA are enabled

4088212 DBMS_OBFUSCATION_TOOLKIT.DES3GetKey performance problem

4114759 Poor performance with DBMS_OBFUSCATION_TOOLKIT.des3getkey (part 2)

4118463 DN of failed logons from externally authenticated LDAP accounts not audited

4155692 EUS logins fail when username includes * or \ characters

4170976 EUS logons do not work for certain characters

Transparent Application Failover

3948754 ArrayIndexOutOfBoundsException using JDBC Thin with FAILOVER clause

4152968 TAF failover does not work properly

XA / Distributed Transactions

3647829 Cursor is not always closed when database link closed (ORA-1000)

3817705 OERI[18301] / OERI[4415] from XA

3839202 OERI[kpndsci-11] using XA with database links

3890992 JDBC XA error -3 returned when rollback with invalid timeout xid

3946694 XA recover throws ArrayIndexOutOfBoundsException

3948711 XA with database links may dump or perform. slowly (link closed)

3986614 XA client with database links repeatedly closes the database links

4065814 JDBC driver using XA returns XA_RMERR when a deferred constraint is violated

4258706 State object corruption possible (rare) with XA

Database Options / Major Features

Advanced Queuing

3192364 OERI:[kwqidgpchdl: chdl] in job queue process for a buffered queue with no remote subscribers

3258674 QMN process may dump or raise an internal error during DML

3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long

3771508 OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server

3804515 "kwqicaclcur" writes trace file entries for ORA-1013 and ORA-3113

3830460 Prevent reporting of certain errors to AQ trace files

3830972 DBMS_AQ.LISTEN on RAC cluster may not see new enqueue messages

3930499 AQ propagation of XMLType throws OERI[kolahashfind:hash table]

3960423 AQ enqueue to large number of queues can be slow

4019844 AQ notifications triggered for rolled back messages on single consumer queues

4028364 EMN0 may hang holding library cache pin if notification recipient does not respond

4084096 utlrp.sql does not validate queues in 9.2

4098102 High CPU consumption by AQ listen

4190303 OJMS (AQ) connection is not closed with the tranasaction timeout in OC4J

4285294 Memory leak in AQ messaging

4314484 AQ Java transformations may fail to propogate with OERI:[kwqptlud:kopa]

Change Data Capture

4051461 Cannot create change tables on logical standby system

Flashback

4252656 Dump in ktfpsnps during flashback operatios

JavaVM / JSP / Corba etc..

3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON

3218825 Memory leak when Java Stored Procedure executed from PLSQL

3546906 Dump (free) using LDAP functions in Java

3626323 JavaVM race condition in threads subsystem on some platforms

3680704 Dump (eoref_resolve_xdesc) in Java Stored Procedure

3701730 Memory leak executing PLSQL or Java calls repeatedly in a single user call

3842889 loadjava may fail with OERI[26599] with over 500 named references

3889303 Dump under sprintf from JavaVM

3964487 Java stored procedure can corrupt memory in MTS

4014485 OERI:KSMASG1 when attempting to signal ORA-4031 for the Java pool

LogMiner

3617406 Partial dictionary dump in redo stream considered complete

3878597 Logminer does not fill in XIDSQN correctly for partial transactions

4042949 Dump possible in ktspffprint while printing redo from 9.0 redo stream

4100479 Dump / spin when querying v$logmnr_content.

4134227 Selects from V$LOGMNR_CONTENTS do not work if query cancelled

4137433 Logminer queries against logmnr_log$ may be slow

Oracle Label Security

3513629 Dump (vopqbc) from query with OLS and CAST(MULTISET())

3514937 SA_SYSDBA.DROP_POLICY does not drop the RLS policies

3721652 ALTER_LABEL() function converts datalabel to userlabel if NEW_DATA_LABEL null

3726694 First update with a new OLS label gets ORA-28115

3936531 Incorrect schema for OLS validation procedure

4039916 Poor performance from trusted store procedures with FULL privilege

4089843 Export of table with OLS policy does not export "label function" properly

Oracle OLAP

3042729 DBMS_AWM.REFRESH_AWDIMENSION does not support skip-level hierarchies

3443451 obj(disksize) shows bad result for all NA variable in AW

3549015 ALL_AW_CUBE_ENABLED_VIEWS is not large enough for large number of objects

3623584 OLAP requires Oracle Partitioning option

3803122 ORA-37666 from aggregate function

3937524 Excessive XMLWriter memory usage by EPB

3937525 Excessive memory usage by SOURCETOXMLCONVERTER in OLAP

3967105 Enhancement to expose MtmLevelHierarchyMap.addOrderSpecification()

4006729 Error in BI beans when same dimension name present in other accessible schema

4018574 Add AW (READERS) and AW (WRITERS)

4053934 Add OLAP SQLFETCH function

4069517 HEIRHEIGHT may fail with ORA-36964

4120814 Large query definition causes OlapiException

4121369 "aggmap add" can be slow

4147135 Dump possible in xsXEQ

4154405 aggregation function errors for qdr'ed valueset

4234510 bib crosstab shows wrong data when selecting numerous measures

4258406 A dimension created as alias can get corrupted by EIF export

Oracle Text (Formerly interMedia Text)

2094257 CTX_DOC.MARKUP does not work if word has a character entity at the end

2380561 "DRG-10817" from CATSEARCH with stemmed stopwords

3007647 CTX_REPORT.INDEX_STATS fails when prefix indexing is enabled (DRG-50857)

3182188 Dump [qximgaop] from SQL using Text index

3225530 DBMS_METADATA fails to generate complete definition for a domain index

3298019 Unreliable results with new_german_spelling enabled

3339967 Text Xpath expression with positional predicates should raise a parse error

3695092 Optimize of a text index may be slow

3746612 DRG-100[50600][drlu.c] for long queries using USER_LEXER

3839540 Dump (drepadd) from Text index create/sync

3917948 Dump (drljtkn) from CTX_DDL.SYNC_INDEX with Japanese lexer

3940410 Cursor leak (ORA-1000) from DML if concurrent session is creating a Text index ONLINE

3965265 ORA-29902 for some Text queries with composite indexes

4001799 Dump from complex Text query

4044362 CTX_REPORT.TOKEN_INFO fails for token_types 604 / 904

4090486 Excessive memory use updating a Text index

4162383 Create Text index on XML fails with DRG-50857/ORA-1480

Oracle Text INSO Filters

4000658 Change from Stellent filters to Keyview filters

Physical Standby Database / Dataguard

4074603+ RMAN backup of primary with a standby using FAL may omit archivelogs

3345155 Hang reopening standby database

3596262 Add DATAFILE on primary can cause standby to raise ORA-1274

3643786 RMAN delete input breaks LOCAL_FIRST archiving

3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]

3798892 Gap resolution between cascaded physical standbys incorrect

3905430 SMON reports ORA-604/ORA-16000 errors when standby DB is opened read only on RAC

3922760 STANDBY_FILE_MANAGEMENT=auto does not auto-create sub-directories

3934961 FAL process does not fetch archivelog from RAC primary when instance down

3941862 ORA-16132 during regular graceful failover

3948384 ORA-4031 possible using LGWR ASYNC for archiving

3967914 Dataguard DELAY is incorrectly based on log receive time at standby

4013788 SHUTDOWN IMMEDIATE may report 'KSR timed out' errors

4035155 Timeout errors possible from LGWR ASYNC / SYNC around midnight on 30th of month

4057347 Switchover fails with ORA-1113 read only tablespace

4106565 DMON may dump executing a DISABLE command

4332141 Instance may crash with Dataguard when too few ARCH configured

RAC (Real Application Clusters) / OPS

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

4066495+ CLUSTER_INTERCONNECTS parameter does not work

3917158P ORA-29740 and a false instance eviction can occur

4063079PI Linux: Installing 9.2.0.6 Patch Set installs old "oracm" version

2000938 A process may dump in kjrgpar in OPS/RAC if an ORA-4031 occurs

2818800 OERI[kjzcwaitX] may occur in RAC

2858082 False ORA-1652 in alert log when there is free space in RAC environment

2881246 Incorrect OERI[kcblibr_1] / OERI[kxttdropobj-1] can occur

2960012 Incorrect (large) 'logons current' in GV$SYSSTAT in RAC

3032886 OERI[kjatioc:!ver] possible in RAC

3048658 OERI [ksires_1] [BADOPTIONS] in RAC

3139157 SMON may fail with ORA-601 lock conflict

3223344 OERI[kclswrite_3] possible in RAC environment with multiple DBW processes

3224546 ORA-12564 from CMAN in a RAC with listener load balancing

3495448 OERI[ksxpcncl3] possible in RAC

3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory

3506641 Dump [kcbhfake] possible during STARTUP in RAC

3565660 OERI[kclrinit_3] from parallel recovery in RAC

3610343 OERI:[ktbdchk1: bad dscn] in RAC

3614008 OERI[kjcs_m:2]

3641819 Undetected deadlock possible in RAC

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

3752329 OERI[525] on [kjct flow control latch] in RAC

3777178 TA / US enqueue deadlock during transaction recovery in RAC

3799470 RAC LMD crashes instance with dump in kjddgmak

3801483 Instance hang possible in RAC

3830972 DBMS_AQ.LISTEN on RAC cluster may not see new enqueue messages

3832099 OERI[kcbgtcr_13] can occur in RAC

3843318 OERI[ksxpwait10] / hang possible in RAC

3849323 LMD may dump [kjddgpop] during deadlock detection in RAC

3857050 LMON leaks memory when another instance leaves or join the cluster

3857903 LMS not posted by LGWR when hot current block requires a log flush during BAST

3875155 RAC startup with SVRCTL / GSD may dump / cause connections to fail

3885860 Latch contention form. concurrent reconfiguration and SYSTEMSTATE dump

3889123 DB_FILE_MULTIBLOCK_READ_COUNT higher than 16 blocks has no effect in RAC

3905430 SMON reports ORA-604/ORA-16000 errors when standby DB is opened read only on RAC

3906669 LMS may fail with OERI[kjbmpclo:cvt]

3910149 Very small SGA memory leak in RAC environments

3917476 OERI[2652] in LMS process

3925815 OERI[kjccfmb:x!] possible in a RAC environment

3934961 FAL process does not fetch archivelog from RAC primary when instance down

3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration

3969563 Hang possible waiting for 'ges inquiry response'

3975816 OERI[kjbrref:!ini] in RAC

3992847 Deadlocks are not detected in rac when one node rebooted more recently than the rest

3998408 RAC instance may crash with OERI:kcsbcscn13

4012318 ORA-27509 after bad interconnect message

4017042 DIAG may loop and keep trying to contact remote instance

4048234 "kjbhistory[0x0.0]" in DBWR trace files in RAC environments

4058532 OERI[17183] from kjxgfhc in RAC

4068333 OERI[kcllrem_2] can occur crashing the instance

4074953 Insert performance problems with ASSM in RAC environments

4104619 DIAG may fail with OERI[17182] during dumping of information

4110284 Enhanced diagnostics for send timeout problems

4131721 Process may fail with OERI:kjsmbesmi1 in RAC

4145827 Dump (skgxpdmpctx) possible in RAC after communication error

4147870 Dump possible (in kjccdel) during shutdown or process abort

4164790 Excessive diagnostic trace may be output when not expected

4172065 OERI[kjbmperr:1] possible in LMS in RAC environments

4204954 OERI[kjbcrtpi:piscn] / RAC instance crash

4220161 Deadlock between SMON processes on different instances

Read Only Database

3905430 SMON reports ORA-604/ORA-16000 errors when standby DB is opened read only on RAC

Replication

3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group

4055881 CREATE_SNAPSHOT_REPOBJECT can be slow

4140264 ORA-3117 can occur during replication push for NULL BLOB columns

Resource Manager

2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL

3870235 Hang waiting for "enqueues" latch when using Resource Manager

Row Level Security / FGA

3467622 ORA-4063 during import of RLS policy on view

3624708 Select with SAMPLE clause returns all rows with FGA policy

3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing

3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063

3864444 Multiple aud$ records are inserted when regular audit and FGA are enabled

3921848 Dump (vopscv) when more than one RLS policy is defined on a table

4143213 Intermittent wrong results from VPD policy not based on application context

Shared Server (formerly MTS)

3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS

3771508 OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server

3839202 OERI[kpndsci-11] using XA with database links

3934729 Random dumps (nstimexp) using DCD with shared servers

3940774 Shared server may dump (in opiexe)

3964487 Java stored procedure can corrupt memory in MTS

Spatial Data

2727824 SDO_WITHIN_DISTANCE fails with 2D window against 3D data indexed 2D

3532846 Dump (kditdes) / Dump (ktaftt) from concurrent SDO_RELATE operations in MTS

3583686 Memory allocation error during spatial query with local partitioned index

3864033 ALTER INDEX of a Spatial index clears storage parameters not specified in the DDL

3923253 SDO_GEOM.RELATE result 'disjoint' / 'overlapbdyintersect' depends on tolerance

3924156 SDO_WITHIN_DISTANCE returns false positive comparing polygons

4057458 SDO_GEOM.SDO_CONVEXHULL gives wrong results

4121712 SDO_INTERSECTION gives null result if linestring with circ. arcs involved

4161498 **PARE may dump

4199456 SDO_GEOM.SDO_INTERSECTION can give wrong results

4242616 SDO_GEOM.RELATE returns different results depending on tolerance

4258719 SDO_RELATE can return wrong result with a point inside a polygone

Streams / Logical Standby

2785957 Streams CPU overhead for LCRs with non-final ADTs and collections

3427396 Logical standby apply may dump (kkttrex)

3465760 OBJECT_OWNER of some DDLs are not captured (eg: dimension, operator, library)

3598358 Streams propagation may fail (OERI:kwqpbqdeqr: deq)

3617406 Partial dictionary dump in redo stream considered complete

3631915 Logical apply errors with OERI:kdogsli1 and ORA-1332

3643786 RMAN delete input breaks LOCAL_FIRST archiving

3697371 Logical standby apply may fail with OERI:knaslod:ipoc

3775570 Dump [memcpy] ORA-12805 during Logical Standby apply

3816608 ORA-1403 occurs when applying an update on a wide table without primary key

3845457 Mining redo for parallel partition maintenance slow

3878509 Logminer excessivly slow when object definition is not in dictionary

3881099 ORA-1280 diagnostic enhancement

3889767 Logminer/logical standby may incorrectly handle age-spilled transactions with rollback

3895546 Capture may dump after certain DDLs

3903913 Streams spill data hard to decode

3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby

3917977 Upstream capture fails intermittently on log file reuse

3918228 OERI [krvuam1] in capture parallel processes

3928153 "alter database [stop | abort] logical standby apply" hangs

3934198 Logical bystanders are not junked on a logical failover

3945264 Dump (knaspd) in apply process for mismatched column

3953131 Altering first_scn of Streams capture results in ORA-30036 / ORA-1562

3960844 Switch to logical standby may not see active PLSQL changes (data missing)

3988801 Dump (ldxsto or lxhasc) in Logical standby apply

4002317 Streams blocked by unwanted very large transaction

4051461 Cannot create change tables on logical standby system

4060997 ORA-26689 in Streams Apply if NLS_SORT is not set to binary

4061535 Dump (knlcinlinedata) in capture process

4091906 Incorrect supplemental logging possible for trailing null columns

4096261 Missing direct loaded LOB data in Streams

4096561 Logminer creates partitions with nologging option

4122757 OERI:knacsrb4406 on logical Standby

4166926 Additional advice needed for "Missing MVDD" Streams warnings

4174973 Active DDL count maintained incorrectly for certain redo patterns

4180233 Logminer age spill table may not be cleaned up properly

4180772 Supplemental logging may fail for updates of cluster tables

4196764 OERI[ktcdso-1] in logical standby apply

4215166 Capture aborts without useful trace information

4313465 DBMS_APPLY_ADM.SET_KEY_COLUMNS() fails

Transportable Tablespaces

2855241 Transport of a tablespace with a HASH partitioned IOT fails during import

3533996 Using transportable tablespaces disables intra-partition PDML

3617574 Transport of bitmap index gives errors at transported to site

3941862 ORA-16132 during regular graceful failover

4016802 Incorrect export produced for transport of composite partitioned table

4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911

XDB

3883156I ORA-6502 from DBMS_XDBZ0.MIGRATE_PITRIG when patching to 9.2.0.5

2307997 OERI [kolaHashFind:hash table] from SELECT xmltypeview over a database link

2549858 ORA-904 during import of XML table with VARRAY

2549870 Import errors (ORA-904) importing XML table with "STORE AS CLOB" clause

2759457 Schemas with inherited types not handled properly (LPX-224)

2768250 OERI[17147] from SELECT of an XML base64Binary type

2884318 ORA-4021 possible upgrading XMLType / XMLTypePI

3026546 False ORA-29907 possible

3116865 Various dumps can occur using XML clonenode

3325825 Cannot store document if schema has restriction of complextype with attributes

3339088 Dump (qmtGetSqlTypeInfo) creating schema based XMLType view

3396792 Dump (qmxtrRewriteOpn) using XDB

3475559 Lost element and attribute value when UpdateXML an XML document using IDREF

3487029 Java method dbms_xslprocessor.setParam does not process parameter properly

3575797 XMLSchemas and types are not exported in table and tablespace mode export

3626425 Export of schema based XMLType may dump

3841861 LPX-225 after using DBMS_XMLGEN.CONVERT(...ENTITY_DECODE)

3872147 OERI[qmxsqloadns] on insert into XML table with empty default namespace

3880405 DBMS_XMLDOM.setnodevalue does not change the nodes value

3930499 AQ propagation of XMLType throws OERI[kolahashfind:hash table]

3955790 XmlElement limited to 30 characters for tag name if used in a subquery

3970412 XDB downgrade to 9.2 may dump

4025594 updatexml adds extra whitespace with each update

4032320 Insert of valid XML document fails with ORA-30930 error

4052380 Passive mode connection to XML DB FTP server does not work

4093818 Memory leak using DBMS_XMLDOM.newdomdocument and DBMS_XMLDOM.freedocument

4093962 toObject fails with ORA-19029 when XML data contains CDATA

4128348 No API to get / set XDB HTTP / FTP port

4132901 Dump selecting from schema based table

4154611 ORA-22992 can occur for distributed XML queries

4156695 Values of XML 'long' element are stored incorrectly in schema based table

4240116 Dump (lxu4property) can occur in XDB shared server

interMedia (Image)

4175251 Performance problem in image matching code

Programming Languages

JDBC

2055862 OracleCachedRowSet.getRow() returns wrong value after last()

2925619 JDBC Thin always default timezone to +00:00

3038630 OracleConnectionCacheImpl.closeSingleConnection does not work properly

3041932 JDBC string to number conversion incorrect when precision specified

3403912 Soft reparse can occur for JDBC statements picked up from the cache

3487029 Java method dbms_xslprocessor.setParam does not process parameter properly

3498977 Poor performance handling VARRAY / ADTs from JDBC

3890992 JDBC XA error -3 returned when rollback with invalid timeout xid

3906221 JDBC binds as a TIMESTAMP when V8Compatibility is true for NULL bind values

3925069 Wrong COLUMN_TYPE returned by getProcedureColumns for a Date parameter

3941059 JDBC OCI connections hang if NAMES.NO_PERSISTENT_RESOURCES enabled

3946694 XA recover throws ArrayIndexOutOfBoundsException

3948754 ArrayIndexOutOfBoundsException using JDBC Thin with FAILOVER clause

3957152 ORA-1401 inserting data over 444 multi-byte characters via a database link

3957791 getObject() shows TIMESTAMP column as DATE (ORA-1483)

3965969 JDBC statement caching uses lots of memory

3978027 Exception not thrown when using handleODBC()

4007340 ArrayIndexOutOfBounds after an ORA-1008

4022772 JDBC statement may not be cached

4055118 Unexpected JDBC character conversion exception for invalid characters in ADTs

4057147 JDBC OCI returns invalid argument exception when binding over 64kb array

4063081 JDBC through HS returns ORA-3001 with inserting data over 1000 bytes long

4063582 setQueryTimeout() method does not work for resultSet.insertRow()

4065814 JDBC driver using XA returns XA_RMERR when a deferred constraint is violated

4128146 CallableStatement bind buffers are not cleared on cache entry

4187593 NULL data is not inserted correctly using a PLSQL table via JDBC

4318266 Default value of escape processing in CachedRowSet is wrong

4352928 Java LOB locators are pickled incorrectly

OCCI

3015647 Multithreaded OCCI client can fail in kputac with OCI-21500[17099]

3720988 Wrong values after OCCI setNull of number varray / vector values

3853332 OCCI client memory leak using statement::setString()

3924164 OCCI using collections with array insert may dump (ttca2p)

3946819 OCCI definition of THREADED_UNMUTEXED is wrong

3992072 ORA-1461 / ORA-2005 inserting a column after setNull() in OCCI

OCI

2733910 Client side dump can occur during OCISessionEnd()

2736591 OCI-21500 [KGHALO2] with large value_sz values for OCIDefineByPos

3417936 Client may dump / error (kpuhhfre)

3453969 Dump (ttcc2u) with with array / null binds

3774546 OCILobRead may dump in kghalo() if there is character set conversion

3796771 Server spin in multibyte from DESCRIBE operation

4073796 OCI client may dump under OCISessionGet when a network error occurs

4102426 Dump (in upidpr) during socket write errors

4216597 ORA-1036 from OCIDirPathPrepare in OCI_UTF16 mode

4369117 OCI direct path out-of-line LOB insert slow

PL/SQL

2487943 Bulk insert in PLSQL may dump (kprcdt / memcpy)

2535150 Executing stored procedure using "CALL" does not use parallelism

2688315 Compilation of ILTypeMgr.java fails on some platforms

2785463 PLS-306 with PLSQL procedure using ORDER BY clause of XMLAgg

2883771 "WAITED TOO LONG FOR ROWCACHE ENQUEUE" when using Resource Manager in PLSQL

2966778 Intermittent ORA-904 errors during heavy load

3083373 ORA-905 when using an analytic clause in SQL within PLSQL

3218825 Memory leak when Java Stored Procedure executed from PLSQL

3635302 OERI[12762] possible executing PLSQL

3637267 Varchar2 is blank padded when local DB charset is different from remote site

3639361 ORA-3106 passing oversized VARCHAR2 ADT attributes between SQL <-> PLSQL

3692370 UNISTR builtin function produces incorrect results when given NCHAR input

3701730 Memory leak executing PLSQL or Java calls repeatedly in a single user call

3711772 OERI 15440 from PLSQL RPC which raises an unhandled exception

3744836 ORA-4043 on SYS_PLSQL_%s_%c from DROP of a versioned object

3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables

3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i

3794969 BFILE locator takes up maximum length rather than actual length

3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes

3845698 Dump (kkxmgifa) possible with user defined function in complex SQL

3872410 Corrupt PLSQL collection after copying empty collection

3875506 ORA-2019 executing PLSQL block over a private database link

3906305 PLSQL Execute of SQL using extract() gives OERI [koksghds1]

3931444 Client PLSQL loads Diana for STANDARD in client runtime environments

4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics

4031272 ORA-6502 using collection tables in PLSQL

4036717 Truncate table in exception handler can causes OERI:kcbzwb_4

4078970 ORA-907 using nested FULL OUTER JOIN in PLSQL

4116896 ORA-932 using extractValue() in SQL inside PLSQL

4130852 ORA-6502 using DBMS_SQL with a RETURNING INTO clause

4159827 PLSQL concatenation (||) involving a CASE statement may be corrupted

4175224 PLS-801 [79110] when subtype is based on cursor%rowtype

4188078 Native mode RAISE_APPLICATION_ERROR does not replace all previous errors

4217038 Load without compile of wrapped PLSQL uses multiple SOURCE$ rows

PL/SQL (DBMS Packages)

3102211 DBMS_METADATA does not recognise materialized view logs

3225530 DBMS_METADATA fails to generate complete definition for a domain index

3397761 DBMS_METADATA does not put a SQL terminator in CONSTRAINT definitions

3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long

3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats

3653586 DBMS_METADATA.GET_DDL performance very slow

3732747 False ORA-1007 using DBMS_SQL.DEFINE_COLUMN

3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used

3865157 OERI [kkzumco2:4] using DBMS_REDEFINITION with more than 10 constraints

3879082 Performance improvements for DBMS_STATS running in auto sample mode

3903530 UTL_HTTP HTTPS via proxy server requiring user authentication fails with ORA-29268

3974771 UTL_HTTP.SET_AUTHENTICATION fails in EBCDIC database

4088212 DBMS_OBFUSCATION_TOOLKIT.DES3GetKey performance problem

4130852 ORA-6502 using DBMS_SQL with a RETURNING INTO clause

4131045 Add DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY

4204326 Cursors with TABLE() expressions no shared when USE_STORED_OUTLINES set

4245958 Dump (pirg2bi) with zero length raw input to UTL_RAW.cast_to_binary_integer

PL/SQL External Procedures (EXTPROC)

2363758 Returning NULL from an EXTPROC callout may dump

3964817 Memory leak in external procedure for OBJECT arguments

Pro* Precompiler

3453969 Dump (ttcc2u) with with array / null binds

3632504 Wrong results from EXEC SQL LOB READ from NCLOB

3678342 ORA-12158 during EXEC SQL CONNECT multithreaded code

3792845 MODE=ANSI client may get error 100 instead of correct error

3796771 Server spin in multibyte from DESCRIBE operation

3858017 Array insert with "EXEC SQL FOR" gets wrong value for SQLERRD[2]

3858625 Insert of long over DB link with NULL binds may ORA-24343

3864781 SQLGLMT does not return error message with run time contexts in Pro Cobol

3986614 XA client with database links repeatedly closes the database links

4067938 Multi-threaded ProC client may dump when using connection pooling

4082618 EXEC SQL ARRAYLEN does not work for length 0

4147836 EXEC SQL ENABLE THREADS leaks memory in the Pro client

4156131 SQLSTATE errorcode wrong when RELEASE_CURSOR=YES

4202929 ORA-905 from ProCobol code CASE-WHEN SQL

4288355 Cobol code with END-EXEC with a space before the PERIOD fails with PCB-00400

XDK

2821451 XDK may dump in qmxGetNumAttrs

3234257 The Regular expression parser is broken in the XML schema validator

3242885 schemaValidate fails with LSX-213 for XML documents with a 'choice' tag

3343899 XSDException parsing valid XML

3781853 XML parser does not allow parameters containing simple quotes (XML-1026)

3785167 JXDocumentBuilderFactory.isNamespaceAware always returns true

3867413 LSX-171 when registering certain XSD

3876508 elementFormDefault which is qualified is treated as invalid

3883840 XMLParseException "ID value XX is not unique" parsing document twice

3912435 OERI[kokegpinlob1] / OracleXMLSQLException from DBMS_XMLSLAVE

3935384 PLSQL XMLparser returns ORA-20100 when parsing UTF-16BE documents

XML

2307997 OERI [kolaHashFind:hash table] from SELECT xmltypeview over a database link

2785463 PLS-306 with PLSQL procedure using ORDER BY clause of XMLAgg

2974848 GetElementsByTagName in DBMS_XMLDOM returns nodes in wrong order

3339967 Text Xpath expression with positional predicates should raise a parse error

3575797 XMLSchemas and types are not exported in table and tablespace mode export

3880405 DBMS_XMLDOM.setnodevalue does not change the nodes value

3906305 PLSQL Execute of SQL using extract() gives OERI [koksghds1]

3928478 OERI[kkchbyt : bfc] using extractValue() and substr()

4025594 updatexml adds extra whitespace with each update

4093962 toObject fails with ORA-19029 when XML data contains CDATA

4112035 ORA-972 on XmlType view if identifier greater than 30 characters long

4116896 ORA-932 using extractValue() in SQL inside PLSQL

4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses

4162383 Create Text index on XML fails with DRG-50857/ORA-1480

Product Related

DBVerify Utility

3571244 dbverify does not report "marked corrupt" blocks in its summary

Export/Import

2375764 Export fails with ORA-1455 if leaf_blocks or distinct_keys >= 2^31

2549858 ORA-904 during import of XML table with VARRAY

2549870 Import errors (ORA-904) importing XML table with "STORE AS CLOB" clause

2820067 ORA-1455 during export if some statistics are over 2^31

3467622 ORA-4063 during import of RLS policy on view

3575797 XMLSchemas and types are not exported in table and tablespace mode export

3591564 ORA-1756 importing functional index with CHR(0) in its expression

3626425 Export of schema based XMLType may dump

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"

3798351 Importing a pre-existing table may DROP the table on an error

3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes

3868753 Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103

3946544 EXP-62 if the header of a wrapped TYPE contains a comment

4015652 Nested Table export fails with ORA-1007

4016802 Incorrect export produced for transport of composite partitioned table

4018783 OERI [12333] on import of table with a LONG column

4047608 Export/import can loose the LOGGING attribute of LOB columns

4085785 OERI[6191] on compressed partition direct export

4089843 Export of table with OLS policy does not export "label function" properly

4154125 Export writes bad SQL to DMP file for XMLTYPE tables with DEFAULT clauses

Intelligent Agent

3614514 "chunk small" event is always detected for locally managed tablespaces

3697528 Archive Full event fails on VMS platforms

3718353 Multiple listener up/down event generates defunct processes

LDAP / Oracle Internet Directory

2818054 LDAP C client may hang in ldap_result() after a modifying an entry

2876095 OID hangs when trying to log a new connection

3046975 LDAP connect/bind slow and can hang when executed in multiple threads

3105389 ldap_init_SSL() does not return error on wrong wallet location

3106241 oidldapd server may hang / leak connections

3259935 ldap_search_s() fails for filter containing a DN having a "," special character

3264021 New DBMS_LDAP interface needed for large binary attributes

3546906 Dump (free) using LDAP functions in Java

3588307 DBMS_LDAP_UTL.get_group_membership ignores groups based on groupOfNames

3789117 Util.getGroupMembership may not return all groups the user is member of.

4118463 DN of failed logons from externally authenticated LDAP accounts not audited

4192421 OPATCH can hang applying some LDAP patches

Portal (MOD_PLSQL)

1834440 Value of CGI variable REMOTE_USER is not logged to Apache logfiles

2023253 File containing 0x5c in its filename not uploaded properly

2058076 Portal cannot upload files when CURSOR_SHARING=FORCE

2244996 Post request for a protected page gets an unexpected HTTP 404 error

2269177 mod_plsql authentication denied when user account is in grace period

2296624 mod_plsql does not refer to modplsql\cfg\xxx directory when displaying error page

2356701 MOD_PLSQL performance logs should log the shadow process id on the server side

2450776 Package init blocks not called after custom global authentication disallows request

2526511 Request failed: URI too long when uploading a Doc file into a content area

2536535 Per package auth of PLSQL gateway calls the wrong authorize() function

2586649 Upload of two files at same time can corrupt second file

3430103 HTTP-414 error when uploading a file via modplsql

RMAN (Recovery Manager)

4074603+ RMAN backup of primary with a standby using FAL may omit archivelogs

2391697 ORA-235 doing backup with RMAN in nocatalog mode

2749174 Auto addition of standby datafile prevents RMAN backup from running

3567953 RMAN connect fails with ORA-7607 with AUDIT_SYS_OPERATIONS set

3643786 RMAN delete input breaks LOCAL_FIRST archiving

3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up

3861505 RMAN does not resync archivelogs produced before switchover

3966722 Concurrent RMAN backups wait on TM enqueue on CKP table

3992314 Non SYSTEM temporary tablespace causes problems for RMAN DUPLICATE

4013855 RMAN crosscheck is slow

4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911

4037606 REPORT OBSOLETE does not report archives when a tablespace is read-only

4115175 ORA-17510 doing backup to disk using veritas odm and large files

SQL*Loader

3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data

3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS

3678149 Direct SQLLOAD may dump (klctrx)

3697185 Index maintenance printed only for first table when loading multiple tables

3743437 Corrupt packed decimal data loaded by SQLLDR conventional path

3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data

3788530 OERI[kohdtf048] with sqlldr direct load with a PLSQL function

3823608 Conventional path load may load incorrect scale/precision for numbers

3833809 Direct load with code conversion can fail with OERI[klaevc_01]

3866720 SQL*Loader-709 occurs during direct load on multi-CPU machine

4006142 SQLLDR may dump in ulfdck

4157832 SQLLDR direct path SQL expressions can load NULLs into NOT NULL columns

SQL*Plus

3908083 SQLPLUS COPY truncates long data with gateway connections

4179282 SQLPLUS need not "select null from dual for update nowait"

Ultra Search

3169422 Ultrasearch crawler does not support lower case characters in table names

3838020 Resource leak when crawling table source with temporary LOB content column

3936668 Ultrasearch validation procedure schema incorrect

3988310 Titles in the query page are intermittently replaced by the URL

4066157 SSO "orcladmin" does not have Ultrasearch superuser privileges by default

4113097 Crawler does not recognize "meta" tags in lowercase.

Wallet Manager

3604730 OWM cannot import certain valid intermediate root CA

3801580 OWM cannot load certificate with CRL Distribution Points extension

3917026 User certificate with CRL extension with duplicate policies fails to import into OWM

3924904 OWM cannot import certain certificates

Miscellaneous

Miscellaneous

3210747 SHUTDOWN IMMEDIATE can fail with OERI[1402]

3515760 TS enqueue may be gotten in wrong mode for ALTER TABLESPACE commands

3552759 Unexpected trace output shown for dynamic optimization

3639594 PMON clean up of an in-progress "alter system set parameter"

3772528 OERI[534] possible if ORADEBUG is used to dump a processes ERRORSTACK

3817792 OERI[6100] while coalescing an index

4026115 Free buffer may have holders/waiters if process is killed

4032462 Event 10360 causes DBW to fail with ORA-1115

4088976 KST trace may use wrong directory name

9.2.0.7 Special Notes (if any)

No Bug# *     Fixed: 9.2.0.7
Security Or Service Denial Vulnerability

This is a marker for the collection of fixes
included in Critical Patch Update (Apr 2005).
See <Note:301040.1> on Metalink

No Bug# *     Fixed: 9.2.0.7
Security Or Service Denial Vulnerability

This is a marker for the collection of fixes
included in Critical Patch Update (Jul 2005).
See <Note:311034.1> on Metalink

Oracle BUG列表

Notable exceptions and omissions

Security Alert Issues fixed in the 9.2.0.7 Patch Set

9.2.0.7 Bug Categories

9.2.0.7 Bug Fixes by Category

Symptom

Task Related

SQL Commands / Features Used

How Things Are Stored / Defined

Net / Connectivity / Authentication / Distributed

Database Options / Major Features

Programming Languages

Product Related

Miscellaneous

9.2.0.7 Special Notes (if any)

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)

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

4055881	CREATE_SNAPSHOT_REPOBJECT can be slow
4369117	OCI direct path out-of-line LOB insert slow

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

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

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

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

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

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

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

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

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

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