美创科技技术社区

注册

 

发新话题 回复该主题

Bugs fixed in the 11.1.0.7 Patch Set [一] [复制链接]

1#










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 [url=]Support Bug Description[/url].


  • ‘*’ 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 Advisory (Oct 2008)

11.1.0.7

- /

-

Note:735216.1

Critical Patch Update for Database Products (Oct 2008)

11.1.0.7

- /

-

Note:467881.1

Critical Patch Update (Apr 2008)

11.1.0.7

- /

-

Note:753340.1

Critical Patch Update for Database Products (Jan 2009)

11.1.0.7

- /

-

Note:467881.1

Critical Patch Update (Jul 2008)

11.1.0.7

- /

-

Note:467881.1

Critical Patch Update Advisory (Jan 2009)


11.1.0.7 Bug Categories


11.1.0.7 Bug Fixes by Category


Advanced Networking Option

Advanced Networking Option

[url=]5743928[/url]

Fix for bug 4764518 causes ORA-28030 with EUS

Undocumented Advanced Networking Option

6012402 6741600


JDBC

JDBC

[url=]4689310[/url]

JDBC Thin proxy authentication fails when specifying username / password separately

[url=]5609480[/url]

getUpdateCount returns wrong values with batching

[url=]6084197[/url]

CHAR data truncated to 2k by JDBC client

[url=]6109228[/url]

PreparedStatement.setQueryTimeout does not work

[url=]6145041[/url]

SQLException from setPlsqlIndexTable() for non String/char data

[url=]6200206[/url]

Conversion from AL16UTF16 to UTF16 is surrogate character sensitive in JDBC Thin

[url=]6203316[/url]

NullPointerException from throwSqlException

[url=]6208793[/url]

Wrong result from isBeforeFirst() in JDBC Thin

[url=]6275369[/url]

JDBC Thin driver does not close the socket on IOException

[url=]6281527[/url]

Null inserted through oracleCachedRowset cannot be deleted

[url=]6312064[/url]

New flag “use1900AsYearForTime” for JDBC

[url=]6338825[/url]

oracle.ons.SubscriptionException cannot be caught

[url=]6362104[/url]

MalformedObjectException when loading JDBC

[url=]6365731[/url]

Password with “?” is not set correctly by JDBC

[url=]6394952[/url]

Cannot close JDBC OCI connection after ORA-3113

[url=]6396242[/url]

ArrayOutOfBoundsException using JDBC batching

[url=]6406402[/url]

connection.setTypeMap() in 11g not backward compatible with 10g

[url=]6407808[/url]

No connectionClosed on JDBC Thin PooledConnection

[url=]6431772[/url]

SQLException calling BLOB.free() multiple times

[url=]6443045[/url]

OERI [kope2_readstr232] binding a Struct with NULL over JDBC

[url=]6453298[/url]

JDBC Thin driver fails to connect with Serbian language (“sr”)

[url=]6474141[/url]

Excess memory use fetching NULL columns in JDBC

[url=]6491743[/url]

SQLException from connection.savepoint() method with pooled connection

[url=]6496226[/url]

JDBC LOB output streams perform badly for large writes

[url=]6513502[/url]

OracleConnection.isUsable() does not work

[url=]6522392[/url]

Wrong column_size for NCHAR/NVARCHAR from DatabaseMetaData.getColumns() in JDBC

[url=]6522973[/url]

NullPointerException using JDBC OCI from checkError()

[url=]6635223[/url]

JDBC define buffers can use memory

[url=]6749302[/url]

JDBC timestamp values incorrect around DST changeover

[url=]6750798[/url]

getoriginalSql() not available in oracle.jdbc in 11g Thin drivers

[url=]6761190[/url]

Statement.Cancel() does not work with PreparedStatement.executeBatch()

[url=]6838136[/url]

JDBC Thin shows connect URL in Exception message

[url=]6977990[/url]

JDBC timestamp value incorrect during DST overlap

[url=]7333655[/url]

Violated deferred CHECK constraint does not throw exception in JDBC Thin

Undocumented JDBC

4183785 5976201 6068533 6272689 6272690 6279736 6352150 6441084 6525017 6527971 6531069 6627150 6632928 6654960 6655200 6658080 6661592 6668623 6764986 6870832 7028625 7028659 7233882


Net Configuration Assistant – NetCA

Net Configuration Assistant – NetCA

[url=]5954282[/url]

Truncated screen data in NETCA

Undocumented Net Configuration Assistant – NetCA

5258718


Oracle Database Configuration Assistant

Oracle Database Configuration Assistant

[url=]6628285[/url]PI

DBCA / DBUA fail with OUI-25031 / java.lang.UnsatisfiedLinkError

Undocumented Oracle Database Configuration Assistant

5938848 6770772 6786722 6796931


Oracle Database Gateway for Sybase

Oracle Database Gateway for Sybase

[url=]7155136[/url]

11g gateway has problems with 3 part object names


Oracle Database Upgrade Assistant

Oracle Database Upgrade Assistant

[url=]5533745[/url]

DBUA does not work for upgrade database on Windows platforms

[url=]6162682[/url]

DBUA upgrade with ASM can fail

[url=]6505158[/url]

DBUA hangs with patch 5115926 during 32-bit to 64-bit upgrade

Undocumented Oracle Database Upgrade Assistant

5531643 6267815 6358004 6408929 6728153


Oracle Internet Directory

Undocumented Oracle Internet Directory

6792566 6803415 6900192


Oracle Net Services

Oracle Net Services

[url=]6639240[/url]P

Win: NetCA fails with Directory Exception

[url=]5725069[/url]

LDAP name lookup for database objects may not work

[url=]5763152[/url]

Hang calling unreachable host over Net

[url=]5837468[/url]

EMON hangs when client application suspended

[url=]5981941[/url]

TNS-3505 using EZconnect when hostname starts with a number

[url=]6017068[/url]

PMON spin in Net code

[url=]6053197[/url]

Connection manager hang

[url=]6139856[/url]

Memory corruption in Net nsevrec leading to dump

[url=]6151830[/url]

osnsui() does not work properly

[url=]6407026[/url]

Multithreaded client dump when client Net trace enabled

Undocumented Oracle Net Services

6085375 6188325 6202562 6271908 6282849 6361233 6488330 6510596 6519261 6525108 6685493 6759850 6760249 6894986 6954217 7000390 7225609


Oracle ODBC Driver

Oracle ODBC Driver

[url=]7125813[/url]P

HP-Itanium: Add support for ODBC 64bit on HP Itanium

[url=]7312763[/url]P

HP Itanium: Add support for ODBC 32 bit

[url=]5561244[/url]

EXCEPTION_ACCESS_VIOLATION in ORANLS10.DLL

[url=]6684004[/url]

ODBC IM003 on SQLALLOCSTMT

Undocumented Oracle ODBC Driver

6031621 6036539 6036541 6158635


Oracle OLAP

Oracle OLAP

[url=]5555067[/url]

OLAP ACROSS command wrong in second iteration

[url=]5912796[/url]

ORA-35654 ALL_OBJECTS dimension cannot be set to null

[url=]5912860[/url]

Dump during dynamic aggregation under xsConvertVal in OLAP

[url=]5972915[/url]

Fatal error during export of OLAP AW using datapump export

[url=]6047657[/url]

OLAP errors for SQL insert during a while loop over a cursor with SQL declare / fetch

[url=]6140382[/url]

Creating OLAP AW fails in shared server mode

[url=]6195891[/url]

ORA-37999 during multi update of AQ

[url=]6202997[/url]

Internal [TxsOqSQLCubePreGenerator::createCubeAWGenerationInfo-01] from OLAP

[url=]6329495[/url]

ORA-918 from OLAP DML

[url=]6334646[/url]

OLAP Total function with multi-dimensional relation returns wrong results

[url=]6372848[/url]

OERI:[XSOOPS][xsbatchnext00] during EIF import

[url=]6414616[/url]

ORA-1405 from DBMS_AW.ADVISE_SPARSITY

[url=]6454468[/url]

Full cube load/aggregation fails with OERISOOPS

[url=]6470257[/url]

OLAP DML variable name length is limited to 16 characters instead of 64

[url=]6489332[/url]

ORA-29532 java.lang.OutOfMemoryError in OLAP load of AW

[url=]6494617[/url]

Cannot attach AW when export and import objects which have permissions

[url=]6520743[/url]

Precomputing aggregation tab does not apply changes in analytic workspace

[url=]6640824[/url]

AW cannot be exported after import of EIF without base level data

[url=]6670913[/url]

It is possible to assign an invalid date to a variable in OLAP

[url=]6687129[/url]

OLAP ORA-36875 limitmap is missing or is not a string literal

[url=]6742924[/url]

Dump (lnxnucoptg) using OLAP

[url=]6822672[/url]

OLAP query fails with ORA-33858 “value of the ampersand-substitution expression is NA”

[url=]6941442[/url]

Datapump export/import of OLAP AW by schema loses grants

[url=]7348412[/url]

Aggregate function aggregating formula may dump in xsAGVDict* or xsagprop

Undocumented Oracle OLAP

3883629 4645251 5374303 5634992 5698901 5753198 5755594 5862502 5877940 5938422 6004043 6022508 6024737 6034336 6052036 6111002 6122442 6127243 6127679 6128087 6132656 6135316 6142782 6142968 6143233 6152707 6155166 6157354 6157591 6157685 6159794 6160157 6167816 6182910 6188245 6188968 6217688 6232547 6242906 6243487 6264497 6269784 6270223 6272433 6273847 6276294 6279760 6314398 6316317 6320018 6321908 6322381 6327700 6327865 6327872 6328158 6330206 6330620 6333429 6333576 6335712 6339171 6340338 6341749 6342182 6344234 6345572 6346100 6346432 6347973 6348166 6348697 6354798 6355061 6355153 6355588 6358032 6363966 6367361 6368061 6372572 6373173 6392134 6393804 6395054 6395965 6399641 6405862 6406842 6412102 6412271 6417823 6430756 6431425 6434395 6434441 6439148 6442627 6448217 6448222 6453492 6453917 6454482 6457172 6484342 6489178 6504861 6507603 6519588 6519815 6520301 6522436 6522797 6522923 6522939 6525032 6525917 6593896 6598704 6599573 6602123 6602545 6603994 6604104 6604599 6608034 6608529 6608911 6610198 6610217 6610226 6610341 6613020 6616176 6618387 6620192 6620465 6626865 6628909 6634162 6640828 6641548 6650710 6652782 6653408 6653665 6655507 6655797 6659158 6661863 6661879 6665229 6665288 6665390 6665453 6665504 6668517 6670732 6671464 6671486 6677214 6680097 6680641 6683457 6684033 6686467 6690683 6698726 6699029 6702270 6709208 6709222 6718374 6719355 6725629 6730475 6735325 6739193 6740938 6743849 6743871 6744039 6744168 6744811 6748597 6750821 6752891 6756050 6759183 6764722 6772093 6781880 6782162 6785616 6788806 6789779 6802694 6805687 6808248 6808519 6808669 6820700 6822923 6837581 6837876 6841407 6854748 6858091 6861157 6868655 6868847 6890675


Oracle Security Service

Oracle Security Service

[url=]6124217[/url]

SSL NZ error 28757 / cannot use certificate due to Empty subject field

[url=]6264536[/url]

Net FIPS functionality does not work in 11.1.0.6

[url=]6274073[/url]

PKCS11 support does not work

[url=]6370967[/url]

SSL TLS 1.0 handshake fails when the client is running on Vista

[url=]6375506[/url]

SSL variables may not be populated when using client certificate

Undocumented Oracle Security Service

5678981 6654908 6744050


Oracle Server

ANSI Joins

[url=]5031632[/url]

Wrong results from NATURAL JOIN

[url=]6471020[/url]

ORA-1790 or ORA-904 from FULL JOIN

[url=]7001990[/url]

wrong result (null column) on ansi outer join query and index access

[url=]7249290[/url]

Wrong results from virtual column in select list of ANSI join

ASSM Space Management (Bitmap Managed Segments)

[url=]6086497[/url]

OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments

[url=]6376915[/url]

HW enqueue contention for ASSM LOB segments

[url=]6413373[/url]

Lob HW enqueue contention

[url=]6474009[/url]

On ASSM tablespaces Scans using Parallel Query can be slower than in 9.2

[url=]6730429[/url]

ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN

[url=]6760697[/url]

DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption

[url=]6844739[/url]

Truncate very slow

Advanced / Secure Networking

[url=]6005762[/url]

SYS_CONTEXT(‘USERENV’,'AUTHENTICATION_METHOD’) returns NULL

Advanced Queuing

[url=]5457450[/url]

Excessive polling of the aq$_<qtab>_f queue table view from dequeue by condition

[url=]5933656[/url]

OERI[kwqpcbk179] from AQ

[url=]6044513[/url]

Cannot dequeue a message with a correlation padded with spaces

[url=]6049324[/url]

Memory leak from array dequeue

[url=]6065604[/url]

DBMS_AQ.DEQUEUE_ARRAY PGA memory leak

[url=]6143688[/url]

node startups cAN spend up to 2 mins in AQ partition code

[url=]6151536[/url]

Altering max_retries can cause orphan messages

[url=]6280961[/url]

OCCI AQ client dumps on FAILOVER

[url=]6341494[/url]

Invalid property name JMSXRcvTimestamp specified for OJMS messages

[url=]6633347[/url]

ORU-10027 from expdp

[url=]6750302[/url]

OCI AQ listener client may dump

[url=]7251909[/url]

ORA-24912 in client on database event notification

Analytic SQL (Windowing etc..)

[url=]5622851[/url]

Wrong results from CONNECT BY with GROUPING SETS

[url=]6051782[/url]

Wrong results using GROUPING SETS with ORDER BY and DISTINCT

[url=]6315495[/url]

OERI[qctstc2o1] / OERI [kkqtcpopn: 0] optimizing subquery inside subquery

[url=]6402957[/url]

Suboptimal parallel query performance for Top-n rank queries.

[url=]6878200[/url]

Dump possible from query with window / group by or sort nodes

Application Context

[url=]6005762[/url]

SYS_CONTEXT(‘USERENV’,'AUTHENTICATION_METHOD’) returns NULL

Automatic Memory Management

[url=]6275904[/url]

ASM does not start of AMM enabled

Automatic Storage Management (ASM)

[url=]6453944[/url]+

ORA-15196 with ASM disks larger than 2TB

[url=]6347380[/url]P

ASM does not find ASM disks if any other non-ASM disks mounted

[url=]4693355[/url]

ASM does not close open descriptors even after DROP DISKGROUP

[url=]6139547[/url]

Shadow process leak on ASM instance when diskspace exhausted (ORA-20)

[url=]6163771[/url]

Mounting a diskgroup fails with error ORA-600 [kfcema02]

[url=]6264570[/url]

Slow file creation in ASM if EM is running

[url=]6270137[/url]

Unnecessary acquisition of the list header block in ASM

[url=]6275904[/url]

ASM does not start of AMM enabled

[url=]6278034[/url]

Poor performance when ASM disks are OFFLINE

[url=]6334552[/url]

Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize

[url=]6361755[/url]

OERI:kfioRqTracer_insert:01 in ASM after an exception

[url=]6367360[/url]

Long ASM file open times

[url=]6399504[/url]

Offline after FORCE DROP causes staleness registry corruption

[url=]6468666[/url]

High redundancy diskgroups do not tolerate loss of disks in two failgroups

[url=]6469211[/url]

Slow startup with many log files on ASM

[url=]6487591[/url]

ASMCMD cannot restore alias directories

[url=]6493270[/url]

ASM does not resync disk properly if it is offlined due to a disk open failure on write

[url=]6494961[/url]

OERI:kfcemk10 on ASM diskgroup mount

[url=]6522708[/url]

ASM instance may hang

[url=]6527427[/url]

ASM instance crash due to OERI:kfclAddToClose10 / OERI:kfcldolockop35

[url=]6597063[/url]

OERI [kfrpass2_03] can occur in ASM

[url=]6605106[/url]

OERI:kfclUpdateBuffers20 due to accessing an ASM null converted buffer

[url=]6639330[/url]

OERI:kfbupdate05 after drop ASM disk

[url=]6639644[/url]

ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC

[url=]6674673[/url]

ASM corruption after IO error with redundancy

[url=]6769870[/url]

ASMCMD LSDSK does not show values of bytes_written

[url=]6859515[/url]

Diagnostic collection may hang or crash the instance

[url=]6925708[/url]

OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance

[url=]6934230[/url]

Instance crash from OERI:kfnmClientRegister05 with ASM

Bitmap Indexes

[url=]6110752[/url]

OERI[[qerbuNStrp:eridgt] from parallel bitmap merge

[url=]6313035[/url]

OERI[kdibc3position] from “bitmap merge” row source

[url=]6399168[/url]

DBMS_STATS can be slow for large table with bitmap indexes

[url=]6525496[/url]

Wrong results (no rows) from BITMAP operation on functional index

[url=]6642751[/url]

Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid

[url=]6653704[/url]

Dump (evaopn2) from nested loop join with bitmap access to functional index

[url=]6694548[/url]

Suboptimal execution plan using bitmap full index scan

[url=]6833602[/url]

Wrong results with BITMAP OR

Change Data Capture

[url=]6454634[/url]

Corrupt data in change table

[url=]6501817[/url]

No rows from DBA_SOURCE_TABLES with CDC

Cluster Ready Services / Parallel Server Management

[url=]7893531[/url]I

11.1.0.6 RDBMS may abort when run with 11.1.0.7 CRS

[url=]4587300[/url]

Improve CRS shutdown sequence

[url=]5629557[/url]

CRS does not receive reconfig from CSS on SAN failure

[url=]5893629[/url]

crsd dumps after being unable to delete backup OCR file

[url=]5926147[/url]

malloc() memory corruption errors from CRS

[url=]6074454[/url]

Service resource does not become offline when VIP does failover

[url=]6165289[/url]

Default service is not set to service_names when crsd.bin is killed

[url=]6219072[/url]

CRS-233 can occur on crs_stop -f

[url=]6401902[/url]

CRSD dumps during OS reboot

[url=]6436734[/url]

OCR timeout for releasing unresponsive session is too long

[url=]6486564[/url]

Lack of symbolic stack trace for ocssd.bin or other executables

[url=]6899183[/url]

srvctl can fail with PROC-9

Code Improvement

[url=]6764318[/url]P

AIX: Stack backtrace improvement

[url=]2227223[/url]

ALTER TABLESPACE READ ONLY waits for all active transactions to complete

[url=]3461251[/url]

V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING

[url=]6167716[/url]

Improve ability to eliminate tables from query

[url=]6522622[/url]

Allow external tables to be pre-processed

[url=]6526370[/url]

New GRANULARITY option for DBMS_STATS

[url=]6688108[/url]

Enhancement: Allow ORA-1555 to be ignored during table scan

[url=]6708183[/url]

CBO cannot get good cardinality estimate for TABLE() functions

[url=]6718212[/url]

enhancement to dbms_stats to merge column usage statistics from remote system

Compressed Data Storage

[url=]7123643[/url]+

Wrong results (NULL) from select on compressed table

[url=]6268371[/url]

ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT

[url=]6374297[/url]

Drop column on a virtual column gets ORA-39726 with fix for bug 6268371

[url=]6512811[/url]

ORA-39726 adding column to table after it is uncompressed (by ALTER TABLE .. MOVE)

Connect By / Hierarchical Queries

[url=]5284200[/url]

Suboptimal plan from SELECT DISTINCT with CONNECT BY

[url=]5416118[/url]

OERI[qkacon:NFswrwo] from CONNECT BY query with subqueries

[url=]5622851[/url]

Wrong results from CONNECT BY with GROUPING SETS

[url=]6073325[/url]

OERI[kkqcbydrv:1] from CONNECT BY

[url=]6244173[/url]

Dump (qeesTraverseExpr) from CONNECT BY with NOT BETWEEN

[url=]6282093[/url]

Cost based CONNECT BY does not OR expand START WITH

[url=]6282944[/url]

Poor CONNECT BY performance with complex views

[url=]6333108[/url]

Wrong results (duplicates) from CONNECT BY query

[url=]6521934[/url]

OERI[qkacon:FJswrwo] from CONNECT BY query

[url=]6643093[/url]

Wrong results from CONNECT BY and WITH clause

[url=]6679575[/url]

Wrong results from CONNECT BY and WITH clause

[url=]6729992[/url]

OERI [qkaconjswpri] during CONNECT BY query

Constraint Related

[url=]5131180[/url]

Wrong NLS settings after query table with DATE related constraints / function based index

[url=]5523375[/url]

expdp does not export disabled PRIMARY KEY constraints

[url=]5851267[/url]

Dump / false constraint violations on DML with trigger

[url=]5885265[/url]

Deferred constraints may incorrectly error at commit for IOTs

[url=]6175584[/url]

Insert hang with Foreign Key constraint and read-only tablespace

[url=]6316536[/url]

ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints

[url=]6474004[/url]

DBMS_METADATA GET_SXML output does not show RELY for a table constraint

[url=]6523114[/url]

ORA-1502 on MVIEW complete refresh with UNIQUE constraint

[url=]7197716[/url]

ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Corrupt/Bad Backup

[url=]6084232[/url]

Corrupt datapump export of encrypted column data

Corruption

[url=]6453944[/url]+

ORA-15196 with ASM disks larger than 2TB

[url=]6922729[/url]P

HPUX: Oracle on HP does not check for “forcedirectio” for NFS

[url=]5923486[/url]

SPFILE streams pool / buffer cache parameters may be changed

[url=]6086497[/url]

OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments

[url=]6316536[/url]

ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints

[url=]6361755[/url]

OERI:kfioRqTracer_insert:01 in ASM after an exception

[url=]6405339[/url]

Corruption / OERI[kcbz_check_objd_typ_3] / OERI:5400 / OERI:5357 from PQ

[url=]6493270[/url]

ASM does not resync disk properly if it is offlined due to a disk open failure on write

[url=]6667318[/url]

Space sign at the end of XMLElement values removed by XMLtype()

[url=]6684357[/url]

Change tracking at standby can miss changed blocks after a database crash

[url=]6760697[/url]

DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption

[url=]6764606[/url]

BACKUP of backupset fails if re-read is needed

Corruption (Dictionary)

[url=]5211477[/url]

Sequence starts with wrong value after expdp/impdp

[url=]5662283[/url]

CREATE or REPLACE view with FORCE can create a corrupt view definition

[url=]6430688[/url]

Property 0×800 of internal object type (SYS_YOID%) is lost after running utlirp

[url=]6430718[/url]

Wrong information in DBA_UPDATABLE_COLUMNS

[url=]6441665[/url]

OERI [kkpolpd12] / dictionary corruption from coalesce of composite hash partitioned table

[url=]6603249[/url]

Create interval partitioned table can insert bad dictionary interval data

[url=]6666915[/url]

OERI[25027] / dictionary corruption from concurrent partition DDL

Corruption (Logical)

[url=]3136315[/url]

Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data

[url=]5667658[/url]

Wrong results / errors from flashback to SCN before segment shrink (affects MViews)

[url=]5685411[/url]

Updating columns to NULL in a trigger may have no effect

[url=]5874989[/url]

Datapump import can load data longer than column definition

[url=]5951099[/url]

Wrong data in materialized view with concurrent insert to master table

[url=]5988345[/url]

Update policy applied to more tables than is should for SELECT for UPDATE

[url=]6215662[/url]

Direct path SQL*Load swaps bytes during load of BINARY_DOUBLE / FLOAT between platforms

[url=]6343054[/url]

Corruption / errors from concurrent update/refresh on materialized join views

[url=]6346393[/url]

Import can load bad SYS.ANYDATA into the database

[url=]6454634[/url]

Corrupt data in change table

[url=]6458801[/url]

REPLACE on a CLOB can corrupt multibyte data

[url=]6703563[/url]

Wrong MV data after fast refresh of ROWID based materialized view

[url=]6756089[/url]

Floating point numbers in OBJECTs can loose precision > 5

[url=]6804815[/url]

Jobs in incorrect schema after datapump import

[url=]6826661[/url]

Wrong data in NUMBER column for specific FLOAT values (SQLT_FLT)

[url=]6994194[/url]

Logical corruption from UPDATE DML

[url=]7008262[/url]

Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work

[url=]7197716[/url]

ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Corruption (Physical)

[url=]6646613[/url]*

IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1

[url=]4527606[/url]

MOVE of IOT can cause corruption / OERI

[url=]6268371[/url]

ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT

[url=]6471351[/url]

ORA-1578 / ORA-26040 due to NOLOGGING after recovery despite of FORCE LOGGING in RAC

[url=]6653934[/url]

Dump / block corruption from ONLINE segment shrink with ROWDEPENDENCIES

[url=]6674673[/url]

ASM corruption after IO error with redundancy

[url=]6730429[/url]

ORA-600 [ktecgeb-2] may occur after converting an ASSM tablespace to a different endianness using RMAN

[url=]6795264[/url]

OERI:18127 / rollback segment corruption in RAC from global transaction

Database Link / Distributed

[url=]5223587[/url]

OERI[4400] from distributed PDML with DDL

[url=]5665531[/url]

ORA-22992 on select from remote table with local LOB variable

[url=]5976269[/url]

Queries using a loopback database link cannot execute in parallel

[url=]5977865[/url]

OERI:qerrmObnd1 from query over database link

[url=]6028753[/url]

ORA-907 / ORA-933 from DML over database link

[url=]6029071[/url]

Wrong results from distributed SQL with OUTER joins

[url=]6056659[/url]

ORA-979 from SQL with ORDER BY and BINDS over database link

[url=]6060280[/url]

Wrong results UNION ALL and database link

[url=]6155920[/url]

ORA-2063 / ORA-972 in subquery using database link

[url=]6163785[/url]

Intermittent Wrong Results with dblink and cursor_sharing

[url=]6318678[/url]

ORA-904 from MERGE SQL over database link

[url=]6351293[/url]

SQL may execute in wrong schema when using database links

[url=]6520125[/url]

ORA-904 from a select over a database link

[url=]6620988[/url]

ORA-904 from outer join query over database link

[url=]6621937[/url]

[NO]PARALLEL_INDEX hint not sent to remote site for SQL over database link

[url=]6718212[/url]

enhancement to dbms_stats to merge column usage statistics from remote system

[url=]6828981[/url]

Unexpected ORA-1461 from SQL over database link

[url=]6960874[/url]

ORA-1483 can occur with fix for bug 6828981

Database Replay

[url=]6336576[/url]

Replay takes longer than capture on RAC

[url=]6733318[/url]

Database replay client incorrectly replays timestamp data

[url=]7040652[/url]

Replayed workload generates different content than original workload

Datapump Export/Import

[url=]5158215[/url]

ORA-39023 / dump (kupfxinit) / ORA-39021 with SPACE character in COMPATIBLE parameter

[url=]5192493[/url]

IMPDP fails if dmp file contains an invalid Oracle number

[url=]5211477[/url]

Sequence starts with wrong value after expdp/impdp

[url=]5523375[/url]

expdp does not export disabled PRIMARY KEY constraints

[url=]5530086[/url]

EXPDP / DBMS_METADATA do not get TRIGGER data if DB_BLOCK_SIZE < 4k

[url=]5690152[/url]

Package comments not imported when using datapump schema import

[url=]5705160[/url]

Cannot impdp a table that has both LONG RAW and TDE encrypted columns

[url=]5747615[/url]

DBMS_DATAPUMP.DATA_FILTER filter INCLUDE_ROWS=1 does not export row data

[url=]5767565[/url]

ImpDP does not handle QUERY parameter with REMAP_SCHEMA set

[url=]5861640[/url]

ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index

[url=]5874989[/url]

Datapump import can load data longer than column definition

[url=]5891213[/url]

ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present

[url=]5944874[/url]

TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present

[url=]5961283[/url]

ORA-39779 from IMPDP if source database has 8i objects

[url=]6051635[/url]

Wrong DDL from DBMS_METADATA for domain index or index on XMLType column

[url=]6063940[/url]

Datapump export / import does not handle tablespace groups

[url=]6081425[/url]

impdp fails with ORA-1403 if table already exists

[url=]6082832[/url]

EXPDP does not mask ENCRYPTION_PASSWORD parameter

[url=]6084232[/url]

Corrupt datapump export of encrypted column data

[url=]6156708[/url]

expdp puts the index creation statements into dump in wrong order

[url=]6368018[/url]

Data pump import with compression=data_only fails (OERI:klaprs_12)

[url=]6379123[/url]

EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

[url=]6454237[/url]

Wrong output from DBMS_METADATA.GET_DDL for trigger definition with comment

[url=]6487005[/url]

impdp for AUDIT on DIRECTORY object fails

[url=]6633314[/url]

ORA-29358 from IMPDP

[url=]6633347[/url]

ORU-10027 from expdp

[url=]6635956[/url]

DBMS_METADATA / Datapump import fails with LPX-7/ORA-39125

[url=]6729716[/url]

expdp/impdp changes scheduler start_date (the year part)

[url=]6749942[/url]

Cannot use 11g expdp with NETWORK_LINK to 10g

[url=]6800507[/url]

Shared pool memory leak (“ksws service *” memory) using EXPDP often

[url=]6804815[/url]

Jobs in incorrect schema after datapump import

Datatypes (AnyData)

[url=]6346393[/url]

Import can load bad SYS.ANYDATA into the database

Datatypes (LOBs/CLOB/BLOB/BFILE)

[url=]5049352[/url]

DBMS_LOB.LOADCLOBFROM does not work on files over 4gb (ORA-22288)

[url=]5051432[/url]

DBMS_LOB does not execute with the privileges of the calling procedure

[url=]5665531[/url]

ORA-22992 on select from remote table with local LOB variable

[url=]6061623[/url]

OERI:qctcte1 from cost based transformation of INSERT as SELECT with TO_LOB

[url=]6082605[/url]

ORA-32036 while executing a WITH clause statement

[url=]6191877[/url]

OERI:kdlxSetEncxCtor-1 from MOVE of securefile LOB with encryption

[url=]6315003[/url]

Truncate table fails with OERI[ktsstrn-4]

[url=]6367945[/url]

OERI:kdliReadPos from securefile LOBs

[url=]6376915[/url]

HW enqueue contention for ASSM LOB segments

[url=]6412375[/url]

ALTER TABLE .. MODIFY LOB does not change PCTVERSION of BASICFILE/SECUREFILE LOB

[url=]6413373[/url]

Lob HW enqueue contention

[url=]6454763[/url]

Various OERI after recovery of SecureFile LOB buffers

[url=]6603936[/url]

Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client

[url=]6607505[/url]

OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s

[url=]6620517[/url]

ORA-29308 from TSPITR with IOT with LOB column

[url=]6667800[/url]

OERI:12333 / client hang using OCILob() in multithreaded OCI client

[url=]6698457[/url]

Securefile LOB can over-allocate space

[url=]6873515[/url]

ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute

[url=]7008262[/url]

Assigning EMPTY_CLOB/EMPTY_BLOB in a trigger does not work

Datatypes (Objects/Types/Collections)

[url=]5308497[/url]

Dump (nsoexc) from natural join with correlation

[url=]5944121[/url]

OERI:kghufree_06 using collections with non-final type elements

[url=]5961283[/url]

ORA-39779 from IMPDP if source database has 8i objects

[url=]6029647[/url]

ORA-12714 accessing typed column from TABLE() function

[url=]6142534[/url]

OCCI getObject() fails to fetch null using isNull() from object with VARRAY

[url=]6165874[/url]

OERI[kksfbc-reparse-infinite-loop] after DROP / reCREATE of subtype

[url=]6430688[/url]

Property 0×800 of internal object type (SYS_YOID%) is lost after running utlirp

[url=]6452485[/url]

SGA memory corruption / OERI [17182] with fix for bug 6085625

[url=]6661262[/url]

TTS expdp from 10.2 and impdp into 11g fails for Spatial or object tables

[url=]6708183[/url]

CBO cannot get good cardinality estimate for TABLE() functions

[url=]6756089[/url]

Floating point numbers in OBJECTs can loose precision > 5

[url=]6760382[/url]

Dump [evaopn2] from DML with triggers and functional index

Datatypes (TIMESTAMP)

[url=]3136315[/url]

Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data

[url=]5437593[/url]

Millisecond value not present using TIMESTAMPTZ.dateValue()

[url=]5764402[/url]

JDBC TIMESTAMPTZ problems with milliseconds

[url=]6119382[/url]

More expensive Index range scan chosen for TIMESTAMP predicate

[url=]6156762[/url]

OCCI fractional seconds portion can be wrong

[url=]6267310[/url]

Import of large table with a TIMESTAMP column is slow

[url=]6316536[/url]

ALTER table to change column to TIMESTAMP WITH TIME ZONE can break constraints

[url=]6317878[/url]

Dump [kksfbc] from INSERT ALL with TRIGGER for certain datatypes

[url=]6330994[/url]

ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments

[url=]6336914[/url]

DBMS_SCHEDULER.GET_SYS_TIME_ZONE_NAME returns NULL for GMT time zone

[url=]6659496[/url]

Slow load of XML documents with TIMESTAMP WITH LOCAL TIMEZONE

[url=]6733318[/url]

Database replay client incorrectly replays timestamp data

[url=]6868399[/url]

JDBC TIMEZONETAB.getOffset() returns wrong GMT offset

Deadlock

[url=]5476091[/url]

Ctrl-C ignored for sessions waiting for mutexes

[url=]5685189[/url]

Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors

[url=]5756769[/url]

Deadlock between Create MVIEW and DML

[url=]5849679[/url]

Undetected deadlock in RAC involving a TM lock

[url=]6145177[/url]

Single resource deadlock with a zero DID

[url=]6410146[/url]

Self deadlock from unbundled describe call

[url=]6475688[/url]

Concurrent rewrite and on-commit refresh can deadlock (library cache pin <–> lock)

[url=]6496514[/url]

RAC deadlock between “libary cache lock” and TX enqueue

[url=]6514983[/url]

False global enqueue deadlock in RAC

[url=]6618312[/url]

Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)

[url=]6644122[/url]

ON COMMIT refresh deadlock (library cache pin V lock)

[url=]6710019[/url]

Deadlock / hang from concurrent MV refresh and TRUNCATE

[url=]7175822[/url]

ORA-60 possible on DROP MATERIALIZED VIEW

Diagnostic Output Problem / Improvement

[url=]6764318[/url]P

AIX: Stack backtrace improvement

[url=]6343023[/url]

Diagnostic enhancement to include short stacks in RAC deadlock reports

[url=]6358382[/url]

10046 trace does not dump NCHAR bind variables in AL16UTF16

[url=]6486564[/url]

Lack of symbolic stack trace for ocssd.bin or other executables

[url=]6659611[/url]

Redo dump code fails to dump invalidation redo records

[url=]6733627[/url]

Unaccounted Wait Time on “Direct Path” operations with FILESYSTEM_IO_OPTIONS=NONE

[url=]6778199[/url]

OERI[kkocxj : pjpctx] lacks useful diagnostics

Direct Path Operations

[url=]3136315[/url]

Direct SQLLoad of a DATE column from a TIMESTAMP loads invalid data

[url=]3951755[/url]

SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index

[url=]4224958[/url]

Direct path loader can dump loading SYSDATE into CHAR(8) column

[url=]5944227[/url]

SQLloader direct path load into IOT can dump [kdblldrp]

[url=]6770202[/url]

SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data

Domain Indexes

[url=]5891213[/url]

ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present

[url=]5908945[/url]

Dump [qxopqdca] with ancilliary operator

[url=]6051635[/url]

Wrong DDL from DBMS_METADATA for domain index or index on XMLType column

[url=]6497310[/url]

ORA-942 / dump for DML in XMLTYPE column with domain index

[url=]6685261[/url]

Dump [lnxmin] using ancilliary operators with inline views

Excessive CPU Usage

[url=]6193945[/url]

High LGWR CPU use and long ‘log file sync’ latency in RAC

[url=]6194582[/url]

High hard parse time with function based indexes

[url=]6337547[/url]

High CPU from query with DSLASH on recursive schema

[url=]6356566[/url]

Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

[url=]6407273[/url]

LGWR spins during slow log switch

[url=]6413089[/url]

Restarting a logminer session can be slow if the session has fallen behind

[url=]6605370[/url]

Excessive hard parse time for nested SQL

[url=]6641036[/url]

High CPU usage by MRP due to checksum processing

Export/Import

[url=]5600056[/url]

Export of triggers extremely slow

[url=]5872788[/url]

ORA-29821 importing OPERATORS

[url=]6267310[/url]

Import of large table with a TIMESTAMP column is slow

[url=]6346393[/url]

Import can load bad SYS.ANYDATA into the database

[url=]6873515[/url]

ORA-32602 from conventional IMPORT for tables with FREEPOOLS LOB attribute

Expression Filters / Rules

[url=]6708565[/url]

DBMS_RLMGR fails with ORA-38500 when specifying NLS length semantics

External Tables

[url=]5734188[/url]

Wrong reporting of row number when using external table

[url=]5852921[/url]

External tables can error with KUP-562

[url=]5938620[/url]

ORA-30657 attempting to disable audit on an external table

[url=]6189541[/url]

KUP-600 [kudmcxggrfunc] / incident report for user error with external table

[url=]6522622[/url]

Allow external tables to be pre-processed

Flashback

[url=]5667658[/url]

Wrong results / errors from flashback to SCN before segment shrink (affects MViews)

[url=]6150680[/url]

ORA-38788 / ORA-38784 from CREATE RESTORE POINT <rpname> GUARANTEE FLASHBACK DATABASE

[url=]6406880[/url]

System hang possible after killing processes when waiting for flashback logs

[url=]6429856[/url]

False ORA-19815 errors from MMON

[url=]6432837[/url]

ORA-19804 errors in alert log / RVWR trace

[url=]6453203[/url]

Very high Flashback archive retention not handled properly

[url=]6470994[/url]

Poor performance when flashback database is enabled with high PROCESSES value

[url=]6511494[/url]

Cannot flashback (ORA-38753)

[url=]6768069[/url]

Cannot FLASHBACK DATABASE on RAC physical standby

[url=]6933768[/url]

ORA-1555 from flashback query even if data is in the tables Flashback Data Archive

[url=]6976005[/url]

CF enqueue held for longer than needed with flashback enabled

[url=]7197716[/url]

ALTER TABLE ADD CONSTRAINT should not be allowed on FLASHBACK data archive tables

Function Based Index (Including DESC Indexes)

[url=]3951755[/url]

SQLLDR Direct load OERI[kohdtf048] / ORA-21780 with function based index

[url=]5131180[/url]

Wrong NLS settings after query table with DATE related constraints / function based index

[url=]5522793[/url]

Wrong results when function based index which returns NCHAR is used

[url=]5739162[/url]

Wrong result when SUBSTR is used in functional index

[url=]5767661[/url]

Wrong results with function based index

[url=]5861640[/url]

ORA-39127 / ORA-30926 from EXPDP of XMLTYPE column with functional index

[url=]5944874[/url]

TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present

[url=]6041584[/url]

Join elimination not working when function-based index exists on table

[url=]6122097[/url]

Wrong Results/Dump [evaopn2] with function based index present

[url=]6131467[/url]

Wrong result when function based index created with SUBSTR

[url=]6145570[/url]

Wrong results / OERI from LIKE with join predicate pushdown

[url=]6194582[/url]

High hard parse time with function based indexes

[url=]6376928[/url]

Dump from GROUP BY query with predicates on functional index column

[url=]6438731[/url]

Dump (under evaopn2) from INSERT as SELECT with function based index

[url=]6474804[/url]

Dump [evaopn2] from push predicate with function based index

[url=]6525496[/url]

Wrong results (no rows) from BITMAP operation on functional index

[url=]6607505[/url]

OERI [15201] from DML on table with FUNCTION BASED index on LOB column/s

[url=]6653704[/url]

Dump (evaopn2) from nested loop join with bitmap access to functional index

[url=]6760382[/url]

Dump [evaopn2] from DML with triggers and functional index

[url=]7026584[/url]

ORA-904 from query using function based index and subquery

Gateways / Heterogeneous Services

[url=]6084823[/url]

ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate

[url=]6262792[/url]

MTA Extproc memory leak

[url=]6342503[/url]

Streams apply process slow down applying into SQL Server through transparent gateway

[url=]6351293[/url]

SQL may execute in wrong schema when using database links

[url=]6398252[/url]

CHAR columns from HS source not correctly blank padded if NLS translated

[url=]6701400[/url]

DG4ODBC does not allow access to Excel

[url=]6778642[/url]

ORA-28500 / sqlcode=-417 from remote query against non-Oracle database

Gateways / MGW Message Gateway

[url=]6754889[/url]

Unable to make bindings connection to non_default QMGR

Gateways / Procedural Gateway For MQ Series

[url=]6686366[/url]

PG4MQ fails with ORA-28509

Gateways / Transparent Gateway For DRDA

[url=]5735157[/url]

TG4DRDA does not properly support unicode data

Global Temporary Tables

[url=]6756739[/url]

OERI[17183] / dump (kxttDrpPh) using temporary tables

Globalization Support (NLS)

[url=]4991474[/url]

Codepoints 0×80 – 0×9f missing from some ISO 8859 character sets

[url=]5131180[/url]

Wrong NLS settings after query table with DATE related constraints / function based index

[url=]5522793[/url]

Wrong results when function based index which returns NCHAR is used

[url=]5638367[/url]

Incorrect sorting of symbols “TEL” in GENERIC_M

[url=]5685304[/url]

LocaleBuilder does not handle special letters in monolingual sorts

[url=]5735157[/url]

TG4DRDA does not properly support unicode data

[url=]6047482[/url]

Rebuilt GENERIC_M / custom sort dumps (lxsucPushKeysToBuf)

[url=]6069409[/url]

ORA-979 when NLS_COMP=linguistic

[url=]6084823[/url]

ORA-2070 deleting from a table over HS using a NVARCHAR column in WHERE predicate

[url=]6131467[/url]

Wrong result when function based index created with SUBSTR

[url=]6168288[/url]

Dump instead of ORA-1863

[url=]6168297[/url]

ORA-12899 from OCIDirPathColArrayToStream with UTF8

[url=]6195148[/url]

TO_MULTI_BYTE(‘-’) maps to wrong display width in UTF8 / AL32UTF8

[url=]6268409[/url]

ORA-29275 error when querying the sql_redo/undo columns of V$LOGMNR_CONTENTS

[url=]6326934[/url]

Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind

[url=]6343150[/url]

Dataguard broker does not work with NLS_COMP=linguistic

[url=]6357601[/url]

Romanian base letter mapping missing for some characters

[url=]6371909[/url]

ORA-979 from GROUP BY when NLS_COMP = LINGUISTIC

[url=]6388718[/url]

Partial multibyte character in V$SQL.SQL_TEXT (SP2-784 from sqlplus)

[url=]6398252[/url]

CHAR columns from HS source not correctly blank padded if NLS translated

[url=]6400373[/url]

Wrong result from DBMS_XMLGEN.CONVERT with multibyte input

[url=]6439315[/url]

Two byte null terminator missing for SQLT_AVC SQLCS_NCHAR define

[url=]6447861[/url]

OERI[evacolverflow] from monolingual sort in multibyte database

[url=]6455659[/url]

Stored outlines do not work in multibyte DB

[url=]6458801[/url]

REPLACE on a CLOB can corrupt multibyte data

[url=]6460895[/url]

CSSCAN may hang / run slowly

[url=]6494820[/url]

CSSCAN fails with ORA-1455 on tables with more than 2^31-1 blocks

[url=]6510788[/url]

Wrong results from LIKE with certain NLS_SORT settings

[url=]6627733[/url]

OERI[dmlsrvColLenChk_2:dty] inserting NULLs into CHAR length semantics column

[url=]6642692[/url]

Wrong results from LIKE operator with NLS_SORT=BINARY_CI and NLS_COMP=linguistic

[url=]6712066[/url]

Wrong result from internal copy of certain NLS characters

[url=]6770202[/url]

SQL Loader returns ORA-12899 with DIRECT=Y for shift sensitive data

Hang (Involving Shared Resource)

[url=]6310591[/url]

DB hang with CKPT waiting for enquiry response in RAC

[url=]6406880[/url]

System hang possible after killing processes when waiting for flashback logs

[url=]6418420[/url]

Database wide hang with process trying to flush buffers from the cache in RAC

[url=]6522708[/url]

ASM instance may hang

[url=]6809093[/url]

Hang due to TT enqueue waits on an UNDO tablespace

Hang (Process Hang)

[url=]6684124[/url]P

Win: Intermittant hang on shutdown immediate/normal

[url=]2227223[/url]

ALTER TABLESPACE READ ONLY waits for all active transactions to complete

[url=]5476091[/url]

Ctrl-C ignored for sessions waiting for mutexes

[url=]5756769[/url]

Deadlock between Create MVIEW and DML

[url=]6120004[/url]

Concurrent eager transactions may cause logical standby apply to hang

[url=]6144079[/url]

Instance crash in RAC (OERI:2103)

[url=]6169451[/url]

OCCI client hangs after TAF failover when using session pools

[url=]6175584[/url]

Insert hang with Foreign Key constraint and read-only tablespace

[url=]6219529[/url]

RAC hang during exchange with hash locks

[url=]6334552[/url]

Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize

[url=]6394429[/url]

Sessions in resource group may be blocked

[url=]6410146[/url]

Self deadlock from unbundled describe call

[url=]6447303[/url]

Processes hang waiting for “DFS lock handle” on DROP DATAFILE

[url=]6475688[/url]

Concurrent rewrite and on-commit refresh can deadlock (library cache pin <–> lock)

[url=]6496514[/url]

RAC deadlock between “libary cache lock” and TX enqueue

[url=]6603936[/url]

Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client

[url=]6618312[/url]

Deadlock between ON COMMIT materialized view refresh and query rewrite (library cache pin V lock deadlock)

[url=]6644122[/url]

ON COMMIT refresh deadlock (library cache pin V lock)

[url=]6667800[/url]

OERI:12333 / client hang using OCILob() in multithreaded OCI client

[url=]6710019[/url]

Deadlock / hang from concurrent MV refresh and TRUNCATE

[url=]6711644[/url]

Dump / hang in multithreaded OCI client

[url=]6733394[/url]

RMAN channel failover hangs in 11g

[url=]6970283[/url]

OCI hang / ORA-12559 after FAN notification

Hang (Process Spins)

[url=]4699720[/url]

MMON or PMON spin in RAC

[url=]4932003[/url]

Query spins when certain REGEXP_LIKE regular expression is used

[url=]5457450[/url]

Excessive polling of the aq$_<qtab>_f queue table view from dequeue by condition

[url=]6084108[/url]

Dump / CPU spin possible after an ORA-3115

[url=]6265559[/url]

Apply spins after sequence altered at primary

[url=]6337547[/url]

High CPU from query with DSLASH on recursive schema

[url=]6346393[/url]

Import can load bad SYS.ANYDATA into the database

[url=]6460895[/url]

CSSCAN may hang / run slowly

[url=]6511361[/url]

DMON may loop trying to resilver a mirrored block

[url=]6605370[/url]

Excessive hard parse time for nested SQL

[url=]6640950[/url]

Update of LONG can cause Streams capture to spin / spill

[url=]6738567[/url]

JVM spins / fails to compile a class with modulus (%) operator

[url=]6795880[/url]

Session spins / OERI after ‘kksfbc child completion’ wait

[url=]6849184[/url]

Spin with ODM with mirrored disks

[url=]6919764[/url]

LMS spin (kclobj) / instance crash

Hash Join

[url=]5947623[/url]

Excess PGA memory used by hash joins

[url=]6126439[/url]

A query with hash join takes a long time to abort from kill session

[url=]6471770[/url]

ora-32690/OERI [32695] [hash aggregation can't be done] from Hash GROUP BY

[url=]6506617[/url]

Wrong results from STAR transformation with extended pruning

Index Organized Tables (IOT)

[url=]6646613[/url]*

IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1

[url=]4527606[/url]

MOVE of IOT can cause corruption / OERI

[url=]5406763[/url]

Wrong cost when access IOT through secondary index

[url=]5885265[/url]

Deferred constraints may incorrectly error at commit for IOTs

[url=]5944227[/url]

SQLloader direct path load into IOT can dump [kdblldrp]

[url=]6070548[/url]

Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT

[url=]6354678[/url]

Wrong results from FIRST ROW MIN / MAX optimization on secondary IOT index

[url=]6620517[/url]

ORA-29308 from TSPITR with IOT with LOB column

[url=]6794366[/url]

CTAS dumps under qertqosSetProperties creating an IOT

Instance May Crash

[url=]7893531[/url]I

11.1.0.6 RDBMS may abort when run with 11.1.0.7 CRS

[url=]6336234[/url]P

Win: Stack overflow can abort the instance / service

[url=]6489596[/url]P

HP: Instance crash possible if DIAG attempts to get a stack

[url=]6849769[/url]P

HP-Itanium: Instance crash possible if DIAG attempts to get a stack

[url=]5686407[/url]

SGA memory corruption / instance crash with various ORA-600 [171XX] when using XDB

[url=]6075582[/url]

OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash

[url=]6079224[/url]

Recommended on Linux: RAC ORA-27506 / IPC Send timeout

[url=]6144079[/url]

Instance crash in RAC (OERI:2103)

[url=]6153945[/url]

SMON crashes instance with OERI[ktcrsp_1: drop/truncate not comp]

[url=]6269484[/url]

OERI [kjbresourcelatch] from DBW if there is a corrupt block in cache

[url=]6271689[/url]

RAC instance crash possible

[url=]6378112[/url]

LMS can crash RAC instance with OERI[kjblpkeydrmqscchk:pkey]

[url=]6500033[/url]

LMON crash the instance with ORA-481 due to DRM sync timeout

[url=]6501007[/url]

DRM sync timeout in RAC

[url=]6509115[/url]

Instance crash in RAC due to OERI[504] on LMD

[url=]6518062[/url]

RAC instance crah with OERI[kjlremast]

[url=]6527427[/url]

ASM instance crash due to OERI:kfclAddToClose10 / OERI:kfcldolockop35

[url=]6639644[/url]

ASM instance crash (ORA-15040 in SMON) during instance recovery in RAC

[url=]6658484[/url]

Instance crash / OERI[kclexpand_5] from DRM in RAC

[url=]6737765[/url]

PMON dump [kgskrecalc] crashes instance cleaning dead process

[url=]6765855[/url]

DBW crashes instance with OERI[kjbrwreq:wip_piscn]

[url=]6778714[/url]

Instance crash in RAC when PMON cleans dead process

[url=]6859515[/url]

Diagnostic collection may hang or crash the instance

[url=]6925708[/url]

OERI:[kfclbast0_05] can occur in ASM with RAC and LMS may crash the ASM instance

[url=]6934230[/url]

Instance crash from OERI:kfnmClientRegister05 with ASM

[url=]6954722[/url]

OERI[15709] in SMON in RAC / instance crash

Instance Startup

[url=]6417713[/url]P

Linux PowerPC: Dump during startup / during select from V$OSSTAT

[url=]6442900[/url]P

Solaris: ORADISM process does start

[url=]6143688[/url]

node startups cAN spend up to 2 mins in AQ partition code

[url=]6469211[/url]

Slow startup with many log files on ASM

[url=]6619318[/url]

GIM-105/GIM-104 from EM Healthcheck during instance startup

[url=]6624011[/url]

ORA-4030 / ORA-4031 on startup with > 4Gb SGA_TARGET

[url=]6795133[/url]

Startup delayed by QMNC queries

Interoperability (Between Releases)

[url=]7893531[/url]I

11.1.0.6 RDBMS may abort when run with 11.1.0.7 CRS

[url=]5377242[/url]

OERI[16203] on reference to remote synonym

[url=]6749942[/url]

Cannot use 11g expdp with NETWORK_LINK to 10g

[url=]6899909[/url]

PLS-907 from pre-11g PLSQL clients

JDBC

[url=]5437593[/url]

Millisecond value not present using TIMESTAMPTZ.dateValue()

[url=]5764402[/url]

JDBC TIMESTAMPTZ problems with milliseconds

[url=]6278984[/url]

java.awt.font.glyphvector.getglyphoutline returns empty shape

[url=]6341494[/url]

Invalid property name JMSXRcvTimestamp specified for OJMS messages

[url=]6629411[/url]

ArrayOutofBoundsException using awt GlyphVector

[url=]6868399[/url]

JDBC TIMEZONETAB.getOffset() returns wrong GMT offset

JavaVM / JSP / Corba etc..

[url=]6639384[/url]P

Win: SocketException using IIOP sockets in stored Java

[url=]5377060[/url]

ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES

[url=]5613685[/url]

Socket.connect() does not respect the timeout period in the JVM

[url=]6310590[/url]

OERI:17147 under ioc_get_granted_roles in JVM

[url=]6392076[/url]

Streams does not handle Java DDL correctly

[url=]6408917[/url]

Excessive PGA memory use for REF cursors returned from stored Java

[url=]6501565[/url]

Dump under JVM from JIT of Java class compiled with old Java compiler

[url=]6640012[/url]

Dump compiling stored Java

[url=]6641438[/url]

Java native frames not cleaned up

[url=]6650069[/url]

ExceptionInInitializerError from JVM

[url=]6653675[/url]

OERI[kgeade_is_0] under ioc_exit_call

[url=]6653782[/url]

OERI[kghfru:ds] in Java Pool when using 64Mb granule size

[url=]6723072[/url]

java.lang.SecurityException using Kerberos in stored Java

[url=]6738567[/url]

JVM spins / fails to compile a class with modulus (%) operator

[url=]6743907[/url]

OCI-21500 [17099] / Java VM dump when concurrent threads use same XDBDocument.toString()

[url=]6833814[/url]

DBMS_JAVA.DEPLOY_CLOSE should not exist

Job Queues

[url=]5705385[/url]

DBMS_SCHEDULE chain does not complete

[url=]5928612[/url]

V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs

[url=]6071651[/url]

Delays executing a job if execution time exceeds SCHEDULE_LIMIT

[url=]6330994[/url]

ORA-1830 from jobs executing programs with TIMESTAMP metadata arguments

[url=]6729716[/url]

expdp/impdp changes scheduler start_date (the year part)

[url=]6805387[/url]

Job slaves not recycled in RAC

[url=]7147411[/url]

Memory corruption / dump in kslgetl in CJQ

Latch Contention

[url=]5918642[/url]

Heavy latch contention with DB_CACHE_ADVICE on

[url=]6333663[/url]

Shared pool latch contention due to fragmentation of large pool

[url=]6356566[/url]

Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

[url=]6505878[/url]

“shared pool” latch contention from XA / distributed transactions

[url=]6530010[/url]

High version count for cursor with binds with fix for bug 5872943

Leak (Memory Leak / Growth)

[url=]5386986[/url]

Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table

[url=]5947623[/url]

Excess PGA memory used by hash joins

[url=]6011182[/url]

Parsing of large query takes long time / memory leak / ORA-4030 /4031

[url=]6049324[/url]

Memory leak from array dequeue

[url=]6065604[/url]

DBMS_AQ.DEQUEUE_ARRAY PGA memory leak

[url=]6181488[/url]

Logical standby can fail ith ORA-4030

[url=]6262792[/url]

MTA Extproc memory leak

[url=]6271590[/url]

SGA subheap imbalance with lots of free memory in a few subheaps

[url=]6356566[/url]

Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

[url=]6400175[/url]

Memory leak from DML with session_cached_cursors with TRIGGERs

[url=]6408917[/url]

Excessive PGA memory use for REF cursors returned from stored Java

[url=]6414844[/url]

Wasted memory possible from batch allocations in kghu subheaps

[url=]6471770[/url]

ora-32690/OERI [32695] [hash aggregation can't be done] from Hash GROUP BY

[url=]6506816[/url]

ORA-4030 / memory leak in ’session heap’ using XDB

[url=]6506818[/url]

PGA memory leak (koh dur heap) converting XMLType to CHAR

[url=]6615740[/url]

ORA-4030 in logical standy (“knas:shtrans”)

[url=]6653879[/url]

XA tracing leaks client side memory / dumps if trace cannot be written

[url=]6656630[/url]

XmlAgg with GROUP BYleaks memory

[url=]6800507[/url]

Shared pool memory leak (“ksws service *” memory) using EXPDP often

[url=]6827260[/url]

Excessive memory usage for LCR cache due to large freelists

Leak (Resources Eg: File Handles)

[url=]5705795[/url]P*

Many child cursors possible for SQL using BINDS. This bug is alerted in Note:403616.1

[url=]4693355[/url]

ASM does not close open descriptors even after DROP DISKGROUP

[url=]5377060[/url]

ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES

[url=]6139547[/url]

Shadow process leak on ASM instance when diskspace exhausted (ORA-20)

[url=]6530010[/url]

High version count for cursor with binds with fix for bug 5872943

[url=]6625888[/url]

File handles open on dropped datafiles in RAC

[url=]6730200[/url]

Kernel Asynch IO leak possible in some clients

Literal Replacement (CURSOR_SHARING)

[url=]3461251[/url]

V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING

[url=]4071519[/url]

GROUP BY query with CURSOR_SHARING fails with ORA-1802

[url=]5757106[/url]

OERI[15851] selecting aggregate of a constant with literal replacement

[url=]6163785[/url]

Intermittent Wrong Results with dblink and cursor_sharing

[url=]6337716[/url]

Wrong max column size for NULL strings with literal replacement

[url=]7212120[/url]

Session cursor cache not used properly when CURSOR_SHARING=force/similar

LogMiner

[url=]5852363[/url]

V$LOGMNR_CONTENTS.SSN may be wrong for some INSERT operations

[url=]6268409[/url]

ORA-29275 error when querying the sql_redo/undo columns of V$LOGMNR_CONTENTS

[url=]6317884[/url]

ORA-1280 from DBMS_LOGMNR.START_LOGMNR without ADD_LOGFILE

[url=]6413089[/url]

Restarting a logminer session can be slow if the session has fallen behind

[url=]6451626[/url]

Dump selecting from V$LOGMNR_CONTENTS or FLASHBACK_TRANSACTION_QUERY

[url=]6650256[/url]

PDDL causes logminer spill

[url=]6683178[/url]

Capture performance degrades due to lots of DDL (eg truncate of empty tables)

Memory Corruption

[url=]5670840[/url]

Various OERI from Resource Manager

[url=]5686407[/url]

SGA memory corruption / instance crash with various ORA-600 [171XX] when using XDB

[url=]6402843[/url]

OERI [17183]/[17128] memory corruption from REGEXP_SUBSTR

[url=]6408390[/url]

Memory corruption from calls to ldmWrite

[url=]6452485[/url]

SGA memory corruption / OERI [17182] with fix for bug 6085625

[url=]6603936[/url]

Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client

[url=]6756739[/url]

OERI[17183] / dump (kxttDrpPh) using temporary tables

[url=]7147411[/url]

Memory corruption / dump in kslgetl in CJQ

Merge SQL (MERGE .. USING)

[url=]7123643[/url]+

Wrong results (NULL) from select on compressed table

[url=]5990542[/url]

OERI[kxfqenq1] / Dump (kxfqgky) from MERGE on one table partition

[url=]6318678[/url]

ORA-904 from MERGE SQL over database link

[url=]6379123[/url]

EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

[url=]6694370[/url]

Update phase of serial direct path merge writes more redo than an update

Migration / Upgrade / Downgrade

[url=]6646613[/url]*

IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1

[url=]6770913[/url]*

Various errors during upgrade to 11g. This bug is alerted in Note:579523.1

[url=]6339160[/url]I

OERI [qctostiix1] can occur during upgrade to 10.2

[url=]6052351[/url]

Dump running catupgrd.sql when creating/replacing streams$transformation_info

[url=]6194594[/url]

OERI[kokeeiix3] can occur during upgrade from 9.2 to 11g with XDB

[url=]6279631[/url]

OERI[kocgpn129] can occur during upgrade from

[url=]6318357[/url]

ORA-29537 during upgrade to 11g

[url=]6379123[/url]

EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

[url=]6446262[/url]

ORA-31000 / other errors on upgrade if INVALID old object versions exist

[url=]6736527[/url]

ORA-30552 from utlrp during 11g upgrade

[url=]6750214[/url]

RMAN-600 [3040] upgrading to 11g catalog

[url=]6929736[/url]

RMAN-6443 running upgrade catalog after export RMAN schema from 10.2 to 11.1

[url=]6956657[/url]

Object tables can become invalid after 10.2->11.1 upgrade

NUMA Related

[url=]6774317[/url]

Long delays when using Resource manager with active session limits on Numa

[url=]6868080[/url]

ORA-4031 with NUMA

Network

[url=]6639384[/url]P

Win: SocketException using IIOP sockets in stored Java

[url=]6083037[/url]

Server side load balancing does not work

[url=]6598142[/url]

OERI:krsb_stream_receive.2 on standby using DCD

OCCI

[url=]6142534[/url]

OCCI getObject() fails to fetch null using isNull() from object with VARRAY

[url=]6156762[/url]

OCCI fractional seconds portion can be wrong

[url=]6169451[/url]

OCCI client hangs after TAF failover when using session pools

[url=]6265838[/url]

OCCI / OCI client can dump in upibrk during failover

[url=]6280961[/url]

OCCI AQ client dumps on FAILOVER

OCI

[url=]7335808[/url]P

Unix: No 32bit instant client make target (ilibociei32)

[url=]5765361[/url]

Client dump using OCIDirPathPrepare in OCI_UTF16ID mode

[url=]5872943[/url]

Adjusting OCI_ATTR_MAXCHAR_SIZE in OCI can cause ORA-1460

[url=]6008713[/url]

libclntsh.so loads itself with “global mode” (can cause symbol collisions)

[url=]6119750[/url]

Cannot register OCI callback for OCIAppCtxSet / OCIAppCtxClearAll

[url=]6168297[/url]

ORA-12899 from OCIDirPathColArrayToStream with UTF8

[url=]6265838[/url]

OCCI / OCI client can dump in upibrk during failover

[url=]6270834[/url]

Dump from multi-threaded client using signal handlers

[url=]6343883[/url]

ORA-932 when using OCI_DESCRIBE_ONLY with user binds

[url=]6439315[/url]

Two byte null terminator missing for SQLT_AVC SQLCS_NCHAR define

[url=]6603936[/url]

Hang/memory corruption/OCI-21500 using LOBS in OCI_OBJECT mode in multi-threaded client

[url=]6607676[/url]

Client hang / dump (kpufhndl0)

[url=]6667800[/url]

OERI:12333 / client hang using OCILob() in multithreaded OCI client

[url=]6711644[/url]

Dump / hang in multithreaded OCI client

[url=]6750302[/url]

OCI AQ listener client may dump

[url=]6756089[/url]

Floating point numbers in OBJECTs can loose precision > 5

[url=]6828981[/url]

Unexpected ORA-1461 from SQL over database link

[url=]6960874[/url]

ORA-1483 can occur with fix for bug 6828981

[url=]6970283[/url]

OCI hang / ORA-12559 after FAN notification

Online DDL

[url=]6653934[/url]

Dump / block corruption from ONLINE segment shrink with ROWDEPENDENCIES

Optimizer

[url=]4444536[/url]

Unnecessary sorting when access made through a global index

[url=]5234947[/url]

ORA-904 from DBMS_STATS.gather_table_stats

[url=]5284200[/url]

Suboptimal plan from SELECT DISTINCT with CONNECT BY

[url=]5406763[/url]

Wrong cost when access IOT through secondary index

[url=]5705630[/url]

Suboptimal plan from ‘or’ expansion

[url=]5893396[/url]

Wrong results possible due to invalid stored outline

[url=]5919513[/url]

Incorrect costing for a top-n query with GROUP BY NOSORT

[url=]5936366[/url]

Wrong results / dump from query on view with select list subquery

[url=]5944076[/url]

Suboptimal plan in FIRST_ROWS(K) mode

[url=]6007259[/url]

CBO does not consider ORA concatenation

[url=]6011182[/url]

Parsing of large query takes long time / memory leak / ORA-4030 /4031

[url=]6016087[/url]

OERI[15160] from subquery unnesting

[url=]6020789[/url]

Dump [vopplog] pushing join predicates

[url=]6021687[/url]

Dump (evaopn2) from COUNT STOPKEY in plan with UNION ALL

[url=]6029071[/url]

Wrong results from distributed SQL with OUTER joins

[url=]6029469[/url]

Suboptimal plan for MIN/MAX optimized query on partitioned table

[url=]6038461[/url]

Wrong results from SQL with UNION and a fast DUAL subquery

[url=]6041584[/url]

Join elimination not working when function-based index exists on table

[url=]6042205[/url]

High parse time for a query using ORDER BY

[url=]6051211[/url]

Too High Join Cardinality with Histograms Present

[url=]6060048[/url]

Dump [kkqtsetgfr] optimizing a query with correlated subquery

[url=]6061623[/url]

OERI:qctcte1 from cost based transformation of INSERT as SELECT with TO_LOB

[url=]6062266[/url]

Cardinality of 0 for range predicate and no histograms

[url=]6070954[/url]

Skip scan may be used instead of a better range scan

[url=]6073325[/url]

OERI[kkqcbydrv:1] from CONNECT BY

[url=]6075238[/url]

OERI[qctcte1] on parse of query with views / subqueries

[url=]6077514[/url]

DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache

[url=]6082745[/url]

Bad Cardinality Estimation with Single Value in Frequency Histograms

[url=]6084811[/url]

MERGE JOIN CARTESIAN not considered

[url=]6087237[/url]

CBO may not choose best join order

[url=]6112946[/url]

gather_database_stats() may be slow (compared to gather_database_stats_job_proc)

[url=]6119382[/url]

More expensive Index range scan chosen for TIMESTAMP predicate

[url=]6119884[/url]

Wrong results with query with OR operator with OR expansion

[url=]6120483[/url]

Query with INLIST does not choose cheapest index (suboptimal plan)

[url=]6122894[/url]

Poor plan from UNION / INTERSECT views with OR predicates

[url=]6123567[/url]

Dump [kkosbn] optimizing query on partitioned table

[url=]6134565[/url]

FIRST_ROWS hint is not honored with “_sort_elimination_cost_ratio” parameter set

[url=]6138746[/url]

Poor plan for SQL with subqueries

[url=]6145570[/url]

Wrong results / OERI from LIKE with join predicate pushdown

[url=]6146906[/url]

Complex view not merged with ROWID in query

[url=]6151963[/url]

Wrong join cardinality with histograms

[url=]6159522[/url]

OERI[qkaffsindex3] from ANALYZE TABLE .. ESTIMATE STATISTICS

[url=]6163564[/url]

Poor cardinality from “LIKE” predicates and binds

[url=]6167716[/url]

Improve ability to eliminate tables from query

[url=]6183577[/url]

OERI[15851] / wrong results / error from UPDATE involving views and subqueries

[url=]6194582[/url]

High hard parse time with function based indexes

[url=]6207468[/url]

Dump (under kkofkrProrateStat) optimizing SQL in FIRST_ROWS mode

[url=]6239971[/url]

CBO costing can differ greatly for =< compared to <

[url=]6251917[/url]

Optimizer selects the merge join cartesian despite the hints

[url=]6276590[/url]

OERI[qctstc2o1] can occur with RBO

[url=]6279242[/url]

Stored outline does not reproduce original parallel plan

[url=]6282093[/url]

Cost based CONNECT BY does not OR expand START WITH

[url=]6282944[/url]

Poor CONNECT BY performance with complex views

[url=]6310653[/url]

OERI [kkqctmdcq: Query Block Could Not] on INSERT as SELECT

[url=]6315495[/url]

OERI[qctstc2o1] / OERI [kkqtcpopn: 0] optimizing subquery inside subquery

[url=]6316585[/url]

Dump / OERI from complex view merging

[url=]6319761[/url]

ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS

[url=]6326934[/url]

Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind

[url=]6329318[/url]

Selectivity of range predicate lower than equality

[url=]6336044[/url]

Dump using DBMS_OUTLN.CREATE_OUTLINE

[url=]6344547[/url]

ORA-6512/ORA-904 from DBMS_STATS with invisible index

[url=]6350462[/url]

Incorrect index statistics scaling for first_rows(k)

[url=]6360414[/url]

OUTLINE does not store USE_HASH_AGGREGATION hint

[url=]6391154[/url]

Stored outlines using OR-expansion ignored if _NO_OR_EXPANSION set

[url=]6399168[/url]

DBMS_STATS can be slow for large table with bitmap indexes

[url=]6400795[/url]

Wrong results from view merging

[url=]6401981[/url]

Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs

[url=]6405967[/url]

Wrong (duplicate) results from view with incorrelated subquery (any, in)

[url=]6408017[/url]

OERI[12811] optimizing a query against fixed view/s

[url=]6438752[/url]

Suboptimal plan due to incorrect costing of unnested subquery

[url=]6438892[/url]

Suboptimal plan with ROWNUM predicate and NESTED LOOPS

[url=]6443402[/url]

Dump [kkommnnj] from LEFT OUTER JOIN

[url=]6455659[/url]

Stored outlines do not work in multibyte DB

[url=]6468287[/url]

Suboptimal plan when ORDER BY includes a VIEW column that has constant predicate

[url=]6469667[/url]

Suboptimal plan with pushed predicates and encrypted column/s

[url=]6488803[/url]

Suboptimal plan due to no group by pushdown without aggregates in PQ

[url=]6503543[/url]

Suboptimal plan due to bad cardinality estimate for RANGE join predicates

[url=]6511034[/url]

Join Cardinality Overly estimated

[url=]6526370[/url]

New GRANULARITY option for DBMS_STATS

[url=]6597500[/url]

Wrong results from CHAR column comparison to constants longer than the column

[url=]6626018[/url]

Cost of filter operation computed as too low a value

[url=]6634836[/url]

Wrong results with view merge and Anti/Semi Join with an aggregate

[url=]6642751[/url]

Dump (qkabxo) from FIRST_ROWS_K if bitmap index chosen / OERI:kkobmid

[url=]6644714[/url]

High number of child cursors with adaptive cursor sharing

[url=]6655241[/url]

DBMS_STATS slow gathering statistics on table with a LOB column

[url=]6656356[/url]

Join elimination may not work if there are join indexes

[url=]6671155[/url]

No join elimination with top level OR in HAVING clause

[url=]6673512[/url]

OERI:qksvcProcessExprCBK_fail from SEM_MODEL query

[url=]6674254[/url]

Suboptimal plan from FIRST_ROWS(x)

[url=]6679567[/url]

DBA_INDEXES.GLOBAL_STATS is “NO” when gather auto stats for partitioned index

[url=]6688200[/url]

No join elimination when WHERE clause uses high level/condition

[url=]6696221[/url]

Outline from OPTIMIZER_FEATURES_ENABLE=8.1.7 not used

[url=]6707916[/url]

Wrong results from join elimination

[url=]6708183[/url]

CBO cannot get good cardinality estimate for TABLE() functions

[url=]6714199[/url]

No pushup through both dimensions for partition wise join

[url=]6718212[/url]

enhancement to dbms_stats to merge column usage statistics from remote system

[url=]6739591[/url]

Wrong results from OUTER JOIN, VIEW, GROUP BY and predicate move around

[url=]6771838[/url]

Suboptimal plan from join with UNION view with empty branch

[url=]6780413[/url]

Wrong results from predicate push with model SQL

[url=]6786141[/url]

Statistics not exchanged when exchanging composite partitioned tables

[url=]6830451[/url]

Wrong results unnesting correlated count subquery and multicolumn expression

[url=]6833602[/url]

Wrong results with BITMAP OR

[url=]6894671[/url]

Wrong results from join elimination

[url=]6901061[/url]

Wrong result from merged outer join view

[url=]6917874[/url]

Wrong results from multi level push of join predicates

[url=]6969498[/url]

Wrong results from index join

[url=]6969743[/url]

Dump (kkoajt) from GROUP BY placement optimization with an anti join

[url=]6972343[/url]

Wrong results with push predicate and cost based transformation

[url=]7014646[/url]

OERI [kkocxj : pjpctx] from complex query

[url=]7039337[/url]

Wrong results on query using GROUP BY placement

[url=]7148905[/url]

Wrong result from subquery unnesting

[url=]7162354[/url]

Wrong results from join predicate push with a ROWID predicate

[url=]7189447[/url]

Wrong results when view merging applied to query

[url=]7213010[/url]

Adaptive cursor sharing generates lots of child cursors

Optimizer (Stored Outlines)

[url=]5893396[/url]

Wrong results possible due to invalid stored outline

[url=]6279242[/url]

Stored outline does not reproduce original parallel plan

[url=]6391154[/url]

Stored outlines using OR-expansion ignored if _NO_OR_EXPANSION set

[url=]6455659[/url]

Stored outlines do not work in multibyte DB

Optimizer (Subquery Factoring – WITH clause)

[url=]6082605[/url]

ORA-32036 while executing a WITH clause statement

[url=]6318487[/url]

Dump (qknviAllocate) from star transformation of SQL using WITH clause

[url=]6360220[/url]

ORA-21780 from subquery factoring SQL WITH clause

[url=]6643093[/url]

Wrong results from CONNECT BY and WITH clause

[url=]6679575[/url]

Wrong results from CONNECT BY and WITH clause

[url=]6797740[/url]

Dump [kkqvmValidAJView] using a SQL WITH clause and anti join

Optimizer Bad Cardinality

[url=]6051211[/url]

Too High Join Cardinality with Histograms Present

[url=]6062266[/url]

Cardinality of 0 for range predicate and no histograms

[url=]6082745[/url]

Bad Cardinality Estimation with Single Value in Frequency Histograms

[url=]6151963[/url]

Wrong join cardinality with histograms

[url=]6163564[/url]

Poor cardinality from “LIKE” predicates and binds

[url=]6326934[/url]

Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind

[url=]6329318[/url]

Selectivity of range predicate lower than equality

[url=]6401981[/url]

Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs

[url=]6438892[/url]

Suboptimal plan with ROWNUM predicate and NESTED LOOPS

[url=]6503543[/url]

Suboptimal plan due to bad cardinality estimate for RANGE join predicates

[url=]6511034[/url]

Join Cardinality Overly estimated

[url=]6708183[/url]

CBO cannot get good cardinality estimate for TABLE() functions

Oracle Disk Manager

[url=]6849184[/url]

Spin with ODM with mirrored disks

Oracle Enterprise Manager

[url=]6826271[/url]

EUSM and OLS Jar files from client ORACLE_HOME

Oracle Label Security

[url=]5839280[/url]

OERI[15265] dropping OLS policy

[url=]6713587[/url]

Usernames with hyphens cannot connect when OLS is installed

Oracle Text (Formerly interMedia Text)

[url=]5867231[/url]

OERI:qernsRowP on Text query with NLS_COMP / NLS_SORT set

[url=]5908945[/url]

Dump [qxopqdca] with ancilliary operator

[url=]6357601[/url]

Romanian base letter mapping missing for some characters

PL/SQL

[url=]5051432[/url]

DBMS_LOB does not execute with the privileges of the calling procedure

[url=]5377242[/url]

OERI[16203] on reference to remote synonym

[url=]5685189[/url]

Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors

[url=]6192202[/url]

Wrong results from subquery unnesting and functions

[url=]6258480[/url]

Dump [lxhh2ci] possible

[url=]6510615[/url]

REF CURSOR opened by PLSQL does not use session cursor cache

[url=]6628326[/url]

ORA-3001 selecting from pipelined table function

[url=]6899909[/url]

PLS-907 from pre-11g PLSQL clients

[url=]7228701[/url]

Client side PLSQL compilation against server may fail with ORA-604 / ORA-1

[url=]7234765[/url]

Wrong results from PLSQL function over an ORDER BY view

PL/SQL (DBMS Packages)

[url=]5049352[/url]

DBMS_LOB.LOADCLOBFROM does not work on files over 4gb (ORA-22288)

[url=]5234947[/url]

ORA-904 from DBMS_STATS.gather_table_stats

[url=]5607386[/url]

DBMS_METADATA.SET_TRANSFORM_PARAM ignored for synonyms and comments

[url=]5685189[/url]

Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors

[url=]5705385[/url]

DBMS_SCHEDULE chain does not complete

[url=]5747615[/url]

DBMS_DATAPUMP.DATA_FILTER filter INCLUDE_ROWS=1 does not export row data

[url=]5881123[/url]

DBMS_METADATA does not extract column alias of MVIEWs

[url=]5944874[/url]

TABLE_STATISTICS through DBMS_METADATA returns analyze if function based index present

[url=]6005996[/url]

DBMS_METADATA.GET_DDL generates incorrect DDL with UNUSED columns

[url=]6017760[/url]

DBMS_METADATA.GET_DDL does not show changed datafile attributes

[url=]6051635[/url]

Wrong DDL from DBMS_METADATA for domain index or index on XMLType column

[url=]6077514[/url]

DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache

[url=]6112946[/url]

gather_database_stats() may be slow (compared to gather_database_stats_job_proc)

[url=]6319761[/url]

ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS

[url=]6344547[/url]

ORA-6512/ORA-904 from DBMS_STATS with invisible index

[url=]6399168[/url]

DBMS_STATS can be slow for large table with bitmap indexes

[url=]6401981[/url]

Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs

[url=]6454237[/url]

Wrong output from DBMS_METADATA.GET_DDL for trigger definition with comment

[url=]6472131[/url]

DBMS_METADATA.GET_DDL returns wrong DDL for CREATE of dictionary managed TEMPORARY tablespace

[url=]6474004[/url]

DBMS_METADATA GET_SXML output does not show RELY for a table constraint

[url=]6526370[/url]

New GRANULARITY option for DBMS_STATS

[url=]6635956[/url]

DBMS_METADATA / Datapump import fails with LPX-7/ORA-39125

[url=]6655241[/url]

DBMS_STATS slow gathering statistics on table with a LOB column

[url=]6661393[/url]

Setting CLIENT_INFO does not affect CLIENT_IDENTIFIER

[url=]6718212[/url]

enhancement to dbms_stats to merge column usage statistics from remote system

[url=]6760697[/url]

DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not detect certain segment header block corruption

PL/SQL External Procedures (EXTPROC)

[url=]6397073[/url]

Cannot open SYSDBA connection in EXTPROC callout

Parallel Query (PQO)

[url=]5223587[/url]

OERI[4400] from distributed PDML with DDL

[url=]5400635[/url]

Wrong Results with Parallel, Null Aware Right Anti Join and Aggregates

[url=]5476091[/url]

Ctrl-C ignored for sessions waiting for mutexes

[url=]5695112[/url]

Dump (kdudcp) from parallel update

[url=]5875941[/url]

PQ slave may run under wrong consumer group

[url=]5947231[/url]

Wrong results from parallel STAR query (with temp_disable)

[url=]5976269[/url]

Queries using a loopback database link cannot execute in parallel

[url=]5990542[/url]

OERI[kxfqenq1] / Dump (kxfqgky) from MERGE on one table partition

[url=]6057203[/url]

Corruption / OERI [kcbchg1_6] from Parallel update

[url=]6110752[/url]

OERI[[qerbuNStrp:eridgt] from parallel bitmap merge

[url=]6241497[/url]

Resource manager with PQ enabled does not use parallelism

[url=]6274465[/url]

DML / queries run serially instead of parallel when there is concurrent DDL

[url=]6279242[/url]

Stored outline does not reproduce original parallel plan

[url=]6327692[/url]

Wrong results from parallel query

[url=]6394739[/url]

PARALLEL_EXECUTION_MESSAGE_SIZE cannot be set above 16384 in RAC

[url=]6402957[/url]

Suboptimal parallel query performance for Top-n rank queries.

[url=]6405339[/url]

Corruption / OERI[kcbz_check_objd_typ_3] / OERI:5400 / OERI:5357 from PQ

[url=]6474009[/url]

On ASSM tablespaces Scans using Parallel Query can be slower than in 9.2

[url=]6488803[/url]

Suboptimal plan due to no group by pushdown without aggregates in PQ

[url=]6525904[/url]

Serial extent map read with PQ and partitioning

[url=]6650256[/url]

PDDL causes logminer spill

[url=]6714608[/url]

Wrong results with star transformation and parallel query

[url=]6748058[/url]

A parallel query executes serially due to correlation variable

[url=]6963900[/url]

OERI[kkoSlaveMapping:pujoi1] on parallel partition wise join

[url=]6995851[/url]

Needless trace from PQ slave on signature mismatch

[url=]7428612[/url]

ORA-17510 when query runs in parallel using index_ffs and sample block

[url=]8255306[/url]

Wrong results from parallel query and ORs

Partitioned Tables

[url=]4444536[/url]

Unnecessary sorting when access made through a global index

[url=]5984440[/url]

Dump [prsatb] from ALTER TABLE .. MODIFY SUBPARTITION

[url=]5990542[/url]

OERI[kxfqenq1] / Dump (kxfqgky) from MERGE on one table partition

[url=]6029469[/url]

Suboptimal plan for MIN/MAX optimized query on partitioned table

[url=]6119382[/url]

More expensive Index range scan chosen for TIMESTAMP predicate

[url=]6123567[/url]

Dump [kkosbn] optimizing query on partitioned table

[url=]6198945[/url]

Dump [dtbpod_part_opt_drop] / ORA-1031 attempting to DROP a partitioned table

[url=]6315144[/url]

Dump (kkpamDInfo) selecting from a composite partitioned table

[url=]6342477[/url]

Materialized View refresh error (ORA-32313) after exchange partition

[url=]6435544[/url]

Split partition can be slow

[url=]6441665[/url]

OERI [kkpolpd12] / dictionary corruption from coalesce of composite hash partitioned table

[url=]6486145[/url]

Need a way to error out if fast split of a partition not possible

[url=]6488060[/url]

Wrong number of records updated when subparititons are truncated

[url=]6525904[/url]

Serial extent map read with PQ and partitioning

[url=]6526370[/url]

New GRANULARITY option for DBMS_STATS

[url=]6603249[/url]

Create interval partitioned table can insert bad dictionary interval data

[url=]6666915[/url]

OERI[25027] / dictionary corruption from concurrent partition DDL

[url=]6679567[/url]

DBA_INDEXES.GLOBAL_STATS is “NO” when gather auto stats for partitioned index

[url=]6714199[/url]

No pushup through both dimensions for partition wise join

[url=]6776107[/url]

TRUNCATE of highly partitioned table can be slow

[url=]6786141[/url]

Statistics not exchanged when exchanging composite partitioned tables

[url=]6801758[/url]

OERI:qksmmAdjustStatistics1 from select on partitioned table

[url=]6809176[/url]

Wrong results from Index FFS with INTERVAL partitioning

[url=]6848154[/url]

Poor performance for DDL with many partitions

[url=]6865413[/url]

Drop table without purge on large partitioned table is slow

[url=]6963900[/url]

OERI[kkoSlaveMapping:pujoi1] on parallel partition wise join

Performance Affected (General)

[url=]6814520[/url]P

Solaris: Poor performance with DB_BLOCK_CHECKSUM = TRUE

[url=]7408467[/url]P

Solaris: directio cannot be enabled for UFS datafiles

[url=]5705795[/url]P*

Many child cursors possible for SQL using BINDS. This bug is alerted in Note:403616.1

[url=]6193945[/url]

High LGWR CPU use and long ‘log file sync’ latency in RAC

[url=]6278034[/url]

Poor performance when ASM disks are OFFLINE

[url=]6319685[/url]

LGWR posts do not scale on some platforms

[url=]6399504[/url]

Offline after FORCE DROP causes staleness registry corruption

[url=]6412947[/url]

Poor performance during DRA

[url=]6470994[/url]

Poor performance when flashback database is enabled with high PROCESSES value

[url=]6774317[/url]

Long delays when using Resource manager with active session limits on Numa

[url=]6874858[/url]

Poor performance with Resource Manager when RMAN is running

[url=]7212120[/url]

Session cursor cache not used properly when CURSOR_SHARING=force/similar

Performance Monitoring

[url=]3461251[/url]

V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING

[url=]5880921[/url]

Time inconsistency between V$SYSMETRIC_HISTORY and SYSDATE

[url=]5918642[/url]

Heavy latch contention with DB_CACHE_ADVICE on

[url=]5928612[/url]

V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs

[url=]6005525[/url]

V$SQL PARSING_SCHEMA_NAME is not populated for schema owners

[url=]6034153[/url]

V$DB_PIPES PIPE_SIZE does not reflect the current pipe size

[url=]6352003[/url]

Add new ‘redo write broadcast ack time’ statistic

[url=]6356566[/url]

Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

[url=]6388718[/url]

Partial multibyte character in V$SQL.SQL_TEXT (SP2-784 from sqlplus)

[url=]6440408[/url]

ORA-1426 numeric overflow querying DBA_WAITERS / DBA_BLOCKERS

[url=]6594459[/url]

Wrong results from V$SYSMETRIC for PGA statistics

[url=]6653834[/url]

Split “virtual circuit status” into idle / non-idle waits

[url=]6733627[/url]

Unaccounted Wait Time on “Direct Path” operations with FILESYSTEM_IO_OPTIONS=NONE

[url=]6753774[/url]

V$LIBRARY_CACHE_ADVICE overestimates ESTD_LC_TIME_SAVED

[url=]7202166[/url]

No rows returned from V$MUTEX_SLEEP

Performance Of Certain Operations Affected

[url=]5600056[/url]

Export of triggers extremely slow

[url=]5747462[/url]

Poor performance of ANALYZE TABLE VALIDATE STRUCTURE CASCADE

[url=]6037872[/url]

Reconfiguration slow in active / passive with large buffer cache

[url=]6077514[/url]

DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache

[url=]6112946[/url]

gather_database_stats() may be slow (compared to gather_database_stats_job_proc)

[url=]6143688[/url]

node startups cAN spend up to 2 mins in AQ partition code

[url=]6242045[/url]

Poor performance on direct path load

[url=]6264570[/url]

Slow file creation in ASM if EM is running

[url=]6267310[/url]

Import of large table with a TIMESTAMP column is slow

[url=]6342503[/url]

Streams apply process slow down applying into SQL Server through transparent gateway

[url=]6367360[/url]

Long ASM file open times

[url=]6376915[/url]

HW enqueue contention for ASSM LOB segments

[url=]6399168[/url]

DBMS_STATS can be slow for large table with bitmap indexes

[url=]6413089[/url]

Restarting a logminer session can be slow if the session has fallen behind

[url=]6435544[/url]

Split partition can be slow

[url=]6457435[/url]

RMAN resync takes long time when v$deleted_object contains too many rows.

[url=]6476935[/url]

Slow RMAN resync due to missing index on RSR table

[url=]6505696[/url]

Fast refresh performance slow

[url=]6510615[/url]

REF CURSOR opened by PLSQL does not use session cursor cache

[url=]6529008[/url]

Slow create tablespace / add datafile

[url=]6650256[/url]

PDDL causes logminer spill

[url=]6655241[/url]

DBMS_STATS slow gathering statistics on table with a LOB column

[url=]6659496[/url]

Slow load of XML documents with TIMESTAMP WITH LOCAL TIMEZONE

[url=]6674549[/url]

Slow fast refresh performance

[url=]6683178[/url]

Capture performance degrades due to lots of DDL (eg truncate of empty tables)

[url=]6694370[/url]

Update phase of serial direct path merge writes more redo than an update

[url=]6776107[/url]

TRUNCATE of highly partitioned table can be slow

[url=]6817844[/url]

Multi pass sort with auto memory management even with plenty of PGA

[url=]6844739[/url]

Truncate very slow

[url=]6848154[/url]

Poor performance for DDL with many partitions

[url=]6865413[/url]

Drop table without purge on large partitioned table is slow

[url=]7173341[/url]

RMAN internal cleanup may be slow

Performance Of Query/ies Affected

[url=]4444536[/url]

Unnecessary sorting when access made through a global index

[url=]5251842[/url]

Poor plan against V$DATAFILE

[url=]5284200[/url]

Suboptimal plan from SELECT DISTINCT with CONNECT BY

[url=]5406763[/url]

Wrong cost when access IOT through secondary index

[url=]5705630[/url]

Suboptimal plan from ‘or’ expansion

[url=]5919513[/url]

Incorrect costing for a top-n query with GROUP BY NOSORT

[url=]5935935[/url]

Poor performance for queries involving block sampling

[url=]5944076[/url]

Suboptimal plan in FIRST_ROWS(K) mode

[url=]6007259[/url]

CBO does not consider ORA concatenation

[url=]6011182[/url]

Parsing of large query takes long time / memory leak / ORA-4030 /4031

[url=]6029469[/url]

Suboptimal plan for MIN/MAX optimized query on partitioned table

[url=]6041584[/url]

Join elimination not working when function-based index exists on table

[url=]6042205[/url]

High parse time for a query using ORDER BY

[url=]6051211[/url]

Too High Join Cardinality with Histograms Present

[url=]6070954[/url]

Skip scan may be used instead of a better range scan

[url=]6082745[/url]

Bad Cardinality Estimation with Single Value in Frequency Histograms

[url=]6084811[/url]

MERGE JOIN CARTESIAN not considered

[url=]6087237[/url]

CBO may not choose best join order

[url=]6119382[/url]

More expensive Index range scan chosen for TIMESTAMP predicate

[url=]6120483[/url]

Query with INLIST does not choose cheapest index (suboptimal plan)

[url=]6122894[/url]

Poor plan from UNION / INTERSECT views with OR predicates

[url=]6134565[/url]

FIRST_ROWS hint is not honored with “_sort_elimination_cost_ratio” parameter set

[url=]6138746[/url]

Poor plan for SQL with subqueries

[url=]6146906[/url]

Complex view not merged with ROWID in query

[url=]6151963[/url]

Wrong join cardinality with histograms

[url=]6194582[/url]

High hard parse time with function based indexes

[url=]6238700[/url]

Queries against DBA_QUEUE_SCHEDULES can be slow

[url=]6239971[/url]

CBO costing can differ greatly for =< compared to <

[url=]6251917[/url]

Optimizer selects the merge join cartesian despite the hints

[url=]6274465[/url]

DML / queries run serially instead of parallel when there is concurrent DDL

[url=]6282093[/url]

Cost based CONNECT BY does not OR expand START WITH

[url=]6282944[/url]

Poor CONNECT BY performance with complex views

[url=]6326934[/url]

Poor selectivity for equality of fixed CHAR column with VARCHAR2 bind

[url=]6328110[/url]

Select COUNT() with an encrypted column is slow

[url=]6360414[/url]

OUTLINE does not store USE_HASH_AGGREGATION hint

[url=]6400175[/url]

Memory leak from DML with session_cached_cursors with TRIGGERs

[url=]6401981[/url]

Missing NDV/MIN/MAX statistics from DBMS_STATS for table with many NULLs

[url=]6438752[/url]

Suboptimal plan due to incorrect costing of unnested subquery

[url=]6438892[/url]

Suboptimal plan with ROWNUM predicate and NESTED LOOPS

[url=]6455659[/url]

Stored outlines do not work in multibyte DB

[url=]6469667[/url]

Suboptimal plan with pushed predicates and encrypted column/s

[url=]6474009[/url]

On ASSM tablespaces Scans using Parallel Query can be slower than in 9.2

[url=]6503543[/url]

Suboptimal plan due to bad cardinality estimate for RANGE join predicates

[url=]6525904[/url]

Serial extent map read with PQ and partitioning

[url=]6605370[/url]

Excessive hard parse time for nested SQL

[url=]6613821[/url]

Queries against DBA_TS_QUOTAS can be slow

[url=]6621937[/url]

[NO]PARALLEL_INDEX hint not sent to remote site for SQL over database link

[url=]6626018[/url]

Cost of filter operation computed as too low a value

[url=]6656356[/url]

Join elimination may not work if there are join indexes

[url=]6694548[/url]

Suboptimal execution plan using bitmap full index scan

[url=]6696221[/url]

Outline from OPTIMIZER_FEATURES_ENABLE=8.1.7 not used

[url=]6748058[/url]

A parallel query executes serially due to correlation variable

[url=]6771838[/url]

Suboptimal plan from join with UNION view with empty branch

[url=]6831879[/url]

Suboptimal query plan with XmlExists and schema based XMLType

分享 转发
TOP
发新话题 回复该主题