Bookmark Go to End

Doc ID: Note:308894.1
Subject: 9.2.0.7 Patch Set - List of Bug Fixes by Problem Type
Type: README
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 12-MAY-2005
Last Revision Date: 22-JUL-2005

Bugs fixed in the 9.2.0.7 Patch Set

  • 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. 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 Categories



9.2.0.7 Bug Fixes by Category



Symptom


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)
4053888 ORA-1499 diagnostic trace does not dump REDO for the table block
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

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

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)

Fix Is Considered An Enhancement
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
4053888 ORA-1499 diagnostic trace does not dump REDO for the table block
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
4183830 Enhancement to diagnostic dump routine (add ksxpdmp)

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

Hang (Process Spins)
3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
3300215 Parse of an OUTER JOIN on nested tables spins
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.
4131501 Parse of query may spin when STAR_TRANSFORMATION_ENABLED = TRUE
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
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
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
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
3333863 DBA_JOBS.LAST_DATE is set even if the job runs with failures
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.* error after adding table columns
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
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
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
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
4147870 Dump possible (in kjccdel) during shutdown or process abort
4156916 Dump / wrong results from TO_DATE without a full date format mask
4161498 SDO.COMPARE may dump
4165093 Dump (in kkocpr) for SQL over database link
4167403 Dump (kglobcl) using PGA_AGGREGATE_TARGET with SESSION_CACHED_CURSORS
4178560 Complex view merge of DISTINCT view may dump
4197878 Dump in msqopnws for some SQL
4237009 Dump (kkooqb) with star transformation
4245958 Dump (pirg2bi) with zero length raw input to UTL_RAW.cast_to_binary_integer



Task Related


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

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

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

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



SQL Commands / Features Used


ANSI Joins
3136807 Wrong results querying against snapshots with ANSI outer join
3228560 OERI[qkebValidateOpn:2] / 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
3300215 Parse of an OUTER JOIN on nested tables spins
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

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

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)
4131501 Parse of query may spin when STAR_TRANSFORMATION_ENABLED = TRUE
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


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
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

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..
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

Job Queues
3333863 DBA_JOBS.LAST_DATE is set even if the job runs with failures

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

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
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

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 SDO.COMPARE 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 upplemental 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)
3007398 DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY parameters are not case sensitive
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
3007398 DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY parameters are not case sensitive
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
4088976 KST trace may use wrong directory name

9.2.0.7 Special Notes (if any)


No Bug# *     Fixed: 9.2.0.7
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
This is a marker for the collection of fixes
included in Critical Patch Update (Jul 2005)..
See <Note:311034.1> on Metalink

End of 9.2.0.7 Fix list
.

Copyright © 2005, Oracle. All rights reserved. Legal Notices and Terms of Use.