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

 
TIP:  Click help for a detailed explanation of this page.
Bookmark Go to End

Subject: 11.1.0.7 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:601739.1 Type: README
  Last Revision Date: 19-SEP-2008 Status: PUBLISHED

Bugs fixed in the 11.1.0.7 Patch Set

  • See Note 454507.1 for Support Status and Alerts affecting 11.1.0 releases.
This note lists the customer bugs fixed in the 11.1.0.7 Patch Set. Bugs are listed by product. RDBMS (Server) bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a Support Bug Description.
  • '*' 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].
  • The term "Undocumented" is used to indicate bug fixes for which there is no published description of the issue/fix.

Notable exceptions and omissions

  • Enterprise Manager / Database Control fixes are NOT listed.
  • Port specific bug fixes are not usually listed .

Security Alert Issues fixed in the 11.1.0.7 Patch Set

Fixed Bug# Security Alert# Document Summary
11.1.0.7 - / - Note 467881.1 Critical Patch Update (Apr 2008)
11.1.0.7 - / - Note 467881.1 Critical Patch Update (Jul 2008)

11.1.0.7 Bug Categories



11.1.0.7 Bug Fixes by Category



Oracle Server


ANSI Joins
5031632 Wrong results from NATURAL JOIN
6471020 ORA-1790 or ORA-904 from FULL JOIN
7249290 Wrong results from virtual column in select list of ANSI join

ASSM Space Management (Bitmap Managed Segments)
6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6376915 HW enqueue contention for ASSM LOB segments
6413373 Lob HW enqueue contention
6474009 On ASSM tablespaces Scans using Parallel Query can be slower than in 9.2
6730429 ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN
6844739 ASSM Truncate very slow even with fix for bug 6086497

Advanced / Secure Networking
6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

Advanced Queuing
5457450 Excessive polling of the aq$_<qtab>_f queue table view from dequeue by condition
5933656 OERI[kwqpcbk179] from AQ
6044513 Cannot dequeue a message with a correlation padded with spaces
6049324 Memory leak from array dequeue
6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
6143688 node startups cAN spend up to 2 mins in AQ partition code
6151536 Altering max_retries can cause orphan messages
6280961 OCCI AQ client dumps on FAILOVER
6341494 Invalid property name JMSXRcvTimestamp specified for OJMS messages
6633347 ORU-10027 from expdp
6750302 OCI AQ listener client may dump

Analytic SQL (Windowing etc..)
5622851 Wrong results from CONNECT BY with GROUPING SETS
6051782 Wrong results using GROUPING SETS with ORDER BY and DISTINCT
6315495 OERI[qctstc2o1] / OERI [kkqtcpopn: 0] optimizing subquery inside subquery
6402957 Suboptimal parallel query performance for Top-n rank queries.
6878200 Dump possible from query with window / group by or sort nodes

Application Context
6005762 SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

Automatic Memory Management
6275904 ASM does not start of AMM enabled

Automatic Storage Management (ASM)
4693355 ASM does not close open descriptors even after DROP DISKGROUP
6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
6163771 Mounting a diskgroup fails with error ORA-600 [kfcema02]
6264570 Slow file creation in ASM if EM is running
6270137 Unnecessary acquisition of the list header block in ASM
6275904 ASM does not start of AMM enabled
6278034 Poor performance when ASM disks are OFFLINE
6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6361755 OERI:kfioRqTracer_insert:01 in ASM after an exception
6367360 Long ASM file open times
6399504 Offline after FORCE DROP causes staleness registry corruption
6453944 ORA-15196 with ASM disks larger than 2TB
6468666 High redundancy diskgroups do not tolerate loss of disks in two failgroups
6469211 Slow startup with many log files on ASM
6487591 ASMCMD cannot restore alias directories
6493270 ASM does not resync disk properly if it is offlined due to a disk open failure on write
6494961 OERI:kfcemk10 on ASM diskgroup mount
6522708 ASM instance may hang
6597063 OERI [kfrpass2_03] can occur in ASM
6605106 OERI:kfclUpdateBuffers20 due to accessing an ASM null converted buffer
6639330 OERI:kfbupdate05 after drop ASM disk
6639644 ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC
6674673 ASM corruption after IO error with redundancy
6769870 ASMCMD LSDSK does not show values of bytes_written
6925708 OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance
6934230 Instance crash from OERI:kfnmClientRegister05 with ASM

Bitmap Indexes
6110752 OERI[[qerbuNStrp:eridgt] from parallel bitmap merge
6313035 OERI[kdibc3position] from "bitmap merge" row source
6399168 DBMS_STATS can be slow for large table with bitmap indexes
6525496 Wrong results (no rows) from BITMAP operation on functional index
6642751 Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid
6653704 Dump (evaopn2) from nested loop join with bitmap access to functional index
6694548 Suboptimal execution plan using bitmap full index scan
6833602 Wrong results with BITMAP OR

Change Data Capture
6501817 No rows from DBA_SOURCE_TABLES with CDC

Cluster Ready Services / Parallel Server Management
4587300 Improve CRS shutdown sequence
5629557 CRS does not receive reconfig from CSS on SAN failure
5893629 crsd dumps after being unable to delete backup OCR file
5926147 malloc() memory corruption errors from CRS
6074454 Service resource does not become offline when VIP does failover
6165289 Default service is not set to service_names when crsd.bin is killed
6219072 CRS-233 can occur on crs_stop -f
6401902 CRSD dumps during OS reboot
6436734 OCR timeout for releasing unresponsive session is too long
6486564 Lack of symbolic stack trace for ocssd.bin or other executables
6899183 srvctl can fail with PROC-9

Code Improvement
2227223 ALTER TABLESPACE READ ONLY waits for all active transactions to complete
6522622 Allow external tables to be pre-processed
6688108 Enhancement: Allow ORA-1555 to be ignored during table scan
6708183 CBO cannot get good cardinality estimate for TABLE() functions
6718212 enhancement to dbms_stats to merge column usage statistics from remote system

Compressed Data Storage
7123643+ Wrong results (NULL) from select on compressed table
6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
6374297 Drop column on a virtual column gets ORA-39726 with fix for bug 6268371
6512811 ORA-39726 adding column to table after it is uncompressed (by ALTER TABLE .. MOVE)

Connect By / Hierarchical Queries
5284200 Suboptimal plan from SELECT DISTINCT with CONNECT BY
5622851 Wrong results from CONNECT BY with GROUPING SETS
6073325 OERI[kkqcbydrv:1] from CONNECT BY
6244173 Dump (qeesTraverseExpr) from CONNECT BY with NOT BETWEEN
6282093 Cost based CONNECT BY does not OR expand START WITH
6282944 Poor CONNECT BY performance with complex views
6333108 Wrong results (duplicates) from CONNECT BY query
6521934 OERI[qkacon:FJswrwo] from CONNECT BY query
6643093 Wrong results from CONNECT BY and WITH clause
6679575 Wrong results from CONNECT BY and WITH clause
6729992 OERI [qkacon:fjswpri] during CONNECT BY query

Constraint Related
5131180 Wrong NLS settings after querying tables with DATE related constraints
5523375 expdp does not export disabled PRIMARY KEY constraints
5851267 Dump / false constraint violations on DML with trigger
5885265 Deferred constraints may incorrectly error at commit for IOTs
6175584 Insert hang with Foreign Key constraint and read-only tablespace
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints
6474004 DBMS_METADATA GET_SXML output does not show RELY for a table constraint
6523114 ORA-1502 on MVIEW complete refresh with UNIQUE constraint
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Corrupt/Bad Backup
6084232 Corrupt datapump export of encrypted column data

Corruption
5923486 SPFILE streams pool / buffer cache parameters may be changed
6086497 OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints
6361755 OERI:kfioRqTracer_insert:01 in ASM after an exception
6405339 Corruption / OERI[kcbz_check_objd_typ_3] / OERI:5400 from PQ
6453944 ORA-15196 with ASM disks larger than 2TB
6471351 Invalidation redo generated under database force logging mode in RAC
6493270 ASM does not resync disk properly if it is offlined due to a disk open failure on write
6667318 Space sign at the end of XMLElement values removed by XMLtype()
6684357 Change tracking at standby can miss changed blocks after a database crash
6760697 DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption
6764606 BACKUP of backupset fails if re-read is needed

Corruption (Dictionary)
5211477 Sequence starts with wrong value after expdp/impdp
5662283 CREATE or REPLACE view with FORCE can create a corrupt view definition
6430688 Property 0x800 of internal object type (SYS_YOID%) is lost after running utlirp
6430718 Wrong information in DBA_UPDATABLE_COLUMNS
6441665 OERI [kkpolpd12] / dictionary corruption from coalesce of composite hash partitioned table
6603249 Create interval partitioned table can insert bad dictionary interval data
6666915 OERI[25027] / dictionary corruption from concurrent partition DDL

Corruption (Logical)
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data
5667658 Wrong results / errors from flashback to SCN before segment shrink (affects MViews)
5685411 Updating columns to NULL in a trigger may have no effect
5874989 Datapump import can load data longer than column definition
5951099 Wrong data in materialized view with concurrent insert to master table
5988345 Update policy applied to more tables than is should for SELECT for UPDATE
6215662 Direct path SQL*Load swaps bytes during load of BINARY_DOUBLE / FLOAT between platforms
6343054 Corruption / errors from concurrent update/refresh on materialized join views
6346393 Import can load bad SYS.ANYDATA into the database
6458801 REPLACE on a CLOB can corrupt multibyte data
6703563 Wrong MV data after fast refresh of ROWID based materialized view
6756089 Floating point numbers in OBJECTs can loose precision > 5
6804815 Jobs in incorrect schema after datapump import
6826661 Wrong data in NUMBER column for specific FLOAT values (SQLT_FLT)
6994194 Logical corruption from UPDATE DML
7008262 Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Corruption (Physical)
6646613* IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note 471479.1
4527606 MOVE of IOT can cause corruption / OERI
6268371 ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
6674673 ASM corruption after IO error with redundancy
6730429 ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN
6795264 OERI:18127 / rollback segment corruption in RAC from global transaction

Database Link / Distributed
5223587 OERI[4400] from distributed PDML with DDL
5665531 ORA-22992 on select from remote table with local LOB variable
5976269 Queries using a loopback database link cannot execute in parallel
5977865 OERI:qerrmObnd1 from query over database link
6028753 ORA-907 / ORA-933 from DML over database link
6029071 Wrong results from distributed SQL with OUTER joins
6056659 ORA-979 from SQL with ORDER BY and BINDS over database link
6060280 Wrong results UNION ALL and database link
6155920 ORA-2063 / ORA-972 in subquery using database link
6163785 Intermittent Wrong Results with dblink and cursor_sharing
6318678 ORA-904 from MERGE SQL over database link
6351293 SQL may execute in wrong schema when using database links
6520125 ORA-904 from a select over a database link
6620988 ORA-904 from outer join query over database link
6621937 [NO]PARALLEL_INDEX hint not sent to remote site for SQL over database link
6718212 enhancement to dbms_stats to merge column usage statistics from remote system
6828981 Unexpected ORA-1461 from SQL over database link
6960874 ORA-1483 can occur with fix for bug 6828981

Database Replay
6336576 Replay takes longer than capture on RAC
6733318 Database replay client incorrectly replays timestamp data
7040652 Replayed workload generates different content than original workload

Datapump Export/Import
5158215 ORA-39023 / dump (kupfxinit) / ORA-39021 with SPACE character in COMPATIBLE parameter
5192493 IMPDP fails if dmp file contains an invalid Oracle number
5211477 Sequence starts with wrong value after expdp/impdp
5523375 expdp does not export disabled PRIMARY KEY constraints
5530086 EXPDP / DBMS_METADATA do not get TRIGGER data if DB_BLOCK_SIZE < 4k
5690152 Package comments not imported when using datapump schema import
5705160 Cannot impdp a table that has both LONG RAW and TDE encrypted columns
5747615 DBMS_DATAPUMP.DATA_FILTER filter INCLUDE_ROWS=1 does not export row data
5767565 ImpDP does not handle QUERY parameter with REMAP_SCHEMA set
5861640 ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index
5874989 Datapump import can load data longer than column definition
5891213 ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present
5944874 TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present
5961283 ORA-39779 from IMPDP if source database has 8i objects
6051635 Wrong DDL from DBMS_METADATA for domain index or index on XMLType column
6063940 Datapump export / import does not handle tablespace groups
6081425 impdp fails with ORA-1403 if table already exists
6082832 EXPDP does not mask ENCRYPTION_PASSWORD parameter
6084232 Corrupt datapump export of encrypted column data
6156708 expdp puts the index creation statements into dump in wrong order
6368018 Data pump import with compression=data_only fails (OERI:klaprs_12)
6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
6454237 Wrong output from DBMS_METADATA.GET_DDL for trigger definition with comment
6487005 impdp for AUDIT on DIRECTORY object fails
6633314 ORA-29358 from IMPDP
6633347 ORU-10027 from expdp
6635956 DBMS_METADATA / Datapump import fails with LPX-7/ORA-39125
6729716 expdp/impdp changes scheduler start_date (the year part)
6749942 Cannot use 11g expdp with NETWORK_LINK to 10g
6800507 Shared pool memory leak ("ksws service *" memory) using EXPDP often
6804815 Jobs in incorrect schema after datapump import

Datatypes (AnyData)
6346393 Import can load bad SYS.ANYDATA into the database

Datatypes (LOBs/CLOB/BLOB/BFILE)
5049352 DBMS_LOB.LOADCLOBFROM does not work on files over 4gb (ORA-22288)
5051432 DBMS_LOB does not execute with the privileges of the calling procedure
5665531 ORA-22992 on select from remote table with local LOB variable
6061623 OERI:qctcte1 from cost based transformation of INSERT as SELECT with TO_LOB
6082605 ORA-32036 while executing a WITH clause statement
6191877 OERI:kdlxSetEncxCtor-1 from MOVE of securefile LOB with encryption
6315003 Truncate table fails with OERI[ktsstrn-4]
6367945 OERI:kdliReadPos from securefile LOBs
6376915 HW enqueue contention for ASSM LOB segments
6412375 ALTER TABLE .. MODIFY LOB does not change PCTVERSION of BASICFILE/SECUREFILE LOB
6413373 Lob HW enqueue contention
6454763 Various OERI after recovery of SecureFile LOB buffers
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client
6607505 OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s
6620517 ORA-29308 from TSPITR with IOT with LOB column
6667800 OERI:12333 / client hang using OCILob() in multithreaded OCI client
6698457 Securefile LOB can over-allocate space
6873515 ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute
7008262 Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work

Datatypes (Objects/Types/Collections)
5308497 Dump (nsoexc) from natural join with correlation
5944121 OERI:kghufree_06 using collections with non-final type elements
5961283 ORA-39779 from IMPDP if source database has 8i objects
6029647 ORA-12714 accessing typed column from TABLE() function
6142534 OCCI getObject() fails to fetch null using isNull() from object with VARRAY
6165874 OERI[kksfbc-reparse-infinite-loop] after DROP / reCREATE of subtype
6430688 Property 0x800 of internal object type (SYS_YOID%) is lost after running utlirp
6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625
6661262 TTS expdp from 10.2 and impdp into 11g fails for Spatial or object tables
6708183 CBO cannot get good cardinality estimate for TABLE() functions
6756089 Floating point numbers in OBJECTs can loose precision > 5
6760382 Dump [evaopn2] from DML with triggers and functional index

Datatypes (TIMESTAMP)
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data
5437593 Millisecond value not present using TIMESTAMPTZ.dateValue()
5764402 JDBC TIMESTAMPTZ problems with milliseconds
6119382 More expensive Index range scan chosen for TIMESTAMP predicate
6156762 OCCI fractional seconds portion can be wrong
6267310 Import of large table with a TIMESTAMP column is slow
6316536 ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints
6317878 Dump [kksfbc] from INSERT ALL with TRIGGER for certain datatypes
6330994 ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments
6336914 DBMS_SCHEDULER.GET_SYS_TIME_ZONE_NAME returns NULL for GMT time zone
6659496 Slow load of XML documents with TIMESTAMP WITH LOCAL TIMEZONE
6733318 Database replay client incorrectly replays timestamp data
6868399 JDBC TIMEZONETAB.getOffset() returns wrong GMT offset

Deadlock
5476091 Ctrl-C ignored for sessions waiting for mutexes
5685189 Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
5756769 Deadlock between Create MVIEW and DML
5849679 Undetected deadlock in RAC involving a TM lock
6145177 Single resource deadlock with a zero DID
6410146 Self deadlock from unbundled describe call
6475688 Concurrent rewrite and on-commit refresh can deadlock (library cache pin <--> lock)
6496514 RAC deadlock between "libary cache lock" and TX enqueue
6514983 False global enqueue deadlock in RAC
6618312 Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)
6644122 ON COMMIT refresh deadlock (library cache pin V lock)
6710019 Deadlock / hang from concurrent MV refresh and TRUNCATE
7175822 ORA-60 possible on DROP MATERIALIZED VIEW

Diagnostic Output Problem / Improvement
6343023 Diagnostic enhancement to include short stacks in RAC deadlock reports
6358382 10046 trace does not dump NCHAR bind variables in AL16UTF16
6486564 Lack of symbolic stack trace for ocssd.bin or other executables
6659611 Redo dump code fails to dump invalidation redo records
6733627 Unaccounted Wait Time on "Direct Path" operations with FILESYSTEM_IO_OPTIONS=NONE
6778199 OERI[kkocxj : pjpctx] lacks useful diagnostics

Direct Path Operations
3136315 Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data
3951755 SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index
4224958 Direct path loader can dump loading SYSDATE into CHAR(8) column
5944227 SQLloader direct path load into IOT can dump [kdblldrp]
6770202 SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data

Domain Indexes
5891213 ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present
5908945 Dump [qxopqdca] with ancilliary operator
6051635 Wrong DDL from DBMS_METADATA for domain index or index on XMLType column
6497310 ORA-942 / dump for DML in XMLTYPE column with domain index
6685261 Dump [lnxmin] using ancilliary operators with inline views

Excessive CPU Usage
6193945 High LGWR CPU use and long 'log file sync' latency in RAC
6337547 High CPU from query with DSLASH on recursive schema
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)
6407273 LGWR spins during slow log switch
6413089 Restarting a logminer session can be slow if the session has fallen behind
6605370 Excessive hard parse time for nested SQL
6641036 High CPU usage by MRP due to checksum processing

Export/Import
5600056 Export of triggers extremely slow
5872788 ORA-29821 importing OPERATORS
6267310 Import of large table with a TIMESTAMP column is slow
6346393 Import can load bad SYS.ANYDATA into the database
6873515 ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute

Expression Filters / Rules
6708565 DBMS_RLMGR fails with ORA-38500 when specifying NLS length semantics

External Tables
5734188 Wrong reporting of row number when using external table
5852921 External tables can error with KUP-562
5938620 ORA-30657 attempting to disable audit on an external table
6189541 KUP-600 [kudmcxgg:grfunc] / incident report for user error with external table
6522622 Allow external tables to be pre-processed

Flashback
5667658 Wrong results / errors from flashback to SCN before segment shrink (affects MViews)
6150680 ORA-38788 / ORA-38784 from CREATE RESTORE POINT <rpname> GUARANTEE FLASHBACK DATABASE
6406880 System hang possible after killing processes when waiting for flashback logs
6429856 False ORA-19815 errors from MMON
6432837 ORA-19804 errors in alert log / RVWR trace
6453203 Very high Flashback archive retention not handled properly
6470994 Poor performance when flashback database is enabled with high PROCESSES value
6511494 Cannot flashback (ORA-38753)
6768069 Cannot FLASHBACK DATABASE on RAC physical standby
6976005 CF enqueue held for longer than needed with flashback enabled
7197716 ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Function Based Index (Including DESC Indexes)
3951755 SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index
5522793 Wrong results when function based index which returns NCHAR is used
5739162 Wrong result when SUBSTR is used in functional index
5767661 Wrong results with function based index
5861640 ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index
5944874 TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present
6041584 Join elimination not working when function-based index exists on table
6122097 Wrong Results/Dump [evaopn2] with function based index present
6131467 Wrong result when function based index created with SUBSTR
6145570 Wrong results / OERI from LIKE with join predicate pushdown
6194582 High hard parse time with function based indexes
6376928 Dump from GROUP BY query with predicates on functional index column
6438731 Dump (under evaopn2) from INSERT as SELECT with function based index
6474804 Dump [evaopn2] from push predicate with function based index
6525496 Wrong results (no rows) from BITMAP operation on functional index
6607505 OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s
6653704 Dump (evaopn2) from nested loop join with bitmap access to functional index
6760382 Dump [evaopn2] from DML with triggers and functional index
7026584 ORA-904 from query using function based index and subquery

Gateways / Heterogeneous Services
6084823 ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate
6262792 MTA Extproc memory leak
6351293 SQL may execute in wrong schema when using database links
6398252 CHAR columns from HS source not correctly blank padded if NLS translated
6701400 DG4ODBC does not allow access to Excel
6778642 ORA-28500 / sqlcode=-417 from remote query against non-Oracle database

Gateways / MGW Message Gateway
6754889 Unable to make bindings connection to non_default QMGR

Gateways / Procedural Gateway For MQ Series
6686366 PG4MQ fails with ORA-28509

Gateways / Transparent Gateway For DRDA
5735157 TG4DRDA does not properly support unicode data

Global Temporary Tables
6683178 Capture performance degrades due to lots of DDL (eg truncate of empty tables)
6756739 OERI[17183] / dump (kxttDrpPh) using temporary tables

Globalization Support (NLS)
4991474 Codepoints 0x80 - 0x9f missing from some ISO 8859 character sets
5131180 Wrong NLS settings after querying tables with DATE related constraints
5522793 Wrong results when function based index which returns NCHAR is used
5638367 Incorrect sorting of symbols "TEL" in GENERIC_M
5685304 LocaleBuilder does not handle special letters in monolingual sorts
5735157 TG4DRDA does not properly support unicode data
6047482 Rebuilt GENERIC_M / custom sort dumps (lxsucPushKeysToBuf)
6069409 ORA-979 when NLS_COMP=linguistic
6084823 ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate
6131467 Wrong result when function based index created with SUBSTR
6168288 Dump instead of ORA-1863
6168297 ORA-12899 from OCIDirPathColArrayToStream with UTF8
6195148 TO_MULTI_BYTE('-') maps to wrong display width in UTF8 / AL32UTF8
6268409 ORA-29275 error when querying the sql_redo/undo columns of V$LOGMNR_CONTENTS
6326934 Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind
6343150 Dataguard broker does not work with NLS_COMP=linguistic
6357601 Romanian base letter mapping missing for some characters
6388718 Partial multibyte character in V$SQL.SQL_TEXT (SP2-784 from sqlplus)
6398252 CHAR columns from HS source not correctly blank padded if NLS translated
6400373 Wrong result from DBMS_XMLGEN.CONVERT with multibyte input
6439315 Two byte null terminator missing for SQLT_AVC SQLCS_NCHAR define
6447861 OERI[evacol:overflow] from monolingual sort in multibyte database
6455659 Stored outlines do not work in multibyte DB
6458801 REPLACE on a CLOB can corrupt multibyte data
6460895 CSSCAN may hang / run slowly
6494820 CSSCAN fails with ORA-1455 on tables with more than 2^31-1 blocks
6510788 Wrong results from LIKE with certain NLS_SORT settings
6627733 OERI[dmlsrvColLenChk_2:dty] inserting NULLs into CHAR length semantics column
6642692 Wrong results from LIKE operator with NLS_SORT=BINARY_CI and NLS_COMP=linguistic
6712066 Wrong result from internal copy of certain NLS characters
6770202 SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data

Hang (Involving Shared Resource)
6310591 DB hang with CKPT waiting for enquiry response in RAC
6406880 System hang possible after killing processes when waiting for flashback logs
6418420 Database wide hang with process trying to flush buffers from the cache
6522708 ASM instance may hang
6809093 Hang due to TT enqueue waits on an UNDO tablespace

Hang (Process Hang)
2227223 ALTER TABLESPACE READ ONLY waits for all active transactions to complete
5476091 Ctrl-C ignored for sessions waiting for mutexes
5756769 Deadlock between Create MVIEW and DML
6120004 Concurrent eager transactions may cause logical standby apply to hang
6144079 Instance crash in RAC (OERI:2103)
6169451 OCCI client hangs after TAF failover when using session pools
6175584 Insert hang with Foreign Key constraint and read-only tablespace
6219529 RAC hang during exchange with hash locks
6334552 Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6394429 Sessions in resource group may be blocked
6410146 Self deadlock from unbundled describe call
6447303 Processes hang waiting for "DFS lock handle" on DROP DATAFILE
6475688 Concurrent rewrite and on-commit refresh can deadlock (library cache pin <--> lock)
6496514 RAC deadlock between "libary cache lock" and TX enqueue
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client
6618312 Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)
6644122 ON COMMIT refresh deadlock (library cache pin V lock)
6667800 OERI:12333 / client hang using OCILob() in multithreaded OCI client
6710019 Deadlock / hang from concurrent MV refresh and TRUNCATE
6711644 Dump / hang in multithreaded OCI client
6733394 RMAN channel failover hangs in 11g
6970283 OCI hang / ORA-12559 after FAN notification

Hang (Process Spins)
4699720 MMON or PMON spin in RAC
4932003 Query spins when certain REGEXP_LIKE regular expression is used
5457450 Excessive polling of the aq$_<qtab>_f queue table view from dequeue by condition
6084108 Dump / CPU spin possible after an ORA-3115
6265559 Apply spins after sequence altered at primary
6337547 High CPU from query with DSLASH on recursive schema
6346393 Import can load bad SYS.ANYDATA into the database
6460895 CSSCAN may hang / run slowly
6511361 DMON may loop trying to resilver a mirrored block
6605370 Excessive hard parse time for nested SQL
6640950 Update of LONG can cause Streams capture to spin / spill
6738567 JVM spins / fails to compile a class with modulus (%) operator
6795880 Session spins / OERI after 'kksfbc child completion' wait
6849184 Spin with ODM with mirrored disks
6919764 LMS spin (kclobj) / instance crash

Hash Join
5947623 Excess PGA memory used by hash joins
6126439 A query with hash join takes a long time to abort from kill session
6471770 ORA-32695 from Hash GROUP BY
6506617 Wrong results from STAR transformation with extended pruning

Index Organized Tables (IOT)
6646613* IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note 471479.1
4527606 MOVE of IOT can cause corruption / OERI
5406763 Wrong cost when access IOT through secondary index
5885265 Deferred constraints may incorrectly error at commit for IOTs
5944227 SQLloader direct path load into IOT can dump [kdblldrp]
6070548 Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT
6354678 Wrong results from FIRST ROW MIN / MAX optimization on secondary IOT index
6620517 ORA-29308 from TSPITR with IOT with LOB column
6794366 CTAS dumps under qertqosSetProperties creating an IOT

Instance May Crash
5686407 SGA memory corruption / instance crash with various ORA-600 [171XX] when using XDB
6075582 OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
6079224 RAC ORA-27506 / IPC Send timeout
6144079 Instance crash in RAC (OERI:2103)
6153945 SMON crashes instance with OERI[ktcrsp_1: drop/truncate not comp]
6269484 OERI [kjbresourcelatch] from DBW if there is a corrupt block in cache
6271689 RAC instance crash possible
6378112 LMS can crash RAC instance with OERI[kjblpkeydrmqscchk:pkey]
6500033 LMON crash the instance with ORA-481 due to DRM sync timeout
6501007 DRM sync timeout in RAC
6509115 Instance crash in RAC due to OERI[504] on LMD
6518062 RAC instance crah with OERI[kjlrem:!ast]
6639644 ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC
6658484 Instance crash / OERI[kclexpand_5] from DRM in RAC
6737765 PMON dump [kgskrecalc] crashes instance cleaning dead process
6765855 DBW crashes instance with OERI[kjbrwreq:wip_piscn]
6778714 Instance crash in RAC when PMON cleans dead process
6925708 OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance
6934230 Instance crash from OERI:kfnmClientRegister05 with ASM
6954722 OERI[15709] in SMON in RAC / instance crash

Instance Startup
6143688 node startups cAN spend up to 2 mins in AQ partition code
6469211 Slow startup with many log files on ASM
6619318 GIM-105/GIM-104 from EM Healthcheck during instance startup
6624011 ORA-4030 / ORA-4031 on startup with > 4Gb SGA_TARGET
6795133 Startup delayed by QMNC queries

Interoperability (Between Releases)
5377242 OERI[16203] on reference to remote synonym
6749942 Cannot use 11g expdp with NETWORK_LINK to 10g

JDBC
5437593 Millisecond value not present using TIMESTAMPTZ.dateValue()
5764402 JDBC TIMESTAMPTZ problems with milliseconds
6278984 java.awt.font.glyphvector.getglyphoutline returns empty shape
6341494 Invalid property name JMSXRcvTimestamp specified for OJMS messages
6629411 ArrayOutofBoundsException using awt GlyphVector
6868399 JDBC TIMEZONETAB.getOffset() returns wrong GMT offset

JavaVM / JSP / Corba etc..
5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
5613685 Socket.connect() does not respect the timeout period in the JVM
6310590 OERI:17147 under ioc_get_granted_roles in JVM
6392076 Streams does not handle Java DDL correctly
6408917 Excessive PGA memory use for REF cursors returned from stored Java
6501565 Dump under JVM from JIT of Java class compiled with old Java compiler
6641438 Java native frames not cleaned up
6650069 ExceptionInInitializerError from JVM
6653675 OERI[kgeade_is_0] under ioc_exit_call
6653782 OERI[kghfru:ds] in Java Pool when using 64Mb granule size
6723072 java.lang.SecurityException using Kerberos in stored Java
6738567 JVM spins / fails to compile a class with modulus (%) operator
6743907 OCI-21500 [17099] / Java VM dump when concurrent threads use same XDBDocument.toString()
6833814 DBMS_JAVA.DEPLOY_CLOSE should not exist

Job Queues
5705385 DBMS_SCHEDULE chain does not complete
5928612 V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs
6071651 Delays executing a job if execution time exceeds SCHEDULE_LIMIT
6330994 ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments
6729716 expdp/impdp changes scheduler start_date (the year part)
6805387 Job slaves not recycled in RAC
7147411 Memory corruption / dump in kslgetl in CJQ

Latch Contention
5918642 Heavy latch contention with DB_CACHE_ADVICE on
6333663 Shared pool latch contention due to fragmentation of large pool
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)
6505878 "shared pool" latch contention from XA / distributed transactions
6530010 High version count for cursor with binds with fix for bug 5872943

Leak (Memory Leak / Growth)
5386986 Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
5947623 Excess PGA memory used by hash joins
6011182 Parsing of large query takes long time / memory leak / ORA-4030 /4031
6049324 Memory leak from array dequeue
6065604 DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
6181488 Logical standby can fail ith ORA-4030
6262792 MTA Extproc memory leak
6271590 SGA subheap imbalance with lots of free memory in a few subheaps
6356566 Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)
6400175 Memory leak from DML with session_cached_cursors with TRIGGERs
6408917 Excessive PGA memory use for REF cursors returned from stored Java
6414844 Wasted memory possible from batch allocations in kghu subheaps
6506816 ORA-4030 / memory leak in 'session heap' using XDB
6506818 PGA memory leak (koh dur heap) converting XMLType to CHAR
6615740 ORA-4030 in logical standy ("knas:shtrans")
6653879 XA tracing leaks client side memory / dumps if trace cannot be written
6656630 XmlAgg with GROUP BYleaks memory
6800507 Shared pool memory leak ("ksws service *" memory) using EXPDP often
6827260 Excessive memory usage for LCR cache due to large freelists

Leak (Resources Eg: File Handles)
4693355 ASM does not close open descriptors even after DROP DISKGROUP
5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
6139547 Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
6625888 File handles open on dropped datafiles in RAC
6730200 Kernel Asynch IO leak possible in some clients

Literal Replacement (CURSOR_SHARING)
3461251 V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING=FORCE
4071519 GROUP BY query with CURSOR_SHARING fails with ORA-1802
5757106 OERI[15851] selecting aggregate of a constant with literal replacement
6163785 Intermittent Wrong Results with dblink and cursor_sharing
6337716 Wrong max column size for NULL strings with literal replacement
7212120 Session cursor cache not used properly when CURSOR_SHARING=force/similar

LogMiner
5852363 V$LOGMNR_CONTENTS.SSN may be wrong for some INSERT operations
6268409 ORA-29275 error when querying the sql_redo/undo columns of V$LOGMNR_CONTENTS
6317884 ORA-1280 from DBMS_LOGMNR.START_LOGMNR without ADD_LOGFILE
6413089 Restarting a logminer session can be slow if the session has fallen behind
6451626 Dump selecting from V$LOGMNR_CONTENTS or FLASHBACK_TRANSACTION_QUERY
6650256 PDDL causes logminer spill

Memory Corruption
5670840 Various OERI from Resource Manager
5686407 SGA memory corruption / instance crash with various ORA-600 [171XX] when using XDB
6402843 OERI [17183]/[17128] memory corruption from REGEXP_SUBSTR
6408390 Memory corruption from calls to ldmWrite
6452485 SGA memory corruption / OERI [17182] with fix for bug 6085625
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client
6756739 OERI[17183] / dump (kxttDrpPh) using temporary tables
7147411 Memory corruption / dump in kslgetl in CJQ

Merge SQL (MERGE .. USING)
5990542 OERI[kxfqenq1] / Dump (kxfqgky) from MERGE on one table partition
6318678 ORA-904 from MERGE SQL over database link
6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
6694370 Update phase of serial direct path merge writes more redo than an update

Migration / Upgrade / Downgrade
6646613* IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note 471479.1
6770913* Various errors during upgrade to 11g. This bug is alerted in Note 579523.1
6339160I OERI [qctostiix1] can occur during upgrade to 10.2
6052351 Dump running catupgrd.sql when creating/replacing streams$transformation_info
6194594 OERI[kokeeiix3] can occur during upgrade from 9.2 to 11g with XDB
6279631 OERI[kocgpn129] can occur during upgrade from
6318357 ORA-29537 during upgrade to 11g
6379123 EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
6446262 ORA-31000 / other errors on upgrade if INVALID old object versions exist
6736527 ORA-30552 from utlrp during 11g upgrade
6750214 RMAN-600 [3040] upgrading to 11g catalog
6929736 RMAN-6443 running upgrade catalog after export RMAN schema from 10.2 to 11.1
6956657 Object tables can become invalid after 10.2->11.1 upgrade

NUMA Related
6774317 Long delays when using Resource manager with active session limits on Numa
6868080 ORA-4031 with NUMA

Network
6083037 Server side load balancing does not work
6598142 OERI:krsb_stream_receive.2 on standby using DCD

OCCI
6142534 OCCI getObject() fails to fetch null using isNull() from object with VARRAY
6156762 OCCI fractional seconds portion can be wrong
6169451 OCCI client hangs after TAF failover when using session pools
6265838 OCCI / OCI client can dump in upibrk during failover
6280961 OCCI AQ client dumps on FAILOVER

OCI
5765361 Client dump using OCIDirPathPrepare in OCI_UTF16ID mode
5872943 Adjusting OCI_ATTR_MAXCHAR_SIZE in OCI can cause ORA-1460
6008713 libclntsh.so loads itself with "global mode" (can cause symbol collisions)
6119750 Cannot register OCI callback for OCIAppCtxSet / OCIAppCtxClearAll
6168297 ORA-12899 from OCIDirPathColArrayToStream with UTF8
6265838 OCCI / OCI client can dump in upibrk during failover
6270834 Dump from multi-threaded client using signal handlers
6343883 ORA-932 when using OCI_DESCRIBE_ONLY with user binds
6439315 Two byte null terminator missing for SQLT_AVC SQLCS_NCHAR define
6603936 Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client
6607676 Client hang / dump (kpufhndl0)
6667800 OERI:12333 / client hang using OCILob() in multithreaded OCI client
6711644 Dump / hang in multithreaded OCI client
6750302 OCI AQ listener client may dump
6756089 Floating point numbers in OBJECTs can loose precision > 5
6828981 Unexpected ORA-1461 from SQL over database link
6960874 ORA-1483 can occur with fix for bug 6828981
6970283 OCI hang / ORA-12559 after FAN notification

Optimizer
4444536 Unnecessary sorting when access made through a global index
5234947 ORA-904 from DBMS_STATS.gather_table_stats
5284200 Suboptimal plan from SELECT DISTINCT with CONNECT BY
5406763 Wrong cost when access IOT through secondary index
5705630 Suboptimal plan from 'or' expansion
5919513 Incorrect costing for a top-n query with GROUP BY NOSORT
5936366 Wrong results / dump from query on view with select list subquery
5944076 Suboptimal plan in FIRST_ROWS(K) mode
6007259 CBO does not consider ORA concatenation
6011182 Parsing of large query takes long time / memory leak / ORA-4030 /4031
6016087 OERI[15160] from subquery unnesting
6020789 Dump [vopplog] pushing join predicates
6021687 Dump (evaopn2) from COUNT STOPKEY in plan with UNION ALL
6029071 Wrong results from distributed SQL with OUTER joins
6029469 Suboptimal plan for MIN/MAX optimized query on partitioned table
6038461 Wrong results from SQL with UNION and a fast DUAL subquery
6041584 Join elimination not working when function-based index exists on table
6042205 High parse time for a query using ORDER BY
6051211 Too High Join Cardinality with Histograms Present
6060048 Dump [kkqtsetgfr] optimizing a query with correlated subquery
6061623 OERI:qctcte1 from cost based transformation of INSERT as SELECT with TO_LOB
6062266 Cardinality of 0 for range predicate and no histograms
6073325 OERI[kkqcbydrv:1] from CONNECT BY
6075238 OERI[qctcte1] on parse of query with views / subqueries
6077514 DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache
6082745 Bad plan with fix for bug 5483301
6084811 MERGE JOIN CARTESIAN not considered
6087237 CBO may not choose best join order
6112946 gather_database_stats() may be slow (compared to gather_database_stats_job_proc)
6119382 More expensive Index range scan chosen for TIMESTAMP predicate
6119884 Wrong results with query with OR operator with OR expansion
6120483 Query with INLIST does not choose cheapest index (suboptimal plan)
6122894 Poor plan from UNION / INTERSECT views with OR predicates
6123567 Dump [kkosbn] optimizing query on partitioned table
6134565 FIRST_ROWS hint is not honored with "_sort_elimination_cost_ratio" parameter set
6138746 Poor plan for SQL with subqueries
6145570 Wrong results / OERI from LIKE with join predicate pushdown
6146906 Complex view not merged with ROWID in query
6151963 Wrong join cardinality with histograms
6159522 OERI[qkaffsindex3] from ANALYZE TABLE .. ESTIMATE STATISTICS
6163564 Poor cardinality from "LIKE" predicates and binds
6183577 OERI[15851] from update involving views and subqueries
6194582 High hard parse time with function based indexes
6207468 Dump (under kkofkrProrateStat) optimizing SQL in FIRST_ROWS mode
6239971 CBO costing can differ greatly for =< compared to <
6251917 Optimizer selects the merge join cartesian despite the hints
6276590 OERI[qctstc2o1] can occur with RBO
6279242 Stored outline does not reproduce original parallel plan
6282093 Cost based CONNECT BY does not OR expand START WITH
6282944 Poor CONNECT BY performance with complex views
6310653 OERI [kkqctmdcq: Query Block Could Not] on INSERT as SELECT
6315495 OERI[qctstc2o1] / OERI [kkqtcpopn: 0] optimizing subquery inside subquery
6316585 Dump (opitca) from complex view merging
6319761 ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS
6326934 Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind
6329318 Selectivity of range predicate lower than equality
6336044 Dump using DBMS_OUTLN.CREATE_OUTLINE
6344547 ORA-6512/ORA-904 from DBMS_STATS with invisible index
6350462 Incorrect index statistics scaling for first_rows(k)
6360414 OUTLINE does not store USE_HASH_AGGREGATION hint
6391154 Stored outlines using OR-expansion ignored if _NO_OR_EXPANSION set
6399168 DBMS_STATS can be slow for large table with bitmap indexes
6400795 Wrong results from view merging
6401981 Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs
6405967 Wrong (duplicate) results from view with incorrelated subquery (any, in)
6408017 OERI[12811] optimizing a query against fixed view/s
6438752 Suboptimal plan due to incorrect costing of unnested subquery
6438892 Suboptimal plan with ROWNUM predicate and NESTED LOOPS
6443402 Dump [kkommnnj] from LEFT OUTER JOIN
6455659 Stored outlines do not work in multibyte DB
6468287 Suboptimal plan when ORDER BY includes a VIEW column that has constant predicate
6469667 Suboptimal plan with pushed predicates and encrypted column/s
6488803 Suboptimal plan due to no group by pushdown without aggregates in PQ
6503543 Suboptimal plan due to bad cardinality estimate for RANGE join predicates
6511034 Join Cardinality Overly estimated
6526370 New GRANULARITY option for DBMS_STATS
6597500 Wrong results from CHAR column comparison to constants longer than the column
6626018 Cost of filter operation computed as too low a value
6634836 Wrong results with view merge and Anti/Semi Join with an aggregate
6642751 Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid
6644714 High number of child cursors with adaptive cursor sharing
6655241 DBMS_STATS slow gathering statistics on table with a LOB column
6656356 Join elimination may not work if there are join indexes
6671155 No join elimination with top level OR in HAVING clause
6673512 OERI:qksvcProcessExprCBK_fail from SEM_MODEL query
6674254 Suboptimal plan from FIRST_ROWS(x)
6679567 DBA_INDEXES.GLOBAL_STATS is "NO" when gather auto stats for partitioned index
6688200 No join elimination when WHERE clause uses high level/condition
6696221 Outline from OPTIMIZER_FEATURES_ENABLE=8.1.7 not used
6707916 Wrong results from join elimination
6708183 CBO cannot get good cardinality estimate for TABLE() functions
6714199 No pushup through both dimensions for partition wise join
6718212 enhancement to dbms_stats to merge column usage statistics from remote system
6739591 Wrong results from OUTER JOIN, VIEW, GROUP BY and predicate move around
6771838 Suboptimal plan from join with UNION view with empty branch
6780413 Wrong results from predicate push with model SQL
6786141 Statistics not exchanged when exchanging composite partitioned tables
6830451 Wrong results unnesting correlated count subquery and multicolumn expression
6833602 Wrong results with BITMAP OR
6894671 Wrong results from join elimination
6901061 Wrong result from merged outer join view
6969498 Wrong results from index join
6969743 Dump (kkoajt) from GROUP BY placement optimization with an anti join
6972343 Wrong results with push predicate and cost based transformation
7014646 OERI [kkocxj : pjpctx] from complex query
7039337 Wrong results on query using GROUP BY placement
7148905 Wrong result from subquery unnesting
7162354 Wrong results from join predicate push with a ROWID predicate
7189447 Wrong results when view merging applied to query
7213010 Adaptive cursor sharing generates lots of child cursors

Optimizer (Stored Outlines)
6279242 Stored outline does not reproduce original parallel plan
6391154 Stored outlines using OR-expansion ignored if _NO_OR_EXPANSION set
6455659 Stored outlines do not work in multibyte DB

Optimizer (Subquery Factoring - WITH clause)
6082605 ORA-32036 while executing a WITH clause statement
6318487 Dump (qknviAllocate) from star transformation of SQL using WITH clause
6360220 ORA-21780 from subquery factoring SQL WITH clause
6643093 Wrong results from CONNECT BY and WITH clause
6679575 Wrong results from CONNECT BY and WITH clause
6797740 Dump [kkqvmValidAJView] using a SQL WITH clause and anti join

Optimizer Bad Cardinality
6051211 Too High Join Cardinality with Histograms Present
6062266 Cardinality of 0 for range predicate and no histograms
6082745 Bad plan with fix for bug 5483301
6151963 Wrong join cardinality with histograms
6163564 Poor cardinality from "LIKE" predicates and binds
6326934 Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind
6329318 Selectivity of range predicate lower than equality
6401981 Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs
6438892 Suboptimal plan with ROWNUM predicate and NESTED LOOPS
6503543 Suboptimal plan due to bad cardinality estimate for RANGE join predicates
6511034 Join Cardinality Overly estimated
6708183 CBO cannot get good cardinality estimate for TABLE() functions

Oracle Disk Manager
6849184 Spin with ODM with mirrored disks

Oracle Enterprise Manager
6826271 EUSM and OLS Jar files from client ORACLE_HOME

Oracle Label Security
5839280 OERI[15265] dropping OLS policy
6713587 Usernames with hyphens cannot connect when OLS is installed

Oracle Text (Formerly interMedia Text)
5867231 OERI:qernsRowP on Text query with NLS_COMP / NLS_SORT set