Doc ID: Note:283897.1
Subject: 9.2.0.6 Patch Set - List of Bug Fixes by Problem Type
Type: README
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 27-SEP-2004
Last Revision Date: 14-OCT-2005

Bugs fixed in the 9.2.0.6 Patch Set

  • See Note 189908.1 for Support Status and Alerts affecting 9.2.0 releases.
This note lists the bugs fixed in the 9.2.0.6 Patch Set over and above those fixed in 9.2.0.5. The 9.2.0.6 Patch Set itself is cumulative and includes all fixes in 9.2.0.2 , 9.2.0.3 , 9.2.0.4 and 9.2.0.5 in addition to the fixes listed in this document. Bugs are listed under significant headings relating to either a feature or a characteristic of the bug. Some bugs are listed in more than one section. Each bug number is hyperlinked to a Support Bug Description.
  • '*' against a bug indicates that an alert exists for that issue.
  • '+' indicates a particularly notable bug.
  • 'P' indicates a port specific bug.@>
  • '@' indicates UNPUBLISHED information X>
  • "OERI:nnnnn is used as shorthand for ORA-600 [nnnnn].

Notable exceptions and omissions

  • Port specific issues may not be listed

Security Alert Issues fixed in the 9.2.0.6 Patch Set

Fixed Bug# Security Alert# Document Summary
9.2.0.6 3828166 Sec. Alert#68 Note 281188.1 Oracle Security Alert #68 - Database Server Vulnerabilities Bug#
9.2.0.6 - - Note 293953.1 Critical Patch Update (Jan 2005)

9.2.0.6 Bug Categories



    9.2.0.6 Bug Fixes by Category



    Symptom


    Corruption
    2696988 CR index block corruption from undo of array delete
    2729654 Downgrade from 10g with recreate controlfile can cause future upgrade problem
    3262494 Block corruption possible during CR rollback of an insert rowpiece
    3489246 OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0

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

    Corruption (Dictionary)
    2617487 Dropping unused columns can corrupt the dictionary for the table
    2921194 ALTER TABLE allows wrong partition to be added into the existing table
    2950468 ALTER SNAPSHOT makes a readonly snapshot updatable
    3370917 Summary metadata corrupted during REFRESH if MVIEW has inline views
    3410546 Function-based index metadata left in COL$ after column is dropped
    3455402 Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
    3608307 OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views

    Corruption (Incorrect / Missing Corruption Checks)
    3569503 PQ may signal a false ORA-8103 under load
    3622875 False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE

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

    Corruption (Logical)
    2660473 Export of a renamed table leaves the trigger pointing to the old tablename
    2719742 Too many rows inserted by MERGE if a row is updated before the merge operation
    2879641 BEFORE ROW TRIGGER produces corrupt data with INSERT from SORT MERGE JOIN
    2928563 Using large collections with EXTPROC can return 0 size collection
    3111464 Fast refresh gives wrong data after update of filter column from null to value
    3127987 NCLOB data is corrupted after insert through JDBC
    3128021 Corrupt column data after EXCHANGE PARTITION with row dependencies
    3265740 Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
    3313274 Direct path load of LOBs can cause data loss/truncation in streams
    3361118 OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
    3365045 Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
    3370235 Corrupt data possible in logical standby
    3393350 NLS characters may be corrupted over DB link for NCHAR data with OCI7
    3408192 Heavy concurrent DML scenarios can cause $R table to contain deleted rowids
    3571946 DELETE trigger does not fire on delete with index scan
    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

    Corruption (Physical)
    3785200* Corruption possible in automatic space managed segments
    This bug is alerted in Note 281047.1
    2576703 IOT block corruption from insert after columns added to all-key IOT
    3069818 Corruption possible modifying a migrated or chained row
    3641822 PDML (including DDL) can cause APPLY to stop
    3641963 Transport of a table with LONG RAW and added columns is corrupt at target

    Corrupt/Bad Backup
    2825248 Resetlogs data ignored in RMAN backup optimization checks
    3297877 OERI[2036] due to bad redo from direct writes
    3615004 Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment

    Deadlock
    2014833 Deadlock possible from concurrent SELECT and TRUNCATE
    2615271 Deadlock from concurrent GRANT and logon
    3166756 Self deadlock (ORA-60) possible on LOB index update
    3268802 Additional diagnostics for deadlock in RAC environment
    3320292 Parallel recompilation hangs when recompiling type generated for pipeline function
    3347676 Deadlock in JDBC connection pool between getConnection() and close()
    3381218 Deadlock involving 'library cache lock' X mode request
    3398485 Deadlock during on demand materialized view refresh (ORA-4020)
    3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
    3437870 Java thread deadlocks sharing OracleOCIConnectionPool connections between threads
    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
    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

    Excessive CPU Usage
    3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin
    3239873 High CPU during parse of statements with many identical predicates
    3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
    3336594 High CPU use in QMON scanning DEF$ tables needlessly
    3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
    3490914 High CPU use during lock escalation retry
    3756797 High CPU may be used during parse of certain query forms

    Feature Unusable
    1488818 ALTER TABLE MOVE on a table of nested table fails with ORA-932
    3224506 XA client using TAF may not failover correctly
    3741539 Logical standby may apply DML from a DDL more than once

    Fix Is Considered An Enhancement
    3566945+ ENH: No block level locking for externally co-ordinated prepared transactions
    3054910 ALTER TYPE does not support change of codepoint semantics
    3130972 ENH: Allow over 1Gb private memory in realfree allocator
    3316345 ENH: Enhance checks on interconnect blocks by a check for the correct DBA
    3364962 Multiple forms support in user_lexer query procedure
    3457571 Enhancement to DBV to show highest SCN in a file / show blocks above an SCN
    3795329 Stack trace unwind is slow on some platforms
    3797523 Enhancement - Include stack information in systemstate dumps
    3868840 _DB_BLOCK_CACHE_PROTECT has high overhead

    Hang (Involving Shared Resource)
    2615271 Deadlock from concurrent GRANT and logon
    2788036 Instance hang due to a noqueue request blocked at master
    2930179 PMON may not cleanup dead Oracle process
    2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
    3420610 RAC "BAST" leak can lead to instance hang
    3544142 It is possible for a process to be FROZEN while holding a latch
    3577341 LGWR may hold TA [1][usn] after an OERI[4005]
    3626463 Hang possible on 'ges inquiry response' after reconfiguration
    3634252 PMON unable to acquire latch when JOB_QUEUE_PROCESSES altered
    3675033 Reintroduction of RAC instance can result in hang / OERI:2103

    Hang (Process Hang)
    3566945+ ENH: No block level locking for externally co-ordinated prepared transactions
    2164658 OCIBreak may not work properly (hang/error)
    2246750 Cache recovery hang due to SMON deadlock in RAC
    2515091 OCIStmtFetch can return no data when used with long data with OCIStmtSetPieceInfo
    2540942 LMS may spin in kjctr_rksxp() during simultaneous shutdown
    2748274 Hang possible on SHUTDOWN with IO slaves.
    2826421 Hang/crash possible when using reliable transport with RAC
    2930179 PMON may not cleanup dead Oracle process
    2932269 Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
    2963357 Apply engine may hang when parallelism is set
    2997330 Hang on library cache pin/lock
    3056014 V$RSRC_CONSUMER_GROUP.ACTIVE_SESSIONS not always decremented
    3122154 AQ JMS receive(wait_time) does not return after wait_time
    3214975 Hang possible on STARTUP in RAC with RSM
    3253770 ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
    3296914 Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
    3315378 A blocked ONLINE index rebuild can cause other DML to hang
    3320292 Parallel recompilation hangs when recompiling type generated for pipeline function
    3323709 Hang on execution of DBMS_REDEFINITION.START_REDEF_TABLE and concurrent insert to same table
    3332578 Refresh of materialized view hangs refresh / results in OERI[kkzgajgd_of2]
    3369017 Logical standby switchover waits for active transactions
    3371003 Logical standby apply hang (library cache pin waits)
    3381218 Deadlock involving 'library cache lock' X mode request
    3395856 Timing window in RAC IPC code can result in dump/hang/OERI[ksxpcncl3]
    3400979 Dump of FILE_HDRS may hang or error (can result in OERI [2103])
    3424721 Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
    3425298 TT lock is not released in space transaction cleanup
    3458197 DLM reconfiguration can hang after communication establishment
    3476477 RAC session can hang
    3479558 Break/SetQueryTimeout can cause JDBC client to hang
    3509265 SHUTDOWN may hang with "waiting for instances to leave: N"
    3555003 View compilation hangs / OERI:17059 after DBMS_APPLY_ADM.SET_DML_HANDLER
    3561040 LMS process may hang waiting for "KJC: wait for msg sends to complete"
    3562032 Cancelled ONLINE index rebuild can deadlock with DML session
    3565109 Logminer may not be able to resolve log files with multiple archive destinations
    3566511 ONLINE index rebuild can cause DML sessions to hang.
    3577341 LGWR may hold TA [1][usn] after an OERI[4005]
    3605165 Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
    3625370 CGS nested reconfiguration may hang
    3632400 LMS may hang in kslges() waiting for a post
    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

    Hang (Process Spins)
    3771668+ Poor INSERT performance with ASSM
    3248196 Schema registration with numerous REFS can spin / use excessive PGA memory
    3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
    3371796 Explain plan spins in kkorminl
    3395198 Query rewrite may spin after partition exchange
    3407944 OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
    3414440 Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
    3443747 A session can spin holding a library cache latch during fixed table lookup
    3458438 Update a long >4k that affects more than 1 record over DB link hangs
    3498315 Insert CLOB datatype from single-byte database to UTF8 hangs
    3571724 Logical standby apply stops applying changes from primary
    3654532 Spin possible from query rewrite with temp table transformation
    3822213 Explain plan with STAR transformation may spin in qkaPobs

    Install Is Not Performed Correctly
    3544619P Solaris: UDLM 3.3.4.6 is missing 9.2.0.5 Patch Set for Solaris 32bit
    3580447P* AIX: HSODBC does not work in 9.2.0.5 on AIX platforms
    This bug is alerted in Note 269472.1
    2702653 XDB install / upgrade may be missing folder "/sys/apps"

    Instance May Crash
    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
    2826421 Hang/crash possible when using reliable transport with RAC
    2901988 PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
    2922873 PMON may die crashing the instance cleaning up a failed "ALTER SYSTEM" command
    2987818 OERI [1153] possible in SMON in RAC
    3037154 PMON may die with ORA-601 (rare)
    3143531 OERI[kcbbic2_1] possible - instance crashes
    3171520 OERI [kclchkinteg_21] possible while evicting instance
    3213745 ALTER SYSTEM SET SHARED_SERVERS can crash RAC instances
    3234034 Database crash possible with shared servers
    3275876 Memory corruption with RAC with large number of instances
    3411021 Oracle process may die due to ORA-27300/ORA-27301/ORA-27302 at skgxppost1
    3439552 OERI[4406] possible in SMON using automatic undo management
    3440376 OERI[kclfadb_2] / LMS crashes the instance
    3452686 OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
    3455602 OERI[2886] can occur making tablespace READ / WRITE crashing the instance
    3482748 LMS may die with OERI:kclfbbast_2
    3518624 PMON may dump in kglrfcl/kglrfst cleaning up a dead process
    3604329 SGA memory corruption from DROP/CREATE of object as OPERATOR
    3607392 PMON may dump during cleanup
    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]
    3636591 PMON may crash instance with OERI[1115]
    3638695 PMON may crash instance cleaning dead process
    3671299 PMON may dump (kslcll) crashing the instance
    3704314 OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash possible
    3724485 Enqueue waits may occur with no obvious holder in RAC
    3819836 OERI[1155] / instance crash possible
    3867789 PMON may crash the instance with an OERI[1155] when cleaning up

    Latch Contention
    3443747 A session can spin holding a library cache latch during fixed table lookup
    3452409 STATISTICS_LEVEL >= TYPICAL can cause latch contention under load

    Leak (Memory Leak / Growth)
    2516787 Repeated ATTACH / DETACH can leak client memory if ADDRESS in ADDRESS_LIST uncontactable
    2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
    2907034 High memory use / ORA-4030 loading XML via createresource()
    3064159 Sessions using ASSM segments may leak memory
    3134518 Memory leak on "bind var" heap from invalidated PLSQL cursor
    3145754 Calling EXTPROC can leak memory if there is no listener
    3192557 JDBC Thin with CallableStatement consumes/leaks database UGA memory
    3194997 DDL against domain indexes can use lots of memory
    3231260 Memory leak from PLSQL concatenation
    3248196 Schema registration with numerous REFS can spin / use excessive PGA memory
    3250195 KUP-4050 / memory leak from consecutive SELECTs against external table
    3275045 PLSQL calling USERENV leaks memory within the PLSQL user call
    3280226 ANALYZE to collect statistics may use more memory than expected
    3281907 Export / import of a composite partitioned table can appear to spin during IMPORT
    3302654 PGA memory leak in "cursor work heap" for queries with VIEW PUSHED PREDICATE over a SORT
    3321798 Private memory growth XML/XSL processing with XDK PLSQL API
    3361066 Private memory leak when running a large update with many subqueries
    3390021 PGA memory leak in apply server
    3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
    3408829 TNS listener leaks memory if remote listener specified in LOCAL_LISTENER
    3421087 Memory leak can occur when using DBMS_XMLGEN
    3450074 Inserting into a table defined as an XMLType leaks UGA memory
    3463669 Memory leak with LOB bind with JDBC OCI driver
    3500369 OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
    3518909 Session (UGA) memory not released after using DBMS_XMLPARSER
    3555080 Memory leak from batch copy of binds from JDBC to C for JDBC OCI
    3567697 JDBC OCI memory leak if PLSQL index table bound as OUT bind with oracleCallableStatement
    3575442 Private memory growth with processing XML/XSL
    3611423 PGA memory leak in AQ propagation process(J000)
    3630538 Memory leak on PObject::pin() in OCCI client
    3667108 Excessive memory allocated when constructing mdm model
    3742353 Excessive memory allocations in OLAP
    3748283 Small PGA memory leak in kpodscn for long running PLSQL against external tables
    3789433 Memory leak possible from lmmrealloc
    3826792 JDBC OCI leaks client side memory when calling PLSQL with REF CURSOR OUT bind

    Leak (Resources Eg: File Handles)
    3141248 Temp LOB leak applying PLSQL operator to the LOB
    3379917 Apply processes(reader, server) leak cursors (ORA-1000)
    3528069 JDBC Thin Net sockets not closed if an error occurs during the Net close operation
    3546019 Cursor leak from interMedia image matching index inserts and updates
    3556570 "select length(foo()) ..." leaks temp LOBs between rows
    3571263 Excessive build-up of distributed transaction locks (DX locks)

    Memory Corruption
    2610353 Dump / memory corruption possible from remote select
    2624824 extractValue() dumps / corrupts memory for values over 4k bytes long
    2890002 OERI[17099] / OERI:gpga_mismatch using MTS on some platforms
    3029367 Dump (kkxcls2) following pipelined procedure call
    3163264 Dump / memory corruption at logical standby for LOB table with trailing nulls
    3199908 Dump (in kkmmctbf) from a DELETE TRIGGER compiled in DEBUG mode
    3449174 Attempt to supplementally log LONG column can OERI/dump
    3451741 Dump (gxtsnGetPar) creating Text index with THEMES=YES
    3466737 Memory corruption optimizing SQL with OR predicates
    3469775 DBMS_XMLGEN.CONVERT can fail with OERI[17112]
    3598341 Enabling constraints can lead to memory corruption / dumps
    3604329 SGA memory corruption from DROP/CREATE of object as OPERATOR
    3642764 PGA corruption possible with CURSOR_SPACE_FOR_TIME if NLS parameters altered
    3675865 Dump (kgidmp / kgidlt) during CONTEXT index sync
    3724548 OERI[kglhdunp2_2] / OERI[1100] under high load

    Performance Affected (General)
    3211428 ANALYZE / Batch operations can disable PREFETCH for all sessions
    3312874 USE_STORED_OUTLINES causes increased "library cache lock" requests in RAC
    3452409 STATISTICS_LEVEL >= TYPICAL can cause latch contention under load
    3588448 Waits for 'global cache cr request' on RAC if UDP overflow occurs
    3611471 High latch waits for "cache buffers chain" latch possible

    Performance Of Query/ies Affected
    3771668+ Poor INSERT performance with ASSM
    2136549 Incorrect cardinality estimate with not equals and NULL values
    2203759 Poor cardinality estimate for "IN" transformation using join with duplicate elimination
    2597829 Poor execution plan possible for remote inserts
    2800494 Multiblock reads of current blocks not used
    2922408 DELETE from PLSQL block slower than from SQL
    2953803 "MONITORING" clause does not work for partitioned IOTs
    3177513 Join not avoided using bitmap join index if UNIQUE index exists also
    3193835 Unnecessary partition scanning depending on predicate order
    3210455 0 selectivity and cost for CTXXPATH index #
    3211428 ANALYZE / Batch operations can disable PREFETCH for all sessions
    3216002 HASH JOIN ANTI / SEMI can use a lot of CPU / spin
    3286346 Rebuild partitioned index and exp/imp of statistics causes inconsistent stats
    3288732 AQ propagation can hold library cache locks longer than needed
    3289786 Suboptimal plan possible with inline view and binds (or replaced literals)
    3297301 DBMS_STATS gather of histogram statistics slow
    3317309 Bad plan choice due to poor selectivity for "col=:bind" or "col=expression" for single value column
    3347339 Stored outline has "NO_ACCESS" instead of "INDEX" hint for domain index access
    3348585 Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
    3349903 Bind peeking does not work for partitioned objects with non-equality predicates
    3354231 Index skip scan is sometimes estimated at very high cost
    3356951 DBMS_STATS can be slow if sample size causes < 2500 rows in the sample
    3361066 Private memory leak when running a large update with many subqueries
    3380026 Suboptimal plan possible for FIRST_ROWS for SQL with ORDER BY and indexes
    3398205 CBO can waste CPU trying to optimize INSERT INTO .. VALUES statements
    3400412 CBO may choose a more expensive HASH JOIN plan with no partition pruning
    3412136 Poor plan (with merge join cartesian) with STAR transformation
    3440097 Suboptimal plan with count(column), bitmap index and view
    3456044 Poor AQ performance from multiple dequeuers performing rollback
    3467364 Adding datafiles serializes on the TT enqueue
    3485930 Slow performance of DBMS_STATS with auto sample size
    3485997 MVIEW log may be populated by DML updating a column not covered by the log
    3497588 Media recovery checkpoint slow when recovering a large number of datafiles
    3499674 CBO may overestimate cost of NL join with index
    3516951 Poor execution plan with merge join cartesian with temp table transformation
    3530612 Dynamic partition pruning may not occur on MERGE
    3545209 Poor performance from semi join with NL to remote table
    3558780 Wrong cardinality estimated on table with an unnested subquery predicate
    3565117 Cartesian join can occur due to not unnesting a subquery
    3566361 DBMS_IOT.NUMBER_TO_UROWID is slow
    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
    3582980 DYNAMIC_SAMPLING hint ignored in some cases
    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
    3617042 Index not used for XPATH of "long" element
    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
    3660908 Suboptimal OLS label tag caching
    3668224 Bind peeking does not occur for predicates of the form COL <op> FUNC(:bind)
    3690369 Incorrect cardinality estimation when using LIKE predicates
    3735785 Pro code with SQL_CURSOR array fetch uses single row fetches and no prefetch
    3740073 Parallel insert allocates an extra buffer row source
    3742802 Full table scan possible if selectivity of BETWEEN is 0
    3746423 Sub-optimal execution plan for range partitioned table with INLIST
    3756797 High CPU may be used during parse of certain query forms
    3784687 Use of BigInteger can be slow
    4322477 Consecutive runs of Spatial query on partition table progressivly get slower

    Security Or Service Denial Vulnerability
    No Bug#* Critical Patch Update (Jan 2005)
    This bug is alerted in Note 293953.1
    3828166* Oracle Security Alert #68 - Database Server Vulnerabilities Bug#
    This bug is alerted in Note 281188.1

    Shared Pool Affected
    2893444 Internal SQL in the extensible optimizer does not always use bind variables
    2909346 Domain indexes can produce recursive literal SQL (affects shared pool)
    3299407 Invalidating cursors frequently can fragment the SGA and leak "kglau" memory
    3405237 ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
    3406977 High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE
    3589588 OERI[15201] if shared pool under load
    3658039 ORA-6540 / shared pool memory use from EMON during PLSQL notification

    Storage Space Usage Affected
    2708814 Fewer rows per block than expected from direct load with SQL functions
    3064971 ORA-54 when running DBMS_LOGMNR_CDC_PUBLISH.PURGE / change table keeps growing
    3157572 Rollback of Array inserts into tables with high PCTFREE can waste space
    3329096 Free space may not be used in an AUTO SPACE MANAGED segment
    3449951 ORA-1562 can occur on DBMS_LOGMNR_SESSION.PURGE_SESSION or DBMS_CAPTURE.ALTER_CAPTURE
    3464629 LOGMNR_SPILL$ table grows in an unbounded fashion

    Wrong Results
    2171066 Negative values can occur in v$librarycache
    2193858 Division of some specific numbers may return an incorrect result
    2243979 Pipelined table functions may dump / give wrong results in SHARED SERVERs
    2365168 Wrong results with PQO and partitioning
    2377173 Wrong results in sort-merge joins with GV$ views
    2417506 Wrong results from outer joined column comparison with operator
    2432123 INPATH against XML with attribute search (@) misses documents
    2504168 Wrong results from query with ANSI outer join syntax and constant predicate
    2507701 Wrong results from outer join with a constant predicate
    2510971 PERCENTILE_CONT() can produce wrong results with an ORDER BY
    2515091 OCIStmtFetch can return no data when used with long data with OCIStmtSetPieceInfo
    2521729 CATSEARCH with INDEX_STEM=YES and GRAMMAR=CONTEXT with stemming misses hits
    2524044 Wrong result possible from CONNECT BY with CBO
    2617729 Wrong rowcount for insert with subquery involving remote HS function
    2619861 Wrong results from hash join on char=nchar columns
    2620423 Wrong results possible from OR expansion with CHAR equality predicate
    2624328 Query over database link can return wrong results
    2628067 Wrong results possible from anti-join
    2639311 Wrong result with multi join key prefetsh
    2650443 JDBC Thin ResultSet.getTimestamp() can cause wrong date manipulation in other threads
    2660665 Wrong result possible from multi-column correlated inlist
    2696988 CR index block corruption from undo of array delete
    2711453 CONNECT BY on a collection type may return wrong results or no rows
    2711993 ANSI join with a set query block may produce wrong results
    2714430 Wrong results from ROWID comparison to rowid with slot#>32767
    2715691 Wrong results possible from INTERSECT / MINUS
    2719742 Too many rows inserted by MERGE if a row is updated before the merge operation
    2738493 Wrong "session connect time" / "process last non-idle time" in V$SYSSTAT
    2764655 V$SYSSTAT "logons cumulative" may be wrong if parallel query used
    2810394 Incorrect scale converting Oracle NUMBER to PACKED DECIMAL
    2816062 Wrong result when using '+' as outer join on indexed REF column
    2817818 BLOB.length() returns a negative value when data exceeds 2gb with thin driver
    2846640 Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
    2858689 Wrong results possible from CHECK CONSTRAINTS which are not NULL SAFE
    2861999 Wrong query results after ALTER TABLE SPLIT PARTITION
    2864055 Wrong results using DISTINCT in inline view using analytic functions
    2883715 Wrong results possible from LIKE against a CHAR column with no wildcard
    2896849 Dump possible using NLS_SORT=french_m, canadian_m or danish_m
    2921612 Query with anti/semi join against a partitioned table can give wrong results
    2929029 Wrong results comparing a REF type with != or <> in the WHERE clause
    2950852 ORDER BY may be ignored for queries using a WINDOW funtion
    2964692 Wrong results with parallel index fast full scan on a global temporary table
    2977019 Wrong results due to incorrect date conversion
    2988417 Wrong results from CONNECT BY ORDER SIBLINGS by a key which uses LEVEL
    2996631 Implicit conversion from nvarchar2 to varchar2 problems in PLSQL
    3031118 Wrong result joining a local table with a remote table
    3033955 Wrong results from UNION ALL with correlated subquery
    3036042 Incorrect semantics for translate XPATH function
    3036462 SHOW SGA shows wrong buffer cache size when it is > 4Gb
    3047105 Wrong results possible from query involving CONNECT BY and join
    3063088 Dump / wrong results using SEQUENCE in select list of a WITH query
    3076818 OERI[2000] during CR undo of array delete in IOT secondary index block
    3094453 Wrong values possible in single table aggregate materialized view
    3096575 Wrong results for queries using RANK() with ORDER BY ascending
    3110547 ORA-904 / wrong results from query over database link
    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
    3132071 Wrong results possible with CURSOR_SHARING=FORCE|SIMILAR
    3138618 Date format errors / wrong results on first SQL on table with check constraint on date column
    3141614 TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
    3149380 Wrong results using stemming , fuzzy or soundex with % in a CONTAINS query
    3158284 Wrong results possible joining a VARCHAR2 to a CHAR column
    3161122 Wrong results (no rows) when list partitioned table inner in nested loops join
    3168530 AQ order of messages may not be preserved
    3177769 Wrong results OR predicates inside AND chains of OR predicates
    3188637 Wrong result with star transformation and OUTER join
    3191604 DBA_JAVA_ARGUMENTS does not show all arguments for LAST method in a CLASS
    3200136 Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
    3202584 Wrong results possible from SDO_BUFFER
    3250883 Inline view using functional index can give wrong results
    3258390 V$SESSION.SCHEMANAME may return wrong value in PLSQL of another user
    3273109 Wrong results possible for NULL in SELECT list for PQO or remote query
    3273357 Wrong results for Text queries with Japanese lexer with single byte spaces
    3306619 Semijoin elimination with parallel query returns wrong result
    3312256 OERI[kftts2bz_many_files] / wrong results after ALTER TABLE MOVE of partitioned table
    3318204 Parallel query gives wrong results with view
    3324069 Wrong results with subqueries using DECODE around aggregates
    3324698 Wrong tokens produced using numjoin and numgroup
    3329128 Wrong results from SQL with GROUPING SETS and IS [NOT] NULL
    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
    3363424 Wrong results from query if base table as LPAD/RPAD/LTRIM/RTRIM check constraints
    3375163 Wrong results from INLIST ITERATOR with multi-column inlists
    3377931 SAVE EXCEPTIONS does not work reliably with a partitioned table
    3380428 SQLLDR may report the incorrect number of rows loaded on 64bit platforms
    3384741 Wrong results from parallel query with redundant join criteria
    3385243 Wrong results from PQ against partitioned tables
    3387932 OLS may return a HIDDEN column in place of a newly added column
    3396223 wrong results with function based index and DECODE function
    3406157 OCISessionGet on an OCI session pool can return a session for a different user
    3406611 Wrong results accessing data via a function based index
    3424515 SQLLDR may output incorrect values for some messages on 64bit systems
    3433964 Wrong result with deferred check constraint when table analyzed
    3437636 "servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly
    3446722 Wrong results from CBO with constant predicates and CHAR = VARCHAR2 column
    3447383 Wrong results with parallel query and partition table join
    3449245 getXML may produce incorrect hex character output
    3454019 Wrong results from wildcard in CATSEARCH / CONTEXT predicate with PREFIX INDEXING
    3454814 Wrong results possible from STAR TRANSFORMATION
    3472564 "CPU used by this session" wrong when using job queue processes
    3477460 Query rewrite can return wrong results
    3487338 Wrong results possible from hash join
    3487660 Wrong results from SMJ with GROUP BY with multiple keys
    3491603 Wrong ORDER BY from parallel execution
    3495537 HTML Sectioner may improperly strip spaces from documents
    3497317 Wrong results with a subquery in a GROUP BY HAVING clause
    3497949 Wrong results or ORA-1410 using stored outlines for CONNECT BY query
    3499678 Extra padding appended to multibyte data using JDBC with ScrollableResultSet
    3504323 DBMS_XMLDOM.cloneNode clones the wholes sub-tree in the XOB tree
    3510094 Use of an analytic function skews the result from CONTEXT indextype SCORE operator
    3512385 Wrong ROWID returned from SELECT over DBLINK when PREFETCH is on
    3523279 Wrong results from UNION in a PLSQL block with CHAR data
    3545642 Wrong result when using LEFT OUTER joins and TABLE() operator
    3559212 Wrong results possible from CBO with multi-table OR list
    3579719 Wrong data length returned selecting CHAR column over HS
    3582296 UNION [all] statement in PLSQL may give wrong results
    3588324 Wrong distance due to tolerance setting ( sdo_geom.sdo_distance )
    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
    3637624 wrong results with DISTINCT and aggregates
    3649357 CTX_DOC.THEMES may not return all themes
    3663103 getTimestamp may return truncated time value using Calendar parameter
    3672097 Wrong results HASH join of CHAR / NCHAR over database link
    3683056 Wrong results possible from nested loop join with index scan
    3685171 sqlerrd(5) does not return correct value on SQL errors
    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
    3749394 SCORE() for fuzzy text operator different for functional versus index access
    3757265 OCCI getNumArrayRows next() method returns cumulative row count
    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
    3802861 JDBC setobject(1,"1",java.sql.types.bit) sets value to 0

    Error May Occur
    3580447P* AIX: HSODBC does not work in 9.2.0.5 on AIX platforms
    This bug is alerted in Note 269472.1
    1488818 ALTER TABLE MOVE on a table of nested table fails with ORA-932
    1608474 ORA-2266 on EXCHANGE PARTITION
    1718232 CREATE SNAPSHOT fast with rowid on xmltype column fails
    2164658 OCIBreak may not work properly (hang/error)
    2180612 SP2-606 from SQLPLUS SPOOL to special device file (/dev)
    2270510 IMP-58 / ORA-22337 importing evolved type object table
    2377581 RMAN-6457 during duplicate target database with disabled threads
    2391278 ORA-22905 using PLSQL variable with TABLE(xmlsequence()...
    2392650 ORA-22324 / ORA-22328 / OERI:koputilcvto2n on ALTER TYPE to add an ATTRIBUTE
    2398218 ProCobol: PCB-400 from EXEC SQL INCLUDE without a period
    2414110 Recover managed standby "finish skip" clause may fail
    2422432 StructDescriptor.createDescriptor() does not honor definer's rights
    2481414 ALTER TABLESPACE ... DEFAULT COMPRESS reports ORA-10616
    2546095 ORA-28528 executing DB2 stored procedure over HS link
    2618400 ORA-907 using ANSI JOIN with FROM clause subqueries
    2622681 PreparedStatement.GetParameterMetaData() throws ORA-17023
    2642076 RMAN "duplicate" fails if too many files OFFLINE/in read-only mode
    2668225 DRG-100 [50935] / ORA-942 from text query on partitioned MVIEW
    2669061 ORA-1007 exporting table with VARRAY
    2708874 OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
    2736436 DBMS_METADATA.GET_DDL returns error for getting DDL of constraint
    2747350