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

Subject: 10.1.0.4 Patch Set - List of Bug Fixes by Problem Type
  Doc ID: Note:295763.1 Type: README
  Last Revision Date: 12-DEC-2005 Status: PUBLISHED

Bugs fixed in the 10.1.0.4 Patch Set

This note lists the bugs fixed in the 10.1.0.4 Patch Set. Bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a Support Bug Description.

Notable exceptions and omissions

Security Alert Issues fixed in the 10.1.0.4 Patch Set

Fixed Bug# Security Alert# Document Summary

10.1.0.4 Bug Categories



10.1.0.4 Bug Fixes by Category



Symptom


Corruption
3022968 Serializable transaction is not properly isolated
3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
3966709 Range/object reuse prematurely (ORA-8103)
4026166 Capture process discards MVDD info for renamed tables
4053888 ORA-1499 diagnostic trace does not dump REDO for the table block

Corruption (Corrupt Export)
3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)

Corruption (Dictionary)
3370649 IOT partitions in bigfile tablespaces do not show in DBA_TAB_PARTITIONS
3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
3798917 Duplicate DEFAULT_TBS_TYPE in DBA_PROPERTIES after upgrade to 10g

Corruption (Incorrect / Missing Corruption Checks)
3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
3853023 False ORA-8103 from EXPDP exporting an ASSM managed IOT
4002681 Log apply terminates due to corrupt redo log block header

Corruption (Index)
2942185 Corruption occurs on direct path load into IOT with ADDED columns

Corruption (Logical)
3878264+ Output from CTXLC corrupt on some platforms
2660473 Export of a renamed table leaves the trigger pointing to the old tablename
3111464 Fast refresh gives wrong data after update of filter column from null to value
3534299 SQLLDR may load corrupt NUMBER data for invalid ZONED DECIMAL data
3571946 DELETE trigger does not fire on delete with index scan
3648071 NAN float data can be inserted despite event 10890
3676337 Wrong data inserted into column when setxxx() called twice with different types
3682068 MV log changes not recorded with complex statement
3686945 Long CLOB data not updated correctly with LOB buffering in multibyte DB
3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
3700058 Rollback to a savepoint with a DB link can result in a full rollback
3740473 Wrong row deleted when using ROWNUM over a view with an ORDER BY
3743437 Corrupt packed decimal data loaded by SQLLDR conventional path
3743445 Direct path SQLLDR may load incorrect numbers for PACKED DECIMAL data
3823379 Data corruption inserting with 10g JDBC OCI drivers to UTF8 database using batching
3823608 Conventional path load may load incorrect scale/precision for numbers
3824149 Missing data possible from Insert as SELECT over database link
3876715 Cannot set a fractional portion of a TIMESTAMP in an ADT
3892672 Data inconsistency replicating between different character sets (Streams)
3908083 SQLPLUS COPY truncates long data with gateway connections
3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
3917532 AnyData objects with length 232/233 may become corrupt - affects Streams
3918257 Streams capture misses out of line clob data with 9.2 compatibility
3960844 Switch to logical standby may not see active PLSQL changes (data missing)
4025276 Bind corruption with Thin driver binding NULL OracleTypes.FIXED_CHAR

Corruption (Physical)
3806172* Logical standby apply may stop with ORA-355 / ORA-353
This bug is alerted in Note 280832.1
3069818 Corruption possible modifying a migrated or chained row
3641963 Transport of a table with LONG RAW and added columns is corrupt at target
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3785333 DROP COLUMN may drop wrong columns in an IOT with OVERFLOW
3811391 Updates to IOTs beyond column 255 in non-key piece can corrupt the IOT
3859298 Block corruption with high INITRANS or rapid ITL growth.
3953458 Array insert to IOT with supplemental logging can corrupt the IOT
4000840 Update can cause block corruption

Corrupt/Bad Backup
3664004* RMAN "backup recovery files" command skips image copy backups
This bug is alerted in Note 278631.1
3575797 XMLSchemas and types are not exported in table and tablespace mode export
3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3844804 RMAN DELETE .. BACKED UP n TIMES can delete an archivelog not yet backed up
3955213 EXPDP may not export all private SYNONYMs

Deadlock
3381218 Deadlock involving 'library cache lock' X mode request
3540821 ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster
3562032 Cancelled ONLINE index rebuild can deadlock with DML session
3585808 JDBC deadlock possible between threads
3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
3624510 JDBC deadlock between oracleConnection / scrollableResultSet
3627263 Deadlock / hang during RAC instance startup
3641819 Undetected deadlock possible in RAC
3646162 False deadlock (ORA-60) in a RAC environment / TM lock mode change
3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
3756949 Sequences can deadlock on space allocation failure
3777178 TA / US enqueue deadlock during transaction recovery in RAC
3896974 ORA-4020 creating DIMENSIONs from schemas simultaneously
3975268 Deadlock possible after gathering statistics for certain SYS objects
3990235 Deadlock in disk drop and instance recovery in ASM

Excessive CPU Usage
3537086 High CPU usage during parse for bitmap plans
3756797 High CPU may be used during parse of certain query forms
3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
3941723 Streams apply may use a lot of CPU with no messages
4042122 Excessive parse time with cost based transformation

Fix Is Considered An Enhancement
3264021 New DBMS_LDAP interface needed for large binary attributes
3395082 SYSMAN PLSQL objects should be kept at instance startup
3554127 Ultrasearch searchlet cannot configure via OID / service registry
3562142 Enhancement - improved performance of utlip / utlrcmp
3697152 Diagnostic to dump memory when a bad KGHU magic number is seen
3795329 Stack trace unwind is slow on some platforms
3797523 Enhancement - Include stack information in systemstate dumps
3819875 Cost-based transformation does not work with objects
3868840 _DB_BLOCK_CACHE_PROTECT has high overhead
3881099 ORA-1280 diagnostic enhancement
3903913 Streams spill data hard to decode
3906430 SSL enterprise users should not require certificate DN to match OID dn
3980583 Dump (inspre0) from DML involving GV$ views
4029071 Enhancement: Allow CRS startup to be detached from DB instance startup
4053888 ORA-1499 diagnostic trace does not dump REDO for the table block

Hang (Involving Shared Resource)
3626461 CRS hang after reboot on master node
3626463 Hang possible on 'ges inquiry response' after reconfiguration
3634252 PMON unable to acquire latch when JOB_QUEUE_PROCESSES altered
3801483 Instance hang possible in RAC
3951017 Sessions hang with 'gc cr multi block request' / UDP overload

Hang (Process Hang)
2997330 Hang on library cache pin/lock
3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
3362575 Hang possible resolving classes in the JVM
3381218 Deadlock involving 'library cache lock' X mode request
3400979 Dump of FILE_HDRS may hang or error (can result in OERI [2103])
3476477 RAC session can hang
3509265 SHUTDOWN may hang with "waiting for instances to leave: N"
3520103 ASM instance hang on "DFS lock handle"
3562032 Cancelled ONLINE index rebuild can deadlock with DML session
3566511 ONLINE index rebuild can cause DML sessions to hang.
3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
3625370 CGS nested reconfiguration may hang
3630273 Apply may hang during initialization with RAC primary
3632400 LMS may hang in kslges() waiting for a post
3644481 ASM instance hang (wait for DD enqueue)
3676676 Ctrl-C/interrupt ignored for query over DB link
3717619 Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
3724485 Enqueue waits may occur with no obvious holder in RAC
3802873 LDAP connections can not be established from MTS dispatchers
3833893 SMON may hold the TT enqueue preventing alter of TEMPORARY TABLESPACE
3843318 OERI[ksxpwait10] / hang possible in RAC
3852108 Concurrent truncates on global temporary table cause library cache lock waits
3876785 XML Parser hangs when processing with multiple threads
3926395 Apply execute error fails on very large transactions
3928153 "alter database [stop | abort] logical standby apply" hangs
3990235 Deadlock in disk drop and instance recovery in ASM

Hang (Process Spins)
3771668+ Poor INSERT performance with ASSM
3206228 Query on V$SQLTEXT_WITH_NEWLINES spins for certain HASH_VALUE predicates
3300215 Parse of an OUTER JOIN on nested tables spins
3458438 Update a long >4k that affects more than 1 record over DB link hangs
3508608 CR request retry can spin in RAC for LOB data
3654532 Spin possible from query rewrite with temp table transformation
3669661 Spin possible registering certain XSD
3796771 Server spin in multibyte from DESCRIBE operation
3822213 Explain plan with STAR transformation may spin in qkaPobs
3831971 Streams Qxxx processes may spin when there is no load

Install Is Not Performed Correctly
3761763 SDO_GEOMETRY invalid during install if object in recycle bin
3936668 Ultrasearch validation procedure schema incorrect

Instance May Crash
3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
3566420P* Solaris: OERI:[KSLAWE:!PWQ] can occur in 9.2.0.5 on 64bit Oracle on Solaris
This bug is alerted in Note 271084.1
2901988 PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
3037154 PMON may die with ORA-601 (rare)
3439552 OERI[4406] possible in SMON using automatic undo management
3440376 OERI[kclfadb_2] / LMS crashes the instance
3482748 LMS may die with OERI:kclfbbast_2
3613126 ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
3615072 PMON can crash the instance with [plio.c: non-reusable inst]
3638695 PMON may crash instance cleaning dead process
3640947 CRS addnode may crash existing instances
3671299 PMON may dump (kslcll) crashing the instance
3671867 OERI[kclchkinteg_2] possible in RAC environment
3679713 OS kill of a process performing ASM IO crahses instance with OERI[kffmrequestfree_1]
3724485 Enqueue waits may occur with no obvious holder in RAC
3754474 OERI[kghfre3] possible with heavy IO workload
3799470 RAC LMD crashes instance with dump in kjddgmak
3819836 OERI[1155] / instance crash possible
3857822 OERI:kfuitrninit_1 possible in ASMB when using ASM
3892704 During reconfiguration processes may fail with OERI:kjuocl1
3903314 Crash due to OERI[kfkOsmUpdReq] with ASM after IO error
3906669 LMS may fail with OERI[kjbmpclo:cvt]
3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
3940412 PMON dump (kgllccl) cleaning up a killed process
3948384 ORA-4031 possible using LGWR ASYNC for archiving
3953494 ASM instance may crash with OERI[kfkupdateufsreq1] after rebalance of diskgroup
3983699 Dump (pfrdef1_get_tdo or kgicsr) with SERIALLY REUSABLE packages with ADTs
3996802 "alter system kill session" can crash the instance if IO slaves used

Latch Contention
3797171 "cache buffers chains" latch contention increased in 10g
3885860 Latch contention form concurrent reconfiguration and SYSTEMSTATE dump
3941893 Latch contention in cursor cache when flushing AWR SQL statistics
4063046 Latch contention due to leaked CR pins for LOB data

Leak (Memory Leak / Growth)
2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
3194997 DDL against domain indexes can use lots of memory
3218825 Memory leak when Java Stored Procedure executed from PLSQL
3258467 High memory consumption from sessions using very many PLSQL packages
3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
3611423 PGA memory leak in AQ propagation process(J000)
3630538 Memory leak on PObject::pin() in OCCI client
3650803 Memory leak in G4DRSRV Gateway process
3667108 Excessive memory allocated when constructing mdm model
3679149 OCISessionRelease not releasing memory for invalid connections
3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables
3756908 OCI client memory leak with End-to-End tracing enabled
3787833 ORA-4030 / excess memory use when an XML schema is registered
3789433 Memory leak possible from lmmrealloc
3795386 Insert as select of LOBS / XMLType across DB Link can leak memory
3802111 Streams capture memory leak
3809246 CRSD memory leak
3825144 Excessive memory use / poor performance for CONNECT BY
3826792 JDBC OCI leaks client side memory when calling PLSQL with REF CURSOR OUT bind
3836164 ORA-4030 / high memory use from SQL with many views/branches
3853332 OCCI client memory leak using statement::setString()
3854034 OERI[733] optimizing SQL using bitmap indexes
3857050 LMON leaks memory when another instance leaves or join the cluster
3908058 Memory leak when using protocol.ora validnode_checking
3919585 Small memory leak due to oracle.xml.util.qxnamehash$weakvalue references
3926395 Apply execute error fails on very large transactions
3948384 ORA-4031 possible using LGWR ASYNC for archiving
3964817 Memory leak in external procedure for OBJECT arguments

Leak (Resources Eg: File Handles)
3546019 Cursor leak from interMedia image matching index inserts and updates
3571263 Excessive build-up of distributed transaction locks (DX locks)
3647829 Cursor is not always closed when database link closed (ORA-1000)
3679149 OCISessionRelease not releasing memory for invalid connections
3764557 ASM LGWR / DBWR do not release disk after it is dropped
3940410 Cursor leak (ORA-1000) from DML if concurrent session is creating a Text index ONLINE
3957178 Cursor leak on error in apply (ORA-1000)

Memory Corruption
3466737 Memory corruption optimizing SQL with OR predicates
3642764 PGA corruption possible with CURSOR_SPACE_FOR_TIME if NLS parameters altered
3724548 OERI[kglhdunp2_2] / OERI[1100] under high load
3737547 Client memory corruption when fetching NULL data
3800160 Internal error / memory corruption using ASM with KST trace
3802438 OERI[17148] / SGA heap corruption with NUMA pools
3830455 Memory corruption possible for invalid ISO2022 escape sequences
3884912 Dump (kghalp) can occur
3928828 OERI[kghfrh:ds] / memory corruption from AQ
3958875 Dump / memory corruption from Text index of EMAIL with long epilogue
3964487 Java stored procedure can corrupt memory in MTS
3990826 Library cache recovery structures are not cleaned up properly (SGA corruption)

Performance Affected (General)
3894096+ Poor MView refresh performance in ASSM tablespaces
3535015 DBMS_STATS slow for partitioned tables with many partitions
3588448 Waits for 'global cache cr request' on RAC if UDP overflow occurs
3588633 Manual shrinking of the buffer cache takes a long time
3611471 High latch waits for "cache buffers chain" latch possible
3797171 "cache buffers chains" latch contention increased in 10g
3857903 LMS not posted by LGWR when hot current block requires a log flush during BAST
3893567 Concurrent SYSTEMSTATE dumps can impact performance
3948711 XA with database links may dump or perform slowly (link closed)

Performance Of Query/ies Affected
3771668+ Poor INSERT performance with ASSM
3177513 Join not avoided using bitmap join index if UNIQUE index exists also
3183084 Performance hit / OERI for index maintenance if TEMPORARY blocksize < index blocksize
3193835 Unnecessary partition scanning depending on predicate order
3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
3359905 CONNECT BY much slower in 9.2 than 8.1
3436577 View merge does not occur for CTAS when it does for the SELECT
3440097 Suboptimal plan with count(column), bitmap index and view
3447032 DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
3491127 DBMS_STATS.GATHER_INDEX_STATS does not gather correct partitioned index stats
3499674 CBO may overestimate cost of NL join with index
3520157 Create index using FFS slower than create index from table
3530612 Dynamic partition pruning may not occur on MERGE
3533996 Using transportable tablespaces disables intra-partition PDML
3537086 High CPU usage during parse for bitmap plans
3537749 HW enqueue contention when loading lob data
3537765 SET queries with DISTINCT in query branch may have poor performance
3545209 Poor performance from semi join with NL to remote table
3566361 DBMS_IOT.NUMBER_TO_UROWID is slow
3566843 Optimizer may not choose best index
3567928 Suboptimal plan with range predicates on CHAR columns with numeric literals
3582445 Predicate on PARTITION BY clause of WINDOW function not pushed into view
3601653 Subquery partition pruning does not work with SYSDATE predicate/s
3607226 No predicate pushing into UNION ALL view with analytic function/s
3611471 High latch waits for "cache buffers chain" latch possible
3614289 Index range cost with predicate on descending key may be too high
3617028 CBO suboptimal plan for multiple 'or' conditions
3620168 DBMS_STATS may set AVG_ROW_LEN to 100
3622251 Redundant range predicates against CHAR columns not removed
3632885 In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
3637851 Additional "no-op" predicate can reduce CPU
3643862 OUTLINES can fail to freeze plan because some hints are not generated
3668224 Bind peeking does not occur for predicates of the form COL <op> FUNC(:bind)
3690369 Incorrect cardinality estimation when using LIKE predicates
3723007 Predicate push down may not occur in 10g (when it did in 9i)
3731042 Optimizer may not cost sub-query unnesting correctly
3731299 Cost based transformation may choose not to push join predicate when it should
3731357 Optimizer does not push join predicate when ROWNUM exists
3735785 Pro code with SQL_CURSOR array fetch uses single row fetches and no prefetch
3737955 Long parse times for long inlists / many AND/OR terms
3742802 Full table scan possible if selectivity of BETWEEN is 0
3745580 Poor performance from SORT MERGE JOIN plan against UNION view
3746423 Sub-optimal execution plan for range partitioned table with INLIST
3756797 High CPU may be used during parse of certain query forms
3777256 Functional indexes on CASE expressions may not be used
3780242 Query unnesting not happenning when uncorrelated subquery has ROWNUM>=1 predicate
3823191 Unnecessary sort when access made through a local index
3825144 Excessive memory use / poor performance for CONNECT BY
3830853 DELETE during REFRESH of MJV can have poor execution plan
3834770 CBO may not unnest an EXISTS() subquery with a view in the FROM clause
3855006 Sub-optimal plan with or expansion due to join order control
3859342 Sort is not parallelised in a view query with MINUS (or INTERSECT)
3867374 Zero cost possible for nested loops access to table with single bitmap semijoin
3880640 Query with ALL operator make get suboptimal plan
3889123 DB_FILE_MULTIBLOCK_READ_COUNT higher than 16 blocks has no effect in RAC
3896254 CBO used with default statistics used when DB2STATS = FALSE
3899748 Incorrect join cardinality for lossless NVL predicates
3906520 NULLs cause poor index range scan performance
3926149 XDB queries can show worse performance in 10.1.0.3 (to 10.1.0.2)
3929805 Slow execution for insert as Select over DB Link with NULL in select list
3940507 Optimizer may not push join predicate inside views with constant columns
3940888 Sub-optimal possible with bind peeking
3945774 Sub optimal plan possible for query blocks with many tables
3950045 Wrong cardinality (CDN) with functional indexes
3953483 Complex view merging does not occur for Insert as Select
3956141 OR filter in CONNECT BY query may be applied at table level
3958887 Incorrect NDV for index statistics with many duplicates
3966573 Sub-optimal plan with CONNECT BY and ROWNUM
3996053 Inefficient dynamic partition pruning SQL
4011806 Performance degradation in PLSQL loop in 10g
4012809 Wrong cardinality estimate causes join predicate to not be pushed down
4042122 Excessive parse time with cost based transformation

Shared Pool Affected
3768052 PLSQL Commit / Rollback wastes cursors and is slower than 8i
3941893 Latch contention in cursor cache when flushing AWR SQL statistics

Storage Space Usage Affected
3219117 LOB SEGMENT uses more space with ASSM
3516451 ALTER TABLE x SHRINK CASCADE does not shrink indexes
3687210 SUMDELTA$ rows never purged
3957037 LOB segment with PCTVERSION may use more space than expected
3970279 LOB segment with retention configuration grow in ASSM tablespace
4137362 Idle Oracle Forms sessions incorrectly appear in Active Session History

Wrong Results
2055862 OracleCachedRowSet.getRow() returns wrong value after last()
2365168 Wrong results with PQO and partitioning
2738493 Wrong "session connect time" / "process last non-idle time" in V$SYSSTAT
2846640 Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
3017095 ALTER MVIEW COMPILE does not update LAST_DDL_TIME in DBA/ALL/USER_OBJECTS
3081127 View for remote table with CHECK OPTION never reports ORA-1402
3111464 Fast refresh gives wrong data after update of filter column from null to value
3128363 OCIAttrGet returns wrong size when CURSOR_SHARING=SIMILAR or FORCE
3141614 TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
3175661 Query rewrite can give wrong results for "NOT IN"
3177769 Wrong results OR predicates inside AND chains of OR predicates
3188637 Wrong result with star transformation and OUTER join
3250883 Inline view using functional index can give wrong results
3258390 V$SESSION.SCHEMANAME may return wrong value in PLSQL of another user
3298019 Unreliable results with new_german_spelling enabled
3318204 Parallel query gives wrong results with view
3324698 Wrong tokens produced using numjoin and numgroup
3333863 DBA_JOBS.LAST_DATE is set even if the job runs with failures
3347567 Wrong results from V$SGASTAT for STREAMS_POOL
3351150 V$SQL_BIND_CAPTURE shows NULL bind names for duplicate binds
3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
3355043 The MIN analytic returns bad data when selecting from nested collection type
3357740 Wrong results from external table in subquery
3374251 copyEvolve() does not reset modification date
3377931 SAVE EXCEPTIONS does not work reliably with a partitioned table
3385243 Wrong results from PQ against partitioned tables
3396223 wrong results with function based index and DECODE function
3406229 XMLTransform gives wrong results
3406611 Wrong results accessing data via a function based index
3417593 Cross platform piecewise fetch of varchar2 data can result in corrupt data
3430105 Parallel full scan of an external table may "SKIP" more rows than defined
3446722 Wrong results from CBO with constant predicates and CHAR = VARCHAR2 column
3454019 Wrong results from wildcard in CATSEARCH / CONTEXT predicate with PREFIX INDEXING
3472564 "CPU used by this session" wrong when using job queue processes
3472676 ArrayIndexOutOfBoundsException or corrupt data changing fetch size between fetches
3477460 Query rewrite can return wrong results
3491603 Wrong ORDER BY from parallel execution
3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
3499258 SQL MIX/MIN functions against CHAR data return as VARCHAR2 in PLSQL
3500762 V$SYSMETRIC_HISTORY "current logons" count is wrong
3523279 Wrong results from UNION in a PLSQL block with CHAR data
3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
3546774 STATS_CROSSTAB gives wrong results if there are cells with 0 frequency
3557094 "NID" leaves stale v$recovery_file_dest information
3559212 Wrong results possible from CBO with multi-table OR list
3559340 V$OSSTAT may contain no data on some platforms with large number of CPUs
3579719 Wrong data length returned selecting CHAR column over HS
3582296 UNION [all] statement in PLSQL may give wrong results
3584515 Wrong results when ANSI syntax does not trap ambiguous column with ORA-918
3585330 getDate on Ultrasearch searchlet Resultset returns null
3599966 Wrong results when multi-column SMJ used after semi-join elimination
3625392 wrong results / dump (evaopn2) with star transformation
3629771 Wrong results possible from COMPRESS KEY INDEX SCAN
3632450 TO_MULTI_BYTE/TO_SINGLE_BYTE do not work on a UTF8 database
3632504 Wrong results from EXEC SQL LOB READ from NCLOB
3637267 Varchar2 is blank padded when local DB charset is different from remote site
3637624 wrong results with DISTINCT and aggregates
3648071 NAN float data can be inserted despite event 10890
3650346 Public synonym resolution fails under certain circumstances
3652356 Wrong GMT offset using TO_CHAR with TZD or TZH:TZM
3654015 SQLLDR direct path may incorrectly reject rows (ORA-2290) with CHECK_CONSTRAINTS
3663103 getTimestamp may return truncated time value using Calendar parameter
3668084 Wrong results from nested FULL OUTER JOIN
3669074 Some V$SHARED_POOL_RESERVED contain incorrect data
3672097 Wrong results HASH join of CHAR / NCHAR over database link
3678133 Wrong result from DECODE with arguments which evaluate to NULL
3682147 Missing bytes fetching RAW OUT PLSQL parameters with JDBC Thin
3683056 Wrong results possible from nested loop join with index scan
3685171 sqlerrd(5) does not return correct value on SQL errors
3688320 Wrong result with parallel query having SMJ and inequality join
3691588 OLAP EVERY function does not loop correctly
3696879 Wrong results from ANSI query with subquery in the ON condition
3699264 Wrong results from XDK if XPATH contains start-with()
3713138 OrdHttpUploadFile.simpleFileName returns wrong filename if name contains a ']' character
3742674 Wrong results possible from ROWID access of single partition
3748199 OCCI Object cache does not support global transactions
3753308 NLS_SORT not applied implicitly to window functions
3754340 FLOAT values loose precision when selecting against a view with a UNION
3754628 Wrong results from illegal query with OUTER joined column in BETWEEN clauses
3755693 Wrong results form index skip scan for LIKE with a wildcard
3757265 OCCI getNumArrayRows next() method returns cumulative row count
3759560 Wrong result using Oracle Object Type with nested subtypes - may appear as NULL
3760380 NULL value for ROWNUM when using an OVER WINDOWING clause
3760954 OCCI::ResultSet::next(N) method can return the END_OF_FETCH when data exists
3762653 Null indicator not set when setting iters = 1 in OCIStmtExexute
3763395 Incorrect ROWCOUNT from BULK FORALL INSERT SAVE EXCEPTIONS with partitioned tables
3768069 Wrong results in subquery unnesting with semi/anti joins
3782820 Wrong results for access by ROWID for ASSM segments
3792845 MODE=ANSI client may get error 100 instead of correct error
3800215 Variable assignments not working in PLSQL loops
3801102 Column values missing in SELECT with correlated scalar subquery in outer join
3812263 Wrong results from semijoin elimination with OR expansion
3815921 Wrong results possible from predicate move around
3816946 Dump (kafger) / wrong results from table scan of compressed table
3823887 Dump / wrong results from NVL expansion
3828269 Wrong results possible when a space character is scanned with a unique index
3828598 Wrong results with unnested remote subqueries
3831897 No rows from query against nested table view column when multiply referenced
3837903 wrong results from complex view merging with correlated subquery in select list
3849938 DBMS_SPACE.UNUSED_SPACE returns wrong block_id for last extent used
3852274 Dump / wrong result from invalid AL32UTF8 character
3855809 Parallel query with OUTER JOIN and ORDER BY returns results unsorted
3858017 Array insert with "EXEC SQL FOR" gets wrong value for SQLERRD[2]
3861541 UTL_LMS.GET_MESSAGE can return wrong character set string if LANGUAGE specified
3884962 Dump [kxspoac] / wrong results possible with SQL from PLSQL
3888015 PLSQL table of records table.count is not incremented
3892220 Wrong results from OUTER join to VIEW on literal in view select list
3896119 CURRENT_UTILIZATION of V$RESOURCE_LIMIT may be too high
3896236 Wrong results with semijoin elimination with NVL-based OR expansion
3897407 Wrong results from OUTER JOIN with FUNCTIONAL INDEX when the OUTER is negated
3911544 Wrong results from select with "OR" expansion on composite partitioned table
3924156 SDO_WITHIN_DISTANCE returns false positive comparing polygons
3925069 Wrong COLUMN_TYPE returned by getProcedureColumns for a Date parameter
3941526 Wrong results from cost based predicate push into UNION/UNION ALL views
4007071 Wrong results selecting from TABLE() collection
4082974 SQL with view push predicate plan produces wrong results
4154591 Wrong results from single table joinback elimination

Error May Occur
3806172* Logical standby apply may stop with ORA-355 / ORA-353
This bug is alerted in Note 280832.1
3502868I IMPDP cannot be used in Standard Edition (ORA-39002 / ORA-439)
3770993P Win: AUTOSTART database fails with ORA-1012 during OS boot
2233987 ORA-1460 from 8i -> 9i SELECT when database uses AL32UTF8
2270510 IMP-58 / ORA-22337 importing evolved type object table
2391697 ORA-235 doing backup with RMAN in nocatalog mode
2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
2747350 Continual ORA-4061 after modifying PLSQL body for PLSQL called from SQL
2822740 Procobol PCB-S-00400 error while parsing SELECT CASE expression
2857330 ORA-1008 from Binds in CURSOR subqueries using WITH
2858082 False ORA-1652 in alert log when there is free space in RAC environment
2876340 ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
2931779 False ORA-1555 accessing "cache read" LOBs in RAC
2965256 ORA-12714 using SQL function on NVARCHAR2/NCHAR operands
2966778 Intermittent ORA-904 errors during heavy load
3026474 ORA-20000 from DBMS_STATS importing table stats with missing column
3040464 Views defined as selecting ALIAS.* should be expanded
3083673 ORA-942 when selecting from another users view which uses WITH
3165930 False ORA-1436 from query with non connect by prior preceeding connect by prior
3202079 ORA-1044 binding large buffer using a dedicated connectionf
3237530 Intermittent ORA-25248 errors in alert file using AQ
3242079 Using quotation marks with PLSQL variable names can result in errors
3278020 ORA-942 creating MVIEW across dblink from 9i to 8i for object table
3320638 ORA-957 on "ALTER TYPE" not final cascade convert to substitutable
3339218 ORA-26571 performing DML on a replicated table
3352279 ORA-14093 / wrong results from subquery pruning with composite partitioned table
3372808 ORA-1265 after DROP DATABASE command
3372915 Text query with bind variables in CONTAINS may raise false parse errors
3384030 ORA-6502 on data pump export with DDL over 32k
3387352 Insert on scrollable ResultSet with ORDER BY gives ORA-1732
3394821 oracleDriver does not work in applet mode
3412553 ORA-942 during functional invocation of CONTAINs on another user's table
3412625 DBMS_METADATA cannot handle AQ queue comments over 50 characters long
3413436 Oracle Text may fail with ORA-1480 errors
3418978 ORA-1 may be thrown immediately for a deferred constraint
3430426 ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
3431498 extract and existsnode may ORA-29900 with three operands
3437943 ORA-12514 if database is created using new port listener in 2nd home
3447792 Multi-table insert can fail with ORA-24335
3452566 Start / abort of multiple instances can leave ASM diskgroup unmountable
3454691 XML parser error inserting valid XML with ampersands in CDATA tag
3456977 ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
3465087 ORA-905 possible from CAST() over DB link if "AT" clause is a column name
3471389 OCIBindByPos fails for PLSQL associate array bind with varchar2(4000)
3472676 ArrayIndexOutOfBoundsException or corrupt data changing fetch size between fetches
3479073 Capture process aborts with ORA-25303 alter ALTER QUEUE TABLE changing instance
3488157 Data pump import of list-partitioned IOT returns ORA-39083 / ORA-926
3492211 ORA-23308/ora-23309 replicating pre-created tables with LOB
3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
3510694 ORA-29875 (ORA-1402) raised during concurrent operations on Text indexes
3527043 ORA-6502 "character string buffer too small" for 1001 char if NLS_LENGTH_SEMANTICS=CHAR
3533428 ORA-904 SYS_TBL$3$.ID running query with GROUP BY CUBE and CONNECT BY
3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
3536149 Element name in SQLX XmlElement() function limited to 30 characters
3540821 ORA-4020 deadlock from concurrent ANALYZE index / query compilation against a cluster
3553962 ORA-18003 rebuilding an outline for SQL with leading spaces
3557842 ORA-903 with UNION ALL in a view
3573951 dbms_output.enable does not honor "buffer_size" correctly
3576897 ORA-22804 inserting over a database link with select using CASE
3578503 CLOB to VARCHAR2 assignment fails in PLSQL clients (ORA-6502)
3579567 Corrupt export exporting a compressed table with direct=y (IMP-9)
3588345 Create spatial index fails with ORA-13249
3591564 ORA-1756 importing functional index with CHR(0) in its expression
3595731 PCB-S-00400 with FORMAT=TERMINAL and using DECIMAL-POINT
3596139 ORA-10632 on direct path export of IOT
3597439 ORA-1153 starting managed recovery when an RMAN backup is running
3601775 IMPDP generates invalid SQL for sequences with large maxvalue (ORA-39083 ORA-933)
3609791 SQLCODE -310 / incorrect SCALE over HS for numbers with zeroes after the decimal place
3616743 ORA-24324 in OCCI trying to set a transaction on a service context
3618700 SQL apply/alter user/role fails with ORA-28003 / ORA-28221
3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
3628621 ORA-6502 from DYNAMIC SQL in AL32UTF8
3631932 SYS_OP_PAR() fails with ORA-979
3639020 XML processing instructions in a simpletype fails validation
3643391 ORA-4043 "object does not exist" using a SYNONYM of a TYPE in JDBC
3643476 RENAME of partition/subpartition can throw ORA-54
3644243 Create MVIEW on scalar subquery in SELECT list gives ORA-22818
3646305 ORA-942 from MVIEW refresh after dropping and recreating table
3648209 BACKUP .. FOR RECOVER OF COPY fails with RMAN-600[13215]
3649839 Intermittent ORA-12805 on internode parallel create/rebuild index
3650346 Public synonym resolution fails under certain circumstances
3662892 Procobol errors for HOST VARIABLE / COLUMN NAME with multibyte character
3668572 ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY
3671655 ORA-22805 flushing objects in OCCI in XA environment
3684796 ORA-904 when explaining GROUPING SETS query with fine grained auditing
3696284 ORA-1457 on FETCH after odefin for packed-decimal
3716255 ORA-21500 can occur querying an XMLType table with the fix for bug 3454829
3726694 First update with a new OLS label gets ORA-28115
3732747 False ORA-1007 using DBMS_SQL.DEFINE_COLUMN
3733108 ORA-20000 in DBMS_UTILITY.COMPILE_SCHEMA/ANALYZE_SCHEMA on mixed-case object names
3733669 Ultrasearch crawl removes already crawled tokens
3747472 ORA-14642 on EXCHANGE PARTITION INCLUDING INDEXES
3761784 Capture stops while mining through upgrade/patch on primary
3766568 ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte
3766919 DRG-10837 after upgrade of UltraSearch to 10g
3769884 Apply aborts on first DML after handler changed when ORA-4068 encountered
3776668 ORA-1478 from distributed transaction between 8i<->9i with different character sets
3787344 ORA-32321 occurs when executing fast refresh
3804250 DML to a remote table from a table with FGA fails with ORA-904/ORA-2063
3818542 PLS-907 from pre-10g PLSQL client executing package with overloaded function
3831513 Import to different character set can fail (PLS-103) if PLSQL contains a NEWLINE in quotes
3858625 Insert of long over DB link with NULL binds may ORA-24343
3861534 ORA-31076 on registering xml schema with no "schemaLocation" <import> element
3866448 Online table redefinition encounters ORA-12018,ORA-904
3896963 ORA-942 when using WITH clause and UNION ALL together
3903530 UTL_HTTP HTTPS via proxy server requiring user authentication fails with ORA-29268
3907008 VARCHAR2 IN with bind size > 31 fails with ORA-6502
3923624 SQLException "Bigger type length than Maximum" from REF_CURSOR in JDBC Thin
3933012 ORA-904 from IN subquery with UNION ALL having co-located remote references
3941862 ORA-16132 during regular graceful failover
3946544 EXP-62 if the header of a wrapped TYPE contains a comment
3946694 XA recover throws ArrayIndexOutOfBoundsException
3953131 Altering first_scn of Streams capture results in ORA-30036 / ORA-1562
3973403 ORA-1562 / ORA-1581 using system managed Undo
3975111 IMP-3 / PLS-103 when importing a job created by DBMS_SCHEDULE
3982017 ORA-3106 PLSQL SELECT across 8i-9i-8i
3992072 ORA-1461 / ORA-2005 inserting a column after setNull() in OCCI
4015165 Unexpected ORA-6502 from PLSQL using host binds when using CHAR length semantics
4033756 RMAN "transport tablespace" fails with ORA-39123 / ORA-12911
4057408 LPX-216 / dump while extracting data from schema based

Internal Error May Occur (ORA-600)
3691672+ OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON
3566420P* Solaris: OERI:[KSLAWE:!PWQ] can occur in 9.2.0.5 on 64bit Oracle on Solaris
This bug is alerted in Note 271084.1
2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
2901988 PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
3072094 CATSEARCH query through a view fails with OERI [20084]
3144710 OERI[526] querying V$ tables over shared server connection
3258674 QMN process may dump or raise an internal error during DML
3264527 OERI[12310] on SELECT with LEFT OUTER JOIN
3270444 OERI[msqopnws.gsets1] for GROUPING SET queries with correlated variables
3333978 Cannot register certain schemas (OERI:qmtsAddSRef1)
3350337 OERI[17183] / OERI:17281 can occur
3365439 OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH
3372217 OERI[kclfadb_5] possible in RAC
3372242 OERI[kjxbdomps2m:!survivor] possible during reconfiguration in RAC
3382648 OERI[kcrradfini.1] possible from ARCH
3384300 OERI[opixrm-1] [invalid handle] for remote mapped SQL (over DB link)
3385457 OERI [150] with event 28266
3385843 OERI [kclchkinteg_19] / crash during instance recovery in RAC (rare)
3400979 Dump of FILE_HDRS may hang or error (can result in OERI [2103])
3439552 OERI[4406] possible in SMON using automatic undo management
3440376 OERI[kclfadb_2] / LMS crashes the instance
3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
3471271 Dump / OERI[25012] when _old_connect_by_enabled = true
3476889 EXPDP fails with OERI[ktcsetscn-1] with large SCN value
3477524 OERI[kfgscdelete_10] after IO error in ASM
3481959 SQLX query using ROWNUM fails with OERI [15160]
3482748 LMS may die with OERI:kclfbbast_2
3488371 OERI[17113] can occur during import of materialized views
3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
3492040 OERI selecting from V$LOGMNR_CONTENTS for long DDL
3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
3505528 OERI[kjlfr_1] in LMD during startup when instance is low on memory
3525940 OERI[kkqscard-1] possible with query rewrite (ENFORCED)
3529179 OERI from "select empty_clob()" into varchar2 variable
3535712 OERI[3020] / ORA-10567 from RAC with standby in max performance mode
3537185 OERI[kfcdeadlockavoid02] adding file in ASM
3546174 OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
3554319 OERI[kqludp2] can occur adding a RULE to a RULESET
3557906 OERI[qctcte1] from predicate move around
3560900 OERI[kcbchg1_3] during direct path insert
3565660 OERI[kclrinit_3] from parallel recovery in RAC
3566124 OERI[insrow-1] during array insert with SAVE EXCEPTIONS and IOT
3570286 OERI[733] from high use of application context (DBMS_SESSION.SET_CONTEXT)
3572299 Tablespace recovery of offline tablespace fails with OERI[kcrrlcmp.10]
3572753 OERI[kghstack_underflow_internal_2] taking backup of controlfile via RMAN
3573149 OERI [kfcmount15] after ASM crash when remounting diskgroup
3573604 A transported bitmap index can give various OERI errors / ORA-8102
3577772 OERI[kcbgkcbcr_1] possible from PQO
3595110 OERI[12337] from multi-column INLIST with partitioned table
3607694 OERI:[15805] using PDML with array binds
3608038 OERI[kclshrshr_8] possible in RAC
3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
3610343 OERI:[ktbdchk1: bad dscn] in RAC
3612581 OERI[kpofdr-long] can occur on SELECT
3613126 ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
3614008 OERI[kjcs_m:2]
3615072 PMON can crash the instance with [plio.c: non-reusable inst]
3617191 OERI[qmxdmatchingchildren:overflow-1] using EXTRACT from large XML document
3621300 OERI[krvseds get obj] while handling thread enable/disable in logical standby
3627650 ORA-701 / OERI:17058 from GRANT / REVOKE select ON OBJECT_USAGE
3631915 Logical apply errors with OERI:kdogsli1 and ORA-1332
3635331 Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
3639267 Dump executing a join with a registered schema
3641398 OERI[kjbmiconsign:ds] possible in RAC
3649683 OERI:KGHALO2 / OERI:KGHALP1 on a query with large number of predicates
3649979 OERI[qesmmCValStat4] from star transformation
3657023 OERI[kcblco_1] possible from HASH joins with migratable sessions
3663357 OERI[koktrpltd1] in object type evolution
3666502 OERI[1236] can occur intermittently in a shared server
3671867 OERI[kclchkinteg_2] possible in RAC environment
3679892 Create partitioned bitmap index in parallel reports "Bad cvl" to the trace
3687456 OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
3687949 Logical standby may not restart properly at start of PDML/PDDL
3714207 OERI[5021] trying to migrate system tablespace to local
3722208 OERI[kjzgpoll1] from DIAG process if ocssd shuts down
3724548 OERI[kglhdunp2_2] / OERI[1100] under high load
3731315 CREATE IOT with PK constraint may throw OERI [15803]
3741962 OERIs due to incorrect buffer cache latch cleanup
3751874 OERI[25012] can occur when _old_connect_by_enabled set to true
3754474 OERI[kghfre3] possible with heavy IO workload
3754773 OERI:kcbsor_2 block recovery failure can occur
3756960 OERI[17159] / instance crash possible with EVENT:10235 set
3757136 OERI:3050 during BMR (Block Media Recovery) through a RESETLOGS
3762714 ALTER DATABASE RECOVER MANAGED STANDBY fails with OERI[3020]
3772033 OERI[ktspfmb_create1] creating a LOB in ASSM using 2k blocksize
3785459 Dump (evaopn2) when updating a view with an INSTEAD OF trigger
3788879 Streams capture process does not abort on OERI[17112]
3789406 OERI[17281][4068] when closing cursors for invalid PLSQL packages
3798917 Duplicate DEFAULT_TBS_TYPE in DBA_PROPERTIES after upgrade to 10g
3799433 OERI[1402] when running a global hanganalyze or dumping SYSTEMSTATE
3800160 Internal error / memory corruption using ASM with KST trace
3800614 OERI[12410] from SQL with analytic functions
3800634 OERI [kghstack_free1] [knlucanon:res_buf] can occur in Streams
3800644 OERI [kghstack_free1] [kniascg: cgpi_knictx] can occur in Streams
3803404 Dequeue may fail with OERI:4406
3803424 OERI:kghstack_underflow_internal_1 querying GV$ views
3803446 OERI[vopuasjct(2): Illegal Expression] can occur optimizing SQL
3812876 OERI[kwqidrdq-buf1] in RAC after buffer ownership changes
3814603 OERI[kccsbck_first] from CSS problem with split brain resolution
3815890 OERI[krccabt_last] when file expanded with block change tracking enabled
3817705 OERI[18301] / OERI[4415] from XA
3817792 OERI[6100] while coalescing an index
3819011 OERI[23050] on DML against a table with OBJECT columns in a replication group
3819836 OERI[1155] / instance crash possible
3827053 OERI[kcbzfb_4] possible if process killed
3829900 OERI[25027] possible accessing index in 10g
3832099 OERI[kcbgtcr_13] can occur in RAC
3832611 OERI[kwqpaspse:!new] scheduling propogation from non-owner instance
3833596 OERI:prssubpspec14 from ALTER MVIEW subpartition specification
3833809 Direct load with code conversion can fail with OERI[klaevc_01]
3843318 OERI[ksxpwait10] / hang possible in RAC
3851225 OERI:[kcsbcscn13] can occur under heavy load
3854034 OERI[733] optimizing SQL using bitmap indexes
3859298 Block corruption with high INITRANS or rapid ITL growth.
3865157 OERI [kkzumco2:4] using DBMS_REDEFINITION with more than 10 constraints
3872410 Corrupt PLSQL collection after copying empty collection
3873324 OERI[kslfget_pvt1] inserting XML with comments over 4k
3892704 During reconfiguration processes may fail with OERI:kjuocl1
3897017 OERI:15239 from ALTER TRIGGER .. ENABLE
3901170 False OERI [kghiexchk:ds] with event 10235 or 10501 set
3904319 OERI [KCBZPBUF_1] can occur in RAC environments
3906669 LMS may fail with OERI[kjbmpclo:cvt]
3912435 OERI[kokegpinlob1] / OracleXMLSQLException from DBMS_XMLSLAVE
3913642 OERI[knlqdqm2usr:4] / incorrect data at Logical Standby
3917581 PLS-801 [23411] doing implicit conversion from NUMBER to LONG
3925815 OERI[kjccfmb:x!] possible in a RAC environment
3928828 OERI[kghfrh:ds] / memory corruption from AQ
3935714 OERI[kokax_oct_adtcbk5] while extracting data from schema based table
3936811 Rare OERI[kjbrass:2scn] after RAC reconfiguration
3938376 OERI[15160] accessing via a bitmap join index
3952778 ASM instance crash OERI[kffmxpresize] when shrinking / growing file
3953494 ASM instance may crash with OERI[kfkupdateufsreq1] after rebalance of diskgroup
3955411 OERI[kfiosubmitio07] signalled after recovering from a block corruption
3963092 OERI[qctcte1] compiling SQL with ORDER BY .. DESC
3975816 OERI[kjbrref:!ini] in RAC
3996802 "alter system kill session" can crash the instance if IO slaves used
4000840 Update can cause block corruption
4010945 OERI[qctstc2o1] from nested subquery with >= 2 levels of nesting
4011826 OERI:kfcGetPin01 on ASM instance if disk out of space
4036717 Truncate table in exception handler can causes OERI:kcbzwb_4
4066077 OERI[kwqbcgetcorr555] the failover capture with online