10.2.0.4 Patch Set - List of Bug Fixes by Problem Type (文档 ID 401436.1)

Bugs fixed in the 10.2.0.4 Patch Set

  • See Note:316900.1 for Support Status and Alerts affecting 10.2.0 releases.
This note lists the customer bugs fixed in the 10.2.0.4 Patch Set which are not already fixed in an earlier 10.2 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 documented 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 10.2.0.4 Patch Set

FixedBug#Security Alert#DocumentSummary
1.0.-2.-0.-4- /-Note:467881.1Critical Patch Update (Apr 2008)

10.2.0.4 Bug Categories



10.2.0.4 Bug Fixes by Category



Advanced Networking Option


Advanced Networking Option
887753Services do not register with ASO encryption turned on
3667025Kerberos cross realm authentication fails using Microsoft Credential Cache (//osmsft)
3786828ORA-12638 using kerberos on Windows
4518385TNS-12637 / dump from simultaneous Kerberos connections
4764518Internal code needed by OID
5031220Incorrect parsing of KRB5CCNAME environment variable (Kerberos)
5031224Default realm clause of client side krb5.conf is not compatible
5095984Kerberos adapter does not support type 4 credential cache file created by kinit
5629724Add support for mapping of > 30 character kerberos principal to DB schema



JDBC


JDBC
3844473getString on a CLOB does not work with ScrollableResultSet
4439777JDBC SQLException binding user ADT to PLSQL
4485954JDBC describe of CHAR semantics column gives wrong size
4523729JDBC XAConnection / XAResource should have one-to-one mapping
4563894Cache parameter of createTemporary API in oracle.sql.clob is ignored
4659157WE8MSWIN1252 characters not converted properly by JDBC Thin
4711863setBigDecimal corrupts number for negative values
4722328Unread CallableStatement refcursor OUT parameter causes dump
4999817getIndexInfo() slow (performs ANALYZE operations)
5069831SQLException "internal error" using JDBC batching
5086162"character set not supported" occurs in JDBC using user defined character set
5124016Implicit connection cache getConnection() blocked during up event processing
5176155JDBC unable to properly locate the scope of an ADT
5231687OERI:kokeeiix selecting an updated ADT which has evolved in JDBC
5256848Corrupt results changing fetch size in JDBC
5347395JDBC batch update returns ORA-910
5347429handleAbandonedConnection is called every "property-check-interval" seconds
5354004ArrayOutOfBoundsException selecting > 200 columns in JDBC
5356342updateCharacterStream() causes ORA-1401 and ORA-12899
5385803JDBC KRPB can dump [lxgu2t]
5499691Non-recoverable ORA-1460 exception on a select
5499751JDBC clearParameters destroys hidden generated key parameter
5506478Using a scrollable resultSet can lead to a hang
5597215Memory leak in Jdbc XA
5614685Suspended transaction cannot be ended from another connection in JDBC XA
5635254Wrong values can be inserted when using JDBC batch inserts
5657975FCF does not work for 10.2 JDBC to 10.1 database
5658207SQLException "missing in or out parameter at index" with clearParameters
5658909connection.rollback() does not clear outstanding batches
5660734JDBC does not update evolved types properly
5691585getProcedureColumns method returns wrong number of rows when running against 10g
5721063Retries fail after XAER_RMERR during xa_commit from JDBC
5752856ArrayOutOfBoundsException with NCHAR literal in JDBC
5867781NullPointerException from StructMetadata of a STRUCT with an ARRAY in it
5875110NullPointerException closing OracleConnectionCacheImpl
5892966No columns from getColumns() when includeSynonyms=true
5892995JDBC XA should not need execute permission on DBMS_SYSTEM
5910901OERI[17278] / OERI[17282][1001] from JDBC Thin using REF CURSORS
5998293No XA_PROTO ending a transaction that has not been started in XA
5998987Incorrect values inserted when first row bound as NULL in JDBC
6006898JDBC OCI driver does not failover on receipt of OCI FAN
6275369JDBC Thin driver does not close the socket on IOException
6731468Stored Java does not work with a custom NLS characterset

Undocumented JDBC
5327559 5475615 5500494 5742117 5927522 6045785 6658792



JPublisher


JPublisher
5206270JPUB plsql_wrapper.sql uses undefined preprocessor directives
5847296JPublishers errors processing package with name length of 29 characters



Net Manager - NetMgr


Net Manager - NetMgr
4661200Net manager adds alias to incorrect context



Oracle Database Configuration Assistant


Oracle Database Configuration Assistant
5690286DBCA does not show all available disks
5710808DBCA errors if ORACLE_HOME contains a directory called "bin"
5875729DBCA silent carries on and completes 'successfully' despite fatal errors
6132986DBCA creates wrong OID entry during DB registration

Undocumented Oracle Database Configuration Assistant
6431822 6692557



Oracle Database Gateway for DRDA


Oracle Database Gateway for DRDA
5606511ORA-28500 calling a DB2 stored procedure with DECIMAL
5745055Error in table/index statistics cache lookup in HS
5923091Placeholder bug for TG4DRDA part of fix for bug 5877437
6007665TG4DRDA dictionary update to ALL_TABLES



Oracle Database Gateway for Sybase


Undocumented Oracle Database Gateway for Sybase
6182186



Oracle Database Gateway for WebSphere MQ


Oracle Database Gateway for WebSphere MQ
5713766Setting MQPMO_NO_SYNCPOINT results in mqput/mqget error 2046
6415898ORA-28511 / ORA-29400 from PG4MQ



Oracle Database Upgrade Assistant


Oracle Database Upgrade Assistant
5115926DBCA does not support XE to EE database cloning / migration
6399599DBUA alters NLS_DATE_FORMAT in newly created spfile resulting in ORA-1830
6505158DBUA hangs with patch 5115926 during 32-bit to 64-bit upgrade



Oracle Fusion Middleware


Oracle Fusion Middleware
5749953PI+Solaris: CRS crashes after applying 10.2.0.3 Patch Set
6083726ONS does not receive NODEDOWN event



Oracle Globalization Development Kit


Oracle Globalization Development Kit
5465998unable to add user-defined character sets to Java
5470375Add toUnicodeChars method
6200032oracle.i18n.util.OraSQLUtil.isValidIdentifier always returns true for UTF-16

Undocumented Oracle Globalization Development Kit
5706974 5860226



Oracle Internet Directory


Oracle Internet Directory
5223331Memory corruption from DBMS_LDAP_UTL.NORMALIZE_DN_WITH_CASE
5237812Client hangs if the an OID DIRECTORY_SERVERS entry in ldap.ora is down
5386748A non-privileged user can perfom config operations in oiddas
5497683Cannot sync LDAP entries with UTF8 characters when using mapping operators
5586373Login with special characters fails with NullPointErexception in ismemberofgroup
5632861DIP_GEN_CREATECHG_EXCEPTION when source contains > 10 object classes
5705503SearchDeltaSize ignored on DIP synchronization
5742856Dump on login if NIS has LDAP configured
5943019ldapsearch fails to connect to Active Directory server



Oracle Multimedia


Oracle Multimedia
6445892IORDSYS objects invalid in the SYS schema after upgrade
4765206Processing JPEG file fails with IMG-703
5505981IMG-703: unable to read image data using set.properties() on TIFFfiles
5748273Failed Image process() corrupts original LOB
5770164ORDX_HTTP_SOURCE leaks connections (ORA-29270)
5978773processCopy fails with IMG-2 "unrecoverable error"
6042995Extract of JPEG image from DICOM file fails with IMG-705
6255772IMG-2 from ORDSYS.ORDIMAGE.process

Undocumented Oracle Multimedia
5174238 5637901 5692668 5717209 6161898 6450327



Oracle Net Services


Oracle Net Services
4417761Net listener cannot contact ONS daemon in different ORACLE_HOME
4570363JavaNet throws exception with nested/multiple ADDRESS_LIST clauses
4570768CMAN not able do connection over two hops - ORA-12564
5076238Dump [nstotoqgetkey] after Net error
5128376Aliases in non-default context not removed by NetCA
5236140Memory leak in clients when using TAF
5351620ORA-12559 from JDBC OCI driver
5518312Small memory leak when niotns fails
5541589Connect timeout with ADDRESS_LIST does not handle refuse correctly
5549203Client spins when sqlnet.outbound_connect_timeout is set
5594035Unable to change the listener password
5663043Memory leak in nsbGet / dump possible under nsbrfr
5701515Only first 5 LDAP server entries used (directory_servers) in ldap.ora
5713832ORA-12637 using DESCRIPTION_LISTS with multithreaded client
5754150ORA-12152 from non-blocking OCI
5837468EMON hangs when client application suspended
5854698Listener dumps / corrupted listener.ora after save_config

Undocumented Oracle Net Services
4723343 4966897 5854128 6397121 6410510 6700564



Oracle ODBC Driver


Oracle ODBC Driver
5202103Requery of data returns old data using ODBC
5376170ODBC ORA-904 for SQL with column names containing spaces
5389003ODBC driver does not round off double data
5706606ODBC driver dump when fetching TIMESTAMP / INTERVAL types
5747525ODBC has wrong sqresus.dll

Undocumented Oracle ODBC Driver
5680202 5758953 5760923 5763138 5763172 5770374 5838037 5846726 5852189 5879622 5888808 5915427 5948621 6059365 6077885 6188277



Oracle OLAP


Oracle OLAP
5121436Dump possible using OLAP (under xstfContextClean -> kghfrh_internal)
5146569Line graph shows axis and labels but no line in the graph
5326419Surrogate build error when loading dimension in AWM
5336254Error with measure folder in two different schemas
5347785OLAP drill down throws exception
5355084AWM randomly gets OOPS with vcread01 and rsdepage02 errors
5357405Session dumps using DBMS_AQ.INTERP
5360145Error during load of AWM
5360207Cannot rerun measure query to refetch data only without affecting edges
5361171Upgrade to 10.2 in AWM hangs
5367686OLAP trigger not working on relation
5384375ORA-3115 from OLAP DB link measure load
5389170Cannot load large cube in OLAP
5392882cube maintenance from AWM dumps (xspgInitPool)
5436458single allocmap and single allocate command return NA
5507506TOTAL function takes a long time in 10g
5555067OLAP ACROSS command wrong in second iteration
5574866OLAP cubes will not update the cube with incremental data
5577196Use of trigger function causes session to dump (in xsILFUNC)
5578127AW attach / initialization in BI beans and D4O slow
5581628OWB generated AW shows incorrect average results
5582161AW measure folders may not show in Discoverer for OLAP or the addin
5603293OLAP DML sort can dump
5604376OLAP session dumps on permitreset
5633245OERI[kghalo2] using OLAP_TABLE rank
5642311BIA-4085 error writing back data to Excel when using permit_write program
5652733OERI:xscbtAddUb401 from OLAP
5653421Error using even numbers for forcasts 'median smoothing window' in OLAP
5676244Values of a variable dimensioned by compressed composite cannot be modified
5684721Dump (in xsAGMClearCompiled) compiling aggmap in OLAP
5687603AW is cached across database sessions
5700568OERI[xscbtaddub401] from OLAP
5700725Query of measure DIM with constant source returns wrong numbers in OLAP
5703138Top/bottom by comprising percent pattern ignores comparison operator
5739350OERI [XSOOPS][XsRS64UpdateIndex01] importing EIF files
5746153OLAP a patch for 10.2.0.3
5762192Dump from compile of aggmap
5888194Export AWM project to XML with french accents ( utf-8 )
5889531Retrieval of schema list is slow in OLAP
5934559OERI[XSOOPS][rsalpage01] updating structures in OLAP
5941689MovingTotal function fails in OLAP
5945656Decode function fails with NA as the third argument in OLAP
6076154OLAP dump executing package body GENDEFINITIONMANAGERINTERFACE
6119941ORA-36188 from OLAP AVERAGE operator
6164538Cannot export AW to EIF
6489332ORA-29532 java.lang.OutOfMemoryError in OLAP load of AW



Oracle Security Service


Oracle Security Service
4407719SSL variables may not display properly
4895416Unable to import ANCERT CA certificate into wallet manager
5131722OWM will not import Verisign ECA certificate
5220448Wallet manager limits the number of certificates that can be loaded (65k)
5396837File handle leak from nzcrlGetCRLFromFile
5450462OWM fails to import root CA from Microsoft certificate authority
5532208Root certs not found in some cases
5851310Unable to import trusted certificate into Wallet Manager
6124217SSL NZ error 28757 / cannot use certificate due to Empty subject field

Undocumented Oracle Security Service
4489608 4555147



Oracle Server


ANSI Joins
4204383Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
4702830OERI[kkoljt1] when using star transformation with an ANSI outer join
4901291Wrong results with left outer joins on view with a function
5188321wrong results (no rows) OR ORA-1445 from ANSI outer join
5590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
5652086OERI[15160] from ANSI join
5765958OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
5964193OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
5988085Dump [kkodsel] from STAR transformation with ANSI view
6006457Suboptimal plan from ANSI outer join
6033480High parse time of query when using ANSI style joins
6686885WRONG RESULTS (missing rows) USING NATIVE FULL OUTER JOIN

ASSM Space Management (Bitmap Managed Segments)
5530583ASSM managed INDEX updates can be slow compared to non-ASSM
5557421Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
5637976ORA-8103/ORA-1410 from concurrent INSERT / export on ASSM tables
5695131HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
5728380DML may spin under ktspffc searching for space in ASSM segment
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK
6086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6376915HW enqueue contention for ASSM LOB segments

Advanced / Secure Networking
4395849ESM tool hangs connecting to directory server on SSL port
5079968SSL auth client connections create erroneous trace files in udump
5584798Unnecessary trace files using EUS with LDAP_DIRECTORY_PASSWORD='PASSWORD'
6005762SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

Advanced Queuing
4478139ORA-28031 "maximum of 148 enabled roles" when creating queue table
4618808AQ operation requiring exclusive lib cache lock may hang
4715375OERI[kwqmtdel] in q00 process in RAC when any instance goes down
4719848Streams DELETE_ERROR does not maintain AQ$_QTABLE_I
4733582Upgrade to 10.2 deletes statistics on AQ tables
4745691OERI[kghufree_06] from AQ propogation of XML payload
5018886OERI:[kwqitnmptme:wait] in Qnnn during propagation of delayed messages
5092843Dump (kpceclose) in EMON
5095889PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
5225596AQ propogation does not work after failover
5358598EMN0 not posted for ha notification
5408664Messages not marked as undeliverable after transformation failure
5415506ORA-4020 when dbms_aqadm.purge_queue_table and select are run
5439588Notifications not delivered when client machine has multiple NICs
5452715OERI[kwqbgqc: bad state] reported after restart of database
5494866PLS-302 'dbver_10i' importing 10g export into 9i with AQ
5506702Dequeue delay experienced after reconfiguration
5523578DBMS_AQADM.add_subscriber fails with ORA-1925 "maximum of x roles exceeded"
5526245"ksxplookup: warning cnh incarnation number" messages in QMNC trace
5545530EMON may spin in kpcopen
5561130Performance of long running transaction using AQ degrades over time
5580871AQ bytes message <= 2000 bytes incompatible between PLSQL and Java
5590163Message dequeued more than once from single consumer queue
5594352JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
5605319Cursor leak from QMON coordinator exceptions
5608198Memory leak by advanced queuing XML transformation
5648610ORA-25235 during AQ propagation
5654680JMS worker thread does not end if exception thrown in onMessage() method
5655612AQ$_PENDING_MESSAGES table can grow indefinitely
5666374FIFO does not occur when multiple listens are followed by dequeues
5717536Dequeue can suffer from a memory leak
5725109Hang if AQ listener onMessage() method raises an error
5734276Queue slave process may spin in kwqitptm
5751016AQ messages enqueued at non-owner instance not moved from WAIT to READY
5758963UGA memory leak possible from AQ dequeue
5852253ORA-25316 from AQ after rollback to savepoint with loopback database link
5857313OERI[kwqbmcrcpts101] after drop propagation
5941601TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
5955596DBMS_AQ.LISTEN hangs after datapump has executed
5962680Dump[kwqicgsubname1] on an AQ enqueue call
6001290Node down events not posted in AQ when node leaves the cluster
6016707OERI[kwqpuspse0-hwmack] from propogation
6044513Cannot dequeue a message with a correlation padded with spaces
6049324Memory leak from array dequeue
6057422ORA-25228 occurs every 30 seconds in racgimon session trace file
6065604DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
6143688node startups cAN spend up to 2 mins in AQ partition code
6154655QMON fails to update queue table affinity for several minutes after failover

Analytic SQL (Windowing etc..)
4436832False ORA-979 "not a group by expression" with literal replacement
4587572ORA-12801/ORA-60 possible from parallel DML with grouping sets
4597871ORA-904 from query using CUBE
5162852Dump from FIRST / LAST aggregations on a NULL table
5196061Dump in evaopn2() from WITH query using WINDOW functions
5216642Dump from SQL using window functions
5286826Wrong results from complex view merge with windowing
5302124Join Predicates are not push inside window functions -- superceeded fix
5638080Wrong sort order using window functions
5641873ORA-904 using a WITH clause that includes a UNION
5670585OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
5847881ORA-3001 from GROUPING SET query against a view containing a function
5906937Wrong result using ROW_NUMBER in SQL using a WITH query block
5942097OERI:qernsRowP from SQL with GROUP BY , ROLLUP and DISTINCT aggregates
6012053OERI [qctcte1] from GROUPING SETs query
6026281OERI[qeshCloseHTI.2] from spreadsheet query
6051782Wrong results using GROUPING SETS with ORDER BY and DISTINCT

Application Context
4902585OERI[510] and ORA-28106 using application context over 30 bytes long
6005762SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL

Automatic Memory Management
4433838Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
4921418Free extents in PGA subheaps not freed (ORA-4030) with Auto Memory Management
5702177Instance crash from OERI[kghchoose_grow_1]
6528336Automatic SGA may repeatedly shrink / grow the shared pool

Automatic Storage Management (ASM)
5526987*ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
5081798+Additional diagnostics for OERI[2103] when ASM involved
6453944+ORA-15196 with ASM disks larger than 2TB
6051728P*HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1
4110313ASM disk resize fails for OS devices grown after ASM instance startup
4319031Wrong header_status in V$ASM_DISK when disk is offline
4380450Unbalanced space usage if diskgroup has only two disks, both of different size
4431215"backup archivelog all delete input" from RMAN removes ASM directory
4489948ASM hangs during a parallel mount and shutdown in RAC
4708822OERI[kfiounidentify01] from PMON
4767278OERI[kcrrupirfs.20] archiving redo to standby with ASM
5230765LGWR spins while waiting for 'log file parallel write' using ASM
5471453OERI[kfkfilrqarr01] using ASM
5472917DBVERIFY may error if ASM disk disconnected
5483613OERI [kfgscAcquireLcl_6] in ASM
5502365OERI [kfcDel20] in ASM
5504989PMON dump [kfgGlobalClose] / instance crash
5554692Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5555908OERI[kghstack_underflow_internal_2] in kfrcsoDelete
5556674V$ASM* dynamic views leak cursors (ORA-01000)
5571643OERI:[kfclAttachBuffer10] in ASM
5575584Failure of an entire failure group is detected one disk at a time
5576584Poor ASM parallel read performance
5682184OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file
5743325ASM instance fails with OERI[kfaDropCOP04]
5757711ORA-15080 during file creation / resize on ASM with HARD
5757752OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
5761185ORA-15041 diskgroup space exhausted after adding disks to a diskgroup
5891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
5893614Full table scan very slow on ASM
5899033SMON dump (kfrCheckCtx) diskgroup instance recovery
5909894ASM datafile lost after rename (ORA-1157)
5922733ASM dump in kfkdumprq with event=15199 level=1050631
5939241Inconsistent diskgroup configuration after rejected DISK OFFLINE
6013983ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
6069360DBW can spin in kfcRunnableWaiter holding a latch in ASM
6074842unable to repair failed asm failgroup after replacement of disks
6139547Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
6334552Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6597063OERI [kfrpass2_03] can occur in ASM
6655999ASM instance hangs on clssgsgetmemberpublicinfo
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

Bitmap Indexes
4596807OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
4697632OERI[atbbjie2] from exchange partition with bitmap join indexes
5063279OERI[kdibllockrange:not validated] updating a partitioned bitmap index
5113934PQ slave dump in qerixGetKey() when using bitmap index access
5262017Query on partitioned table with bitmap index gives OERI[qernsRowP]
5331374OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
5401876wrong results when optimizer uses "BITMAP CONVERSION" over "BITMAP OR"
5449488Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
5667683Parse of query can spin in kkosbn
5960268Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index
6694548Suboptimal execution plan using bitmap full index scan

Change Data Capture
5165904Materialized View DDL may execute when it should wait
5252389CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
5533982Updated columns set to null show old not-null values in change table using async CDC
5693948ORA-31466 error when setting up CDC with table names using multibyte characters
5881493CDC ordered sequence causes large performance degradation on RAC
6064864Archives containing DDL for not replicated objects take longer to process
6314151'1/1/1988 0:0:0' in COMMIT_TIMESTAMP$ column when CDC apply error is re-executed

Cluster Ready Services / Parallel Server Management
6001843Pcluvfy error during CRS post installation check
5667023P+Linux: CRS does not start after applying 10.2.0.3
5495242PIHPUX: CRS may not install
5845104PIWin64: 10.2.0.3 OPMD.EXE does not work
3602716EVMD unable to detect EOF while reading configuration file
4440013CRS startup of RAC fails when FSFO enabled
4566428cluvfy displays duplicate names in the output
4574574crs_start opens a physical standby database as opposed to mounting the instances
4587300Improve CRS shutdown sequence
4598992"Action script for resource 'ora.xxx.vip' stdout redirection" errors in crsd.log
4692561cluvfy reports a failure if ssh banner enabled
4882822Service failover blocked on VIP
4906820EVMD deadlocks on disconnect
4930431Failure of 1 CSSD can hang starting CSSD on other nodes
4951464CRS shutdown stops and then restarts EVMD
4996577CVU does not recognise long device names
5003881Value of restart_attempts wrong after DB policy is changed
5014134Improved diagnostics for oclsomon (do not overwrite log file)
5093126FCF does not respond to SRV_PRECONNECT events
5101517VIP does not failover with auto_start=2
5125957Cannot start CRS after CRS ugprade
5129769CLUVFY check subsystems which are not configured
5131219CSS shuts down the node when disk IO is suspended momentarily
5137401oprocd logfile is cleared after a reboot
5168043VIPCA silent mode cannot handle upper case characters in hostnames
5169752SRVM OCR keys not security consistent with respective CRS resources
5184535PRKR-1008 from SRVCTL ADD INSTANCE / DBCA
5188493crsd.bin can use excess CPU on reboot
5192194CSS does not start on one of the nodes ("takeover aborted due to unknown nodes")
5207138Add support for 'toc' for reboot in HPUX
5220760Dump in NetLocalGroupGetMembers
5236370OCR cache invalidation error with delete key operation
5274513VIP,ONS,GSD check fails in cluvfy when nodename is in capital letters
5278777CRSD version is 10.2.0.1 after applying 10.2.0.2 patchset
5297925Disabling one instance disables restart of all the instances in the node
5303454Better diagnostics when CSS voting disk IO hangs but later resumes
5334170racgevtf can dump in lmmstfree
5334661ocssd.log refers to non-existing node 0
5336797EVMD and CSSD core files are overwritten
5338035PRKR-1008 using DBCA to create RAC instance
5348062A 500 ms delay can occur until CSS starts reconfiguration after vendor CM reconfiguration
5365683CRS repeatedly stops and restarts VIPs while recovering multiple nodes
5377165Dump from crsctl when invalid parameters are passed
5388818cluvfy should not use remote shell for local node
5437462CSS does not monitor vendor clusterware network
5442229VIP does not failover when public LAN disconnected pulled (crsd communicating on public LAN)
5442867Deadlock can occur by terminating multiple CSS clients
5446160RLB information cannot be forwarded
5448707Better tolerance of CRS init scripts to low system resource conditions
5451987CSSD could run as root if oracle_user not set
5454307CLWS OCSSD dump during startup
5454388OPROCD dumps with fix for bug 5015469
5458333racgimon should do more checking for connections
5461281Reconfiguration delayed due to diskping seen after reboot was issued
5467456Directory $ORA_CRS_HOME/crs/auth was unexpectedly removed
5479767CLWS instance going down not noticed for 10 min
5487604CRSD core dump
5488977scls_process_spawn provides insuficient diagnostics on execve() failure
5503111racgimon startd <dbname> uses a lot of CPU
5507883CRS install fails in CRS root.sh due to node panics
5513471cluvfy needs easy to parse output for each nodes status
5529659OCSSD fails to join the cluster
5533311crsctl debug log res:<name> does not check name
5549682High CPU usage by srvctl
5553318CRSD dump before node rebooted when killed CSSD in CRSD master
5555728Some peer-to-peer connections between EVMD's not established properly
5556681OCR does not correctly compare OCR configurations
5568399CRS upgrade can corrupt OCR
5601369OCSSD dump in clssgmmbrdatacmpl()
5623137CSS time out during reconfiguration (timeout in clssgmMasterCMSync)
5629557CRS does not receive reconfig from CSS on SAN failure
5651085Session disconnection blocks service resource stop action
5664042Internal change to diagcollection.pl script
5668854CRSD may dump if resource unregistered/re-registered as it starts
5679560Unexpected node reboot on death of "init.cssd fatal"
5690258Default VIP check_interval should be less than 60 seconds
5698321Wrong return code from srvctl from failed "modify nodeapps" operation
5709121CRS startup can hang
5734797CSSD abort possible from concurrent startup
5735507Dump in procr_open_key
5735768killed ocssd.bin on a node causes other nodes's crsd restart
5736843WaitOnEvictions can wait too long (another misscount)
5843485Unnecessary VIP failback trial makes VIP unavailable for 14s on network down
5852975Shared storage check does not discover shared disks
5853909CSSD permission problems (skgxninit errors in CSSD log)
5854172VIPCA fails with exception thread main error
5855383CRS bundle patch does not apply on some platforms
5858733cvu checks for exact package versions
5861703CSSD failure 139 and node reboot if nfs mounted voting disk is remounted
5862719init.crsd does not set a high file limit on all platforms (notable Linux)
5893629crsd dumps after being unable to delete backup OCR file
5901176Memory corruption in CLSC async connect handling
5901254Starting node cannot join the cluster
5903964EVMD does not shut down when OCR is corrupted
5911174Hang in CLSC in nsevwait
5911855Split brain resolution can fail
5929527racgimon dump in clsrcwrft() during instance startup
5929833OCR cannot determine the latest update
5932861VIP does not switch over when CRS is stopped
5938788False split brain
5949311False split brain result
5974219Cluster hang when node dies during reconfig
6001290Node down events not posted in AQ when node leaves the cluster
6005526CSS will not shutdown evmd.bin with fix for bug 5442229
6022204oprocd enhanced error reporting mechanisms
6029676OPEN/CLOSED messages from userid 0 after CRS shutdown
6051925racgimon dump under slzgetevar -> getenv
6054978Locked resources are not recovered by CRSD even once they are unlocked
6057422ORA-25228 occurs every 30 seconds in racgimon session trace file
6087596OCR can hang
6114137Running LMS in real-time can cause CSS crash and node reboot
6117687CRS slow memory leak from repeated "crsctl check crs"
6134126OCR backup can fail
6655999ASM instance hangs on clssgsgetmemberpublicinfo

Code Improvement
5031712DBV enhanced to report NOLOGGING corrupt blocks with DBV-201 instead of DBV-200
5238255Timezone changed data in CSV format
5245494Improved control over whether star transformation is performed
5614566Enh: Allow library cache heaps to be purged manually
5726895Code allowed to throw ORA-0 which can give misleading ORA-1 errors
5932060Enh: Add support for direct SQL on partitioned table/index
5933469ORA-20 does not show in any trace / alert
5966238Better diagnostics for OERI[kcbgtcr_1]
6022204oprocd enhanced error reporting mechanisms
6875865Database instrumentation for OCM

Compressed Data Storage
4061534OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
4600946Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
5496041OERI[6006] / index corruption on compressed index
5577788Block corruption / OERI:6585 updating row in compressed block
5599596Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
5621677Logical corruption with PARALLEL update
5912350Dump (kdr9ir2f0rst4srp0) on select of compressed table having > 255 columns
6268371ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT

Compressed Key Index / IOT
4545196Corrupt index leaf by RMAN CONVERT from cross platform transport of compress-key indexes
5034323Dictionary corruption when adding a subpartition to a table with a key compressed local index

Connect By / Hierarchical Queries
4770292Wrong results from CONNECT BY query on IOT with secondary index/es
5033488Dump in kokmrwo from CONNECT BY
5061079Poor CONNECT BY plan
5065418CONNECT BY performance degrades when temp space needed on disk
5119354OERI from CONNECT BY and correlated START WITH columns
5126645OERI [kkqtcorcbk: correlated string no] from CONNECT BY
5150562Dump expCheckExprEquiv from pipelined function in hierarchical query
5211863Poor plan for CONNECT BY
5225168Dump (evaopn2) from CONNECT BY
5234379Dump in qknlazopn() from hierarchical query
5254539OERI[qkacon:FJfsrwo] on executing hierarchical query
5371149OERI[qctcte1] from query with CONNECT BY
5391575OERI:[qkaconCompareOpn:dty] from CONNECT BY with HAVING clause
5487686Wrong results from CONNECT BY query
5488174Dump [evaopn2] on a CONNECT BY query
5507887Wrong results for CONNECT BY using CONNECT_BY_ISLEAF
5526851Wrong Results (missing rows) on CONNECT BY when using function-based index
5590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
5594381OERI[qkacon:FJswrwo] from CONNECT BY query
5837795Wrong results / OERI from cost based CONNECT BY
5847521Hierarchical (CONNECT BY) query on IOT returns wrong results
5854634OERI[qkshtQBGet:1] from CONNECT BY query
5872956Slow or Wrong Results on CONNECT BY queries with constant predicates
5882372Wrong results from CONNECT BY
5903581Wrong Results with "Connect By with Filtering"
6027610Wrong results from CONNECT BY query
6333108Wrong results (duplicates) from CONNECT BY query

Constraint Related
4580190Bulk insert to partitioned table can insert constraint violating rows
4618715Dump inserting into a view with OLS policy on tables
4620832Dump in kzrtppg with multiple referential constraints and OLS policy
4771851Dump (kxccsrw) from INSERT .. AS SELECT / MERGE
5324773Constraints using LTRIM() may fail for valid data
5462687CHECK constraint can cause wrong results
5472523Non violated deferred CHECK constraint fails (ORA-2290) at COMMIT
5504961ORA-2292 slow to be signalled with many child rows
5579055Dump (kxccres) updating view with instead of trigger
5766196ORA-942 on schema level import of table with foreign key and XMLSchema
5923497Select with constraints fails with OERI[12863]

Corrupt/Bad Backup
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces

Corruption
6453944+ORA-15196 with ASM disks larger than 2TB
4201573ALTER SYSTEM RESET of an spfile parameter can corrupt the SPFILE
4344935OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
5031712DBV enhanced to report NOLOGGING corrupt blocks with DBV-201 instead of DBV-200
5690593Datafile corrupt for ASM datafiles copied using xdb/ftp
5892080updateXML corrupts repeating elements
6057203Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK
6086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6132301OERI[kcb_pre_apply_1] when db_block_checksum is set to FULL

Corruption (Dictionary)
5034323Dictionary corruption when adding a subpartition to a table with a key compressed local index
5632050OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
5936058Corrupt metadata from tablespace transport
6136074ORA-4068 / ORA-4065 ORA-6508 on VALID objects
6436867Recompilation may skip compilation of some dependent objects (ORA-4068)

Corruption (Incorrect / Missing Corruption Checks)
3569503PQ may signal a false ORA-8103 under load

Corruption (Index)
4545196Corrupt index leaf by RMAN CONVERT from cross platform transport of compress-key indexes
5179313INSERT /*append parallel*/ can corrupt an index
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5496041OERI[6006] / index corruption on compressed index
5621677Logical corruption with PARALLEL update

Corruption (Logical)
5363584+Array insert into table can corrupt redo
5686711+Wrong cursor may be executed if schemas have objects with same names
3419260Silent truncation on insert via DB link from single to multibyte charset
4193047Sequences / synonyms / indexes not created in logical standby database
4580190Bulk insert to partitioned table can insert constraint violating rows
4714295It is possible to drop an OLS group which is still in use in an existing label
4883635MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows
4904743ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
4933222Apply update of clob in multibyte charset double spaces characters
4959294DBMS_XMLSTORE does not follow CHAR based semantics
5019803Wrong data inserted for INSERT INTO .. SELECT DISTINCT with DEFAULT values
5024737Streams LCRs may be filtered when using distributed commit SCN
5087369logical standby potential data loss during failover
5104257SQLLoader truncates nested table columns
5165904Materialized View DDL may execute when it should wait
5182679INSERT as remote SELECT using CASE can produce wrong data
5190543Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5256791Trigger "UPDATING('col')" clause can return TRUE when column not updated
5352587Triggers not working correctly with timestamp datatype
5436371Image corruption / spin loading multiple nested objects in multibyte
5515703Streams table diverges after partial rollback on primary
5554692Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5567934NCHAR literal replacement can produce corrupt N literals
5577788Block corruption / OERI:6585 updating row in compressed block
5588615Single source streams with DML handler duplicates CLOB column value
5616820Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
5621677Logical corruption with PARALLEL update
5685411Updating columns to NULL in a trigger may have no effect
5872835Multiple trigger execution from SERIAL insert as Parallel select
5873852sqlldr inserts character data longer than the column length (CHAR length semantics)
5874989Datapump import can load data longer than column definition
5936058Corrupt metadata from tablespace transport
6057203Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK
6329316Wrong number of rows inserted by ARRAY insert into partitioned table with concurrent DDL
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

Corruption (Physical)
6646613*IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
4450606+LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
4592596Corruption (ORA-1410 / ORA-8103) from multi-table insert with direct load
4899479Undo/redo corruption if distributed transactions used
5599596Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
5609096MERGE / UPDATE to IOT can cause corruption
5636728LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
5909894ASM datafile lost after rename (ORA-1157)
5941030Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
6268371ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

DBVerify Utility
5031712DBV enhanced to report NOLOGGING corrupt blocks with DBV-201 instead of DBV-200
5472917DBVERIFY may error if ASM disk disconnected

Database Link / Distributed
3419260Silent truncation on insert via DB link from single to multibyte charset
4311273ORA-2064 using MERGE statement over a database link
4351422Dump from CREATE TABLE AS SELECT (CTAS) over DB link
4373687SET_SCHEMA_INSTANTIATION_SCN does not error if database link unavailable
4490782Unparse operations give wrong date for BC TO_DATE literals
4491223Dump selecting ROWID with a remote join
4581334Cursors accessing remote tables may be repeatedly rebuilt and not used
4624183ORA-1017 reported using DB links with IDENTIFIED EXTERNALLY accounts
4648039PLSQL hangs with database links and autonomous_transaction
4658456ORA-920 from distributed query using CASE against remote table/s
4701527Cursors not shared when executing procedures over a dblink
4768022ALTER TABLE can fail with ORA-60
4865959Wrong results / exception from Java Stored Procedure accessing data over DBLINK
4889807False ORA-904 from co-located join (over database link)
4899479Undo/redo corruption if distributed transactions used
4913460Soft parsing re-occurs for select using database link
5015321OERI[qerrmObnd1] [932] using binds with some functions over a DBLINK
5015547Cannot create a materialized view over a database link (ORA-942)
5024737Streams LCRs may be filtered when using distributed commit SCN
5128933Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5182679INSERT as remote SELECT using CASE can produce wrong data
5216523OERI[16608] from create materialize view on remote table with objects / types
5223587OERI[4400] from distributed PDML with DDL
5245451Intermittent ORA-904 referencing remote objects columns
5246372OERI[opidsii1] accessing remote database accessing 3rd remote database
5299546ORA-942 from create materialized view with join between local and remote tables
5327132Wrong results from colocated OUTER join over DBLINK with TO_DATE
5354469Poor performance of remote fetch with high fetch counts
5405345OERI[kkofkrMarkK] when running a query using a database link
5455632Dump accessing tables over a database link
5467520PLSQL errors accessing synonym to remote object
5509293Query with subquery across DB link has poor performance
5852253ORA-25316 from AQ after rollback to savepoint with loopback database link
6028753ORA-907 / ORA-933 from DML over database link
6029071Wrong results from distributed SQL with OUTER joins
6145525Dump selecting > 34 columns from HS (FDS)

Datapump Export/Import
4352110ORA-39125 from expdp/impdp of triggers with nulls in WHEN clause
4517481ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
4595736ORA-6502 during impdp due to wrong logging_level put in export dump
4660745TABLESPACE GROUP clause not generated by DBMS_METADATA.GET_DLL
4996004EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
5027003ORA-39068 from EXPDP if parallel > 1
5071931Datapump import with remap tablespace and schema is very slow
5095025ORA-4030 (kxs-heap-c,temporary memory) using expdp
5120780Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5135951ORA-22337 on import if database schema has been evolved
5152232EXPDP loses global index parameters for local domain indexes
5157602Datapump export/import modifies the chains created with dbms_scheduler
5220845Large packages imported via data pump are not shipped to logical standby
5292551IMPDP slow when importing a table with initialized column of type varray
5352426Data pump import dumps (lxinitc)
5464834ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
5472417EXPDP on RAC fails with ORA-39014 / ORA-12801 (error signaled in parallel query server)
5502124ORA-39096 importing 10.1 EXPDP file with 10.2 data pump
5515882ORA-1427 from EXPDP
5548895OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column
5550618Dump [nszgclient] from EXPDP
5555463Slow performance of datapump IMPORT with small LOBs
5576865Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
5590185Consistent export data pump job (flashback_time) has poor performance
5620375PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
5632683EXPDP / IMPDP may error for DDL modified tables
5680970ORA-39001 when attempting to export partition defined as an object type
5713912ORA-39125 / ORA-6502 from datapump import via network
5714205EXPDP / IMPDP do not support long lists for parameters
5718757ORA-31693 / ORA-6502 during datapump net import
5857884EXPDP fails with ORA-39125 / ORA-6502
5874989Datapump import can load data longer than column definition
5875568IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
5891213ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present
5910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
5941030Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
5972794EXPDP via network_link with parallel > 1 fails with KUP-4038
6063940Datapump export / import does not handle tablespace groups
6080303Datapump export does not unload data until all metadata unloaded with PARALLEL > 1
6140330imp / impdp cannot create object views with circular dependencies
6379123EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

Datatypes (AnyData)
4531589ORA-22370 when passing sys.anydata containing collection to a method
5307199OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
5350076Anydata and timestamp can loose precision
5548895OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column

Datatypes (LOBs/CLOB/BLOB/BFILE)
4450606+LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
4559728Select lob from view loops / OERI [17059] if synonym dropped
4583442ORA-22877 during move hash partition with LOB
4680009Insert LOB data fails with ORA-3106 or ORA-8176
4745114OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
4865755OERI[9999] during DBMS_LOB operation
4933222Apply update of clob in multibyte charset double spaces characters
5051432DBMS_LOB does not execute with the privileges of the calling procedure
5176017Exp/imp loses "RETENTION" settings of LOB columns
5196175OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
5374820Client side dump on import of table with more than one LOB column into 32k block size
5396550Spin in ktsplbfmb holding HW enqueue during LOB segment management
5413989OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
5442534Dump in kokscold assigning NULL to CLOB
5447395Shared server tied to session when BFILE used
5472702ORA-1403 during SQL Apply of redo from table import (redo issue)
5500044Waits on 'cursor: pin X' / 'kksfbc child completion' or ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5510345ORA-22282 with LOB buffering enabled
5549410Inconsistent characters read returned from OCILobRead
5555463Slow performance of datapump IMPORT with small LOBs
5560256Multi threaded OCI program hang when calling OCILobLocatorAssign
5588615Single source streams with DML handler duplicates CLOB column value
5636728LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
5644951OERI[rworupo.2] querying outline LOB with ORDER BY clause
5654094ORA-3106 for SQL with RETURNING clause with indicator binds
5666733LOB segment does not use free space from freelist in RAC database
5674184ORA-22282 when using LOB buffering
5676637OERI[17114] using EMPTY_CLOB() in a trigger
5682121Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
5721994Unexpected errors from non blocking OCI LOB calls
5723140Temp LOB space not released after commit
5723260Logminer slow / excess memory use processing batch inserts with LOBs
5870781DBMS_LOB.INSTR() function does not find patterns across the 4gig boundary
5879179ORA-22925 from CSSCAN when reading CLOB data
5926074OERI [12333] on update of more than one CLOB column
5941355"Split partition" does not move LOB to correct tablespace
5974207Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL
6148212Dump [qmuhshget_internal] can occur accessing LOBs
6315913ORA-3106 for SQL using BLOBs after TAF failover
6376915HW enqueue contention for ASSM LOB segments

Datatypes (Objects/Types/Collections)
4309607ALTER TYPE CASCADE fails adding attributes to various types
4554026Pinning TDO may fail for extensibility types
4583492Dump possible using ADT columns when table has many columns
4643723After type evolution extracting attributes gets OERI[17280]
4691237High "library cache" latch gets from SQL using objects in PLSQL
4726702ALTER TYPE may dump (koktupd_dplvl) due to a REF dependency
4895068Dump [kopxccc] during pickling
5022188Direct SQLLOAD of partitioned object table of non final types fails
5076729OERI[pmucitnxt] doing type manipulation
5104257SQLLoader truncates nested table columns
5135951ORA-22337 on import if database schema has been evolved
5182299Dump on grant / revoke of privileges on a TYPE
5192858DROP TABLE with object type column with statistics can dump (kknerd)
5216523OERI[16608] from create materialize view on remote table with objects / types
5225836DROP TYPE .. VALIDATE dumps for large partitioned table
5292551IMPDP slow when importing a table with initialized column of type varray
5368266ORA-904 using multiple TABLE() objects in the FROM clause
5436371Image corruption / spin loading multiple nested objects in multibyte
5520937Cannot upgrade images for dictionary types to 8.1 image format
5577046ADD or DROP attribute causes UNION query to fail with ORA-1790
5721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5725761Objects with debug privilege are not shown in the ALL_OBJECTS view
5763434Spin in kokes2q when sorting on VARRAY column over 4k long
5763538Wrong results / dump with object type column in SQL
5841624OERI[kokeicadd2] accessing object with embedded substitutable attributes
5910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
6029647ORA-12714 accessing typed column from TABLE() function
6118038OERI[koputilcvto2n] on an ALTER TYPE
6140330imp / impdp cannot create object views with circular dependencies
6145841OERI[kologsf2] on COLLECT(..) with wrong datatype
6150438COLLECT() does not work correctly for ADTs residing in different schemas
6452485SGA memory corruption / OERI [17182] with fix for bug 6085625

Datatypes (TIMESTAMP)
4992603TIMESTAMP.timestampValue(Calendar) does not exist
5126270Version 3 TIMEZONE check script (utltzuv2.sql)
5128933Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5190543Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5238255Timezone changed data in CSV format
5350076Anydata and timestamp can loose precision
5350339ORA-979 using TIMESTAMP in triggers and GROUP BY clause
5352587Triggers not working correctly with timestamp datatype
5417281oracle.sql.DATE looses a year when constructed from BC Timestamp
5468695TIMESTAMPTZ wrong near daylight switch
5616820Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
5632264Version 4 TIMEZONE files
5688685JVM timezone changes for Western Australia December 2006 (superceeded)
5726033timezdif.csv for version 4 timezone files
5865568JVM timezone changes (version 4 timezone data for JVM)
5885079Incorrect output from INTERVALDS.stringValue() for negative intervals
5910187No bind peeking for implicit string bind to timestamp
5923970Include objects/nested tables in utltzuv2.sql
5961654ldiinterfromtz returns wrong offset during DST fallback
5973217OCCI::intervalds object attribute uses day precision for fractional seconds
6156762OCCI fractional seconds portion can be wrong

Deadlock
5907779+Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
4441119Not enough information dumped when RAC detects a deadlock
4587572ORA-12801/ORA-60 possible from parallel DML with grouping sets
4768022ALTER TABLE can fail with ORA-60
5334733Deadlock resolution can be slow in RAC
5415506ORA-4020 when dbms_aqadm.purge_queue_table and select are run
5454831RAC deadlock possible on working set latches
5470095Self deadlock should provide more targeted diagnostics
5485914Mutex self deadlock on explain / trace of remote mapped SQL
5557421Self-deadlock (ORA-60) on FB enqueue if session killed during INSERT in ASSM
5604698Deadlock between 'library cache lock' and 'library cache pin' using replication
5685189Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
5695131HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
5883112False deadlock in RAC
5941601TM deadlock from concurrent dbms_aqadm_sys.alter_subscriber()
5983020MMON deadlock with user session executing ALTER USER
5998048Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled
6057351AWR deadlock between Mxxx processes during snapshot purging process
6267208OERI:2103 due to deadlock between PV enqueue and "slave class create" latch
6496514RAC deadlock between "libary cache lock" and TX enqueue

Diagnostic Output Problem / Improvement
5950810PMissing Call Stack in Trace
5963785PHPUX: Missing Short Stack in tracefiles
3995047Explain plan does not show a part of the execution path
4995756Enhanced diagnostics for index code
5385614Need diagnostics for OERI:ktrviupk_4
5470095Self deadlock should provide more targeted diagnostics
5696474Diagnostic enhancement for ORA-600 errors on global temporary tables
5721941Additional diagnostict for OERI[kgmgchd1]
5843585Additional diagnostics for "ges inquiry response" RAC hangs
5854415RAC diagnostic enhancement for corrupt messages
6155905Additional diagnostics

Direct Path Operations
4592596Corruption (ORA-1410 / ORA-8103) from multi-table insert with direct load
5022188Direct SQLLOAD of partitioned object table of non final types fails
5179313INSERT /*append parallel*/ can corrupt an index
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5228136ORA-26065 from SQLLDR direct path load of objects containing a LOB and constraints
5510918Log miner slow mining direct load redo
5941030Datapump import can produce corrupt blocks when there is a LONG / LONG RAW
5944227SQLloader direct path load into IOT can dump [kdblldrp]
5953355OERI[klaprs_30] / OERI[klaprs_10] during SQLLOADER direct path load
5973648ORA-54 during concurrent parallel direct SQLLOAD in RAC

Domain Indexes
4566516Transportable tablespace does not handle domain indexes
4644425SGA corruption on UPDATE with functional domain index
5136863OERI from join between partitioned table and domain index
5152232EXPDP loses global index parameters for local domain indexes
5228074OERI[12455] raised from SQL with DOMAIN index when FOR UPDATE option is used
5252061PGA memory corruption / OERI[17456] creating a domain index
5307199OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
5370332ODCITableFetch fails with ORA-28579
5403398Dump when costing user defined operators / functions
5530761ORA-1031 from EXP of domain index
5656948Dump returning collection from ODCIAggregate
5891213ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present
5908945Dump [qxopqdca] with ancilliary operator

Excessive CPU Usage
6455161+Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
4605569LCK may accumulate CPU time on one instance
4697189High CPU usage for large sorts
5362897Non linear CPU increase when adding more shared server sessions
5399325Mutex latch spin causes high CPU on non-CAS platforms
5471994LCK may accumulate CPU time when SMON does Serial Transaction recovery
5530958Larger SGAs and SQL in long running transactions can use excess CPU in ktaifm
5734276Queue slave process may spin in kwqitptm
5896963High LGWR CPU and longer "log file sync" with fix for bug 5065930
5958244LMS processes running in realtime can spin
6001617LCK may accumulate CPU time / ORA-4031 possible
6356566Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)
6407273LGWR spins during slow log switch

Export/Import
3370858Import fails (ORA-932) using FROMUSER / TOUSER for schema based xmltype
4038803IMP-3 / ORA-1722 when using nls_numeric_characters != '.,'
4328909Resource plans and resource groups not imported during full import
4559546Cannot used exp/imp of MVIEW with XMLTYPE column
4912371Dump possible in kohrsmc()
5120780Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5176017Exp/imp loses "RETENTION" settings of LOB columns
5349808IMP-60 hit when importing a table with an XML schema based XMLType column
5374820Client side dump on import of table with more than one LOB column into 32k block size
5391326ORA-942 importing functional indexes as SYS
5402151ORA-439 when importing into Standard Edition db using streams_instantiation=y
5494866PLS-302 'dbver_10i' importing 10g export into 9i with AQ
5530761ORA-1031 from EXP of domain index
5664206ORA-6502 during export of functional index expression over 4k
5766196ORA-942 on schema level import of table with foreign key and XMLSchema
5872788ORA-29821 importing OPERATORS
6140330imp / impdp cannot create object views with circular dependencies

Expression Filters / Rules
6349820Expression filter indexable attributes truncates length to 500 characters

External Tables
4644351OERI[15819] / wrong results from parallel select
5195356Dump (memcpy) under kudmprcbk() when accessing external table
5600425wrong results from select on external table
5676948OERI [qxxmslSelectLocator_10] from SQL*Loader

Feature Unusable
6074842unable to repair failed asm failgroup after replacement of disks

Flashback
4459574FLASHBACK_TRANSACTION_QUERY shows multi row INSERT as SELECT as only one row
5172559ora-600's during reinstate of logical standby after fast-start failover
5209867ORA-38777 is thrown by MRP when flashback through resetlogs
5225733After flashback operation, new logs are not applied in logical standby
5385614Need diagnostics for OERI:ktrviupk_4
5486023"GLOBAL CACHE ELEMENT DUMP" in LMS trace with FLASHBACK
5891280MRP0 on standby may not start (OERI:krfg_aset_1)
5933838Database crash (ORA-449) after ALTER DATABASE FLASHBACK OFF in RAC
5949116Flashback logs are not purged when archiver is out of disk space
6010833Recovery following flashback does not utilize changes in online redo log
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK
6168063High "Flashback buf free by RVWR" waits
6406880System hang possible after killing processes when waiting for flashback logs
6768069Cannot FLASHBACK DATABASE on RAC physical standby

Function Based Index (Including DESC Indexes)
4619997Function based index may not be used for INLIST predicate
4916783Wrong results/Missing predicates from query using INLIST w/FUNCTION BASED index
5377092Wrong results from FAST FULL SCAN of an index on a CASE expression
5391326ORA-942 importing functional indexes as SYS
5513123DUmp [kkfies] from SQL using functional indexes with subqueries
5526851Wrong Results (missing rows) on CONNECT BY when using function-based index
5574966Dump (evaopn2) or Wrong Results with views and function-based index
5619833Dump (qerixGetKey) from query rewrite on join including functional index
5664206ORA-6502 during export of functional index expression over 4k
5686412Dump (evaopn2) from query using functional index
5698193Wrong Results when using TRIM on check constraints or function based indexes.
5796376Dump [kkobrak] from index join with a FUNCTION based index
5843316Wrong results with index join and function-based index
5860221Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
5889331Dump from cost based optimization of INSERT .. SELECT with function based index

Gateways / Heterogeneous Services
3197358Dump when DBMS_HS_RESULT_SET is fetched out of sequence
4767996Dump in HS with very long TNS connect string
4864563HS does not send to_number predicate to HS database
4998706Gateway agent trace does not work
5175364Data truncation / null data selecting NVARCHAR2 over TG4MSQL
5229137PLS-201 compiling program units referencing tables on RDB
5489166INSERT SQL over HS may error
5550614Wrong results selecting BIGINT data from MySQL using MySQL ODBC driver
5601756HS does not supply size for large objects (ORA-28500)
5610906HSODBC dump invoking Data Dictionary translation query multiple times
5738652Intermittent lost RPC connection when executing FDS stored procedure
5898868SELECT FOR UPDATE errors over HS to Teradata
5900857ORA-23619 from HS log based replication
5935527Cursor leak with fix for bug 5260266 / OERI:17280 from Ctrl-C using pipeline function
6053772Dump [kpubsuuc] for SQL over HS using binds
6145525Dump selecting > 34 columns from HS (FDS)

Gateways / ODBC
5385973ODP.NET gets truncated char/varchar data in HSODBC environment

Gateways / Transparent Gateway For DRDA
5877437TG4DRDA gets sqlcode=-102, sqlstate=54002 using concat function

Gateways / Transparent Gateway For SQL Server
4552393Heterogenous apply fails for updates with WHERE .. IS NULL
5733637Select for update fails against TG4MSQL
5844876ORA-28550 from TG4SYBS

Global Temporary Tables
4344935OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
4736557ORA-1466 on read only transaction
5081271PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
5689991ORA-8176 fetching from global temporary table with INSERTS between fetches
5696474Diagnostic enhancement for ORA-600 errors on global temporary tables
6193398Wrong results with parallel query with temporary tables inside views

Globalization Support (NLS)
3419260Silent truncation on insert via DB link from single to multibyte charset
3945156ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
4346448NLS_COMP = ANSI gives wrong results comparing CHAR with VARCHAR2
4517481ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
4730249Logical Standby or Adhoc query fails with ORA-1801 when using a different characterset
4904743ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
4905638Wrong results / errors in session that opens the database for certain NCHAR characterset
4933222Apply update of clob in multibyte charset double spaces characters
4959294DBMS_XMLSTORE does not follow CHAR based semantics
4996004EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
5017909V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
5120476No blank padding with multibyte charset if no character set conversion
5126270Version 3 TIMEZONE check script (utltzuv2.sql)
5128625OERI[17147] / OERI [17182] / NULL result from NLSSORT
5175364Data truncation / null data selecting NVARCHAR2 over TG4MSQL
5252496Wrong result when using a LIKE predicate with NLS_COMP = LINGUISTIC
52576989idata NLS files missing leading to file handle leak
5259741DBMS_XMLGEN.CONVERT trims output for multibyte database
5285966Dump [lxhlod] on select passing NULL for NLS parameter to a function
5326327OERI[qctbyt : bfc] using NLS_LENGTH_SEMANTICS=CHAR
5436371Image corruption / spin loading multiple nested objects in multibyte
5444175glb files created in gdk_custom.zip by ginstall are ignored by Java
5494008Wrong results from LIKE in multibyte when NLS_COMP=linguistic and NLS_SORT=binary_ci(ai)
5526851Wrong Results (missing rows) on CONNECT BY when using function-based index
5567934NCHAR literal replacement can produce corrupt N literals
5576865Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
5594352JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
5604120Performance problems after applying calendar deviation
5632264Version 4 TIMEZONE files
5685296Logical apply stops with PLS-103 due to NLS_NUMERIC_CHARACTERS setting
5693948ORA-31466 error when setting up CDC with table names using multibyte characters
5712086OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
5757315Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
5838153CAST operator does consider NLS_LENGTH_SEMANTICS
5873852sqlldr inserts character data longer than the column length (CHAR length semantics)
5875568IMPDP can error on create table in multibyte with ORA-39125 / ORA-6502
5879179ORA-22925 from CSSCAN when reading CLOB data
5903706ISO2022-JP-OUTLOOK has no mapping for the katakana middle dot character
5985257Wrong results from UTL_I18N.TRANSLITERATE using 'hwkatakana_fwkatakana'
6168288Dump instead of ORA-1863
6357601Romanian base letter mapping missing for some characters
6460895CSSCAN may hang / run slowly
6494820CSSCAN fails with ORA-1455 on tables with more than 2^31-1 blocks

Hang (Involving Shared Resource)
5526987*ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
4489948ASM hangs during a parallel mount and shutdown in RAC
5057695SHUTDOWN IMMEDIATE can be slow
5079641Switchover hangs attempting to recover a log file from a previous primary
5188493crsd.bin can use excess CPU on reboot
5230765LGWR spins while waiting for 'log file parallel write' using ASM
5376770Spin in kcldle in RAC can cause a cluster hang
5387017Primary hang when physical standby "shutdown immediate"
5688403'IPC Send timeout' error just after 'flush_cache' event in RAC
5931789Database hang possible as CKPT cannot get controlfile enqueue (CF)
5955955DWB may spin when collecting object level statistics with concurrent DDL
6069360DBW can spin in kfcRunnableWaiter holding a latch in ASM
6310591DB hang with CKPT waiting for enquiry response in RAC
6406880System hang possible after killing processes when waiting for flashback logs

Hang (Process Hang)
5898210+Hang from concurrent MV refresh and library cache invalidation in RAC
5907779+Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
3140249Data guard broker hangs when standby listener is down
4618808AQ operation requiring exclusive lib cache lock may hang
4648039PLSQL hangs with database links and autonomous_transaction
4927753GRANT / ALTER USER can hang
4930431Failure of 1 CSSD can hang starting CSSD on other nodes
5023410QC can wait on "PX Deq: Join ACK" when slave is available
5166735DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
5225733After flashback operation, new logs are not applied in logical standby
5378806xa_rollback cannot interrupt a long running SELECT branch
5382088Fast start failover can hang on broker MIV mismatch
5392993DDL can hang if EXPLAIN PLAN issued previously for the same DDL statement
5396550Spin in ktsplbfmb holding HW enqueue during LOB segment management
5399901Archived log entries can take a long time to search in Dataguard
5444539Database connections not released after database failover or recycle
5454831RAC deadlock possible on working set latches
5500044Waits on 'cursor: pin X' / 'kksfbc child completion' or ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5503590Logminer Adhoc can hang or error mining logs from a RAC database
5511675OCCI hang in terminateStatelessConnectionPool
5560256Multi threaded OCI program hang when calling OCILobLocatorAssign
5567141OERI[526] / hang with fix for bug 5508574 installed with > 31 CPUs
5602452Capture gets stuck in 'dictionary initialization' after recovery
5604698Deadlock between 'library cache lock' and 'library cache pin' using replication
5654680JMS worker thread does not end if exception thrown in onMessage() method
5692304Enabling fixes for bugs bug 4364202 and bug 3566511 causes shutdown immediate to hang (for n-minutes)
5725109Hang if AQ listener onMessage() method raises an error
5746223Old primary hangs after a FSFO and prevents automatic reinstatement
5955596DBMS_AQ.LISTEN hangs after datapump has executed
5974219Cluster hang when node dies during reconfig
5983020MMON deadlock with user session executing ALTER USER
6013968Hang / OERI:504 with patch for bug 5863519 installed
6019084RAC hang possible when node leaves the cluster with fix for bug 5844816
6057351AWR deadlock between Mxxx processes during snapshot purging process
6144079Instance crash in RAC (OERI:2103)
6334552Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6496514RAC deadlock between "libary cache lock" and TX enqueue

Hang (Process Spins)
6110331+OERI[kcbget_37] / OERI[1100] / spin possible
5452672PA database hang can occur (DBW spin)
3551896Dump / spin from SELECT on V$SESSTAT
4387531Spin running XPATH on SB table with IOT structured varrays
4553025Large inserts into hash clustered tables can spin
4605569LCK may accumulate CPU time on one instance
4697189High CPU usage for large sorts
4699720MMON or PMON spin in RAC
5369855OERI:733 or Spin (qksopLogSame) from star transformation
5376770Spin in kcldle in RAC can cause a cluster hang
5417292Query compilation may spin in kkogtp
5436371Image corruption / spin loading multiple nested objects in multibyte
5471994LCK may accumulate CPU time when SMON does Serial Transaction recovery
5484652QMNC process spin in Streams
5545530EMON may spin in kpcopen
5631915Select from V$ views using X$KGLLK can spin
5667683Parse of query can spin in kkosbn
5670585OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
5692304Enabling fixes for bugs bug 4364202 and bug 3566511 causes shutdown immediate to hang (for n-minutes)
5718007Spin (in qcopxla / qcopx0la) with OR predicates on PARTITION key columns
5728380DML may spin under ktspffc searching for space in ASSM segment
5734276Queue slave process may spin in kwqitptm
5757315Spin possible comparing 2 strings with monolingual sort (NLS_SORT)
5763245Parse may spin in kkpapRTPRuningSetup
5763434Spin in kokes2q when sorting on VARRAY column over 4k long
5952530Spin / hang after cluster reconfiguration
5955955DWB may spin when collecting object level statistics with concurrent DDL
5958244LMS processes running in realtime can spin
6001617LCK may accumulate CPU time / ORA-4031 possible
6041084Spin during parse of query with INLIST against list partition key
6069360DBW can spin in kfcRunnableWaiter holding a latch in ASM
6084108Dump / CPU spin possible after an ORA-3115
6460895CSSCAN may hang / run slowly
6640950Update of LONG can cause Streams capture to spin / spill
6753486PMON spins if dead process hold library cache mutex

Hash Join
5383936+Wrong results from Parallel Query with OUTER join and HASH join
4475206Excess PGA memory use with many hash joins
4540971Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
4566991Hash group-by is not reported in v$sql_workarea_active
5376015Wrong results with hash semijoin when build rows do not fit in memory/Spill to disk
5759075Wrong results from PQ with HASH on ANSI CHAR join
5893340OERI [32695] [hash aggregation can't be done] from hash aggregation
5947623Excess PGA memory used by hash joins

Index Organized Tables (IOT)
6646613*IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
4387531Spin running XPATH on SB table with IOT structured varrays
4719798DBMS_STREAMS_ADM.maintain_schemas incorrectly requests supplemental log for IOT with overflow
4725385DBMS_STATS on partitioned IOT with additional indexes can be slow
4770292Wrong results from CONNECT BY query on IOT with secondary index/es
5236908Primary key index not used for IOT
5255455DML error logging not working for primary key violation with insert on IOT table
5494240OERI[15201] during select from an IOT
5558244OERI[kcbnew_3] can occur
5567937False ORA-1 / ORA-1403 from logminer rolling back IOT redo
5609096MERGE / UPDATE to IOT can cause corruption
5685645Logminer does not support IOT with OVERFLOW if table has been altered
5847521Hierarchical (CONNECT BY) query on IOT returns wrong results
5924538Logical standby apply fails with ORA-1427 for operations on IOTs
5944227SQLloader direct path load into IOT can dump [kdblldrp]
6070548Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT

Install/Patching Is Not Performed Correctly
6051728P*HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1
5495242PIHPUX: CRS may not install
5845104PIWin64: 10.2.0.3 OPMD.EXE does not work
5161782Dump installing XDB
5507883CRS install fails in CRS root.sh due to node panics

Instance May Crash
5605370*Various dumps / instance crash possible. This bug is alerted in Note:454464.1
6017420*OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed. This bug is alerted inNote:453309.1
6441119PInstance crash due to ORA-27300 / ORA-27152
6458590PSolaris: SIGFPE in kglsim_update_simresz / ORA-822 MMAN terminates instance
6656824PDBW can crash with fix for bug 6087207 installed
4422686LMD/LMS cannot be frozen during reconfig
4433838Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
4744529OERI:kclpred_1 / crash possible in RAC
5081271PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
5118012Instance crash with OERI[kclswrite_3] with multiple DBW processes
5118272Instance crash with ORA-600 [1433], [60] due to lgwr filling up msg blocks (Messages could be for LGWR or ARCH)
5131219CSS shuts down the node when disk IO is suspended momentarily
5190596LMON dumps LMS0 too often during DRM leading to IPC send timout
5324905nsprecv() can corrupt the SGA when using shared servers
5375583LMS process dies with OERI[kclexpandlock_1]
5377099Dump [kksfreeheap] / OERI:504 / SGA corruption / crash possible
5384248OERI[k2gtelock: !k2gtca] / instance crash cleaning up distributed transaction
5412994Dump in ksrchconnect_ctx leading to instance crash
5476873Instance crash due to PMON ORA-601 / OERI[ksudlp1]
5504989PMON dump [kfgGlobalClose] / instance crash
5512921Instance crash caused by SMON OERI[kcblus_1] / dump
5554692Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10]
5578157Instance crash with ORA-600 [1433] (RSM has all message blocks)
5587421LMS fails with OERI [kjmpmsg_1]
5600050LMON may fails with OERI [kjbrref:pkey] during DRM
5690100RAC instance crash with OERI[kjbmpwrite:wip2]
5702177Instance crash from OERI[kghchoose_grow_1]
5721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5730717OERI:kclchkinteg_18 / LMS crashes the instance
5736850SGA corruption / crash from PQO bloom filter
5757752OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
5762514DBWR crashes instance with OERI[kcbbctsc_3]
5863519Instance crash due to LMS dump (in kclcsr)
5899033SMON dump (kfrCheckCtx) diskgroup instance recovery
5933838Database crash (ORA-449) after ALTER DATABASE FLASHBACK OFF in RAC
5962344Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
5983403PMON may crash the instance with OERI[kksStatsRecovery-Bad-Opcode]
6005113OERI[kclrwrite_7] in DBWn process followed by instance crash in RAC
6013983ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
6018125Instance crash during dynamic remastering or instance reconfiguration
6035614Instance crash / dump [kghunphy] with fix for bug 5922239
6075582OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
6144079Instance crash in RAC (OERI:2103)
6195283OERI[1100] / crash using Resource Manager
6239052LMS can crash instance with OERI[kjbrchkinteg:last]
6271689RAC instance crash possible
6501007DRM sync timeout in RAC
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

Instance Startup
5752399P+Sol: Mandatory Patch to use Oracle with Veritas or Solstice Disk Suite on Solaris
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
4440013CRS startup of RAC fails when FSFO enabled
4771560Open resetlogs can fail with ORA-1667
5087787ORA-29702 starting RAC with large buffer cache
5247609RMAN slow performance during register database/open resetlogs
5572026ORA-942 / ORA-1031 in tracefile when starting the database as SYSOPER
5744546MMON OERI [1403]
5855896Reconfiguration takes a long time restarting instance in active/standby RAC
5857949Startup may fail due to dump [rfmsoexinst] from DMON
6143688node startups cAN spend up to 2 mins in AQ partition code
6781496OERI[KGHLATCH_REG4] on STARTUP with >61 CPUs in RAC with fix for 5508574

Interoperability (Between Releases)
5933477*Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database. This bug is alerted in Note:455832.1
5245451Intermittent ORA-904 referencing remote objects columns

JDBC
4308334OERI[12314] during XA commit/rollback/prepare while attached to different transaction
4992603TIMESTAMP.timestampValue(Calendar) does not exist
5190543Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5417281oracle.sql.DATE looses a year when constructed from BC Timestamp
5468695TIMESTAMPTZ wrong near daylight switch
5734901JDBC Thin XMLType.getDOM fails with SQLException
5885079Incorrect output from INTERVALDS.stringValue() for negative intervals
5945463XA clients should not require execute privilege on DBMS_SYSTEM
6278984java.awt.font.glyphvector.getglyphoutline returns empty shape

JavaVM / JSP / Corba etc..
4865959Wrong results / exception from Java Stored Procedure accessing data over DBLINK
4898765NullPointerException from stored Java when maxAdvance of glyph computed
5074285Dump [eorealize_xref] from stored Java using reflective methods
5258410Dump [eoa_scan_mark_object] using stored Java threads
5372831OERI:26599 / dumps in JVM after database has been closed for recovery / opened
5400158OERI[17078] / dump running Java DDL (loadjava) concurrently
5688685JVM timezone changes for Western Australia December 2006 (superceeded)
5711011"SocketException: socket is closed" using RMI with shared servers
5862057Oracle JVM incorrectly returns true for "x instanceof object[]" when "x" is a class
5865568JVM timezone changes (version 4 timezone data for JVM)
5963041Socket.shutdownOutput() closes the socket in the Oracle JVM
6065183A dump in AccessControlContext methods in the Oracle JVM
6065728Oracle JVM performance enhancement
6120084Dump (eoistrnrep->strncpy) in Oracle JVM

Job Queues
4552696DBMS_Scheduler is suppressing no_data_found exceptions in jobs
4904904Problems with DBMS_SCHEDULER JOB_START time (eg ORA-1877)
5111250DBMS_SCHEDULER jobs fail silently with OLS / OID
5120780Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5140631V$SESSION.sql_address not set by DBMS_SCHEDULER
5157602Datapump export/import modifies the chains created with dbms_scheduler
5166735DBMS_SCHEDULER "EXECUTABLE" jobs with large amounts of data output to STDERR can hang
5377153DBMS_SCHEDULER call heap memory leak when changing attributes of a job
5593617Job scheduler cannot be used on logical standby (ORA-16224)
5620375PLS-103 from datapump import of dbms_scheduler jobs with PLSQL_BLOCK
5928612V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs

LDAP / Oracle Internet Directory
4395849ESM tool hangs connecting to directory server on SSL port
4571240ESM denies access to non-orcladmin users if anonymous binds disabled
5111250DBMS_SCHEDULER jobs fail silently with OLS / OID

Latch Contention
6455161+Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
4691237High "library cache" latch gets from SQL using objects in PLSQL
5749075High Requests on dc_rollback_segments. latch / US enqueue contention
5918642Heavy latch contention with DB_CACHE_ADVICE on
6333663Shared pool latch contention due to fragmentation of large pool
6356566Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

Leak (Memory Leak / Growth)
4475206Excess PGA memory use with many hash joins
4540971Hash group by significantly over allocates memory and breaks V$SQL_XX statistics
4566991Hash group-by is not reported in v$sql_workarea_active
4587117ORA-384 can occur even if there is free space in some pool/s
5058318Memory leak (in "koh-kghu" heap of type "kolccst obj")
5089522Memory leak in niotns in MRP process
5095025ORA-4030 (kxs-heap-c,temporary memory) using expdp
5095889PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
5220562ORA-4030 (sort subheap,sort key) on insert a partitioned table with concurrent DDL
5377153DBMS_SCHEDULER call heap memory leak when changing attributes of a job
5377973Register schema fails with ORA-4031
5382621OCCI memory leak in getColumnListMetaData()
5386986Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
5391505High PGA consumption for query (kxs-heap-c) from OR expansion
5408970Memory leak using XMLType() constructor on ADT in a loop
5464834ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
5477912Memory leak parsing DTD
5482555Shared server does not release memory
5485417Memory leak of "blockers api immd" during global hang analyze
5516917Excessive mermory usage when running a query using nested loops
5529797PGA leak / OERI KWQPCBK179 during Streams propogation
5548510_FIX_CONTROL parameter leaks memory in the shared pool
5556674V$ASM* dynamic views leak cursors (ORA-01000)
5573238Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
5608198Memory leak by advanced queuing XML transformation
5618049"mvobj part des" leaked memory after partition DDL (ORA-4031)
5629416Client memory leak after switching schema
5668025XMLParser.Parse() can leak memory
5717536Dequeue can suffer from a memory leak
5723260Logminer slow / excess memory use processing batch inserts with LOBs
5758963UGA memory leak possible from AQ dequeue
5891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
5947623Excess PGA memory used by hash joins
6011182Parsing of large query takes long time / memory leak / ORA-4030 /4031
6043052Leak in perm allocations with "library cache" comments (ORA-4031)
6049324Memory leak from array dequeue
6065604DBMS_AQ.DEQUEUE_ARRAY PGA memory leak
6356566Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

Leak (Resources Eg: File Handles)
5705795P*Many child cursors possible for SQL using BINDS. This bug is alerted in Note:403616.1
4367986Bind peeked parallel cursors do not share
4584641Cursor leak using DBMS_XMLGEN with a PLSQL function returning sys_refcursor
4918946OCCI terminateEnvironment can leave threads
4966024VLM buffer leak on if an error occurs
5141429"skgspawn 27142" errors and defunct Oracle processes
5166745Excessive redo generation with auditing enabled
5252389CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
52576989idata NLS files missing leading to file handle leak
5557660ORA-20 / process group leak from OCI Connection Pool connections
5605319Cursor leak from QMON coordinator exceptions
5935527Cursor leak with fix for bug 5260266 / OERI:17280 from Ctrl-C using pipeline function
6139547Shadow process leak on ASM instance when diskspace exhausted (ORA-20)

Literal Replacement (CURSOR_SHARING)
5146740+Wrong results with bind variables/CURSOR_SHARING
2837580Dump if SQL has > ~35000 literals
4202503Parse errors possible using CONTAINS with cursor_sharing=similar/force
4436832False ORA-979 "not a group by expression" with literal replacement
4513695Poor performance for SELECT with ROWNUM=1 with literal replacement
5155885OERI[kkslgbv0] with CURSOR_SHARING=similar
5177766OERI[17059] with SESSION_CACHED_CURSORS
5254759ORA-12801/ORA-1008 occurs on a parallel query with bind variables
5364819OERI[kkslpbp:1] when using literal replacement
5476507OERI[15868] / OERI[15160] can occur with cursor sharing
5757106OERI[15851] selecting aggregate of a constant with literal replacement
5762750ORA-907 when cursor_sharing is enabled
5863277ORA-1008 from SQL on second run when cursor_sharing=similar/force

LogMiner
5035058V$LOGMNR_CONTENTS.MineValue may not show an UNDO value
5299237Inconsistent results from v$logmnr_contents with committed_data_only
5388885Hang / OERI[krvxbpns01] accessing V$LOGMNR_CONTENTS from RAC
5437445Incorrect username displayed from logminer adhoc query when auditing is on
5503590Logminer Adhoc can hang or error mining logs from a RAC database
5510918Log miner slow mining direct load redo
5518651ORA-1301 from dbms_logmnr_d.build
5531784V$LOGMNR_CONTENTS CSF may be wrong
5567937False ORA-1 / ORA-1403 from logminer rolling back IOT redo
5685645Logminer does not support IOT with OVERFLOW if table has been altered
5723260Logminer slow / excess memory use processing batch inserts with LOBs
5744428dbms_logmnr_d.build may get a downstream build failure
5888733Wrong results from V$LOGMNR_CONTENTS referencing AUDIT_SESSIONID
5962344Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
6064864Archives containing DDL for not replicated objects take longer to process
6114833Logminer does not signal error if log unavailable in continuous_mine
6124804Dump [krvxbpc_processcommit] selecting from v$logmnr_contents

Memory Corruption
4583492Dump possible using ADT columns when table has many columns
4644425SGA corruption on UPDATE with functional domain index
4745691OERI[kghufree_06] from AQ propogation of XML payload
4899479Undo/redo corruption if distributed transactions used
5128625OERI[17147] / OERI [17182] / NULL result from NLSSORT
5172559ora-600's during reinstate of logical standby after fast-start failover
5252061PGA memory corruption / OERI[17456] creating a domain index
5324905nsprecv() can corrupt the SGA when using shared servers
5583634OERI [17147] / dump after inserting a text node of size 64000
5671774Memory corruption due to TDE with imported certificate
5681955SGA corruption in RAC (OERI [17114] / OERI [17112])
5712086OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
5716932Memory corruption / OERI [17147] / dump selecting from PATH_VIEW
5721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5735091Memory corruption when using XMLAGG
5736850SGA corruption / crash from PQO bloom filter
5860221Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
5900857ORA-23619 from HS log based replication
6136494Capture process aborts with OERI [17112] / OERI [17147]
6143117Rare intermittent mutex problem
6452485SGA memory corruption / OERI [17182] with fix for bug 6085625
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

Merge SQL (MERGE .. USING)
4216668Dump from INSERT / MERGE on internal columns
4311273ORA-2064 using MERGE statement over a database link
4406211Dump (insLoadRowInfo) from MERGE SQL with false condition
4572043DML monitoring is incorrect for MERGE / MTI
4771851Dump (kxccsrw) from INSERT .. AS SELECT / MERGE
4883635MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5387478ORA-28132 for user with EXEMPT ACCESS POLICY privilege
5609096MERGE / UPDATE to IOT can cause corruption
5731952MERGE statement does not insert rows if source is a (inline) view with parallel
6379123EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

Migration / Upgrade / Downgrade
6646613*IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
5501528IORA-6545 recompiling with PLSQL_WARNINGS set
5841554IOERI:kqludp2 during upgrade to 10.2.0.3
5892355I+Upgrade to 10.2.0.3 can fail with ORA-600 [22635]
4733582Upgrade to 10.2 deletes statistics on AQ tables
4882839ORA-4068 / ORA-4065 after upgrade
5094908Dump (kokbBuildExplodedTree) recompiling a view after upgrade to 10.2
5125957Cannot start CRS after CRS ugprade
5520937Cannot upgrade images for dictionary types to 8.1 image format
5568399CRS upgrade can corrupt OCR
5640527ORA-1403 running utlu102i.sql on an 8.1.7.4 database
5715079ORA-1281 when applying a Patch Set on a logical standby
5871314Pickler fix needed to allow some DB upgrade / downgrade to work
5947653XE to EE upgrade fails in XDBx
5955764OERI[kccirsd_4] during CONTROLFILE upgrade from pre 10.2 version
6052351Dump running catupgrd.sql when creating/replacing streams$transformation_info
6379123EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2

Multi Table Insert SQL
4397693Dump (apaqba) from multi table insert with WHEN clause under RBO
4592596Corruption (ORA-1410 / ORA-8103) from multi-table insert with direct load

NCOMP
5974207Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL

NUMA Related
5173642Data not read from cache on second execution with NUMA optimization enabled

Network
5389730PSolaris-X86: 32bit clients cannot use Native naming adapter (ORA-12154)
4767996Dump in HS with very long TNS connect string
4998706Gateway agent trace does not work
5406976Dump (lxhscn) if DB calls out over NET with a FAILOVER clause
5755010Listener registration never completes
6083037Server side load balancing does not work
6390420TNS-12535 is logged twice to sqlnet.log at time-out with shared servers

OCCI
4918946OCCI terminateEnvironment can leave threads
5382621OCCI memory leak in getColumnListMetaData()
5511675OCCI hang in terminateStatelessConnectionPool
5956137OCCI dumps using stack instance of pObject derived classes
5970288OCCI isNull() on object column always returns false even when object is null
5973217OCCI::intervalds object attribute uses day precision for fractional seconds
6156762OCCI fractional seconds portion can be wrong

OCI
5389730PSolaris-X86: 32bit clients cannot use Native naming adapter (ORA-12154)
4730906"ilibociei" target in ins_rdbms.mk does not work
5120476No blank padding with multibyte charset if no character set conversion
5131157OCI may error reexecuting a statement against a table with an altered column type
5242942Client dump (OCIPClearMxCtr) using stateless connection pool
5292883Dump from OCI client using OCI7 olog() call
5413989OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
5444539Database connections not released after database failover or recycle
5497630ORA-3124 from NULL LONG bind for an UPDATE which matches no rows
5510345ORA-22282 with LOB buffering enabled
5549410Inconsistent characters read returned from OCILobRead
5557660ORA-20 / process group leak from OCI Connection Pool connections
5558356Bad describe information using change notification
5560256Multi threaded OCI program hang when calling OCILobLocatorAssign
5629416Client memory leak after switching schema
5643527OCILobOpen/OCILobGetChunkSize do not return OCI_STILL_EXECUTING in non blocking mode
5682121Multithreaded OCI clients do not mutex properly for LOB operations (ORA-21500 [17099])
5683652OCIHandleFree performance issue. PeopleTools Mandatory
5694101OCI piecewise operation returns wrong piece length for long / long varchar data
5715788genezi -v reports 32-bit library instead of 64-bit
5721502Non blocking client may dump executing PLSQL
5721702Error information may be lost in non-blocking OCI
5721994Unexpected errors from non blocking OCI LOB calls
5722178ORA-1002 in non blocking mode
5736739Compressed fetching can fail in non blocking mode
5736747Resumed OCIStmtExecute can fail in non-blocking mode
5765361Client dump using OCIDirPathPrepare in OCI_UTF16ID mode
5932089FAN OCI clients not aborted by OCI on public network down

Online DDL
4596807OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes

Optimizer
599680Unnecessary sort for SELECT DISTINCT
3748430i_*part$, i_*part_obj$ should be created as unique indexes
3945156ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
3995047Explain plan does not show a part of the execution path
4204383Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
4215910DBMS_STATS may use a 100% row sample size when not expected
4226736Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
4273361Unique index access not used with INLIST predicate
4397693Dump (apaqba) from multi table insert with WHEN clause under RBO
4422100Sort merge join on inequality should have control parameter
4444536Unnecessary sorting when access made through a global index
4483240INLIST may use suboptimal index
4513695Poor performance for SELECT with ROWNUM=1 with literal replacement
4545802Poor Outer Join Cardinality estimation with filters on outer table
4567767Execution Plan changes upon rowcache reload
4581014DBMS_STATS issues gathering SIZE AUTO / SKEWONLY
4587431Dump (in kkqucsv) / spin from query with a multi column IN subquery predicate
4605810Index may not be chosen to eliminate ORDER BY SORT
4619997Function based index may not be used for INLIST predicate
4652100Poor plan with bind peeking for SQL against LIST partitioned tables
4664788Query with UNION can dump in kkqudhus
4684209Dump (under evaopn2) with transitive predicate from CHECK constraint
4698023CBO trace may treat a predicate value as 'out-of-range'
4704779Incorrect histogram type shown (frequency/height-balanced)
4708389Nested loop join costing ignores parallelism of index used to probe in right side
4712638OERI[15160] / dump [kkogbro]
4724074Small CPU performance overhead during optimization
4725385DBMS_STATS on partitioned IOT with additional indexes can be slow
4733582Upgrade to 10.2 deletes statistics on AQ tables
4752814Wrong selectivity on comparision of VARCHAR2 column with CHAR variable
4868646Dump from cost based query transformation
4872602Sub-query is unnested even though cost is higher
4878299Bad plan from join with FIRST_ROWS_N or a ROWNUM predicate
4899105OERI[19004] from multi table join
4905112CREATE OUTLINE on DML using an indexed partitioned table may dump (kauxalo)
4924149Push predicate not working when function in the filter
5022061Dump [kkessc] optimizing query with inequality join if INDEX SKIP SCAN considered
5040753Optimal index is not picked on simple query / Column group statistics
5058503Dump[kkogtp] can occur selecing ROWID from a join view
5061079Poor CONNECT BY plan
5082178Bind peeking may occur when it should not
5089444Dump (kkodsel) from select with a subquery with star transformation
5101017Trace files with "table_stats(failed sampling n)" messages
5112856OERI[kghstack_underflow_internal_1]... [kkocxj : predtailpp]
5128368Dump [kkoeqv] optimizing a query with nested views
5129407Suboptimal plan for SQL with multiple OR branches
5163554OERI[qctopn1] during join predicate pushdown
5169247Dump (eg in qkarid) from SELECT FOR UPDATE after table elimination
5199213Very bad plan for UNION ALL and push constant predicate / Wrong Results
5211863Poor plan for CONNECT BY
5211984Parse errors with USE_STORED_OUTLINES
5220356Partition pruning predicates not cost pushed into UNION ALL views
5236881Wrong Results (More rows) with a CONCATENATE of ANTI joins
5236908Primary key index not used for IOT
5240607FIRST_K_ROWS may choose inefficient NESTED LOOPS join
5245494Improved control over whether star transformation is performed
5259048Optimizer does not recognize/use HASH clusted index access with OR list
5263572Wrong cardinarity for predicates of form "col like func(:bind)"
5284303Poor plan for predicates against character columns containing numeric data
5288623CBO may not choose the best index for ORDER BY elimination
5302124Join Predicates are not push inside window functions -- superceeded fix
5308692ORA-1426 error when running DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
5333268DBMS_STATS.GATHER_INDEX_STATS can be slow
5337352OERI[kkqtcpopn: 0] during parse with subquery unnesting
5352807CREATE INDEX with COMPUTE option does not gather statistics
5358150Dump (apaqbd) using CAST with cost based transformation
5362021Dump from SQL using user defined functions
5364143Bind Peeking is not done upon query reload, Execution Plan changes
5382842Select fails with OERI[qctcte1] using cost based transformation
5385629Push predicate optimization does not occur
5387148View not merged even though the cost is lower
5391505High PGA consumption for query (kxs-heap-c) from OR expansion
5395270OERI[qctcte1] / dump / wrong results from view merging
5396162Suboptimal plan from ANSI query with semi join
5399282First k rows optimization may not always pick best plan
5417292Query compilation may spin in kkogtp
5434872OERI[qolgenol-1] when executing dbms_outln.create_outline
5440119Dump in kkogast
5449488Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
5454975Dump executing DBMS_OUTLN.CREATE_OUTLINE
5468809Predicate order can affect execution plan
5482831Suboptimal plan with FIRST_ROWS_K or EXISTS subquery
5483301Cardinality of 1 when predicate value non-existent in frequency histogram
5487686Wrong results from CONNECT BY query
5488174Dump [evaopn2] on a CONNECT BY query
5490501Wrong Results with COALESCE or NVL2 on aggregations inside subqueries
5505157Predicates are not pushed in UNION ALL views
5519856Wrong cardinality from CBO for "col LIKE function(:bind)"
5526851Wrong Results (missing rows) on CONNECT BY when using function-based index
5547058Poor plan with old_style predicate push into UNION ALL views
5547895No transitive predicates produced for user defined deterministic function
5548510_FIX_CONTROL parameter leaks memory in the shared pool
5570942Query Rewrite causes high parse time with high hits on 'latch: row cache objects' and dc_object_ids / Dump in STRLEN
5573425Wrong results from subquery unnesting with complex view merge
5580497Dump (kkeais) during query optimization
5585187Wrong Results doing MERGE JOIN with a correlated subquery on the right side
5592012Wrong results with INLIST and UNION/UNION ALL
5608992Wrong results from filter push with OUTER join
5611962CBO MAX/MIN optimization may not occur
5618040FIRST_ROWS may give poor plan if index chosen to eliminate a SORT
5620485Non code based push predicate into UNION view can get poor plan
5624216Wrong cardinality for UNION ALL with no WHERE clause
5632128Materialized View refresh looses statistics on primary key
5632192Wrong Results with Max/Min in subquery/view
5634346Multi-column INLIST may not use INLIST ITERATOR
5645718ORA-1476 gathering statistics with DBMS_STATS
5650477Poor plan possible due to lack of view merging
5680702Suboptimal execution path for semi / anti join
5682441Wrong Results (no rows) joining views with predicates using PLSQL functions
5694466OERI[15160] from subquery unnesting
5694984Index distinct key count scaling is wrong for first_rows(k)
5698193Wrong Results when using TRIM on check constraints or function based indexes.
5705630Suboptimal plan from 'or' expansion
5707754Dump can occur executing a large query
5708897Wrong results from ROWNUM with semi/anti join
5709414DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO call is very expensive
5741044Suboptimal execution plan as 1 row table not detected
5741121Suboptimal plan for "not equals" predicates
5742678Index range scan used to get MAX value instead of index min/max first row
5754362Plans can change after deleting statistics on a partitioned table
5762598Suboptimal plan due to bad cardinality for numeric string constants
5766310Bad join cardinality is in the presence of histograms
5766450Dump [kkomprf] when attempting STAR transformation
5796376Dump [kkobrak] from index join with a FUNCTION based index
5837795Wrong results / OERI from cost based CONNECT BY
5842686Poor plan due to bad average column length for tables with LONG RAW
5843316Wrong results with index join and function-based index
5845347Dump [kkogbys] parsing SQL with GROUP BY
5872956Slow or Wrong Results on CONNECT BY queries with constant predicates
5882954Long parse time for query against tables with many partitions
5889331Dump from cost based optimization of INSERT .. SELECT with function based index
5891471Poor cardinality estimates with check constraints
5893396Wrong results possible due to invalid stored outline
5903581Wrong Results with "Connect By with Filtering"
5903829OERI[qkshtTabInf2:1] can occur parsing a query
5913871FGA records are written for recursive SQL under DBMS_STATS
5932203Wrong result when comparing same column with values of different datatypes
5939115ora-600 [kghstack_underflow_internal_1][pcols in kkpapdaextsqueryslvl]
5944076Suboptimal plan in FIRST_ROWS(K) mode
5949981Bad cardinality with histogram
5960268Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index
5976822Suboptimal plan possible
6006300Push predicate does not occur
6007259CBO does not consider ORA concatenation
6011182Parsing of large query takes long time / memory leak / ORA-4030 /4031
6016075Wrong Results for query with correlated subquery and predicate pull up
6016087OERI[15160] from subquery unnesting
6019818ORA-1422 from DBMS_STATS auto granularity
6020789Dump [vopplog] pushing join predicates
6029071Wrong results from distributed SQL with OUTER joins
6038461Wrong results from SQL with UNION and a fast DUAL subquery
6041535Wrong results when predicate pushed into union-all branches
6042205High parse time for a query using ORDER BY
6051211Too High Join Cardinality with Histograms Present
6062266Cardinality of 0 for range predicate and no histograms
6070954Skip scan may be used instead of a better range scan
6075238OERI[qctcte1] on parse of query with views / subqueries
6077514DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache
6082745Bad Cardinality Estimation with Single Value in Frequency Histograms
6084811MERGE JOIN CARTESIAN not considered
6087237CBO may not choose best join order
6114166Pre-10g outlines may not work in later releases
6119884Wrong results with query with OR operator with OR expansion
6122894Poor plan from UNION / INTERSECT views with OR predicates
6123567Dump [kkosbn] optimizing query on partitioned table
6134565FIRST_ROWS hint is not honored with "_sort_elimination_cost_ratio" parameter set
6151963Wrong join cardinality with histograms
6159522OERI[qkaffsindex3] from ANALYZE TABLE .. ESTIMATE STATISTICS
6163564Poor cardinality from "LIKE" predicates and binds
6188881Index selectivity adjustment for anti/semi join causes wrong index to be chosen
6239971CBO costing can differ greatly for =< compared to <
6251917Merge join Cartesian setting optimizer_index_caching and optimizer_index_cost_adj
6350462Incorrect index statistics scaling for first_rows(k)
6400795Wrong results from view merging
6408017OERI[12811] optimizing a query against fixed view/s
6511034Join Cardinality Overly estimated
6686885WRONG RESULTS (missing rows) USING NATIVE FULL OUTER JOIN
6758230MultiColumn Selectity may not be used

Optimizer (Stored Outlines)
5211984Parse errors with USE_STORED_OUTLINES
5893396Wrong results possible due to invalid stored outline

Optimizer (Subquery Factoring - WITH clause)
4702284ORA-604 / ORA-902 from WITH clause with scalar subquery involving an object column
5073249Dump from fast refresh of MV using "WITH .. AS"
5130732Query using "WITH" clause can fail with ORA-942
5196061Dump in evaopn2() from WITH query using WINDOW functions
5470034ORA-1436 from TKPROF EXPLAIN of query using a WITH clause
5497168Wrong results isolation_level=serializable and WITH clause
5641873ORA-904 using a WITH clause that includes a UNION
5708633Wrong results / dump [ldxite] from materialized WITH clause
5906937Wrong result using ROW_NUMBER in SQL using a WITH query block
5987000OERI:qkxrPXformQbc1 can occur for SQL using a WITH clause
6360220ORA-21780 from subquery factoring SQL WITH clause

Optimizer Bad Cardinality
4545802Poor Outer Join Cardinality estimation with filters on outer table
4567767Execution Plan changes upon rowcache reload
4652100Poor plan with bind peeking for SQL against LIST partitioned tables
4752814Wrong selectivity on comparision of VARCHAR2 column with CHAR variable
5263572Wrong cardinarity for predicates of form "col like func(:bind)"
5284303Poor plan for predicates against character columns containing numeric data
5364143Bind Peeking is not done upon query reload, Execution Plan changes
5483301Cardinality of 1 when predicate value non-existent in frequency histogram
5519856Wrong cardinality from CBO for "col LIKE function(:bind)"
5624216Wrong cardinality for UNION ALL with no WHERE clause
5741121Suboptimal plan for "not equals" predicates
5762598Suboptimal plan due to bad cardinality for numeric string constants
5766310Bad join cardinality is in the presence of histograms
5891471Poor cardinality estimates with check constraints
5949981Bad cardinality with histogram
6051211Too High Join Cardinality with Histograms Present
6062266Cardinality of 0 for range predicate and no histograms
6082745Bad Cardinality Estimation with Single Value in Frequency Histograms
6151963Wrong join cardinality with histograms
6163564Poor cardinality from "LIKE" predicates and binds
6511034Join Cardinality Overly estimated
6758230MultiColumn Selectity may not be used

Oracle Data Mining
4509805Model build fails with dm_nested_* and special characters
5374844ABN model build fails using dataset in excess of 100,000 rows

Oracle Disk Manager
5698225ORA-17507 can occur using 16k block size with ODM
5909894ASM datafile lost after rename (ORA-1157)
6377317OERI[ksfdrfms3] using ODM if a log corruption is detected
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM

Oracle Label Security
4304023Logical Standby does not support OLS properly
4618715Dump inserting into a view with OLS policy on tables
4620832Dump in kzrtppg with multiple referential constraints and OLS policy
4714295It is possible to drop an OLS group which is still in use in an existing label
5111250DBMS_SCHEDULER jobs fail silently with OLS / OID
5162768Wrong results using more than one OLS policy on a table
5480607OERI:kghstack_underflow_internal_3] from DROP_POLICY
5674756OLS does not set selectivity of predicates causing bad execution plans
5839280OERI[15265] dropping OLS policy

Oracle OLAP
5586253Dataload from remote table does not work using DBMS_AW (OLAP)

Oracle Text (Formerly interMedia Text)
4202503Parse errors possible using CONTAINS with cursor_sharing=similar/force
4614980OERI:15448 from Text query
5095815Select with CONTAINS predicate on view fails
5147225Poor performance of parallel context query with ROWNUM predicate
5259868Text query using index in another schema fails (ORA-20000, DRG-50857)
5677420ORA-20000 from Text query against partitioned table
5728347ORA-20000, DRG-10599 occurs during text query through synonym
5867231OERI:qernsRowP on Text query with NLS_COMP / NLS_SORT set
5908945Dump [qxopqdca] with ancilliary operator
6357601Romanian base letter mapping missing for some characters

Oracle Univeral Installer
6474976PHPUX Itanium: OUI overwrites libnmapi2.so.1 when uninstalling

PL/SQL
5501528IORA-6545 recompiling with PLSQL_WARNINGS set
2834295ORA-12714 declaring cursor for a function that returns a table of NVARCHAR2
4493741Cannot see SQL_TEXT for procedure calls from EXECUTE IMMEDIATE
4580190Bulk insert to partitioned table can insert constraint violating rows
4587556OERI:17069 compiling a package with a self referencing synonym
4609147ORA-918 if PLSQL block has same package and function name
4648039PLSQL hangs with database links and autonomous_transaction
4691237High "library cache" latch gets from SQL using objects in PLSQL
4725022Wrong results from a function call using a CONCAT of a NULL
4745114OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
4882839ORA-4068 / ORA-4065 after upgrade
5051432DBMS_LOB does not execute with the privileges of the calling procedure
5076729OERI[pmucitnxt] doing type manipulation
5118104Dump compiling PLSQL using pseudo columns with INSERT .. RETURNING
5150562Dump expCheckExprEquiv from pipelined function in hierarchical query
5229137PLS-201 compiling program units referencing tables on RDB
5298826Wrong results from SQL using DETERMINISTIC function/s
5367514Wrong number of exceptions returned executing a bulk insert
5401776Poor performance using DBMS_XMLDOM
5467520PLSQL errors accessing synonym to remote object
5547895No transitive predicates produced for user defined deterministic function
5564384ORA-6502 assigning values from SQL to PLSQL variables
5685189Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
5721502Non blocking client may dump executing PLSQL
5765958OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
5847881ORA-3001 from GROUPING SET query against a view containing a function
5933883ORA-918 error creating a package
5934741Dump (kgmtncch) from CALL statement with OUT CHAR arguments
5935527Cursor leak with fix for bug 5260266 / OERI:17280 from Ctrl-C using pipeline function
5974207Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL
6136074ORA-4068 / ORA-4065 ORA-6508 on VALID objects
6494146OERI [kksfbc-reparse-infinite-loop] can occur

PL/SQL (DBMS Packages)
4430244+Segment advisor can load blocks of dropped objects into buffer cache (KCB OERI errors)
4226736Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
4552696DBMS_Scheduler is suppressing no_data_found exceptions in jobs
4581014DBMS_STATS issues gathering SIZE AUTO / SKEWONLY
4667479ORA-16224 when using UTL_FILE / ORA-1031 using a DIRECTORY under GUARD ALL
4898580DBMS_METADATA.GET_DEPENDENT_DDL does not show comments on materialized view columns correctly
5040555DBMS_SPACE.OBJECT_GROWTH_TREND output is not correct
5128933Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5140631V$SESSION.sql_address not set by DBMS_SCHEDULER
5333268DBMS_STATS.GATHER_INDEX_STATS can be slow
5376783DBMS_SPACE.OBJECT_GROWTH_TREND can perform excessive IO
5645718ORA-1476 gathering statistics with DBMS_STATS
5672041Wrong information returned by DBMS_METADATA
5685189Self deadlock on dc_objects after DBMS_SPACE.UNUSED_SPACE errors
5709414DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO call is very expensive
5842686Poor plan due to bad average column length for tables with LONG RAW
5910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
5913871FGA records are written for recursive SQL under DBMS_STATS
5985257Wrong results from UTL_I18N.TRANSLITERATE using 'hwkatakana_fwkatakana'
6005996DBMS_METADATA.GET_DDL generates incorrect DDL with UNUSED columns
6017760DBMS_METADATA.GET_DDL does not show changed datafile attributes
6019818ORA-1422 from DBMS_STATS auto granularity
6077514DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache
6140309OERI[ktssupd_seg_2] from DBMS_SPACE_ADMIN.TABLESPACE_FIX_SEGMENT_EXTBLKS

PL/SQL External Procedures (EXTPROC)
5120476No blank padding with multibyte charset if no character set conversion
5130238ORA-28583 in external procedure
6397073Cannot open SYSDBA connection in EXTPROC callout

Parallel Query (PQO)
5383936+Wrong results from Parallel Query with OUTER join and HASH join
3569503PQ may signal a false ORA-8103 under load
4226736Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
4336528PQ may be slower than expected (timeouts on "PX Deq: Signal ACK")
4367986Bind peeked parallel cursors do not share
4407269Wrong result with nested loop parallel query with ROWNUM pushdown
4532105pqsnap does not report parallelism for alter table modify lob rebuild freepools
4581220OERI:kzaSqlTxtLob1 with fine grained auditing and parallel query
4587572ORA-12801/ORA-60 possible from parallel DML with grouping sets
4644351OERI[15819] / wrong results from parallel select
4708389Nested loop join costing ignores parallelism of index used to probe in right side
4753238OERI[kxfpgetsumpms] from PQ
4755448Dump [kxfxgf] on parallel slave processes when using PQ trace
5023410QC can wait on "PX Deq: Join ACK" when slave is available
5024703PARALLEL on Spatial index is ignored
5030215Excessive waits on PX Deq Signal ACK when RAC enabled
5045992OERI[kxspoac : EXL 1] from PQ with a numeric bind
5097836Wrong results / OERI:15818 from parallel query with range TQ
5113934PQ slave dump in qerixGetKey() when using bitmap index access
5161523Wrong results / slow Parallel query due to data skew on multi-key table queues
5179313INSERT /*append parallel*/ can corrupt an index
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5223587OERI[4400] from distributed PDML with DDL
5228711ORA-604 trace from PQ slaves with FGA policy
5254759ORA-12801/ORA-1008 occurs on a parallel query with bind variables
5258521OERI[kkpapDimToLevel1] from parallel query with partitioned tables
5370626Wrong results (more rows) on a parallel query over one partition with anti/semi join NL.
5409593Parallel insert as select into partitioned table can dump
5455093Wrong results from PQ with hash distribution with fixed CHAR join keys
5488790Wrong results from Parallel Query
5566580OERI:15817 using parallel query with a large number of columns
5571916wrong (duplicate) values with parallel and STAR (missing "PX block iterator")
5586632Dump (qkaGranuleIteratorTraverse) on query on partitioned tables
5611623Parallel query slave dump (kkpapitsize)
5621677Logical corruption with PARALLEL update
5645771No pruning for Nested Loops Join on a range-list partitioned table in parallel
5673934ORA-12801 / OERI 15810 during parallel DML
5731952MERGE statement does not insert rows if source is a (inline) view with parallel
5736850SGA corruption / crash from PQO bloom filter
5759075Wrong results from PQ with HASH on ANSI CHAR join
5872835Multiple trigger execution from SERIAL insert as Parallel select
5875941PQ slave may run under wrong consumer group
5903293Wrong Results for Parallel Query using Group By or Distinct or has correlation
5910422SESSIONS_PER_USER resource limit works inconsistently for PQ processes
5947231Wrong results from parallel STAR query (with temp_disable)
5981212Wrong results (SORT ORDER BY STOPKEY pushed below a FILTER) in PQ
6057203Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update
6158287Wrong results from PQO with EXISTS subquery
6193398Wrong results with parallel query with temporary tables inside views
6241497Resource manager with PQ enabled does not use parallelism
6274465DML / queries run serially instead of parallel when there is concurrent DDL

Partitioned Tables
3748430i_*part$, i_*part_obj$ should be created as unique indexes
4444536Unnecessary sorting when access made through a global index
4580190Bulk insert to partitioned table can insert constraint violating rows
4583442ORA-22877 during move hash partition with LOB
4652100Poor plan with bind peeking for SQL against LIST partitioned tables
4668012Wrong results from IS_ALTER_COLUMN / IS_DROP_COLUMN for partition operations
4697632OERI[atbbjie2] from exchange partition with bitmap join indexes
4904223ALTER TABLE EXCHANGE PARTITION may dump / OERI
4905112CREATE OUTLINE on DML using an indexed partitioned table may dump (kauxalo)
4959915ORA-39083 / ORA-1647 during TTS import of a range-list partition table
5022188Direct SQLLOAD of partitioned object table of non final types fails
5034323Dictionary corruption when adding a subpartition to a table with a key compressed local index
5063279OERI[kdibllockrange:not validated] updating a partitioned bitmap index
5099909Partition not eliminated when joined to non mergeable view
5136863OERI from join between partitioned table and domain index
5139572OERI[qkauix2] on drop partition with parallelism
5213452Fast refresh fails with ORA-936 after truncation of default LIST partition
5220356Partition pruning predicates not cost pushed into UNION ALL views
5220562ORA-4030 (sort subheap,sort key) on insert a partitioned table with concurrent DDL
5225836DROP TYPE .. VALIDATE dumps for large partitioned table
5226383Dump (kkpapDiGetRange) from subquery pruning with composite partitions
5245038Wrong results with query against a list partitioned table with null partition key
5262017Query on partitioned table with bitmap index gives OERI[qernsRowP]
5331374OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
5370626Wrong results (more rows) on a parallel query over one partition with anti/semi join NL.
5397953Dump [kkpapItgetAll] accessing partitioned table using multi column INLIST
5409593Parallel insert as select into partitioned table can dump
5411244ORA-4022 raised while rebuilding index partitions concurrently
5472523Non violated deferred CHECK constraint fails (ORA-2290) at COMMIT
5479902Dump qertbStart running query on partitioned table
5500044Waits on 'cursor: pin X' / 'kksfbc child completion' or ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5524408Wrong result when query has 256+ bind variables on partitioning column
5556025Wrong Results from partition pruning and ORs
5556152Dropping a partitioned can be slow (Waits on 'dfs lock handle' for CI[1][2])
5556174Dropping a partitioned table slow (waits for 'gc current grant busy')
5566439Dropping a partitioned table is slow ('enq: RO - fast object reuse' waits)
5576013Wrong results (no rows) with partition pruning [PARTITION LIST ALL (LAST)]
5586632Dump (qkaGranuleIteratorTraverse) on query on partitioned tables
5604940Wrong results from a join and extended partition naming
5611623Parallel query slave dump (kkpapitsize)
5618049"mvobj part des" leaked memory after partition DDL (ORA-4031)
5630149ORA-22877 from partition / subpartition MOVE of HASH partition
5632050OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
5649326OERI[kksfbc-reparse-infinite-loop] can occur after DDL on partitioned table
5650372Wrong results / OERI[kkpapdrmfkk1] from predicate elimination on partitioned table
5652906Spatial DML fails if there is concurrent partition DDL
5677420ORA-20000 from Text query against partitioned table
5680970ORA-39001 when attempting to export partition defined as an object type
5690241Dump / wrong results from OR predicate on partition columns
5718007Spin (in qcopxla / qcopx0la) with OR predicates on PARTITION key columns
5724215No query rewrite if materialized view is partitioned
5724540False ORA-1 from subquery partition pruning
5747782Update of a partition table with UNUSED columns dumps [kdddcp or kdtInsRow]
5754362Plans can change after deleting statistics on a partitioned table
5763245Parse may spin in kkpapRTPRuningSetup
5882954Long parse time for query against tables with many partitions
5932060Enh: Add support for direct SQL on partitioned table/index
5939115ora-600 [kghstack_underflow_internal_1][pcols in kkpapdaextsqueryslvl]
5941355"Split partition" does not move LOB to correct tablespace
5961454ORA-29861 on DML with concurrent partition maintenance on different partition
5984440Dump [prsatb] from ALTER TABLE .. MODIFY SUBPARTITION
5996430Reading extent maps for unanalyzed partitions can be expensive
6025805ORA-14403 raised when executing select for update
6041084Spin during parse of query with INLIST against list partition key
6059327ORA-39083 / ORA-1647 during TTS import of subpartioned table
6123567Dump [kkosbn] optimizing query on partitioned table
6329316Wrong number of rows inserted by ARRAY insert into partitioned table with concurrent DDL
6435544Split partition can be slow
6776107TRUNCATE of highly partitioned table can be slow

Performance Affected (General)
5500535PHP-IA: Async IO limit too low for Oracle background processes
5705795P*Many child cursors possible for SQL using BINDS. This bug is alerted in Note:403616.1
5079978High US enqueue contention in RAC
5087592"log file sync" waits from read only commits
5173642Data not read from cache on second execution with NUMA optimization enabled
5518811Long latencies (several seconds) on BOC acks when one instance is idle
5751672"In memory undo latch" contention from kturimugur
5896963High LGWR CPU and longer "log file sync" with fix for bug 5065930
5964485High waits in RAC due to LCK0 delay receiving ASTs
6319685LGWR posts do not scale on some platforms
6450342Process uses too many async IO descriptors
6528336Automatic SGA may repeatedly shrink / grow the shared pool

Performance Monitoring
5052029PHPUX-PA: "ksugetosstat failed" / no rows from V$OSSTAT
1798853sppurge.sql does not run in batch mode
4493741Cannot see SQL_TEXT for procedure calls from EXECUTE IMMEDIATE
4572043DML monitoring is incorrect for MERGE / MTI
4969005Dump [kglLockIterator] querying V$ views
5010879V$SESSION slow and does not show any BLOCKING_SESSION column data
5087155DBA_DATA_FILES and V$DATAFILE views do not show all files
5452234V$LIBRARYCACHE "gets" accounted wrong
5470034ORA-1436 from TKPROF EXPLAIN of query using a WITH clause
5485914Mutex self deadlock on explain / trace of remote mapped SQL
5518550Prefetch does not occur if event 10046 is set
5545735Wrong values for V$SYSSTAT "open cursors current"
5552515Incorrect V$SGASTAT information for "ktcmvcb"
5649377V$GCSPFMASTER_INFO.REMASTER_CNT is never updated
5658143DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE cannot set trace
5692368Poor performance of queries against GV$ / V$ views on library cache / shared cursors
5917836V$LOCK does not show locks for attached XA sessions
5918642Heavy latch contention with DB_CACHE_ADVICE on
5928612V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs
6075099ORA-1476 from spreport (statspack)
6356566Memory leak / high CPU selecting from V$SQL_PLAN (affects statspack)

Performance Of Certain Operations Affected
4215910DBMS_STATS may use a 100% row sample size when not expected
4725385DBMS_STATS on partitioned IOT with additional indexes can be slow
4736971Delayed XA transaction recovery
4920266RMAN backup / restore of ARCHIVELOG can be slow
5057695SHUTDOWN IMMEDIATE can be slow
5064356RMAN backup to NFS slow due to "noac" requirement / ORA-27054 if not set
5071931Datapump import with remap tablespace and schema is very slow
5093060Streams unnecessary flow control at apply site
5116414Cleanup of non-existence objects by SMON takes a long time
5219484RMAN catalog resyncs can be very slow
5292551IMPDP slow when importing a table with initialized column of type varray
5327658Dataguard logical standby can be slow
5333268DBMS_STATS.GATHER_INDEX_STATS can be slow
5354469Poor performance of remote fetch with high fetch counts
5364613Performance of XSL transform extremely slow
5370578Capture process slow on startup on 'control file sequential read'
5401776Poor performance using DBMS_XMLDOM
5455880Excessive recursive query on TS$ when using a "tablespace group" as temporary tablespace
5504961ORA-2292 slow to be signalled with many child rows
5510918Log miner slow mining direct load redo
5521682RMAN DUPLICATE with SKIP can be slow
5523619DBMS_LOGSTDBY.INSTANIATE_TABLE can be slow
5530583ASSM managed INDEX updates can be slow compared to non-ASSM
5556152Dropping a partitioned can be slow (Waits on 'dfs lock handle' for CI[1][2])
5556174Dropping a partitioned table slow (waits for 'gc current grant busy')
5561130Performance of long running transaction using AQ degrades over time
5566439Dropping a partitioned table is slow ('enq: RO - fast object reuse' waits)
5576584Poor ASM parallel read performance
5590185Consistent export data pump job (flashback_time) has poor performance
5604120Performance problems after applying calendar deviation
5683652OCIHandleFree performance issue. PeopleTools Mandatory
5709414DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO call is very expensive
5723260Logminer slow / excess memory use processing batch inserts with LOBs
5752105ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE is slow with fix for 4430244
5764993Unnecessary "buffer busy waits" timeout during index block split
5846062DROP TABLESPACE takes a long time on very large buffer cache
5861536Slow DDL due to Tablespace lookup with large number of tablespaces
5881229AV capture is slow
5893614Full table scan very slow on ASM
5893704Occassional 1 second timeouts on "gc buffer busy" wait
5899994RMAN resync is slow when the standby becomes primary (during switchover)
5922239ALTER SYSTEM KILL SESSION IMMEDIATE pauses for 30s increments
5936294SWITCH DATABASE TO COPY / LIST COPY OF DATABASE RECOVERABLE are slow
5955732Two child cursors created when querying ku$_10_1_fhtable_view
5996430Reading extent maps for unanalyzed partitions can be expensive
5998048Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled
6017440Streams capture / CDC / apply slow mining DMLs for tables with REFRESH ON COMMIT Materialized Views
6034995RMAN slow SYNC due to too many rows in ROUT table
6037872Reconfiguration slow in active / passive with large buffer cache
6064864Archives containing DDL for not replicated objects take longer to process
6077514DBMS_STATS.GATHER_FIXED_OBJECT_STATS can be slow with large buffer cache
6080303Datapump export does not unload data until all metadata unloaded with PARALLEL > 1
6135499Wrong Streams rule for bidirectional setup from MAINTAIN_* APIs
6143688node startups cAN spend up to 2 mins in AQ partition code
6163622SQL apply degrades with larger transactions
6168063High "Flashback buf free by RVWR" waits
6376915HW enqueue contention for ASSM LOB segments
6435544Split partition can be slow
6529008Slow create tablespace / add datafile
6776107TRUNCATE of highly partitioned table can be slow

Performance Of Query/ies Affected
6455161+Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
599680Unnecessary sort for SELECT DISTINCT
4226736Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
4273361Unique index access not used with INLIST predicate
4336528PQ may be slower than expected (timeouts on "PX Deq: Signal ACK")
4444536Unnecessary sorting when access made through a global index
4483240INLIST may use suboptimal index
4513695Poor performance for SELECT with ROWNUM=1 with literal replacement
4545802Poor Outer Join Cardinality estimation with filters on outer table
4567767Execution Plan changes upon rowcache reload
4583239INSERT .. SELECT with OR chains with identical predicates slower than same SELECT
4605810Index may not be chosen to eliminate ORDER BY SORT
4619997Function based index may not be used for INLIST predicate
4652100Poor plan with bind peeking for SQL against LIST partitioned tables
4697189High CPU usage for large sorts
4708389Nested loop join costing ignores parallelism of index used to probe in right side
4752814Wrong selectivity on comparision of VARCHAR2 column with CHAR variable
4872602Sub-query is unnested even though cost is higher
4878299Bad plan from join with FIRST_ROWS_N or a ROWNUM predicate
4913460Soft parsing re-occurs for select using database link
4924149Push predicate not working when function in the filter
5010879V$SESSION slow and does not show any BLOCKING_SESSION column data
5029334Queries against DBA_EXTENTS slow for locally managed tablespace
5030215Excessive waits on PX Deq Signal ACK when RAC enabled
5040753Optimal index is not picked on simple query / Column group statistics
5061079Poor CONNECT BY plan
5065418CONNECT BY performance degrades when temp space needed on disk
5082178Bind peeking may occur when it should not
5099909Partition not eliminated when joined to non mergeable view
5103126Insert of duplicate rows with unique constraint slow
5129407Suboptimal plan for SQL with multiple OR branches
5138741High waits on 'row cache lock' when using materialized views on RAC
5147225Poor performance of parallel context query with ROWNUM predicate
5161523Wrong results / slow Parallel query due to data skew on multi-key table queues
5162867Sort operation on a table that selects encrypted column slows down
5199213Very bad plan for UNION ALL and push constant predicate / Wrong Results
5211863Poor plan for CONNECT BY
5220356Partition pruning predicates not cost pushed into UNION ALL views
5236908Primary key index not used for IOT
5240607FIRST_K_ROWS may choose inefficient NESTED LOOPS join
5258887Queries on DBA_FREE_SPACE_COALESCED Slow
5259025The fixed table x$ktfbue has no statistics
5263572Wrong cardinarity for predicates of form "col like func(:bind)"
5284303Poor plan for predicates against character columns containing numeric data
5288623CBO may not choose the best index for ORDER BY elimination
5302124Join Predicates are not push inside window functions -- superceeded fix
5364143Bind Peeking is not done upon query reload, Execution Plan changes
5385629Push predicate optimization does not occur
5387148View not merged even though the cost is lower
5396162Suboptimal plan from ANSI query with semi join
5403489Poor performance on 64-bit systems
5449488Suboptimal plan for SQL with negated predicates (BITMAP MINUS)
5468809Predicate order can affect execution plan
5482831Suboptimal plan with FIRST_ROWS_K or EXISTS subquery
5483301Cardinality of 1 when predicate value non-existent in frequency histogram
5505157Predicates are not pushed in UNION ALL views
5509293Query with subquery across DB link has poor performance
5518550Prefetch does not occur if event 10046 is set
5519856Wrong cardinality from CBO for "col LIKE function(:bind)"
5530958Larger SGAs and SQL in long running transactions can use excess CPU in ktaifm
5547058Poor plan with old_style predicate push into UNION ALL views
5547895No transitive predicates produced for user defined deterministic function
5570942Query Rewrite causes high parse time with high hits on 'latch: row cache objects' and dc_object_ids / Dump in STRLEN
5611962CBO MAX/MIN optimization may not occur
5618040FIRST_ROWS may give poor plan if index chosen to eliminate a SORT
5620485Non code based push predicate into UNION view can get poor plan
5620640Slow OPEN RESETLOGS with FLASHBACK RECOVERY AREA
5624216Wrong cardinality for UNION ALL with no WHERE clause
5634346Multi-column INLIST may not use INLIST ITERATOR
5645771No pruning for Nested Loops Join on a range-list partitioned table in parallel
5650477Poor plan possible due to lack of view merging
5674756OLS does not set selectivity of predicates causing bad execution plans
5680702Suboptimal execution path for semi / anti join
5692368Poor performance of queries against GV$ / V$ views on library cache / shared cursors
5694984Index distinct key count scaling is wrong for first_rows(k)
5705630Suboptimal plan from 'or' expansion
5741044Suboptimal execution plan as 1 row table not detected
5741121Suboptimal plan for "not equals" predicates
5742678Index range scan used to get MAX value instead of index min/max first row
5754362Plans can change after deleting statistics on a partitioned table
5766310Bad join cardinality is in the presence of histograms
5838613Suboptimal plan from STAR transformation
5842686Poor plan due to bad average column length for tables with LONG RAW
5844495Suboptimal plan with VPD and DML statement
5872956Slow or Wrong Results on CONNECT BY queries with constant predicates
5882954Long parse time for query against tables with many partitions
5884519V$SESSION is slow with fix for bug 5010879
5884780Suboptimal plan for STAR transformation
5891471Poor cardinality estimates with check constraints
5903581Wrong Results with "Connect By with Filtering"
5910187No bind peeking for implicit string bind to timestamp
5944076Suboptimal plan in FIRST_ROWS(K) mode
5949981Bad cardinality with histogram
5976822Suboptimal plan possible
6006300Push predicate does not occur
6006457Suboptimal plan from ANSI outer join
6007259CBO does not consider ORA concatenation
6011182Parsing of large query takes long time / memory leak / ORA-4030 /4031
6033480High parse time of query when using ANSI style joins
6041535Wrong results when predicate pushed into union-all branches
6042205High parse time for a query using ORDER BY
6051211Too High Join Cardinality with Histograms Present
6070954Skip scan may be used instead of a better range scan
6082745Bad Cardinality Estimation with Single Value in Frequency Histograms
6084811MERGE JOIN CARTESIAN not considered
6087237CBO may not choose best join order
6114166Pre-10g outlines may not work in later releases
6122894Poor plan from UNION / INTERSECT views with OR predicates
6134565FIRST_ROWS hint is not honored with "_sort_elimination_cost_ratio" parameter set
6151963Wrong join cardinality with histograms
6188881Index selectivity adjustment for anti/semi join causes wrong index to be chosen
6239971CBO costing can differ greatly for =< compared to <
6251917Merge join Cartesian setting optimizer_index_caching and optimizer_index_cost_adj
6274465DML / queries run serially instead of parallel when there is concurrent DDL
6328110Select COUNT() with an encrypted column is slow
6694548Suboptimal execution plan using bitmap full index scan

Physical Standby Database / Dataguard
3140249Data guard broker hangs when standby listener is down
4193047Sequences / synonyms / indexes not created in logical standby database
4230058ORA-1219 on connect to RMAN after physical standby is opened read only
4398691DG broker does not set FAL_SERVER correctly in RAC
4404952DG broker does not support cold-failover clusters
4538727Applied column is not updated in V$ARCHIVED_LOG
4663793ORA-16224 on select from ALL_OBJECTS on standby with DataGuard
4690705Repeated ORA-1041 from heartbeat ping
4767278OERI[kcrrupirfs.20] archiving redo to standby with ASM
4969780Dump (krvxdts) from RFS
5022127RMAN catalog resync fails RMAN-20098
5063635OERI[kccdagf_3] during file creation
5079641Switchover hangs attempting to recover a log file from a previous primary
5089522Memory leak in niotns in MRP process
5209867ORA-38777 is thrown by MRP when flashback through resetlogs
5238386ORA-322 possible reading standby redo log header
5327658Dataguard logical standby can be slow
5372831OERI:26599 / dumps in JVM after database has been closed for recovery / opened
5382088Fast start failover can hang on broker MIV mismatch
5387017Primary hang when physical standby "shutdown immediate"
5396680dgmgrl returns success for a failed reinstate
5399901Archived log entries can take a long time to search in Dataguard
5526409FAL gaps reported at standby for log not yet written at primary
5532046Deadlock on metadata lock during quiesce of old primary
5573544Trace files generated on DG primary by sqlplus sessions
5576816FAL gap resolution does not work with max_connection set in some scenario
5578157Instance crash with ORA-600 [1433] (RSM has all message blocks)
5743829DG Broker process dump
5746174MRP hangs with async LNS and parallel archival
5746223Old primary hangs after a FSFO and prevents automatic reinstatement
5757282Broker commands to standby can error (ORA-16613)
5759876Dump [rfm_get_chief_lock] on Broker startup
5844816Fast Start Failover (FSFO) occurs after planned primary shutdown
5844945Bystander cannot receive missing logfiles from the old branch after failover
5857949Startup may fail due to dump [rfmsoexinst] from DMON
5891280MRP0 on standby may not start (OERI:krfg_aset_1)
5893318Broker reinstate after failover fails with ORA-38777 in RAC
5894403MRP0 process fails with SIGFPE in kcrarmb
5899994RMAN resync is slow when the standby becomes primary (during switchover)
5930819RMAN ignores Streams when deleting logs if both streams and DG are implemented
5934150MRP at standby ignores entries created when database was primary
5942620Archivelog gap may not get resolved
5951587Unresolved gap after FSFO (fast start fail over)
5981084OERI[kcrrtcln.seqvio] can occur
5999200FSFO fails with ORA-16750 "failed to activate logical standby"
6029425ORA-1207 recovering datafile from standby
6035495ORA-19909 during MRP / RMAN-600 on resync
6039415ORA-355 can occur during real time apply
6082660Old primary stays up after failover
6143316Cannot rebuild DG broker config files without bouncing primary in FSFO
6311900RFS writes misleading messages to the alert log
6680806ORA-16139 from ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY
6762914ORA-326 during Managed Standby Recovery after thread disable
6768069Cannot FLASHBACK DATABASE on RAC physical standby

Pro* Precompiler
5389730PSolaris-X86: 32bit clients cannot use Native naming adapter (ORA-12154)
5674184ORA-22282 when using LOB buffering

Query Rewrite (Including Materialized Views)
5898210+Hang from concurrent MV refresh and library cache invalidation in RAC
386181ORA-12014 when creating a refresh complete / refresh force materialized view
4054238ORA-12899 with complex aggregate expressions in a materialized view
4119210OERI[kkqgSetFields.2] possible from query rewrite
4200563OERI[kkqsfcsi-1] from query rewrite
4226141Materialized view reports NOT NULL column as nullable
4380471OERI[kkqsfcsi-1] from query rewrite with an ORDER BY
4482978OERI[qkagby.noexec] on materialized view recompile
4483439ORA-904 error during Materialized View fast refresh
4485775OERI [qsmqLockTableSummarySubheap-1] selecting from materialized view with TDE enabled
4559546Cannot used exp/imp of MVIEW with XMLTYPE column
4681323Query rewrite not occurring if query references a materialized view
4740187ORA-30353 creating materializer view with SYSDATE in the refresh clause
4768022ALTER TABLE can fail with ORA-60
4864149Query rewrite with ORDER BY of grouping_id dumps in evagrp
4883635MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows
5008674OERI [kkqsfcsi-1] from query rewrite
5015547Cannot create a materialized view over a database link (ORA-942)
5073249Dump from fast refresh of MV using "WITH .. AS"
5096560Dump (selexe) when recompiling a materialized view with a UNION
5136425ORA-32337 from ON COMMIT MATERIALIZED VIEW after a direct load
5138741High waits on 'row cache lock' when using materialized views on RAC
5165904Materialized View DDL may execute when it should wait
5169684Wrong results (all rows no filtering) when rewrite enabled on a view
5182679INSERT as remote SELECT using CASE can produce wrong data
5217296ORA-32411 reported on materialized view refresh
5261145OERI[12261] from dbms_mview.explain_rewrite
5299546ORA-942 from create materialized view with join between local and remote tables
5354437ORA-1435 on create materialized view of UNION ALL from different sites
5363258Query rewrite can fail with OERI[voprvl1]
5487101Complete refresh does not preserve parallelism of indexes
5493858ORA-604 / ORA-1422 from materialized view operations
5501349Compilation errors from materialized iew with OUTER JOIN
5530043OERI [kkzg_add_ref_stmt_lst.1] can occur during materialized view refresh
5564090Rewrite does not occur for join with selection predicate connected by OR
5570942Query Rewrite causes high parse time with high hits on 'latch: row cache objects' and dc_object_ids / Dump in STRLEN
5572957Dump (under kkqssjsce) with query rewrite enabled and heavy load
5583712ORA-942 on create materialized view on remote view
5619833Dump (qerixGetKey) from query rewrite on join including functional index
5632128Materialized View refresh looses statistics on primary key
5660643OERI[kkqsfcsi-1] during query rewrite of SQL with set operator
5669051Query rewrite may dump in kkqsMMVNormalizeQBC
5724215No query rewrite if materialized view is partitioned
5845901Dump from concurrent CREATE MATERIALIZED VIEW and DDL on base tables
5850776OERI[kkqsMMVReAggRewriteExp:notoptfou] from query rewrite
5872368ORA-22160 from DBMS_ADVISOR.TUNE_MVIEW
5964193OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
6017440Streams capture / CDC / apply slow mining DMLs for tables with REFRESH ON COMMIT Materialized Views
6041713OERI[kkzdgdefq_oci - stexec] refreshing through definer rights procedure

RAC (Real Application Clusters) / OPS
6017420*OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed. This bug is alerted inNote:453309.1
5898210+Hang from concurrent MV refresh and library cache invalidation in RAC
4398691DG broker does not set FAL_SERVER correctly in RAC
4422686LMD/LMS cannot be frozen during reconfig
4441119Not enough information dumped when RAC detects a deadlock
4489948ASM hangs during a parallel mount and shutdown in RAC
4584985OERI[kclexpand_9] can occur
4605569LCK may accumulate CPU time on one instance
4634662OERI:kolaslGetLength-1 from V$SQL in RAC
4699720MMON or PMON spin in RAC
4715375OERI[kwqmtdel] in q00 process in RAC when any instance goes down
4744529OERI:kclpred_1 / crash possible in RAC
4760728ORA-38301 during DROP TABLE when already dropped from a different node
4936689Crash dump (cdmp) generation cannot be limited dynamically
4963729Global hanganalyze can leak memory / OERI[kghgethpsz1]
4966024VLM buffer leak on if an error occurs
5030215Excessive waits on PX Deq Signal ACK when RAC enabled
5064356RMAN backup to NFS slow due to "noac" requirement / ORA-27054 if not set
5079978High US enqueue contention in RAC
5118012Instance crash with OERI[kclswrite_3] with multiple DBW processes
5138741High waits on 'row cache lock' when using materialized views on RAC
5165885OERI[kclcls_8] or OERI[Kjbrchkpkeywait:Timeout] can occur in RAC
5179008Dump (kjzhablar) possible in RAC
5225596AQ propogation does not work after failover
5304233DBW endlessly writes error "kjbhistory[0xaa19.27000.."
5334733Deadlock resolution can be slow in RAC
5353526GCS reconfiguration performance improvement
5360289Startup in RAC can be slow
5361398Longer deadlock token (DI enqueue) get time with higher number of nodes
5366893CF enqueue contention during first pass redo scan
5370641Inefficient interconnecct lost packet handling
5375583LMS process dies with OERI[kclexpandlock_1]
5376770Spin in kcldle in RAC can cause a cluster hang
5379206SMON blocked waiting for CF enqueue during 1st pass recovery (for 1 second)
5388885Hang / OERI[krvxbpns01] accessing V$LOGMNR_CONTENTS from RAC
5403150ORA-603 when cannot get lock within Resource Manager "switch_time" in RAC
5415594xa_commit returns -4 (XA_NOTA) after RAC failover
5454831RAC deadlock possible on working set latches
5470095Self deadlock should provide more targeted diagnostics
5471994LCK may accumulate CPU time when SMON does Serial Transaction recovery
5485242ORA-29701 in RAC environment
5486023"GLOBAL CACHE ELEMENT DUMP" in LMS trace with FLASHBACK
5503590Logminer Adhoc can hang or error mining logs from a RAC database
5506702Dequeue delay experienced after reconfiguration
5518811Long latencies (several seconds) on BOC acks when one instance is idle
5526996OERI[kjhn_post_ha_alert0-784] can occur in RAC due to racgimon problem
5530697OERI[kjshash:!esm2] in PQ slave process in RAC querying GV$ view
5556152Dropping a partitioned can be slow (Waits on 'dfs lock handle' for CI[1][2])
5556174Dropping a partitioned table slow (waits for 'gc current grant busy')
5566439Dropping a partitioned table is slow ('enq: RO - fast object reuse' waits)
5587421LMS fails with OERI [kjmpmsg_1]
5593693Connection load balancing does not work if db_domain is set
5596032LMON may wait in network validation
5599293RAC instance termination may unexpectedly stall for several seconds than needed
5600050LMON may fails with OERI [kjbrref:pkey] during DRM
5649377V$GCSPFMASTER_INFO.REMASTER_CNT is never updated
5663447ORA-27544 using HMP protocol in RAC
5666733LOB segment does not use free space from freelist in RAC database
5681955SGA corruption in RAC (OERI [17114] / OERI [17112])
5688403'IPC Send timeout' error just after 'flush_cache' event in RAC
5690100RAC instance crash with OERI[kjbmpwrite:wip2]
5695610OERI[kxfpgsg] isolation_level = serializable in RAC
5697333ORA-25402 from TAF in RAC
5721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5730717OERI:kclchkinteg_18 / LMS crashes the instance
5744546MMON OERI [1403]
5751016AQ messages enqueued at non-owner instance not moved from WAIT to READY
5764556OERI[kctdsb_internal_03]
5843585Additional diagnostics for "ges inquiry response" RAC hangs
5844816Fast Start Failover (FSFO) occurs after planned primary shutdown
5854415RAC diagnostic enhancement for corrupt messages
5855896Reconfiguration takes a long time restarting instance in active/standby RAC
5857949Startup may fail due to dump [rfmsoexinst] from DMON
5863519Instance crash due to LMS dump (in kclcsr)
5881493CDC ordered sequence causes large performance degradation on RAC
5883112False deadlock in RAC
5884519V$SESSION is slow with fix for bug 5010879
5891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
5893318Broker reinstate after failover fails with ORA-38777 in RAC
5893704Occassional 1 second timeouts on "gc buffer busy" wait
5899033SMON dump (kfrCheckCtx) diskgroup instance recovery
5900401Instance crash by LMON due to "skgpgpstack: read() ..." error
5933838Database crash (ORA-449) after ALTER DATABASE FLASHBACK OFF in RAC
5939241Inconsistent diskgroup configuration after rejected DISK OFFLINE
5942620Archivelog gap may not get resolved
5950708'gcs resources' and 'gcs shadows' are imbalanced across shared pool subpools
5952530Spin / hang after cluster reconfiguration
5958244LMS processes running in realtime can spin
5964485High waits in RAC due to LCK0 delay receiving ASTs
5968965xa_recover on RAC may not return all prepared transactions
5973648ORA-54 during concurrent parallel direct SQLLOAD in RAC
5974572WRH$_SERVICE_STAT can grow very large in RAC
6001617LCK may accumulate CPU time / ORA-4031 possible
6005113OERI[kclrwrite_7] in DBWn process followed by instance crash in RAC
6013968Hang / OERI:504 with patch for bug 5863519 installed
6018125Instance crash during dynamic remastering or instance reconfiguration
6019084RAC hang possible when node leaves the cluster with fix for bug 5844816
6037872Reconfiguration slow in active / passive with large buffer cache
6057703OERI[kclchkblkdma_3] can occur in RAC
6075582OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
6083037Server side load balancing does not work
6114833Logminer does not signal error if log unavailable in continuous_mine
6123145Dump [ksxpunmap] in RAC
6143688node startups cAN spend up to 2 mins in AQ partition code
6144079Instance crash in RAC (OERI:2103)
6154655QMON fails to update queue table affinity for several minutes after failover
6239052LMS can crash instance with OERI[kjbrchkinteg:last]
6271689RAC instance crash possible
6310591DB hang with CKPT waiting for enquiry response in RAC
6442431A node may stop receiving connections with RAC load balancing
6496514RAC deadlock between "libary cache lock" and TX enqueue
6501007DRM sync timeout in RAC
6768069Cannot FLASHBACK DATABASE on RAC physical standby
6781496OERI[KGHLATCH_REG4] on STARTUP with >61 CPUs in RAC with fix for 5508574

RMAN (Recovery Manager)
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
4230058ORA-1219 on connect to RMAN after physical standby is opened read only
4431215"backup archivelog all delete input" from RMAN removes ASM directory
4457221Dump [under kdxcom] doing RMAN compressed backup
4538727Applied column is not updated in V$ARCHIVED_LOG
4541506RMAN OERI[1880] when MAXPIECESIZE is set
4545196Corrupt index leaf by RMAN CONVERT from cross platform transport of compress-key indexes
4659734RMAN-6900 RMAN-6901 ORA-19921 during RMAN commands
4920266RMAN backup / restore of ARCHIVELOG can be slow
5016125RMAN convert with parallelism > 1 fails (RMAN-3009 / ORA-19927)
5022127RMAN catalog resync fails RMAN-20098
5063635OERI[kccdagf_3] during file creation
5064356RMAN backup to NFS slow due to "noac" requirement / ORA-27054 if not set
5207044RMAN "backup validate check logical" fails with OERI[krbbfmx_notfound]
5219484RMAN catalog resyncs can be very slow
5247609RMAN slow performance during register database/open resetlogs
5278539ORA-23605 on create of new capture
5448714ORA-1455 on RMAN backup database for files over 4Tb in size
5521682RMAN DUPLICATE with SKIP can be slow
5620640Slow OPEN RESETLOGS with FLASHBACK RECOVERY AREA
5705762Duplicate may fail on RESTORE
5742127RMAN backup sometimes fails if datafile grows during backup
5870989RMAN restore failover gives ORA-19864 error
5899994RMAN resync is slow when the standby becomes primary (during switchover)
5902410V$RECOVERY_FILE_DEST.SPACE_RECLAIMABLE and V$BACKUP_FILES.OBSOLETE wrong for retention policy NONE
5928555OERI[krastrso_reserve] during BACKUP BACKUPSET
5930819RMAN ignores Streams when deleting logs if both streams and DG are implemented
5932029ORA-21000 when running RMAN "resync catalog"
5932181RESYNC of RMAN catalog fails with ORA-1 (on TF_U2) or RMAN-20042 after switchover
5936294SWITCH DATABASE TO COPY / LIST COPY OF DATABASE RECOVERABLE are slow
5971763RMAN-20098 during CATALOG SYNC
5977767RMAN "minimize load" with "duration" causes backup to timeout
6013213OERI[17183] selecting from X$KRBAFF
6034995RMAN slow SYNC due to too many rows in ROUT table
6035495ORA-19909 during MRP / RMAN-600 on resync
6253529RMAN duplicate/restore database fails restoring archivelog ORA-19636
6451722RSR table in RMAN catalog database never gets cleaned

Read Only Tablespace/s
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
5693140OERI[kdtdelrow-2] from array insert with concurrent ALTER TABLESPACE READ ONLY
5695131HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment

Recovery
6128197*OERI[kcrfr_resize2] / cannot recover database. This bug is alerted in Note:453259.1
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
4577403OERI [kcbr_pending_3] during parallel recovery
4736971Delayed XA transaction recovery
4899479Undo/redo corruption if distributed transactions used
5387683ORA-27103 / ORA-27129 during media recovery
6010833Recovery following flashback does not utilize changes in online redo log
6029425ORA-1207 recovering datafile from standby
6251003Reduce maximum reads that can be issued by a recovery slave
6267094OERI[kghstack_underflow_internal_1] recovering logical standby

Recycle Bin
5083393DBA_FREE_SPACE FILE_ID / REL_FNO may be wrong
6113520Cannot add table into single table cluster (ORA-25136)

Regular Expressions
5194354DUMP[kghalp] when executing query with index using REGEXP_SUBSTR
5682195Dump (lstmclo) evaluating regular expression in case insensitive mode

Replication
5604698Deadlock between 'library cache lock' and 'library cache pin' using replication

Resource Manager
4886649OERI[kgskthrexit3] possible from resource manager
5403150ORA-603 when cannot get lock within Resource Manager "switch_time" in RAC
5910422SESSIONS_PER_USER resource limit works inconsistently for PQ processes
6040079DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP does not work
6195283OERI[1100] / crash using Resource Manager
6241497Resource manager with PQ enabled does not use parallelism
6816727Resource manager does not handle errors correctly

Row Level Security / FGA
4581220OERI:kzaSqlTxtLob1 with fine grained auditing and parallel query
5084679OERI from EXPLAIN_REWRITE CLOB interface with VPD
5084757OERI when executing explain_plan with VPD
5228711ORA-604 trace from PQ slaves with FGA policy
5387478ORA-28132 for user with EXEMPT ACCESS POLICY privilege
5844495Suboptimal plan with VPD and DML statement
5860927FGA records are not written for view on remote table
5913871FGA records are written for recursive SQL under DBMS_STATS
5938452VPD does not work when a CURSOR expression is used against a synonym
5998048Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled

SQL*Loader
4766696Loader LDR-297 / ORA-1756 from SQL / expression ending with a single quote
5022188Direct SQLLOAD of partitioned object table of non final types fails
5104257SQLLoader truncates nested table columns
5228136ORA-26065 from SQLLDR direct path load of objects containing a LOB and constraints
5579610SQLLoaded message and error return code for SKIP INDEX MAINTENANCE
5651245ORA-1801 from SQL Loader instead of the elapsed time of the load message
5676948OERI [qxxmslSelectLocator_10] from SQL*Loader
5716353ORA-12899 from SQL Loader for valid data
5873852sqlldr inserts character data longer than the column length (CHAR length semantics)
5944227SQLloader direct path load into IOT can dump [kdblldrp]
5953355OERI[klaprs_30] / OERI[klaprs_10] during SQLLOADER direct path load
5973648ORA-54 during concurrent parallel direct SQLLOAD in RAC

Security ( Authentication / Privileges / Auditing )
4069679USERENV of SESSIONID returns 0 when used in a logon TRIGGER WHEN clause
4254770OERI:kzaSqlBindLob1 can occur with AUDIT_TRAIL = DB_EXTENDED for sql using binds
4395849ESM tool hangs connecting to directory server on SSL port
4596532Wrong results from V$XML_AUDIT_TRAIL
5021304V$PARAMETER view of AUDIT_SYSLOG_LEVEL looses all characters after a "."
5078627Audit sessionid is zero for jobs invoked by job scheduler
5081050No audit for logout action with audit_trail=xml
5162867Sort operation on a table that selects encrypted column slows down
5166745Excessive redo generation with auditing enabled
5182299Dump on grant / revoke of privileges on a TYPE
5248932XML audit filenames should be based on process id
5254198ALTER USER SYS IDENTIFIED BY VALUES does not change the password file
5376108ORA-1109 when shutting down the database with AUDIT_TRAIL=DB
5437445Incorrect username displayed from logminer adhoc query when auditing is on
5514908SYS.AUD$.CLIENTID not set for ALTER DATABASE SQL
5617311ORA-1017 cannot connect through proxy using distinguished name
5654013EUS shared server connection fails with ORA-28030
5660888OERI[kzspvcr:1] using proxy authentication with > 16 roles
5711129XML audit file does not record all bind variables correctly
5924763Rows missing from V$XML_AUDIT_TRAIL
5945463XA clients should not require execute privilege on DBMS_SYSTEM
5977486Password changes not propogated to logical standby when password expires
5998048Deadlock on COMMIT updating AUD$ / Performance degradation when FGA is enabled
6018252Insert statement with RETURNING clause fails with ORA-1031
6035889ORA-28003 from create / alter user if password verification function contains special character
6041317OERI when inserting ASCII 0x0 into CHAR/VARCHAR2 with AUDIT_TRAIL=DB_EXTENDED
6152756Audit trail string value not quoted
6322324OS audit trail should include length of attribute values

Shared Pool Affected
5705795P*Many child cursors possible for SQL using BINDS. This bug is alerted in Note:403616.1
4367986Bind peeked parallel cursors do not share
4467058IO requests can flush the pool / signal a hidden ORA-4031 error
4581334Cursors accessing remote tables may be repeatedly rebuilt and not used
4701527Cursors not shared when executing procedures over a dblink
5082178Bind peeking may occur when it should not
5386986Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
5465597SQL apply does not use bind variables while processing sequence updates
5479172ORA-4031 with multiple partially-allocated permanent chunks
5508505ORA-4031 while shared heap still has unused reserved extents
5548389Library cache allocation for 'column mapping' not using uniform sized extents
5548510_FIX_CONTROL parameter leaks memory in the shared pool
5555683Intermittent ORA-1801 when shared pool under pressure
5573238Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
5618049"mvobj part des" leaked memory after partition DDL (ORA-4031)
5704636Event 10503 does not work in 10.2.0.1 - 10.2.0.3 inclusive
5841488Extra child cursors for INSERT or MERGE SQL with fix for bug 4701527
5950708'gcs resources' and 'gcs shadows' are imbalanced across shared pool subpools
6011182Parsing of large query takes long time / memory leak / ORA-4030 /4031
6043052Leak in perm allocations with "library cache" comments (ORA-4031)
6333663Shared pool latch contention due to fragmentation of large pool

Shared Server (formerly MTS)
4739114Dump in shared server after using DBMS_XMLDOM
5324905nsprecv() can corrupt the SGA when using shared servers
5362897Non linear CPU increase when adding more shared server sessions
5447395Shared server tied to session when BFILE used
5482555Shared server does not release memory
5654013EUS shared server connection fails with ORA-28030
5711011"SocketException: socket is closed" using RMI with shared servers
6056865Intermittent OERI [kcblci_1] using shared servers
6333663Shared pool latch contention due to fragmentation of large pool
6390420TNS-12535 is logged twice to sqlnet.log at time-out with shared servers

Space Management (Locally Managed Tablespaces)
5029334Queries against DBA_EXTENTS slow for locally managed tablespace
6017760DBMS_METADATA.GET_DDL does not show changed datafile attributes

Spatial / Spatial Advisor
5652906Spatial DML fails if there is concurrent partition DDL

Spatial Data
5024703PARALLEL on Spatial index is ignored
5118210OERI[kopuigpfx1] on insert to table with sdo_geometry column with INSTEAD OF trigger
5374225SDO_FILTER query fails with OERI[kdsgrp1]
5959987Spatial aggregations fail with ORA-22813

Star Transformation
4372359Wrong results from temp table star transformation
4702830OERI[kkoljt1] when using star transformation with an ANSI outer join
5089444Dump (kkodsel) from select with a subquery with star transformation
5113934PQ slave dump in qerixGetKey() when using bitmap index access
5245494Improved control over whether star transformation is performed
5369855OERI:733 or Spin (qksopLogSame) from star transformation
5397482Wrong results from Star transformation with transitive join predicate
5512415Wrong result from star transformation with EXISTS subquery
5568316Wrong results from star transformation
5571916wrong (duplicate) values with parallel and STAR (missing "PX block iterator")
5612751OERI:qertqosSetPart4 if STAR transformation is considered and rejected
5670294Dump (qknviAllocate) using star transformation
5766450Dump [kkomprf] when attempting STAR transformation
5838613Suboptimal plan from STAR transformation
5884780Suboptimal plan for STAR transformation
5947231Wrong results from parallel STAR query (with temp_disable)
5988085Dump [kkodsel] from STAR transformation with ANSI view

Star Transformation With Temp. Tables
5381446Wrong results / dump from STAR transformation with INDEX join
5649765Dump [evaopn2] from star transformation with pushed predicate

Storage Space Usage Affected
4380450Unbalanced space usage if diskgroup has only two disks, both of different size
5093837ALTER TABLE SHRINK does not take PCTFREE into account
5387030Automatic tuning of undo_retention causes unusual extra space allocation
5442919Expired extents not being reused (ORA-30036)
5655612AQ$_PENDING_MESSAGES table can grow indefinitely
5666733LOB segment does not use free space from freelist in RAC database
5723140Temp LOB space not released after commit
5974572WRH$_SERVICE_STAT can grow very large in RAC
6147372COL_USAGE$ may keep growing in size

Streams / Logical Standby
3023540"Create index ... online" does not create index on logical standby
4061534OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
4304023Logical Standby does not support OLS properly
4369756Log apply may dump [krvsmso]
4373687SET_SCHEMA_INSTANTIATION_SCN does not error if database link unavailable
4408041Dropped foreign key column puts wrong table name in DDL redo for streams
4552393Heterogenous apply fails for updates with WHERE .. IS NULL
4556298Auto delete turned off after ACTIVATE LOGICAL STANDBY APPLY
4567042Logical standby log apply may stop with OERI[knacend910]
4627457ORA-24042 from REMOVE_STREAMS_CONFIGURATION if queue_to_queue is true
4667479ORA-16224 when using UTL_FILE / ORA-1031 using a DIRECTORY under GUARD ALL
4681763ORA-6502 from DBMS_STREAMS_ADM.maintain_schemas if schema is empty
4681796DBMS_STREAMS_ADM.maintain_schemas gives unhelpful ORA-2019 error
4682527ORA-26762 from maintain_* scripts if source db name does not include dot (.)
4684070Password changes not propogated to logical standby
4719798DBMS_STREAMS_ADM.maintain_schemas incorrectly requests supplemental log for IOT with overflow
4719848Streams DELETE_ERROR does not maintain AQ$_QTABLE_I
4730249Logical Standby or Adhoc query fails with ORA-1801 when using a different characterset
4933222Apply update of clob in multibyte charset double spaces characters
4959652Streams may get OERI [kwqbespayl518]
5024737Streams LCRs may be filtered when using distributed commit SCN
5040073ORA-27047 from DBMS_STREAMS_TABLESPACE_ADM pull tablespace
5058318Memory leak (in "koh-kghu" heap of type "kolccst obj")
5087279User DDL incorrectly skipped on logical standby
5087369logical standby potential data loss during failover
5093060Streams unnecessary flow control at apply site
5095889PGA leak during propagation in "kwqpcbk:koioalm" and "kwqpcbk:csid"
5116197Queue_to_Queue propagation cannot be configured with ADD_GLOBAL_PROPAGATION_RULES
5154689OERI[kql_tab_diana:new dep] / table dependency deleted in Streams
5183594Logical standby apply stops / OERI [kghstack_underflow_internal_2] with SKIP / UNSKIP on SYS tables
5190392Drop of table with triggers fails (ORA-16227) on logical standby
5196175OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
5197305NON_SCHEMA_DDL option skip() setting causes type bodys to be skipped
5205636Apply fails with ORA-26687 while dropping a table with referential constraints
5206649Logical standby finish apply time is highly variable on an idle system
5220845Large packages imported via data pump are not shipped to logical standby
5225733After flashback operation, new logs are not applied in logical standby
5261453Standby "apply skip failed transaction" fails
5278539ORA-23605 on create of new capture
5287523ORA-16216 starting SQL apply after rolling upgrade completion
5327658Dataguard logical standby can be slow
5350292ORA-16210 logical standby coordinator process terminates with error
5360422Datapump export from logical standby fails with ORA-39004 / ORA-39091 / ORA-44004
5370578Capture process slow on startup on 'control file sequential read'
5394563DBMS_STREAMS_ADM.maintain_simple_tts does not check if tablespace exists
5399050Logical standby does not ignore data pump external table creations (Apply stops ORA-955)
5406025DDL on primary can invalidate related objects on logical standby
5465597SQL apply does not use bind variables while processing sequence updates
5472702ORA-1403 during SQL Apply of redo from table import (redo issue)
5484652QMNC process spin in Streams
5496852Skipping grant object skips every grant
5501269Alter shrink operations are not applied in logical standby
5512840Logical standby fetch slave stops with OERI [knahfgx704]
5515703Streams table diverges after partial rollback on primary
5517195Logical standby table INSTANTIATE_TABLE may silently fail
5523619DBMS_LOGSTDBY.INSTANIATE_TABLE can be slow
5529797PGA leak / OERI KWQPCBK179 during Streams propogation
5567641Streams capture terminates on restart with OERI[krvuatla]
5567937False ORA-1 / ORA-1403 from logminer rolling back IOT redo
5575674CAPTURE_IGNORE_TRANSACTION parameter handles rolled back transaction incorrectly
5581472Streams capture excessive IO during low / idle redo generation
5584105ORA-1 against I_STREAMS_APPLY_SPILL_TXN in Streams apply
5584790PURGE_SESSION not deleting archive logs that are no longer needed
5588615Single source streams with DML handler duplicates CLOB column value
5593617Job scheduler cannot be used on logical standby (ORA-16224)
5602452Capture gets stuck in 'dictionary initialization' after recovery
5623403ORA-26773 invalid data type for "malformed redo" in Streams Capture
5640593Streams OERI:kwqbmcrcpts101 while spilling messages
5653824DBMS_LOGSTDBY.build may use wrong logs
5677680Starting SQL apply fails with ORA-1426
5685296Logical apply stops with PLS-103 due to NLS_NUMERIC_CHARACTERS setting
5685645Logminer does not support IOT with OVERFLOW if table has been altered
5715079ORA-1281 when applying a Patch Set on a logical standby
5723260Logminer slow / excess memory use processing batch inserts with LOBs
5744428dbms_logmnr_d.build may get a downstream build failure
5769961Excessive trace from DML errors on logical standby
5770059DBA_CAPTURE . required_checkpoint_scn not moving forward
5837643Ignored transactions not excluded from oldest_scn computation on restart
5860221Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
5865842DBA_REGISTERED_ARCHIVED_LOG.DICTIONARY_END contains extra space for 'NO' value
5867943Capture aborts with OERI[knlcloop-200] mining "ALTER TABLE SPLIT PARTITION ..."
5881229AV capture is slow
5883622Capture dump / error after restart
5886044No way to purge v$streams_transactions
5924538Logical standby apply fails with ORA-1427 for operations on IOTs
5930819RMAN ignores Streams when deleting logs if both streams and DG are implemented
5942476OERI [kcrrcomp.4] can occur in Streams
5977486Password changes not propogated to logical standby when password expires
6004936Standby apply stops after ORA-16146
6017440Streams capture / CDC / apply slow mining DMLs for tables with REFRESH ON COMMIT Materialized Views
6034040Apply aborts with OERI [knlcfpactx:any_knlso] using RENAME_SCHEMA
6043052Leak in perm allocations with "library cache" comments (ORA-4031)
6064864Archives containing DDL for not replicated objects take longer to process
6135499Wrong Streams rule for bidirectional setup from MAINTAIN_* APIs
6136494Capture process aborts with OERI [17112] / OERI [17147]
6154377REQUIRED_CHECKPOINT_SCN not moving
6163622SQL apply degrades with larger transactions
6267094OERI[kghstack_underflow_internal_1] recovering logical standby
6640950Update of LONG can cause Streams capture to spin / spill
6644215OERI[krvxradfd] during autodelete of partial log on logical standby

System Managed Undo (SMU)
5079978High US enqueue contention in RAC
5387030Automatic tuning of undo_retention causes unusual extra space allocation
5439554"buffer busy wait" timeouts with automatic undo management and in memory undo
5442919Expired extents not being reused (ORA-30036)
5512921Instance crash caused by SMON OERI[kcblus_1] / dump
5749075High Requests on dc_rollback_segments. latch / US enqueue contention
6499872ORA-01628: max # extents (32765) for rollback seg

Transparent Application Failover
5406976Dump (lxhscn) if DB calls out over NET with a FAILOVER clause
5415594xa_commit returns -4 (XA_NOTA) after RAC failover
5444539Database connections not released after database failover or recycle
5697333ORA-25402 from TAF in RAC
5758870ORA-3135 from TAF with SELECT type FAILOVER
6315913ORA-3106 for SQL using BLOBs after TAF failover

Transparent Data Encryption
4485775OERI [qsmqLockTableSummarySubheap-1] selecting from materialized view with TDE enabled
5667253Dump while selecting from encrypted table with CHAR column and subquery
5671774Memory corruption due to TDE with imported certificate
6057069Wrong results possible when the columns are encrypted
6207959DBA_UPDATABLE_COLUMNS shows view as not updatable when TDE enabled
6328110Select COUNT() with an encrypted column is slow

Transportable Tablespaces
4087161Tranport tablespace import ORA-904 for tables with XMLType columns
4125093OPEN RESETLOGS is not possible if RMAN backup omits plugged-in READ ONLY tablespaces
4545196Corrupt index leaf by RMAN CONVERT from cross platform transport of compress-key indexes
4566516Transportable tablespace does not handle domain indexes
4959915ORA-39083 / ORA-1647 during TTS import of a range-list partition table
5037851ORA-31000 from DBMS_TTS.TRANSPORT_SET_CHECK with XDB
5936058Corrupt metadata from tablespace transport
6059327ORA-39083 / ORA-1647 during TTS import of subpartioned table
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK

Triggers
5115882+Wrong returned value from UPDATE .. RETURNING with before ROW trigger
4069679USERENV of SESSIONID returns 0 when used in a logon TRIGGER WHEN clause
4352110ORA-39125 from expdp/impdp of triggers with nulls in WHEN clause
4768022ALTER TABLE can fail with ORA-60
4893136OERI:17287 dropping / creating triggers that use the "CALL" statement
5118210OERI[kopuigpfx1] on insert to table with sdo_geometry column with INSTEAD OF trigger
5256791Trigger "UPDATING('col')" clause can return TRUE when column not updated
5350339ORA-979 using TIMESTAMP in triggers and GROUP BY clause
5579055Dump (kxccres) updating view with instead of trigger
5616820Triggers using :OLD values of TIMESTAMP columns see :NEW values instead
5676637OERI[17114] using EMPTY_CLOB() in a trigger
5685411Updating columns to NULL in a trigger may have no effect
5872835Multiple trigger execution from SERIAL insert as Parallel select

Truncate
6455161+Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild
4344935OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
5213452Fast refresh fails with ORA-936 after truncation of default LIST partition
6086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6776107TRUNCATE of highly partitioned table can be slow

Unstable Execution Plan
4567767Execution Plan changes upon rowcache reload
5364143Bind Peeking is not done upon query reload, Execution Plan changes

Wallet Manager
5551624ORA-28353 creating a wallet

Workload repository / reporting
4632024MMON reports spurious high version count SQL
4748642ORA-6502 error encountered in top blocking sessions in ASH
5088977MMON dump (in keltfill) intermittently
5239294ORA-1403 failure in AUTO_SPACE_ADVISOR_JOB_PROC
5245039Tablespace space used % alert not triggered when used space is > 320gb
5376783DBMS_SPACE.OBJECT_GROWTH_TREND can perform excessive IO
5486074OERI [keltnfy-ldminit] when DNS is not available
5974572WRH$_SERVICE_STAT can grow very large in RAC

Wrong Results
6646613*IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
4925103+Wrong results using MAX() on column containing NULLs
5115882+Wrong returned value from UPDATE .. RETURNING with before ROW trigger
5146740+Wrong results with bind variables/CURSOR_SHARING
5383936+Wrong results from Parallel Query with OUTER join and HASH join
5686711+Wrong cursor may be executed if schemas have objects with same names
6044413+Intermittent wrong results when table prefetch occurs
5010657PHPUX-Itanium: No rows from V$OSSTAT / incorrect CPU_COUNT
4319031Wrong header_status in V$ASM_DISK when disk is offline
4346448NLS_COMP = ANSI gives wrong results comparing CHAR with VARCHAR2
4372359Wrong results from temp table star transformation
4407269Wrong result with nested loop parallel query with ROWNUM pushdown
4424952extractValue returns wrong result
4459574FLASHBACK_TRANSACTION_QUERY shows multi row INSERT as SELECT as only one row
4490782Unparse operations give wrong date for BC TO_DATE literals
4538727Applied column is not updated in V$ARCHIVED_LOG
4552696DBMS_Scheduler is suppressing no_data_found exceptions in jobs
4596532Wrong results from V$XML_AUDIT_TRAIL
4644351OERI[15819] / wrong results from parallel select
4668012Wrong results from IS_ALTER_COLUMN / IS_DROP_COLUMN for partition operations
4692059Wrong results from SQL with subquery with multi-column correlation predicate
4694156TIMESTAMP column in DBA_TAB_MODIFICATIONS not updated
4704779Incorrect histogram type shown (frequency/height-balanced)
4725022Wrong results from a function call using a CONCAT of a NULL
4743582Intermittent wrong results from TABLE SCAN with COL1 relop COL2 predicate
4770292Wrong results from CONNECT BY query on IOT with secondary index/es
4865959Wrong results / exception from Java Stored Procedure accessing data over DBLINK
4874013INTEGER may show SCALE as -127
4883635MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows
4892567DBMS_XMLPARSER does not validate XML document against a DTD correctly
4898580DBMS_METADATA.GET_DEPENDENT_DDL does not show comments on materialized view columns correctly
4901291Wrong results with left outer joins on view with a function
4904743ALTER SESSION SET NLS% does not work if OCI_PARSE_ONLY used
4905638Wrong results / errors in session that opens the database for certain NCHAR characterset
4916783Wrong results/Missing predicates from query using INLIST w/FUNCTION BASED index
5010879V$SESSION slow and does not show any BLOCKING_SESSION column data
5017909V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
5021304V$PARAMETER view of AUDIT_SYSLOG_LEVEL looses all characters after a "."
5035058V$LOGMNR_CONTENTS.MineValue may not show an UNDO value
5040555DBMS_SPACE.OBJECT_GROWTH_TREND output is not correct
5049938Wrong result order from query with ORDER BY of COUNT(col)
5083393DBA_FREE_SPACE FILE_ID / REL_FNO may be wrong
5087155DBA_DATA_FILES and V$DATAFILE views do not show all files
5097836Wrong results / OERI:15818 from parallel query with range TQ
5119354OERI from CONNECT BY and correlated START WITH columns
5120476No blank padding with multibyte charset if no character set conversion
5126270Version 3 TIMEZONE check script (utltzuv2.sql)
5161523Wrong results / slow Parallel query due to data skew on multi-key table queues
5162768Wrong results using more than one OLS policy on a table
5169684Wrong results (all rows no filtering) when rewrite enabled on a view
5175364Data truncation / null data selecting NVARCHAR2 over TG4MSQL
5179313INSERT /*append parallel*/ can corrupt an index
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5182679INSERT as remote SELECT using CASE can produce wrong data
5188321wrong results (no rows) OR ORA-1445 from ANSI outer join
5190543Wrong timestamp from oracle.sql.TIMESTAMPLTZ near daylight savings transition
5197305NON_SCHEMA_DDL option skip() setting causes type bodys to be skipped
5199213Very bad plan for UNION ALL and push constant predicate / Wrong Results
5205394Corrupt XML element data converting to generalized object
5236881Wrong Results (More rows) with a CONCATENATE of ANTI joins
5245038Wrong results with query against a list partitioned table with null partition key
5252496Wrong result when using a LIKE predicate with NLS_COMP = LINGUISTIC
5258521OERI[kkpapDimToLevel1] from parallel query with partitioned tables
5259741DBMS_XMLGEN.CONVERT trims output for multibyte database
5286826Wrong results from complex view merge with windowing
5298826Wrong results from SQL using DETERMINISTIC function/s
5299237Inconsistent results from v$logmnr_contents with committed_data_only
5302124Join Predicates are not push inside window functions -- superceeded fix
5327132Wrong results from colocated OUTER join over DBLINK with TO_DATE
5345571Wrong results with UNION and a subquery
5348010Wrong results using ROWNUM < # and optimizer uses bitmap conversion count
5350076Anydata and timestamp can loose precision
5367514Wrong number of exceptions returned executing a bulk insert
5370626Wrong results (more rows) on a parallel query over one partition with anti/semi join NL.
5376015Wrong results with hash semijoin when build rows do not fit in memory/Spill to disk
5377092Wrong results from FAST FULL SCAN of an index on a CASE expression
5381446Wrong results / dump from STAR transformation with INDEX join
5395270OERI[qctcte1] / dump / wrong results from view merging
5397482Wrong results from Star transformation with transitive join predicate
5401876wrong results when optimizer uses "BITMAP CONVERSION" over "BITMAP OR"
5403791Wrong results for query with ROWNUM and ORDER BY
5403855Wrong result with sql_trace = true when prefetch is active
5415881Wrong sort order returned by query
5417281oracle.sql.DATE looses a year when constructed from BC Timestamp
5437445Incorrect username displayed from logminer adhoc query when auditing is on
5452234V$LIBRARYCACHE "gets" accounted wrong
5455093Wrong results from PQ with hash distribution with fixed CHAR join keys
5462687CHECK constraint can cause wrong results
5468695TIMESTAMPTZ wrong near daylight switch
5475037Feature usage statistics incorrectly show 'Advanced Security' to be used.
5481520Wrong results with ROWNUM and bind peeking with fix for bug 4513695
5481650GV$SESSION.blocking_session has incorrect value
5487686Wrong results from CONNECT BY query
5488790Wrong results from Parallel Query
5490501Wrong Results with COALESCE or NVL2 on aggregations inside subqueries
5494008Wrong results from LIKE in multibyte when NLS_COMP=linguistic and NLS_SORT=binary_ci(ai)
5497168Wrong results isolation_level=serializable and WITH clause
5507887Wrong results for CONNECT BY using CONNECT_BY_ISLEAF
5512415Wrong result from star transformation with EXISTS subquery
5524408Wrong result when query has 256+ bind variables on partitioning column
5526851Wrong Results (missing rows) on CONNECT BY when using function-based index
5527591DBA_TABLESPACE_USAGE_METRICS USED_PERCENT/USED_SPACE may be wrong
5527727Show parameter UTL_FILE_DIR may not show the parameter value
5531784V$LOGMNR_CONTENTS CSF may be wrong
5533982Updated columns set to null show old not-null values in change table using async CDC
5545735Wrong values for V$SYSSTAT "open cursors current"
5549410Inconsistent characters read returned from OCILobRead
5550614Wrong results selecting BIGINT data from MySQL using MySQL ODBC driver
5552515Incorrect V$SGASTAT information for "ktcmvcb"
5556025Wrong Results from partition pruning and ORs
5568316Wrong results from star transformation
5569805XMLelement query using outer join returns wrong results
5571916wrong (duplicate) values with parallel and STAR (missing "PX block iterator")
5573425Wrong results from subquery unnesting with complex view merge
5574966Dump (evaopn2) or Wrong Results with views and function-based index
5576013Wrong results (no rows) with partition pruning [PARTITION LIST ALL (LAST)]
5580871AQ bytes message <= 2000 bytes incompatible between PLSQL and Java
5585187Wrong Results doing MERGE JOIN with a correlated subquery on the right side
5590163Message dequeued more than once from single consumer queue
5590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
5592012Wrong results with INLIST and UNION/UNION ALL
5600425wrong results from select on external table
5604940Wrong results from a join and extended partition naming
5608992Wrong results from filter push with OUTER join
5621677Logical corruption with PARALLEL update
5632192Wrong Results with Max/Min in subquery/view
5632264Version 4 TIMEZONE files
5638080Wrong sort order using window functions
5642214Wrong results / ORA-1427 from scalar subquery in SELECT list with complex view merging
5650372Wrong results / OERI[kkpapdrmfkk1] from predicate elimination on partitioned table
5666374FIFO does not occur when multiple listens are followed by dequeues
5672041Wrong information returned by DBMS_METADATA
5682441Wrong Results (no rows) joining views with predicates using PLSQL functions
5690241Dump / wrong results from OR predicate on partition columns
5694101OCI piecewise operation returns wrong piece length for long / long varchar data
5698193Wrong Results when using TRIM on check constraints or function based indexes.
5708633Wrong results / dump [ldxite] from materialized WITH clause
5708897Wrong results from ROWNUM with semi/anti join
5715742XMLTransform() truncates output without error message
5725761Objects with debug privilege are not shown in the ALL_OBJECTS view
5731952MERGE statement does not insert rows if source is a (inline) view with parallel
5759075Wrong results from PQ with HASH on ANSI CHAR join
5762846wrong results from filter push down with non-deterministic function
5763538Wrong results / dump with object type column in SQL
5763576Wrong results from XMLForest()
5837795Wrong results / OERI from cost based CONNECT BY
5838153CAST operator does consider NLS_LENGTH_SEMANTICS
5840483ORA-937 / ORA-979 not occurring with subquery GROUP BY
5843316Wrong results with index join and function-based index
5847521Hierarchical (CONNECT BY) query on IOT returns wrong results
5862057Oracle JVM incorrectly returns true for "x instanceof object[]" when "x" is a class
5865842DBA_REGISTERED_ARCHIVED_LOG.DICTIONARY_END contains extra space for 'NO' value
5870781DBMS_LOB.INSTR() function does not find patterns across the 4gig boundary
5872956Slow or Wrong Results on CONNECT BY queries with constant predicates
5879627Wrong results with ROWNUM restriction
5882372Wrong results from CONNECT BY
5885079Incorrect output from INTERVALDS.stringValue() for negative intervals
5888733Wrong results from V$LOGMNR_CONTENTS referencing AUDIT_SESSIONID
5889927Wrong results from view with un-correlated subqueries
5893396Wrong results possible due to invalid stored outline
5893779Intermittent wrong results when table prefetch occurs - superceded fix
5902410V$RECOVERY_FILE_DEST.SPACE_RECLAIMABLE and V$BACKUP_FILES.OBSOLETE wrong for retention policy NONE
5903293Wrong Results for Parallel Query using Group By or Distinct or has correlation
5903581Wrong Results with "Connect By with Filtering"
5906937Wrong result using ROW_NUMBER in SQL using a WITH query block
5921386Wrong result doing view merging and outer join
5923491ALL_UPDATABLE_COLUMNS shows view is not updatable when it is
5924763Rows missing from V$XML_AUDIT_TRAIL
5932203Wrong result when comparing same column with values of different datatypes
5938452VPD does not work when a CURSOR expression is used against a synonym
5947231Wrong results from parallel STAR query (with temp_disable)
5961654ldiinterfromtz returns wrong offset during DST fallback
5970288OCCI isNull() on object column always returns false even when object is null
5981212Wrong results (SORT ORDER BY STOPKEY pushed below a FILTER) in PQ
5985257Wrong results from UTL_I18N.TRANSLITERATE using 'hwkatakana_fwkatakana'
5985594Wrong (empty) result set for queries using "OR"
6005762SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') returns NULL
6005996DBMS_METADATA.GET_DDL generates incorrect DDL with UNUSED columns
6016075Wrong Results for query with correlated subquery and predicate pull up
6017760DBMS_METADATA.GET_DDL does not show changed datafile attributes
6027610Wrong results from CONNECT BY query
6029071Wrong results from distributed SQL with OUTER joins
6038461Wrong results from SQL with UNION and a fast DUAL subquery
6041535Wrong results when predicate pushed into union-all branches
6050882Wrong results from ANSI outer join with fix for bug 4967068 or 5864217
6051782Wrong results using GROUPING SETS with ORDER BY and DISTINCT
6057069Wrong results possible when the columns are encrypted
6070548Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT
6084485Wrong result when aggregate column selected twice with ORDER BY
6084512DBA_UNDO_EXTENTS shows dropped undo segments
6085625Wrong child cursor may be executed which has mismatching bind information
6088227Wrong Results with with count() and IS NULL
6114833Logminer does not signal error if log unavailable in continuous_mine
6119884Wrong results with query with OR operator with OR expansion
6156762OCCI fractional seconds portion can be wrong
6158287Wrong results from PQO with EXISTS subquery
6193398Wrong results with parallel query with temporary tables inside views
6207959DBA_UPDATABLE_COLUMNS shows view as not updatable when TDE enabled
6266023V$ARCHIVE_DEST_STATUS reports false "destination has a gap" for disabled redo thread
6314151'1/1/1988 0:0:0' in COMMIT_TIMESTAMP$ column when CDC apply error is re-executed
6316993Wrong results / dump (qernsRowP) from join back elimination of 1 row table
6333108Wrong results (duplicates) from CONNECT BY query
6400795Wrong results from view merging
6450021Wrong results from X$ / V$ / DBA_* views for file numbers > 32k
6653652Wrong results from simple view merging
6686885WRONG RESULTS (missing rows) USING NATIVE FULL OUTER JOIN

Wrong/Bad Shared Cursor
5686711+Wrong cursor may be executed if schemas have objects with same names
5555683Intermittent ORA-1801 when shared pool under pressure
6085625Wrong child cursor may be executed which has mismatching bind information

XA / Distributed Transactions
4308334OERI[12314] during XA commit/rollback/prepare while attached to different transaction
4377584OERI[18201] from concurrent xaorollback and xaoprepare
4736971Delayed XA transaction recovery
4899479Undo/redo corruption if distributed transactions used
5378806xa_rollback cannot interrupt a long running SELECT branch
5384248OERI[k2gtelock: !k2gtca] / instance crash cleaning up distributed transaction
5415594xa_commit returns -4 (XA_NOTA) after RAC failover
5917836V$LOCK does not show locks for attached XA sessions
5945463XA clients should not require execute privilege on DBMS_SYSTEM
5968965xa_recover on RAC may not return all prepared transactions
5983683OERI[17182] creating / deleting XDB resource in XA environment

XDB
3370858Import fails (ORA-932) using FROMUSER / TOUSER for schema based xmltype
4277241ORA-22813 for large xmlagg() with GROUP BY
4377659Schema validation with number of nodes > 64k results in LSX-201
4387531Spin running XPATH on SB table with IOT structured varrays
4424952extractValue returns wrong result
4563159SYS_XMLAGG fails with ORA-24347 if null value passed
4584641Cursor leak using DBMS_XMLGEN with a PLSQL function returning sys_refcursor
4739114Dump in shared server after using DBMS_XMLDOM
4877048Dump (qmtModelGetMCA) on registering XML schemas using group
4887880OERI:[qkactasrowvector_13] from CTAS with XML related operations
4892567DBMS_XMLPARSER does not validate XML document against a DTD correctly
4931883FTP PUT in XDB can be slow
4959294DBMS_XMLSTORE does not follow CHAR based semantics
5018532Insert / validate of valid document may OERI / dump
5037851ORA-31000 from DBMS_TTS.TRANSPORT_SET_CHECK with XDB
5161782Dump installing XDB
5205394Corrupt XML element data converting to generalized object
5210484ORA-21700 with xsd:restriction where parent has sqlinline="false"
5211545Select with EXTRACT dumps in lxXmlGEntEsc2
5221989ORA-30937 with chameleon schemas
5252061PGA memory corruption / OERI[17456] creating a domain index
5253806PLSQL DBMS_XMLDOM transformations may produce wrong non XML output
5259741DBMS_XMLGEN.CONVERT trims output for multibyte database
5263631EXTRACT query fails with ORA-31196 for XML schema using substitution groups
5326319XMLType transform fails with spaces in parameters ORA-31011
5330677XMLDB reports a validation error by mistake
5332686Parsing XMLType (Opaque type) in Java fails
5347371Dump [kkoojt] on a query against XML / XDB
5349808IMP-60 hit when importing a table with an XML schema based XMLType column
5364613Performance of XSL transform extremely slow
5377973Register schema fails with ORA-4031
5382590ALTER TABLE MOVE does not move all underlying objects of XDB table
5385791ORA-932 with enumeration and complextype / simplecontent
5389917ORA-30992 / ORA-1830 from XDB with DATE with TIMEZONE info
5391686value().getnamespace() returns null
5392772Corrupt XML output from SQLX
5399932getrootelement() returns null even for valid single element node
5401776Poor performance using DBMS_XMLDOM
5408970Memory leak using XMLType() constructor on ADT in a loop
5437241Dump accessing XML DOM in PLSQL
5437716Wrong results with nested XML table operators
5471712ORA-31067 from updateXML() with unescaped entities
5477912Memory leak parsing DTD
5491132xslprocessor.newStylesheet failS when XSL Document includes OS files
5497611OERI[qctVCO:csform] from Xquery using XMLType constructor
5512159doctype is appended to the XML when parsed against a DTD
5555833Dump [kokees2c] from Xquery
5563913EXTRACT is producing 'xsi:type="simple"' attribute after fix to 4713210
5569805XMLelement query using outer join returns wrong results
5583634OERI [17147] / dump after inserting a text node of size 64000
5586842ORA-4045 / ORA-22973 from DBMS_METADATA with XML schemas
5655708LPX-1 parsing a file using DTD loaded via parsedtdclob and setdoctype
5667235ProcessXSL does not indicate if style sheet output is XML or not
5668025XMLParser.Parse() can leak memory
5669015Invalid ORA-29875 after creating number index on XML index
5687843PGA memory leak inserting XMLDocument with many out of line elements
5690593Datafile corrupt for ASM datafiles copied using xdb/ftp
5715742XMLTransform() truncates output without error message
5716932Memory corruption / OERI [17147] / dump selecting from PATH_VIEW
5734901JDBC Thin XMLType.getDOM fails with SQLException
5735091Memory corruption when using XMLAGG
5736250Dump [kpotcpop] using XDB
5763576Wrong results from XMLForest()
5766196ORA-942 on schema level import of table with foreign key and XMLSchema
5856727Query on schemaValidate XMLtype table fails with OCI-30937
5864763ORA-30951 inserting valid XML document
5865159Dump (in lxxmlgentesc2) accessing text node with size close to 64k
5872480LPX-224 can occur in XDB
5892080updateXML corrupts repeating elements
5920672DBMS_XMLDOM ignores xml:space="preserve"
5947653XE to EE upgrade fails in XDBx
5983683OERI[17182] creating / deleting XDB resource in XA environment
6051977DBMS_XMLGEN fails with OERI[qmxtcCtxConvertString] converting unescaped ampersand
6079393ORA-918 on select from xmltype schema based table with 2 xmltable() used
6154575XmlTransform does not have an option for 'pretty printing'

XML
4087161Tranport tablespace import ORA-904 for tables with XMLType columns
4745691OERI[kghufree_06] from AQ propogation of XML payload

Error May Occur
5501528IORA-6545 recompiling with PLSQL_WARNINGS set
5752399P+Sol: Mandatory Patch to use Oracle with Veritas or Solstice Disk Suite on Solaris
386181ORA-12014 when creating a refresh complete / refresh force materialized view
2834295ORA-12714 declaring cursor for a function that returns a table of NVARCHAR2
3370858Import fails (ORA-932) using FROMUSER / TOUSER for schema based xmltype
3569503PQ may signal a false ORA-8103 under load
3945156ORA-979 from DBMS.GATHER_TABLE_STATS when NLS_COMP=LINGUISTIC
4038803IMP-3 / ORA-1722 when using nls_numeric_characters != '.,'
4054238ORA-12899 with complex aggregate expressions in a materialized view
4087161Tranport tablespace import ORA-904 for tables with XMLType columns
4110313ASM disk resize fails for OS devices grown after ASM instance startup
4277241ORA-22813 for large xmlagg() with GROUP BY
4311273ORA-2064 using MERGE statement over a database link
4377659Schema validation with number of nodes > 64k results in LSX-201
4387531Spin running XPATH on SB table with IOT structured varrays
4436832False ORA-979 "not a group by expression" with literal replacement
4478139ORA-28031 "maximum of 148 enabled roles" when creating queue table
4483439ORA-904 error during Materialized View fast refresh
4517481ORA-904 / ORA-20000 loading metadata with IMPDP using varying width characterset
4549673ORA-30926 / OERI:13030 during update
4559546Cannot used exp/imp of MVIEW with XMLTYPE column
4563159SYS_XMLAGG fails with ORA-24347 if null value passed
4583442ORA-22877 during move hash partition with LOB
4587117ORA-384 can occur even if there is free space in some pool/s
4587572ORA-12801/ORA-60 possible from parallel DML with grouping sets
4595736ORA-6502 during impdp due to wrong logging_level put in export dump
4597871ORA-904 from query using CUBE
4599177Allow > 255 arguments to an operator
4609147ORA-918 if PLSQL block has same package and function name
4624183ORA-1017 reported using DB links with IDENTIFIED EXTERNALLY accounts
4627457ORA-24042 from REMOVE_STREAMS_CONFIGURATION if queue_to_queue is true
4658456ORA-920 from distributed query using CASE against remote table/s
4659734RMAN-6900 RMAN-6901 ORA-19921 during RMAN commands
4663793ORA-16224 on select from ALL_OBJECTS on standby with DataGuard
4680009Insert LOB data fails with ORA-3106 or ORA-8176
4681763ORA-6502 from DBMS_STREAMS_ADM.maintain_schemas if schema is empty
4682527ORA-26762 from maintain_* scripts if source db name does not include dot (.)
4686909CONVERT function reports ORA-1482
4690705Repeated ORA-1041 from heartbeat ping
4730249Logical Standby or Adhoc query fails with ORA-1801 when using a different characterset
4736557ORA-1466 on read only transaction
4740187ORA-30353 creating materializer view with SYSDATE in the refresh clause
4760728ORA-38301 during DROP TABLE when already dropped from a different node
4766696Loader LDR-297 / ORA-1756 from SQL / expression ending with a single quote
4889807False ORA-904 from co-located join (over database link)
4904904Problems with DBMS_SCHEDULER JOB_START time (eg ORA-1877)
4905638Wrong results / errors in session that opens the database for certain NCHAR characterset
4959915ORA-39083 / ORA-1647 during TTS import of a range-list partition table
4966024VLM buffer leak on if an error occurs
4996004EXPDP fails with ORA-31642 when NLS_SORT=binary_ci and NLS_COMP=ansi
5015547Cannot create a materialized view over a database link (ORA-942)
5017909V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
5027003ORA-39068 from EXPDP if parallel > 1
5031712DBV enhanced to report NOLOGGING corrupt blocks with DBV-201 instead of DBV-200
5037851ORA-31000 from DBMS_TTS.TRANSPORT_SET_CHECK with XDB
5040073ORA-27047 from DBMS_STREAMS_TABLESPACE_ADM pull tablespace
5064356RMAN backup to NFS slow due to "noac" requirement / ORA-27054 if not set
5095815Select with CONTAINS predicate on view fails
5120780Long text for job gets EXP-85 ORA-6502 on dbms_sched_job_export
5130238ORA-28583 in external procedure
5130732Query using "WITH" clause can fail with ORA-942
5131157OCI may error reexecuting a statement against a table with an altered column type
5135951ORA-22337 on import if database schema has been evolved
5136425ORA-32337 from ON COMMIT MATERIALIZED VIEW after a direct load
5141429"skgspawn 27142" errors and defunct Oracle processes
5147006DML error logging fails with lower case identifiers
5179313INSERT /*append parallel*/ can corrupt an index
5181547Index corruption after insert-only merge /*+ append */ or PDML into table
5188321wrong results (no rows) OR ORA-1445 from ANSI outer join
5190392Drop of table with triggers fails (ORA-16227) on logical standby
5205636Apply fails with ORA-26687 while dropping a table with referential constraints
5209867ORA-38777 is thrown by MRP when flashback through resetlogs
5211984Parse errors with USE_STORED_OUTLINES
5213452Fast refresh fails with ORA-936 after truncation of default LIST partition
5217296ORA-32411 reported on materialized view refresh
5220562ORA-4030 (sort subheap,sort key) on insert a partitioned table with concurrent DDL
5221989ORA-30937 with chameleon schemas
5228136ORA-26065 from SQLLDR direct path load of objects containing a LOB and constraints
5228711ORA-604 trace from PQ slaves with FGA policy
5229137PLS-201 compiling program units referencing tables on RDB
5238386ORA-322 possible reading standby redo log header
5245451Intermittent ORA-904 referencing remote objects columns
5252389CDC apply changes lead to maximum open cursors exceeded (ORA-1000)
5254198ALTER USER SYS IDENTIFIED BY VALUES does not change the password file
5254759ORA-12801/ORA-1008 occurs on a parallel query with bind variables
5259868Text query using index in another schema fails (ORA-20000, DRG-50857)
5263631EXTRACT query fails with ORA-31196 for XML schema using substitution groups
5278539ORA-23605 on create of new capture
5287523ORA-16216 starting SQL apply after rolling upgrade completion
5299546ORA-942 from create materialized view with join between local and remote tables
5308692ORA-1426 error when running DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
5324773Constraints using LTRIM() may fail for valid data
5326319XMLType transform fails with spaces in parameters ORA-31011
5330677XMLDB reports a validation error by mistake
5349808IMP-60 hit when importing a table with an XML schema based XMLType column
5350339ORA-979 using TIMESTAMP in triggers and GROUP BY clause
5354437ORA-1435 on create materialized view of UNION ALL from different sites
5360422Datapump export from logical standby fails with ORA-39004 / ORA-39091 / ORA-44004
5368266ORA-904 using multiple TABLE() objects in the FROM clause
5370332ODCITableFetch fails with ORA-28579
5374844ABN model build fails using dataset in excess of 100,000 rows
5376108ORA-1109 when shutting down the database with AUDIT_TRAIL=DB
5386986Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
5387478ORA-28132 for user with EXEMPT ACCESS POLICY privilege
5387683ORA-27103 / ORA-27129 during media recovery
5389756False ORA-29907 error when using domain index operator
5389917ORA-30992 / ORA-1830 from XDB with DATE with TIMEZONE info
5391326ORA-942 importing functional indexes as SYS
5391505High PGA consumption for query (kxs-heap-c) from OR expansion
5400311ORA-1436 using "_old_connect_by_enabled"=true
5402151ORA-439 when importing into Standard Edition db using streams_instantiation=y
5411244ORA-4022 raised while rebuilding index partitions concurrently
5413989OCIStmtSetPieceInfo() does not work for piece sizes > 16777180
5415506ORA-4020 when dbms_aqadm.purge_queue_table and select are run
5417204ORA-19639 on RECOVER COPY OF RMAN
5442919Expired extents not being reused (ORA-30036)
5448714ORA-1455 on RMAN backup database for files over 4Tb in size
5464834ORA-4030 (kxs-heap-c,temporary memory) using EXPDP
5467520PLSQL errors accessing synonym to remote object
5470034ORA-1436 from TKPROF EXPLAIN of query using a WITH clause
5472523Non violated deferred CHECK constraint fails (ORA-2290) at COMMIT
5479172ORA-4031 with multiple partially-allocated permanent chunks
5485242ORA-29701 in RAC environment
5493858ORA-604 / ORA-1422 from materialized view operations
5494866PLS-302 'dbver_10i' importing 10g export into 9i with AQ
5497630ORA-3124 from NULL LONG bind for an UPDATE which matches no rows
5500044Waits on 'cursor: pin X' / 'kksfbc child completion' or ORA-44203 on table_x_x child from concurrent LOB append and drop partition
5502124ORA-39096 importing 10.1 EXPDP file with 10.2 data pump
5508505ORA-4031 while shared heap still has unused reserved extents
5514109OERI [kql-hash-collision] / false ORA-955
5515882ORA-1427 from EXPDP
5518651ORA-1301 from dbms_logmnr_d.build
5523578DBMS_AQADM.add_subscriber fails with ORA-1925 "maximum of x roles exceeded"
5530761ORA-1031 from EXP of domain index
5531989ALTER SYSTEM REGISTER may take a few seconds before connections allowed
5548389Library cache allocation for 'column mapping' not using uniform sized extents
5551624ORA-28353 creating a wallet
5555683Intermittent ORA-1801 when shared pool under pressure
5557660ORA-20 / process group leak from OCI Connection Pool connections
5564384ORA-6502 assigning values from SQL to PLSQL variables
5567937False ORA-1 / ORA-1403 from logminer rolling back IOT redo
5572026ORA-942 / ORA-1031 in tracefile when starting the database as SYSOPER
5573238Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
5576828ALTER PACKAGE does not always break NULL locks
5577046ADD or DROP attribute causes UNION query to fail with ORA-1790
5583712ORA-942 on create materialized view on remote view
5584105ORA-1 against I_STREAMS_APPLY_SPILL_TXN in Streams apply
5594352JMS-120 / OCI-1858 when dequeueing AQ bytes message with JDBC-OCI
5605319Cursor leak from QMON coordinator exceptions
5613040ORA-370 from DML against transported tablespace
5617311ORA-1017 cannot connect through proxy using distinguished name
5618049"mvobj part des" leaked memory after partition DDL (ORA-4031)
5623403ORA-26773 invalid data type for "malformed redo" in Streams Capture
5630149ORA-22877 from partition / subpartition MOVE of HASH partition
5632683EXPDP / IMPDP may error for DDL modified tables
5636728LOB corruption / ORA-1555 when reading LOBs after a SHRINK operation
5637976ORA-8103/ORA-1410 from concurrent INSERT / export on ASSM tables
5641873ORA-904 using a WITH clause that includes a UNION
5642214Wrong results / ORA-1427 from scalar subquery in SELECT list with complex view merging
5643527OCILobOpen/OCILobGetChunkSize do not return OCI_STILL_EXECUTING in non blocking mode
5645718ORA-1476 gathering statistics with DBMS_STATS
5648610ORA-25235 during AQ propagation
5653824DBMS_LOGSTDBY.build may use wrong logs
5654013EUS shared server connection fails with ORA-28030
5663447ORA-27544 using HMP protocol in RAC
5664206ORA-6502 during export of functional index expression over 4k
5674184ORA-22282 when using LOB buffering
5677680Starting SQL apply fails with ORA-1426
5689991ORA-8176 fetching from global temporary table with INSERTS between fetches
5693948ORA-31466 error when setting up CDC with table names using multibyte characters
5697333ORA-25402 from TAF in RAC
5698225ORA-17507 can occur using 16k block size with ODM
5699967ORA-1120 executing "drop tablespace ... including contents'.
5711011"SocketException: socket is closed" using RMI with shared servers
5713912ORA-39125 / ORA-6502 from datapump import via network
5715079ORA-1281 when applying a Patch Set on a logical standby
5716353ORA-12899 from SQL Loader for valid data
5718757ORA-31693 / ORA-6502 during datapump net import
5722178ORA-1002 in non blocking mode
5724540False ORA-1 from subquery partition pruning
5726895Code allowed to throw ORA-0 which can give misleading ORA-1 errors
5728347ORA-20000, DRG-10599 occurs during text query through synonym
5733637Select for update fails against TG4MSQL
5743325ASM instance fails with OERI[kfaDropCOP04]
5757282Broker commands to standby can error (ORA-16613)
5757711ORA-15080 during file creation / resize on ASM with HARD
5758870ORA-3135 from TAF with SELECT type FAILOVER
5762750ORA-907 when cursor_sharing is enabled
5769454CREATE INDEX fails with unexpected ORA-54
5840434ORA-1200 if instance crashes / is aborted right after a datafile RESIZE operation
5844876ORA-28550 from TG4SYBS
5847881ORA-3001 from GROUPING SET query against a view containing a function
5852253ORA-25316 from AQ after rollback to savepoint with loopback database link
5857884EXPDP fails with ORA-39125 / ORA-6502
5863277ORA-1008 from SQL on second run when cursor_sharing=similar/force
5870989RMAN restore failover gives ORA-19864 error
5872000Healthcheck errors for 32bit database on 64bit OS with fix for 4526916
5872368ORA-22160 from DBMS_ADVISOR.TUNE_MVIEW
5872480LPX-224 can occur in XDB
5872788ORA-29821 importing OPERATORS
5879179ORA-22925 from CSSCAN when reading CLOB data
5891213ORA-6502 / LPX-7 from DBMS_METADATA.GET_DDL with domain index present
5900857ORA-23619 from HS log based replication
5903293Wrong Results for Parallel Query using Group By or Distinct or has correlation
5910237EXPDP / DBMS_METADATA has wrong syntax for for nested table with row movement enabled
5924208ORA-1031 from DDL due to using wrong shared DDL cursor
5924538Logical standby apply fails with ORA-1427 for operations on IOTs
5932029ORA-21000 when running RMAN "resync catalog"
5932181RESYNC of RMAN catalog fails with ORA-1 (on TF_U2) or RMAN-20042 after switchover
5959987Spatial aggregations fail with ORA-22813
5961454ORA-29861 on DML with concurrent partition maintenance on different partition
5972794EXPDP via network_link with parallel > 1 fails with KUP-4038
5973648ORA-54 during concurrent parallel direct SQLLOAD in RAC
5974207Unexpected ORA-1031 from LOB access - affects NCOMPed PLSQL
5977767RMAN "minimize load" with "duration" causes backup to timeout
5999200FSFO fails with ORA-16750 "failed to activate logical standby"
6018252Insert statement with RETURNING clause fails with ORA-1031
6025805ORA-14403 raised when executing select for update
6028753ORA-907 / ORA-933 from DML over database link
6029647ORA-12714 accessing typed column from TABLE() function
6035495ORA-19909 during MRP / RMAN-600 on resync
6035889ORA-28003 from create / alter user if password verification function contains special character
6057203Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update
6059327ORA-39083 / ORA-1647 during TTS import of subpartioned table
6075099ORA-1476 from spreport (statspack)
6085625Wrong child cursor may be executed which has mismatching bind information
6113520Cannot add table into single table cluster (ORA-25136)
6136074ORA-4068 / ORA-4065 ORA-6508 on VALID objects
6139547Shadow process leak on ASM instance when diskspace exhausted (ORA-20)
6140330imp / impdp cannot create object views with circular dependencies
6150438COLLECT() does not work correctly for ADTs residing in different schemas
6162163Wrong order of operations when mapping a buffer in the buffer cache
6268371ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
6315913ORA-3106 for SQL using BLOBs after TAF failover
6334552Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6360220ORA-21780 from subquery factoring SQL WITH clause
6379123EXPDP/IMPDP ORA-39083 due to changes in MERGE privilege between 10.1 and 10.2
6436867Recompilation may skip compilation of some dependent objects (ORA-4068)
6493035ORA-12842 / ORA-12839 from INSERT .. SELECT
6494820CSSCAN fails with ORA-1455 on tables with more than 2^31-1 blocks
6680806ORA-16139 from ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY
6762914ORA-326 during Managed Standby Recovery after thread disable

Internal Error May Occur (ORA-600)
5526987*ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1
5605370*Various dumps / instance crash possible. This bug is alerted in Note:454464.1
6017420*OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed. This bug is alerted inNote:453309.1
6128197*OERI[kcrfr_resize2] / cannot recover database. This bug is alerted in Note:453259.1
6646613*IOT corruption after upgrade from <= 9.2 to >= 10g. This bug is alerted in Note:471479.1
4430244+Segment advisor can load blocks of dropped objects into buffer cache (KCB OERI errors)
4450606+LOB corruption / ORA-600 [ktsbvmap1] when updating a LOB
5081798+Additional diagnostics for OERI[2103] when ASM involved
5363584+Array insert into table can corrupt redo
6110331+OERI[kcbget_37] / OERI[1100] / spin possible
5841554IOERI:kqludp2 during upgrade to 10.2.0.3
5892355I+Upgrade to 10.2.0.3 can fail with ORA-600 [22635]
3901785SELECT FOR UPDATE with LONG may OERI[13009]
4061534OERI[krvtadc] / dump in capture mining redo for COMPRESSed table
4095802Concurrent DROP / LOCK against same table can fail with OERI[16608]
4119210OERI[kkqgSetFields.2] possible from query rewrite
4200563OERI[kkqsfcsi-1] from query rewrite
4254770OERI:kzaSqlBindLob1 can occur with AUDIT_TRAIL = DB_EXTENDED for sql using binds
4308334OERI[12314] during XA commit/rollback/prepare while attached to different transaction
4309607ALTER TYPE CASCADE fails adding attributes to various types
4344935OERI from DML on TEMPORARY TABLE after autonomous TRUNCATE
4377584OERI[18201] from concurrent xaorollback and xaoprepare
4380471OERI[kkqsfcsi-1] from query rewrite with an ORDER BY
4387531Spin running XPATH on SB table with IOT structured varrays
4433838Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
4440918OERI[kewucmb_1] can occur
4482978OERI[qkagby.noexec] on materialized view recompile
4485775OERI [qsmqLockTableSummarySubheap-1] selecting from materialized view with TDE enabled
4541506RMAN OERI[1880] when MAXPIECESIZE is set
4549673ORA-30926 / OERI:13030 during update
4559728Select lob from view loops / OERI [17059] if synonym dropped
4567042Logical standby log apply may stop with OERI[knacend910]
4577403OERI [kcbr_pending_3] during parallel recovery
4581220OERI:kzaSqlTxtLob1 with fine grained auditing and parallel query
4584985OERI[kclexpand_9] can occur
4587556OERI:17069 compiling a package with a self referencing synonym
4596807OERI[6002] on update statement with concurrent ONLINE rebuild of bitmap indexes
4600946Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
4614980OERI:15448 from Text query
4634662OERI:kolaslGetLength-1 from V$SQL in RAC
4643723After type evolution extracting attributes gets OERI[17280]
4644351OERI[15819] / wrong results from parallel select
4655998OERI / dump from SQL involving SORT operations
4668719OERI[kdtdelrow-2] from bulk insert
4674037OERI:kclscrs_9 dumping processstate
4686006OERI:[kkqsaljg:nobjs is 0] from view with exists and having clause
4694073OERI[kgmgcdty2] possible from SQL using LIKE
4697252OERI[kglsim_unpinhp2] can occur
4697632OERI[atbbjie2] from exchange partition with bitmap join indexes
4702830OERI[kkoljt1] when using star transformation with an ANSI outer join
4708822OERI[kfiounidentify01] from PMON
4712638OERI[15160] / dump [kkogbro]
4715375OERI[kwqmtdel] in q00 process in RAC when any instance goes down
4744529OERI:kclpred_1 / crash possible in RAC
4745114OERI[kolrrdl:0rfc] using temporary LOBs in PLSQL
4745691OERI[kghufree_06] from AQ propogation of XML payload
4767278OERI[kcrrupirfs.20] archiving redo to standby with ASM
4864581OERI [kkqtnlop2cbk : 1] on SELECT with extra parenthesis
4865755OERI[9999] during DBMS_LOB operation
4868255Dump (kpofdr) in executing a query with ORDER BY with row shipping enabled
4877360OERI[kccscf_1] from CREATE CONTROLFILE with COMPATIBLE = 10.2
4887675OERI[kgsclogoff-notempty] can occur during logoff
4887880OERI:[qkactasrowvector_13] from CTAS with XML related operations
4893136OERI:17287 dropping / creating triggers that use the "CALL" statement
4899105OERI[19004] from multi table join
4899479Undo/redo corruption if distributed transactions used
4902585OERI[510] and ORA-28106 using application context over 30 bytes long
4904223ALTER TABLE EXCHANGE PARTITION may dump / OERI
4939224OERI[18095] during distributed autonomous transaction
4941795OERI[kdtdelrow-2] during array DML if ORA-2049 occurs
4959652Streams may get OERI [kwqbespayl518]
5008674OERI [kkqsfcsi-1] from query rewrite
5015321OERI[qerrmObnd1] [932] using binds with some functions over a DBLINK
5018532Insert / validate of valid document may OERI / dump
5018886OERI:[kwqitnmptme:wait] in Qnnn during propagation of delayed messages
5028099OERI:kcbzwb_4 can occur using in memory undo
5029528OERI:[qkacon:qkaconGetPathOps:1] from SYS_CONNECT_BY_PATH
5045992OERI[kxspoac : EXL 1] from PQ with a numeric bind
5051602OERI[17182] from SCROLLABLE select with duplicate columns
5060402OERI[12325] can occur
5063279OERI[kdibllockrange:not validated] updating a partitioned bitmap index
5063635OERI[kccdagf_3] during file creation
5076729OERI[pmucitnxt] doing type manipulation
5081271PMON may crash the instance with OERI:kcblibr_1 during temp table cleanup
5084679OERI from EXPLAIN_REWRITE CLOB interface with VPD
5084757OERI when executing explain_plan with VPD
5099891OERI using SQL with a SAMPLE clause
5112856OERI[kghstack_underflow_internal_1]... [kkocxj : predtailpp]
5118012Instance crash with OERI[kclswrite_3] with multiple DBW processes
5118210OERI[kopuigpfx1] on insert to table with sdo_geometry column with INSTEAD OF trigger
5118272Instance crash with ORA-600 [1433], [60] due to lgwr filling up msg blocks (Messages could be for LGWR or ARCH)
5119354OERI from CONNECT BY and correlated START WITH columns
5126645OERI [kkqtcorcbk: correlated string no] from CONNECT BY
5128625OERI[17147] / OERI [17182] / NULL result from NLSSORT
5136863OERI from join between partitioned table and domain index
5139572OERI[qkauix2] on drop partition with parallelism
5154689OERI[kql_tab_diana:new dep] / table dependency deleted in Streams
5155885OERI[kkslgbv0] with CURSOR_SHARING=similar
5162852Dump from FIRST / LAST aggregations on a NULL table
5163554OERI[qctopn1] during join predicate pushdown
5165885OERI[kclcls_8] or OERI[Kjbrchkpkeywait:Timeout] can occur in RAC
5177766OERI[17059] with SESSION_CACHED_CURSORS
5183594Logical standby apply stops / OERI [kghstack_underflow_internal_2] with SKIP / UNSKIP on SYS tables
5196175OERI[kghstack_underflow_internal_1] with supplemental logging for LOBS
5216523OERI[16608] from create materialize view on remote table with objects / types
5218905OERI[kcbnew_3] when segment advisor has been used
5223587OERI[4400] from distributed PDML with DDL
5228074OERI[12455] raised from SQL with DOMAIN index when FOR UPDATE option is used
5234379Dump in qknlazopn() from hierarchical query
5246372OERI[opidsii1] accessing remote database accessing 3rd remote database
5252061PGA memory corruption / OERI[17456] creating a domain index
5254539OERI[qkacon:FJfsrwo] on executing hierarchical query
5258521OERI[kkpapDimToLevel1] from parallel query with partitioned tables
5261145OERI[12261] from dbms_mview.explain_rewrite
5262017Query on partitioned table with bitmap index gives OERI[qernsRowP]
5307199OERI:OCIOpaqueDataLoad1 can occur using ODCI with AnyData / AnyDataSet
5326327OERI[qctbyt : bfc] using NLS_LENGTH_SEMANTICS=CHAR
5331374OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration
5337352OERI[kkqtcpopn: 0] during parse with subquery unnesting
5345999Dump / OERI accessing V$SPPARAMETER
5347371Dump [kkoojt] on a query against XML / XDB
5363258Query rewrite can fail with OERI[voprvl1]
5364819OERI[kkslpbp:1] when using literal replacement
5369855OERI:733 or Spin (qksopLogSame) from star transformation
5371149OERI[qctcte1] from query with CONNECT BY
5372831OERI:26599 / dumps in JVM after database has been closed for recovery / opened
5374225SDO_FILTER query fails with OERI[kdsgrp1]
5375583LMS process dies with OERI[kclexpandlock_1]
5382842Select fails with OERI[qctcte1] using cost based transformation
5384248OERI[k2gtelock: !k2gtca] / instance crash cleaning up distributed transaction
5385614Need diagnostics for OERI:ktrviupk_4
5385791ORA-932 with enumeration and complextype / simplecontent
5387049ALTER TABLE MOVE with 255 columns or more can dump / OERI
5388885Hang / OERI[krvxbpns01] accessing V$LOGMNR_CONTENTS from RAC
5391575OERI:[qkaconCompareOpn:dty] from CONNECT BY with HAVING clause
5395270OERI[qctcte1] / dump / wrong results from view merging
5399670OERI[keltgtyp] [22303] can occur
5400158OERI[17078] / dump running Java DDL (loadjava) concurrently
5403150ORA-603 when cannot get lock within Resource Manager "switch_time" in RAC
5405345OERI[kkofkrMarkK] when running a query using a database link
5434872OERI[qolgenol-1] when executing dbms_outln.create_outline
5452715OERI[kwqbgqc: bad state] reported after restart of database
5454975Dump executing DBMS_OUTLN.CREATE_OUTLINE
5471453OERI[kfkfilrqarr01] using ASM
5476507OERI[15868] / OERI[15160] can occur with cursor sharing
5476873Instance crash due to PMON ORA-601 / OERI[ksudlp1]
5480607OERI:kghstack_underflow_internal_3] from DROP_POLICY
5482174pick release database error ora-00600 and ora-00036 after upgrade to 10g
5483613OERI [kfgscAcquireLcl_6] in ASM
5486074OERI [keltnfy-ldminit] when DNS is not available
5494240OERI[15201] during select from an IOT
5496041OERI[6006] / index corruption on compressed index
5496727OERI[7005] possible with null bind
5497611OERI[qctVCO:csform] from Xquery using XMLType constructor
5502365OERI [kfcDel20] in ASM
5508574OERI[504] / OERI[99999] / Dump [kgscdump] with > 31 CPUs
5512840Logical standby fetch slave stops with OERI [knahfgx704]
5512921Instance crash caused by SMON OERI[kcblus_1] / dump
5514109OERI [kql-hash-collision] / false ORA-955
5526996OERI[kjhn_post_ha_alert0-784] can occur in RAC due to racgimon problem
5527665OERI[kcbkzx_3] / OERI[kcbkzs_6] for SCURRENT prewarm buffers
5529797PGA leak / OERI KWQPCBK179 during Streams propogation
5530043OERI [kkzg_add_ref_stmt_lst.1] can occur during materialized view refresh
5530697OERI[kjshash:!esm2] in PQ slave process in RAC querying GV$ view
5532110OERI[qcscpqbTxt] can occur
5548895OERI [OCIKCallPush: deprecated] from EXPDP of ANYDATA column
5555908OERI[kghstack_underflow_internal_2] in kfrcsoDelete
5558244OERI[kcbnew_3] can occur
5566580OERI:15817 using parallel query with a large number of columns
5567141OERI[526] / hang with fix for bug 5508574 installed with > 31 CPUs
5567641Streams capture terminates on restart with OERI[krvuatla]
5571643OERI:[kfclAttachBuffer10] in ASM
5578157Instance crash with ORA-600 [1433] (RSM has all message blocks)
5579699OERI [smbGetNxtAloSiz:max] from query with large sort
5580497Dump (kkeais) during query optimization
5583634OERI [17147] / dump after inserting a text node of size 64000
5587421LMS fails with OERI [kjmpmsg_1]
5590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
5594381OERI[qkacon:FJswrwo] from CONNECT BY query
5599596Block corruption / OERI [kddummy_blkchk] on clustered or compressed tables
5600050LMON may fails with OERI [kjbrref:pkey] during DRM
5603197OERI[qctvco:csform] from UPDATE SQL with a subquery
5612751OERI:qertqosSetPart4 if STAR transformation is considered and rejected
5617382OERI[qctcte1] with the fix from bug 5259868
5631836OERI[kghalo4] can occur
5632050OERI[kkpolpd12] / dictionary corruption from CONCURRENT partition DDL
5638146OERI:kqlfFillBindData:1 for SQL with thousands of binds
5640593Streams OERI:kwqbmcrcpts101 while spilling messages
5644951OERI[rworupo.2] querying outline LOB with ORDER BY clause
5649326OERI[kksfbc-reparse-infinite-loop] can occur after DDL on partitioned table
5650372Wrong results / OERI[kkpapdrmfkk1] from predicate elimination on partitioned table
5652086OERI[15160] from ANSI join
5654584OERI[qernsRowP] when using DISTINCT on CONNECT_BY_ROOT
5660643OERI[kkqsfcsi-1] during query rewrite of SQL with set operator
5660888OERI[kzspvcr:1] using proxy authentication with > 16 roles
5669051Query rewrite may dump in kkqsMMVNormalizeQBC
5670585OERI [kxfxsSendCounter1] / OERI [15574] / spin from WINDOW query
5673934ORA-12801 / OERI 15810 during parallel DML
5676637OERI[17114] using EMPTY_CLOB() in a trigger
5676948OERI [qxxmslSelectLocator_10] from SQL*Loader
5681955SGA corruption in RAC (OERI [17114] / OERI [17112])
5682184OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file
5690100RAC instance crash with OERI[kjbmpwrite:wip2]
5693140OERI[kdtdelrow-2] from array insert with concurrent ALTER TABLESPACE READ ONLY
5694466OERI[15160] from subquery unnesting
5695131HW enqueue deadlock / OERI:1153 from array insert with SAVE EXCEPTIONS to READ ONLY ASSM segment
5695610OERI[kxfpgsg] isolation_level = serializable in RAC
5702177Instance crash from OERI[kghchoose_grow_1]
5707822'alter table .. deallocate unused keep ..' fails with OERI[kcbgcur_2]
5712086OERI[17147] / dump from TO_CHAR(date) with over long FORMAT string in multibyte
5730717OERI:kclchkinteg_18 / LMS crashes the instance
5735146OERI[6704] during SELECT FOR UPDATE
5736850SGA corruption / crash from PQO bloom filter
5742127RMAN backup sometimes fails if datafile grows during backup
5743325ASM instance fails with OERI[kfaDropCOP04]
5744546MMON OERI [1403]
5757106OERI[15851] selecting aggregate of a constant with literal replacement
5757752OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash
5762514DBWR crashes instance with OERI[kcbbctsc_3]
5764556OERI[kctdsb_internal_03]
5765958OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL
5837795Wrong results / OERI from cost based CONNECT BY
5839280OERI[15265] dropping OLS policy
5841624OERI[kokeicadd2] accessing object with embedded substitutable attributes
5850776OERI[kkqsMMVReAggRewriteExp:notoptfou] from query rewrite
5854634OERI[qkshtQBGet:1] from CONNECT BY query
5855995OERI:kksCallPopCallback possible after ORA-4030
5857313OERI[kwqbmcrcpts101] after drop propagation
5860221Apply aborts with OERI[17147] / memory corruption with FUNCTION BASED index
5864217OERI [kkoljt1] from ANSI query with join elimination
5867231OERI:qernsRowP on Text query with NLS_COMP / NLS_SORT set
5867943Capture aborts with OERI[knlcloop-200] mining "ALTER TABLE SPLIT PARTITION ..."
5885908OERI[12259] can occur instead of ORA-1001
5891280MRP0 on standby may not start (OERI:krfg_aset_1)
5891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
5893340OERI [32695] [hash aggregation can't be done] from hash aggregation
5894422OERI[525] / OERI[kglsim_rebalru2]
5903829OERI[qkshtTabInf2:1] can occur parsing a query
5923497Select with constraints fails with OERI[12863]
5923866OERI[2103] when database is suspended
5926074OERI [12333] on update of more than one CLOB column
5928555OERI[krastrso_reserve] during BACKUP BACKUPSET
5935527Cursor leak with fix for bug 5260266 / OERI:17280 from Ctrl-C using pipeline function
5939115ora-600 [kghstack_underflow_internal_1][pcols in kkpapdaextsqueryslvl]
5942097OERI:qernsRowP from SQL with GROUP BY , ROLLUP and DISTINCT aggregates
5942476OERI [kcrrcomp.4] can occur in Streams
5953355OERI[klaprs_30] / OERI[klaprs_10] during SQLLOADER direct path load
5955764OERI[kccirsd_4] during CONTROLFILE upgrade from pre 10.2 version
5964193OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
5981084OERI[kcrrtcln.seqvio] can occur
5983403PMON may crash the instance with OERI[kksStatsRecovery-Bad-Opcode]
5987000OERI:qkxrPXformQbc1 can occur for SQL using a WITH clause
6005113OERI[kclrwrite_7] in DBWn process followed by instance crash in RAC
6012053OERI [qctcte1] from GROUPING SETs query
6013213OERI[17183] selecting from X$KRBAFF
6013968Hang / OERI:504 with patch for bug 5863519 installed
6013983ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance
6015158OERI [kkshgnc-nextchild] can occur
6016087OERI[15160] from subquery unnesting
6016707OERI[kwqpuspse0-hwmack] from propogation
6026281OERI[qeshCloseHTI.2] from spreadsheet query
6034040Apply aborts with OERI [knlcfpactx:any_knlso] using RENAME_SCHEMA
6041317OERI when inserting ASCII 0x0 into CHAR/VARCHAR2 with AUDIT_TRAIL=DB_EXTENDED
6041713OERI[kkzdgdefq_oci - stexec] refreshing through definer rights procedure
6046844OERI:2103 not avoided when it could be for some scenarios
6051977DBMS_XMLGEN fails with OERI[qmxtcCtxConvertString] converting unescaped ampersand
6056865Intermittent OERI [kcblci_1] using shared servers
6057203Corruption with zero length column (ZLC) / OERI [kcbchg1_6] from Parallel update
6057703OERI[kclchkblkdma_3] can occur in RAC
6075238OERI[qctcte1] on parse of query with views / subqueries
6075487OERI[kddummy_blkchk]..[18020/18026] for DDL on plugged ASSM tablespace with FLASHBACK
6075582OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
6086497OERI[ktspgetmyb-1] / bitmap segment corruption for ASSM segments
6118038OERI[koputilcvto2n] on an ALTER TYPE
6129874Illegal ALTER SYSTEM SQL allowed
6132301OERI[kcb_pre_apply_1] when db_block_checksum is set to FULL
6136494Capture process aborts with OERI [17112] / OERI [17147]
6140309OERI[ktssupd_seg_2] from DBMS_SPACE_ADMIN.TABLESPACE_FIX_SEGMENT_EXTBLKS
6143117Rare intermittent mutex problem
6145841OERI[kologsf2] on COLLECT(..) with wrong datatype
6159522OERI[qkaffsindex3] from ANALYZE TABLE .. ESTIMATE STATISTICS
6195283OERI[1100] / crash using Resource Manager
6239052LMS can crash instance with OERI[kjbrchkinteg:last]
6267094OERI[kghstack_underflow_internal_1] recovering logical standby
6267208OERI:2103 due to deadlock between PV enqueue and "slave class create" latch
6334552Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
6377317OERI[ksfdrfms3] using ODM if a log corruption is detected
6408017OERI[12811] optimizing a query against fixed view/s
6436867Recompilation may skip compilation of some dependent objects (ORA-4068)
6452485SGA memory corruption / OERI [17182] with fix for bug 6085625
6494146OERI [kksfbc-reparse-infinite-loop] can occur
6597063OERI [kfrpass2_03] can occur in ASM
6644215OERI[krvxradfd] during autodelete of partial log on logical standby
6651027OERI:kgkprrpicknext1 / dumps from DBRM
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM
6781496OERI[KGHLATCH_REG4] on STARTUP with >61 CPUs in RAC with fix for 5508574

Process May Dump (ORA-7445) / Abend / Abort
5605370*Various dumps / instance crash possible. This bug is alerted in Note:454464.1
5648872*Dump (opidsa) from DESCRIBE of a cursor. This bug is alerted in Note:418531.1
5933477*Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database. This bug is alerted in Note:455832.1
6037186PSolaris-X86: Dump in/under delrow
6458590PSolaris: SIGFPE in kglsim_update_simresz / ORA-822 MMAN terminates instance
6656824PDBW can crash with fix for bug 6087207 installed
2837580Dump if SQL has > ~35000 literals
3197358Dump when DBMS_HS_RESULT_SET is fetched out of sequence
3551896Dump / spin from SELECT on V$SESSTAT
4095802Concurrent DROP / LOCK against same table can fail with OERI[16608]
4202503Parse errors possible using CONTAINS with cursor_sharing=similar/force
4204383Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries
4216668Dump from INSERT / MERGE on internal columns
4308334OERI[12314] during XA commit/rollback/prepare while attached to different transaction
4335601Dump can occur in lxsCntByte
4351422Dump from CREATE TABLE AS SELECT (CTAS) over DB link
4369756Log apply may dump [krvsmso]
4397693Dump (apaqba) from multi table insert with WHEN clause under RBO
4406211Dump (insLoadRowInfo) from MERGE SQL with false condition
4457221Dump [under kdxcom] doing RMAN compressed backup
4491223Dump selecting ROWID with a remote join
4583492Dump possible using ADT columns when table has many columns
4587431Dump (in kkqucsv) / spin from query with a multi column IN subquery predicate
4600946Dump / OERI[kghstack_free1] on array insert to COMPRESSed table
4618715Dump inserting into a view with OLS policy on tables
4620832Dump in kzrtppg with multiple referential constraints and OLS policy
4655998OERI / dump from SQL involving SORT operations
4664788Query with UNION can dump in kkqudhus
4683638Dump [nsoexc] raised from CREATE TABLE AS SELECT (CTAS)
4684209Dump (under evaopn2) with transitive predicate from CHECK constraint
4687581Dump (kcsgrsn) during SHUTDOWN
4702284ORA-604 / ORA-902 from WITH clause with scalar subquery involving an object column
4712638OERI[15160] / dump [kkogbro]
4726702ALTER TYPE may dump (koktupd_dplvl) due to a REF dependency
4739114Dump in shared server after using DBMS_XMLDOM
4755448Dump [kxfxgf] on parallel slave processes when using PQ trace
4767996Dump in HS with very long TNS connect string
4771851Dump (kxccsrw) from INSERT .. AS SELECT / MERGE
4864149Query rewrite with ORDER BY of grouping_id dumps in evagrp
4868255Dump (kpofdr) in executing a query with ORDER BY with row shipping enabled
4868646Dump from cost based query transformation
4877048Dump (qmtModelGetMCA) on registering XML schemas using group
4895068Dump [kopxccc] during pickling
4899479Undo/redo corruption if distributed transactions used
4905112CREATE OUTLINE on DML using an indexed partitioned table may dump (kauxalo)
4912371Dump possible in kohrsmc()
4927556A dump can occur in kewmprepspsylstat()
4927563Dump in qerixGetKey
4929094Client side dump under OCISessionGet using OCISessionPoolCreate with OCI_SPC_HOMOGENEOUS
4932527Dump (under kopp2atsize) processing nested objects
4969005Dump [kglLockIterator] querying V$ views
5001547Dump (kkoVerifyBindEquivalence) can occur
5018532Insert / validate of valid document may OERI / dump
5022061Dump [kkessc] optimizing query with inequality join if INDEX SKIP SCAN considered
5023743Dump (kkqucpon) from query with aggregate subquery
5033488Dump in kokmrwo from CONNECT BY
5034323Dictionary corruption when adding a subpartition to a table with a key compressed local index
5058503Dump[kkogtp] can occur selecing ROWID from a join view
5073249Dump from fast refresh of MV using "WITH .. AS"
5074285Dump [eorealize_xref] from stored Java using reflective methods
5088977MMON dump (in keltfill) intermittently
5089444Dump (kkodsel) from select with a subquery with star transformation
5092843Dump (kpceclose) in EMON
5094908Dump (kokbBuildExplodedTree) recompiling a view after upgrade to 10.2
5096560Dump (selexe) when recompiling a materialized view with a UNION
5113934PQ slave dump in qerixGetKey() when using bitmap index access
5118104Dump compiling PLSQL using pseudo columns with INSERT .. RETURNING
5120395Dump [ksupgpq] queryung X$KSUPGP (eg by DBMS_STATS)
5128368Dump [kkoeqv] optimizing a query with nested views
5128933Dump from DBMS_SQL selecting TIMESTAMP data over a database link
5150562Dump expCheckExprEquiv from pipelined function in hierarchical query
5161782Dump installing XDB
5163554OERI[qctopn1] during join predicate pushdown
5169247Dump (eg in qkarid) from SELECT FOR UPDATE after table elimination
5179008Dump (kjzhablar) possible in RAC
5182299Dump on grant / revoke of privileges on a TYPE
5183729Dump (kkmins) from insert into a view
5192858DROP TABLE with object type column with statistics can dump (kknerd)
5194354DUMP[kghalp] when executing query with index using REGEXP_SUBSTR
5195356Dump (memcpy) under kudmprcbk() when accessing external table
5196061Dump in evaopn2() from WITH query using WINDOW functions
5206570Dump (ksusrs) when session is sniped
5211545Select with EXTRACT dumps in lxXmlGEntEsc2
5216642Dump from SQL using window functions
5220760Dump in NetLocalGroupGetMembers
5225168Dump (evaopn2) from CONNECT BY
5225836DROP TYPE .. VALIDATE dumps for large partitioned table
5226383Dump (kkpapDiGetRange) from subquery pruning with composite partitions
5234379Dump in qknlazopn() from hierarchical query
5242942Client dump (OCIPClearMxCtr) using stateless connection pool
5243259Dump (lxgcnv) can occur using CONVERT with bind variables
5258410Dump [eoa_scan_mark_object] using stored Java threads
5285966Dump [lxhlod] on select passing NULL for NLS parameter to a function
5292883Dump from OCI client using OCI7 olog() call
5334170racgevtf can dump in lmmstfree
5337099Dump using oradebug during shutdown
5345999Dump / OERI accessing V$SPPARAMETER
5358150Dump (apaqbd) using CAST with cost based transformation
5362021Dump from SQL using user defined functions
5364819OERI[kkslpbp:1] when using literal replacement
5372831OERI:26599 / dumps in JVM after database has been closed for recovery / opened
5377099Dump [kksfreeheap] / OERI:504 / SGA corruption / crash possible
5381446Wrong results / dump from STAR transformation with INDEX join
5387049ALTER TABLE MOVE with 255 columns or more can dump / OERI
5395270OERI[qctcte1] / dump / wrong results from view merging
5397953Dump [kkpapItgetAll] accessing partitioned table using multi column INLIST
5400158OERI[17078] / dump running Java DDL (loadjava) concurrently
5403150ORA-603 when cannot get lock within Resource Manager "switch_time" in RAC
5403398Dump when costing user defined operators / functions
5406976Dump (lxhscn) if DB calls out over NET with a FAILOVER clause
5409593Parallel insert as select into partitioned table can dump
5412994Dump in ksrchconnect_ctx leading to instance crash
5437241Dump accessing XML DOM in PLSQL
5440119Dump in kkogast
5442534Dump in kokscold assigning NULL to CLOB
5446630Dump (nszgclient) using USERENV of AUTHENTICATION_METHOD
5454388OPROCD dumps with fix for bug 5015469
5455632Dump accessing tables over a database link
5459023Dump (krccrpio) can occur
5479902Dump qertbStart running query on partitioned table
5487604CRSD core dump
5488174Dump [evaopn2] on a CONNECT BY query
5504989PMON dump [kfgGlobalClose] / instance crash
5508574OERI[504] / OERI[99999] / Dump [kgscdump] with > 31 CPUs
5513123DUmp [kkfies] from SQL using functional indexes with subqueries
5550618Dump [nszgclient] from EXPDP
5555833Dump [kokees2c] from Xquery
5570942Query Rewrite causes high parse time with high hits on 'latch: row cache objects' and dc_object_ids / Dump in STRLEN
5572957Dump (under kkqssjsce) with query rewrite enabled and heavy load
5574966Dump (evaopn2) or Wrong Results with views and function-based index
5576865Dumps in strlen/kpodpmop/kpodpp errors during IMPDP
5579055Dump (kxccres) updating view with instead of trigger
5586632Dump (qkaGranuleIteratorTraverse) on query on partitioned tables
5590396Dump or Wrong Results with ANSI JOINS and CONNECT BY
5606145Dump parsing query with IN subquery with SET operation
5610906HSODBC dump invoking Data Dictionary translation query multiple times
5611623Parallel query slave dump (kkpapitsize)
5619833Dump (qerixGetKey) from query rewrite on join including functional index
5640904Dump (kcsgrsn) while writing redo buffers to trace
5649765Dump [evaopn2] from star transformation with pushed predicate
5656948Dump returning collection from ODCIAggregate
5667253Dump while selecting from encrypted table with CHAR column and subquery
5670294Dump (qknviAllocate) using star transformation
5682195Dump (lstmclo) evaluating regular expression in case insensitive mode
5686412Dump (evaopn2) from query using functional index
5690241Dump / wrong results from OR predicate on partition columns
5703276Dump [kxtogiop]
5707754Dump can occur executing a large query
5708633Wrong results / dump [ldxite] from materialized WITH clause
5712202Dump [qcuCatNames] can occur when trying to signal an ORA-904 error
5715079ORA-1281 when applying a Patch Set on a logical standby
5721502Non blocking client may dump executing PLSQL
5721821SGA corruption / Dump[kglobcl] / crash if objects dropped / recreated
5743829DG Broker process dump
5747782Update of a partition table with UNUSED columns dumps [kdddcp or kdtInsRow]
5753629Query may dump [in kpopfr / kposdi]
5759876Dump [rfm_get_chief_lock] on Broker startup
5763538Wrong results / dump with object type column in SQL
5765361Client dump using OCIDirPathPrepare in OCI_UTF16ID mode
5766450Dump [kkomprf] when attempting STAR transformation
5796376Dump [kkobrak] from index join with a FUNCTION based index
5845347Dump [kkogbys] parsing SQL with GROUP BY
5845901Dump from concurrent CREATE MATERIALIZED VIEW and DDL on base tables
5857949Startup may fail due to dump [rfmsoexinst] from DMON
5863519Instance crash due to LMS dump (in kclcsr)
5865159Dump (in lxxmlgentesc2) accessing text node with size close to 64k
5868656MMAN dump (kghlkaftf)
5889331Dump from cost based optimization of INSERT .. SELECT with function based index
5891737Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC
5892453Dump [ldxeti] from certain DATE expressions
5894403MRP0 process fails with SIGFPE in kcrarmb
5908945Dump [qxopqdca] with ancilliary operator
5912350Dump (kdr9ir2f0rst4srp0) on select of compressed table having > 255 columns
5922733ASM dump in kfkdumprq with event=15199 level=1050631
5933643Dump under msqidn
5934741Dump (kgmtncch) from CALL statement with OUT CHAR arguments
5944227SQLloader direct path load into IOT can dump [kdblldrp]
5951591Dump in kkecdn due to exponent overflow
5960268Dump (kkoiodoi) when FIRST_K_ROWS considers bitmap index
5962344Dump from Logminer due to stack corruption under krvtgct_GetColumnTranslation
5962680Dump[kwqicgsubname1] on an AQ enqueue call
5984440Dump [prsatb] from ALTER TABLE .. MODIFY SUBPARTITION
5988085Dump [kkodsel] from STAR transformation with ANSI view
5989589Dump (qctcopn) from create force view
5990716Query using index join dumps [evaopn2]
6020789Dump [vopplog] pushing join predicates
6035614Instance crash / dump [kghunphy] with fix for bug 5922239
6036151Dump (qctcopn) when LNNVL() gets used in a query
6052351Dump running catupgrd.sql when creating/replacing streams$transformation_info
6053772Dump [kpubsuuc] for SQL over HS using binds
6065183A dump in AccessControlContext methods in the Oracle JVM
6070548Dump (qertbGetPartitionNumber) / wrong results from bitmap access to IOT
6075582OERI[kjbmpref:sh] / dump [kjmpbmsg] in LMS causing instance crash
6084108Dump / CPU spin possible after an ORA-3115
6120084Dump (eoistrnrep->strncpy) in Oracle JVM
6123145Dump [ksxpunmap] in RAC
6123567Dump [kkosbn] optimizing query on partitioned table
6124804Dump [krvxbpc_processcommit] selecting from v$logmnr_contents
6139254Dump (perdcs) with fix for bug 6061892
6145525Dump selecting > 34 columns from HS (FDS)
6148212Dump [qmuhshget_internal] can occur accessing LOBs
6168288Dump instead of ORA-1863
6316993Wrong results / dump (qernsRowP) from join back elimination of 1 row table
6651027OERI:kgkprrpicknext1 / dumps from DBRM
6674196OERI / buffer cache corruption using ASM, OCFS or any ksfd client like ODM
6789193Dump [kdu_array_flush] during array update with fix for bug 6057203

Miscellaneous
5918964PHPUX: trace files may not dump all memory
6087207PFalse WARNING in alert log indicating lack of OS KERNEL I/O RESOURCES
4591936Unnecessary "kccsga_update_ckpt ..." media recovery messages are logged at startup
4929809sysresv not showing shared memory correctly when more segments
4936689Crash dump (cdmp) generation cannot be limited dynamically
4999743"cannot open symbol table" errors possible
5111399Archiver error message should be tagged with 'ORA-' prefix
5201883Unnecessary MMAN trace lines
5362226PMON may not clean up dead processes
5390964Connect time limit takes 60 seconds longer than defined (ORA-2399)
5454792Require faster restart of non-fatal background processes
5555371CURSORTRACE event cannot be turned off fully
5673171Async LNS writes trace messages even when LOG_ARCHIVE_TRACE=0

Notable change of behaviour introduced in 10.2.0.4
5082178Bind peeking may occur when it should not
5483301Cardinality of 1 when predicate value non-existent in frequency histogram
6085625Wrong child cursor may be executed which has mismatching bind information

Notable change of behaviour introduced in 11.1.0.7
6085625Wrong child cursor may be executed which has mismatching bind information
6322324OS audit trail should include length of attribute values

Undocumented Oracle Server
1641830 2107554 3328206 3519123 3639234 3750258 3806471 4047619 4338536 4376208 4393925 4396553 4409481 4428921 4432352 4447737 4457984 4476868 4494261 4496134 4520630 4526053 4544061 4557534 4637849 4640034 4661499 4671485 4687887 4697792 4698775 4713979 4716096 4725196 4733886 4861707 4881930 4905742 4919496 4940771 4944768 4963246 4967676 5003715 5005581 5007913 5013480 5013727 5015431 5035494 5044700 5051196 5071507 5079213 5084315 5084399 5084541 5087200 5087584 5087859 5110229 5112202 5123630 5125541 5146782 5152141 5164551 5166612 5168995 5172550 5173165 5173408 5178508 5179574 5183826 5185262 5186226 5192934 5206057 5220972 5229082 5234600 5236480 5238019 5244897 5317510 5318331 5321020 5325277 5335993 5344876 5345044 5345593 5352626 5355300 5357808 5358586 5360518 5362985 5371506 5381630 5382718 5382807 5382820 5387396 5387862 5389786 5394193 5394395 5394403 5402113 5402870 5404921 5412601 5413025 5414286 5417185 5417355 5434708 5442398 5444738 5447228 5447985 5461412 5463428 5463688 5463845 5464405 5467320 5470385 5471564 5478966 5487578 5488425 5493889 5495664 5496713 5497395 5497455 5499284 5499323 5505447 5507237 5509220 5518184 5520806 5526229 5527095 5529472 5534322 5534883 5545471 5546194 5546616 5548340 5548455 5549073 5549249 5550536 5556113 5559689 5563114 5563727 5564781 5564866 5568394 5570170 5570483 5570494 5572871 5577769 5579614 5580104 5582158 5584570 5585245 5587115 5592687 5599096 5605290 5605818 5607040 5607728 5613032 5613308 5614841 5614889 5617399 5618471 5618621 5623397 5631379 5631760 5633009 5633073 5633267 5636065 5636254 5637389 5638182 5638686 5640167 5645793 5646598 5647304 5647512 5654236 5658289 5660845 5661783 5664019 5664495 5668244 5669659 5672750 5674938 5675559 5678569 5682392 5683807 5684836 5685211 5685715 5687305 5687510 5692581 5692725 5696581 5698937 5699005 5699039 5701109 5703443 5703450 5703484 5703761 5706095 5709060 5710268 5714377 5714562 5714639 5715271 5717666 5719417 5720234 5720734 5723480 5726425 5727878 5728269 5728286 5730414 5731352 5732260 5732346 5732366 5737820 5739680 5742842 5746099 5746268 5746535 5748587 5748964 5752694 5752700 5752711 5752714 5752886 5752905 5755606 5755869 5756296 5762916 5764363 5766424 5768025 5769278 5840089 5840350 5840553 5841304 5843417 5845045 5845153 5849556 5850326 5851195 5853495 5854745 5855705 5855824 5855909 5856342 5857475 5857575 5862287 5862424 5865565 5865935 5867998 5868049 5868103 5870213 5875447 5877934 5877983 5878206 5879414 5880835 5884797 5885418 5885920 5887993 5888324 5890516 5892157 5893006 5895115 5895730 5896174 5898105 5900239 5900506 5900544 5900597 5902795 5905778 5906191 5907687 5909968 5911095 5911432 5913327 5913493 5918546 5918577 5918604 5918610 5919264 5919487 5921992 5922192 5924180 5924631 5925874 5928867 5933017 5933486 5937934 5939287 5939669 5941547 5941950 5942522 5943719 5943737 5946044 5949611 5953186 5956964 5959683 5963586 5967615 5968443 5971338 5972943 5976951 5977733 5978516 5979305 5979421 5980520 5981452 5984774 5986306 5986435 5988209 5996230 5996801 6000980 6001230 6002065 6002072 6002087 6003071 6003108 6003685 6004012 6006373 6006388 6006407 6006592 6009616 6011453 6014542 6017294 6018192 6020007 6022256 6025844 6025984 6027587 6028557 6028768 6029550 6030413 6031991 6034018 6034451 6034721 6036889 6037196 6039329 6039956 6040862 6041939 6042387 6043161 6045345 6051831 6053567 6053591 6054240 6054489 6055452 6056710 6058885 6059173 6062044 6064453 6066548 6067932 6071289 6071678 6072574 6073597 6079069 6082586 6083916 6084901 6086362 6087286 6087708 6111479 6111732 6114196 6117573 6118087 6119621 6120019 6121044 6125341 6125559 6126205 6126508 6127175 6130202 6131293 6132918 6137968 6137981 6138769 6141333 6142937 6146463 6162120 6162909 6168086 6168375 6169660 6180943 6181175 6184271 6194087 6199373 6199463 6203196 6213612 6217433 6239184 6239779 6257877 6269865 6272721 6273173 6273187 6273395 6273708 6273713 6273720 6273724 6273725 6273727 6273732 6273734 6273743 6273748 6273749 6273750 6273752 6273758 6273764 6273765 6273768 6273770 6273771 6273827 6273912 6275129 6275133 6275135 6277183 6282391 6311966 6316892 6318919 6320437 6329024 6330542 6331591 6336519 6339686 6340058 6343633 6346676 6349653 6356355 6361253 6361433 6361436 6361440 6361443 6361464 6361469 6361470 6361472 6361473 6361587 6361984 6363132 6368102 6378161 6379631 6385527 6396410 6397250 6404766 6408911 6414483 6417500 6430615 6431152 6432075 6439912 6442149 6442499 6442747 6444726 6450420 6450989 6452406 6467580 6468247 6486915 6487210 6491820 6492075 6492624 6493253 6494943 6495698 6498732 6503450 6508722 6509008 6510362 6513210 6513356 6522994 6524616 6526103 6528990 6529095 6531519 6594835 6594915 6595761 6597692 6599610 6600521 6600986 6602212 6602428 6603832 6604431 6604780 6605063 6605162 6605229 6605908 6606435 6608873 6610714 6610739 6610762 6613719 6614282 6615830 6616666 6619406 6621082 6624297 6625823 6625846 6634066 6634158 6634634 6634746 6638094 6639406 6642072 6644670 6649094 6652325 6658931 6659054 6660857 6664213 6668097 6668134 6670312 6672370 6674318 6676631 6677727 6680380 6681637 6684364 6684714 6684841 6685674 6689904 6697717 6698680 6700022 6701103 6702527 6709709 6709773 6712314 6712414 6713408 6714003 6714415 6718527 6718662 6720691 6724635 6724666 6725314 6727500 6727520 6728620 6731134 6734072 6734222 6737648 6739098 6741557 6743634 6744654 6748772 6749185 6749532 6749786 6750019 6770121 6775201 6776065 6777078 6780180 6785949 6786411 6790199 6797072



Oracle Spatial


Oracle Spatial
4582210Local partitioned spatial index fails on tablespace transport
5097326NLS_TERRITORY=german causes problems with numeric representation in Spatial
5117577SDO_CS.transform() not supported with EPSG CRS (3005)
5197581ORA-29532 from CREATE_FEATURE
5253336shortestPathAStar() NDM Java API loops when no path can be found
5411907REMOVE_DUPLICATE vertices adds more vertices to the end of the geometry
5497674VALIDATE_GEOMETRY_WITH_CONTEXT reports false errors
5507634SDO_RELATE returns wrong results
5512782SDO_TOPO_MAP.add_point_geometry - edge should split, but does not
5554484Unable to correct invalid geometry with rectify_geometry or migrate.to_current
5671929Large memory allocation when using SDO_GEOM.RELATE
5675163ORA-29532 from SDO_TOPO_MAP.ADD_EDGE attempting to add an edge ends
5694168SDO_ANYINTERACT performs slowly on feature layers with lots of features
5738090Offseting a single straight segment produces a spurious circular arc
5743792LOAD_TOPO_MAP cannot be called multiple times in the same transaction
5750711Dump [mdgoplun] querying Spatial data
5766563Parallel create of Spatial index with SDO_NON_LEAF_TBL fails
5838363Spatial Unit of length issue in wkt
5840592SDO_LRS.OFFSET_GEOM_SEGMENT returns null values
5871002SDO_TOPO_GEOMETRY constructor fails on versioned topology
5873149Projection name problem in Spatial
5900199ORA-29885 ORA-29400 attempting to create a Spatial index
5912272Behaviour of SDO_NET.validate_network inconsistent with manual
5929643Performance problem while deleting features in hierarchical topology model
5949568Need distance stopping condition so SDO_NN/SDO_BATCH_SIZE do not scan entire table
5982684Placeholder bug for network data model fixes
5983129Partitioned local spatial index needs a way to set status to valid
6000704Wrong result returned by sdo_sam.simplify_geometry()
6004768Queries against ALL_SDO_GEOM_METADATA are slow
6011024SDO_GEOM.RELATE with 'determine' mask returns unknown mask
6027858Wrong results from SDO_RELATE
6038442Wrong results from the SDO_GEOM.sdo_intersection() function
6055668Wrong results from SDO_RELATE
6059034ORA-13363 when using 2D query windows to view 3D data
6070096Wrong results from SDO_RELATE
6070333NETWORK.addnode(link,distanceratio,istemporary) creates incorrect link geometry
6087105SDO_LRS.OFFSET_GEOM_SEGMENT returns Null for some geometries
6087331SDO_TOPO_OBJECT_ARRAY size is too small
6114292Intermittent OERI from Spatial queries
6119611bandNumbers / layerNumbers of getRasterSubset over 99 fails (ORA-13410)
6193816Errors using Spatial with index created with layer_gtype=POINT
6194209ORA-4030 / excess memory use loading new geometry
6196135Topology FACE$ has invalid MBR for faces with inner island faces
6272191Wrong results from SDO_INSIDE on touch and disjoint
6315932ORA-13249 using SDO_JOIN() with long table / schema names
6368037Spatial READ_NETWORK can be slow
6485701Decimal degree conversion factor not accurate in spatial
6602344RELATE can be slow for very large (10k vertices) geometries
8451041patch request for merge bug 8451038 on top of 10.2.0.4 for linux 64bit (226)

Undocumented Oracle Spatial
4450253 5115167 5149238 5357619 5404430 5632711 5899894 5946382 5968582 5968833 5971691 5985754 6054474 6065691 6070136 6085696 6122040 6122642



Oracle Text


Oracle Text
6166683IPZ-Linux: ctxhx missing from 10.2.0.3
2553707CTX_DOC.HIGHLIGHT returns only first query term when NOT operator is used
4360454Wrong results using Japanese V-GRAM Lexer
4439469Analyze index (table) can block DML operations with Text indexes
4531863Cursors are not closed when creating text index with multi_lexer and user_lexer
4562807OERI:[kole_t2u] / dump using gist / theme against corrupt documents
4605900DRG-51030 when using wildcard with chinese_lexer
4901547Text markup does not work properly on special characters in XMLType columns
5221677High CPU with many Text indexes
5223027CTX_DOC.MARKUP does not work with Japanese lexer
5226126Create text index fails with huge number of documents
5232076Korean morph lexer stores lower case string in $I table
5274156Dump (drexuAnalyzeQuery) from Text query
5326179No error reported in multi_column_datastore if filter fails
5329098Placeholder bug for Text Verity filter fixes
5336737A dump can occur using Japanese stemming
5345988HTML section does not index some section data
5350590CTX_DOC.MARKUP fails with ORA-20000 if document contains illegal characters
5354012Negative numbers not excluded with stopclass numbers when printjoins is set
5365424Text indexing BFILES does not index all valid documents
5378039Dump (drexudmcx) using sync (on commit) Text index with shared servers
5390154SYNC_INDEX can be slow
5438110DRG-11513 creating text index with multibyte file names
5451092Wrong characters highlighted by ctx_doc.markup()
5456354Text query on XML data can return wrong results due to XML attribute size limit
5470592Text indexing a URL can dump
5533182Create text index spins
5563839CTX_DOC.markup() highlights wrong characters
5587976Dump [drurnew] using Text
5596325Text query gives wrong results or fails with ORA-1410 ORA-29903
5631223Wrong results from progressive relaxation when table is partitioned
5687645DRVODM data mining function may fail with DRG-50857 / ORA-955
5707554DRG-11301 when creating text index with long user-lexer procedure name
5710143ctx_doc.markup() highlights wrong characters
5714888ORA-1002 when creating Text index with direct datastore
5738457ORA-20000 from Text query with no further information
5738539DRG-10502 from Sync with parallelism for another users index
5751742JAPANESE_LEXER can spin
5859738DRG-11308 when creating context index
5905735Text query can dump (in drexrdstqx)
6068474Dump (drlaload) calling CTX_QUERY.browse_words with a null
6073036Dump[dred1cm] from Text query using progressive relaxation
6122785Inconsistent results / errors from fuzzy parallel CONTAINS query

Undocumented Oracle Text
5237224 5401928 5567066 5576706 5644887 5663785 5714713 5917938 6072096 6598793



Oracle Ultra Search


Oracle Ultra Search
4474426Schema version 10.2 is not compatible for Ultrasearch component
4743226Fix for bug 3680460 incorrectly reintroduced bug 3588054
4994742Content with meta redirect not working correctly during Portal crawling
5684293RTF documents incorrectly displayed when opened



Oracle XML Developers Kit


Oracle XML Developers Kit
4292142cdata-section-elements attribute ignored when using DBMS_XMLGEN.setxslt
4318081extract query does not extract all nodes if the number of nodes exceeds 64k
4515075C++ SAX parser can fail when trying to access attributes
4886354XQuery on a collection leads to ORA-1000 "maximum open cursors exceeded"
4967236OERI[17282] processing XML
5003275Dump in XSL API for stylesheets with large number of patterns
5105337XVM processor adds linefeed in every line
5255317Memory leak XslxPathSample / DOMSample
5258225NullPointerException validating a schema using Oracle schema checker
5353998XQuery encounters LPX-601, ORA-19202, ORA-31011
5354090Leading space in XQuery results
5362697LSX-204 in schemaValidate() for element in complextype defined as 'all'
5416292XPath query against a large XML file fails with ORA-31186
5487993Dumps handling XSL
5511036LSX-290 with schemaValidate()
5573534Memory leak from XMLAccess()
5579674Wrong time stamp values are populated when using transx utility in XDK
5587299Fix for bug 4443086 is incorrect
5655847Stylesheet not working as expected in 10g
5689971Dump (under ltxvmmatchkey) using DBMS_XMLPROCESSOR
5694997xmlxvmcompiledom needs a BASEURI parameter
5700527XSL transformation fails for large XML documents
5707711LPX-242 occurs when XML documents include the ampersand (&amp;) for attribute
5934591XDK "runtimeexception: byte 31 149" when FilePageManager is used
5946122Incorrect conversion from DTD to XSD

Undocumented Oracle XML Developers Kit
5719525 5860555



PL/SQL


PL/SQL
709811PLS-123 / dump compiling package with PLSQL_DEBUG = true
4381035ORA-932 if not all select items in PLSQL dynamic select statement are defined
4435282PLSQL cannot use database link with name longer than 30 chars
4507743ORA-6502 is not raised for number precision overflow in PLSQL
4619731PLSQL may see wrong (old) value for a package variable
4644108Dump assigning BINARY FLOATs or DOUBLES to a BIND in PLSQL
4686467Spin using UTL_TCP / UTL_HTTP
5015298OERI[kpotcprc: uga depth exceeded] can occur after an ORA-1000
5029092ORA-12713 not reported for RPCs with NLS_NCHAR_CONV_EXCP set
5066528DBMS_TRACE enhancements
5123798ORA-4067 from client side PLSQL
5131945PLS-801 during PLSQL interop between 11g and 10.2
5168773Poor performance of fetch with nested tables/ADTs in 10g
5183045PLSQL dump under pevm_MOVN
5214109Corruption / OERI:kopp2ucoll700 calling PLSQL using negative array out parameters
5249142ORA-4062 from PLSQL RPC
5252427Collections (arrays) passed from JDBC to PLSQL show up as NULL
5389854Memory leak using bulk insert with SAVE EXCEPTIONS
5394728Errors / wrong results running SQL in PLSQL from old front end (eg Forms)
5415410ORA_DEBUG_JDWP may get corrupted
5436549Dump [pevm_bcsrwc] after FORALL array operation
5483284PLSQL 10g/11g interoperability problem with binary_float / binary_double literals / constants
5484847Dump (koputilassert) from 8.0 RPC to >=9i server
5575771UTL_HTTP cannot handle https connections without a content-length
5581731Errors loading wrapped PLSQL in multibyte from client other than SQLPLUS
5589275PLSQL BULK COLLECT INTO can spin
5597014PLS-707[2603] occurs while compiling a package
5599607FORMAT_ERROR_BACKTRACE returns wrong line number for exceptions inside loop
5613128PLS-707 from ALTER TABLE DROP TYPE then ADD METHOD
5637147Wrong Results from TRUNC of a timestamp in PL/SQL
5693291PLSQL optimizer incorrectly optimizes common subexpressions
585916410g PLSQL compile time slower than 9.2
5878041plsql_optimize_level=2 can significantly impact compile time of complex procedures
5890966Intermittent ORA-6502 with package level associative array
5910731Dump (pfsadt) using multiset in PLSQL
5911891Wrong results with timestamp binds in PLSQL
5924384ORA-21780 in PLSQL
5957181ORA-4043 on SYS_PLSQL_% types if similar named synonyms / objects exist
5958121Timezone problems when calling a pipelined table-function
5978646Ctrl-C when executing PLSQL can dump [pfrdlunam]
5980005ORA-6533 while indexing a collection inside FORALL
6034173ORA-3106 error when fetching into a cursor from PLSQL
6061892Memory Leak on 'PLS non-lib hp' by recursive PLSQL calls / ORA-4030 AND ORA-21780
6067804ORA-910 not signaled when pipelined function tries to return > 4000 byte varchar2
6068126Dump (pevm_instc2) using REF cursors in PLSQL
6075168Memory leak if PLSQL callout using OBJECT arguments returns an error
6121452Client PLSQL dump attempting an RPC in OCI mode without a database connection
6139946Wrong results from TIMESTAMP with TIMEZONE arithmetic in PLSQL
6214869Dynamically invoked PLSQL calls from AQ looses package globals

Undocumented PL/SQL
4686355 5001170 5368764 5706508 5866120 5918614 5944772 6028746 6040276 6071378 6273273 6273275 6273278 6273280 6275158 6361423 6361425 6373214 6416327 6435593 6632001



Precompilers


Precompilers
5214846Procobol clients may insert NULLs using host-tables with indicators
5674966ORA-1727 from ProCobol with PACKED DECIMAL

Undocumented Precompilers
5551558 5589879 6272839



SQL*Plus


SQL*Plus
4768243OSERROR not caught by SQLPLUS in 10g
4901089SP2-310 unable to open file error when file name ending with "$"
5474008SQLPLUS does not failover with RAC and DataGuard
5844617SQLPLUS returns wrong exit status using 'whenever' clause
6334570Need a target to rebuild SQLPLUS shared libraries

REFERENCES

NOTE:403616.1 - Many Child Cursors create in 10.2.0.3 on Windows and Linux
NOTE:418531.1 - ORA-7445[opidsa] after Applying the 10.2.0.3 Patch Set
NOTE:434500.1 - When Starting A Database With The 10.2.0.3 Executables, Error "ORA-15059: invalid device type for ASM disk" Occurs
NOTE:453259.1 - ORA-600 [KCRFR_RESIZE2] while applying archivelogs created with a big log_buffer
NOTE:453309.1 - Fix for Bug 5454831 Can cause ORA-600 errors in RAC/CRS Environments

BUG:5015469 - OPROCD REBOOTS NODE WHEN TIME IS SET BACK BY XNTPD


BUG:5260266 - ORA-07445 ACCESS_VIOLATION 0X81B43D WHEN USING TG4MSQL




BUG:4364202 - DATADICTIONARY IS NOT CLEANED UP ON TIMEOUT ON ALTER INDEX REBUILD ONLINE
BUG:4513695 - SELECT WITH ROWNUM=1 PERFORMANCE IS TOO LATE USING CURSOR_SHARING=SIMILAR
BUG:4701527 - CURSORS NOT SHARED WHEN EXECUTING PROCEDURES OVER A DBLINK


BUG:6085625 - ORA-01483: INVALID LENGTH FOR DATE OR NUMBER BIND VARIABLE
NOTE:455832.1 - Core dump - Access Violation in Client Applications After Upgrade to 9.2.0.8, 10.1.0.5 , 10.2.0.x 11.1 and the client or server is still a prior version
NOTE:467881.1 - Oracle Critical Patch Update - January 2008 and Beyond
NOTE:468572.1 - ASM instance may hang or RDBMS instance may crash with ORA-600 [2103] error
NOTE:471479.1 - IOT Corruptions After Upgrade from COMPATIBLE <= 9.2 to COMPATIBLE >= 10.1
BUG:6087207 - WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES

NOTE:245840.1 - Introduction to "Bug Description" Articles
NOTE:316900.1 - ALERT: Oracle 10g Release 2 (10.2) Support Status and Alerts
BUG:6057203 - ORA-00600 [KCBCHG1_6] RUNNING AN UPDATE WITH PARALLEL HINT
BUG:3566511 - REQUEST FOR BACKOFF/RETRY SOLUTION TO INDEX REBUILD HANG PROBLEM IN 3315378
BUG:5508574 - ORA-00600 [99999] , ORA-07445 [KGSCDUMP()+673]
BUG:5844816 - SRVCTL STOP DATABASE TRIGGER FSFO
BUG:5863519 - SIGSEGV, ORA-7445 [KCLCSR()+18368], LMS2 PROCESS DIES, INSTANCE DIES
BUG:5877437 - TG4DRDA CAUSES SQLCODE=-102, SQLSTATE=54002 USING CONCAT FUNCTION

NOTE:454464.1 - Various Dumps/ Instance Crash possible - Bug 5605370
 
 

相关内容

   
 
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值