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.

• For fixes added in 9.2.0.5 see Note 263791.1
• For fixes added in 9.2.0.4 see Note 245758.1
• For fixes added in 9.2.0.3 see Note 245939.1
• For fixes added in 9.2.0.2 see Note 246017.1

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	Continual ORA-4061 after modifying PLSQL body for PLSQL called from SQL
2808862	ORA-306 possible from OracleConnection.clearClientIdentifer()
2810530	ORA-22285 from DBMS_LOB.LOADFROMFILE
2820848	LGWR may not wait long enough (ORA-16163)
2822740	Procobol PCB-S-00400 error while parsing SELECT CASE expression
2827062	NullPointerException in JDBC Thin when connecting with SecurityManager enabled
2834541	IMP-93 on import when using the TOUSER parameter
2840895	ORA-22921 inserting into remote CLOB with varying width characterset
2876340	ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
2922873	PMON may die crashing the instance cleaning up a failed "ALTER SYSTEM" command
2929556	ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
2965256	ORA-12714 using SQL function on NVARCHAR2/NCHAR operands
3082401	Apply process fails to start after database is bounced (ORA-16081)
3083802	Complete refresh of an object materialized view can fail with ORA-942
3094739	ORA-29908 / ORA-12801 using PQ with ancilliary operators such as CONTAINS / SCORE
3097081	"ALTER TABLE x modify ..." cannot add certain column constraints (ORA-2253)
3107414	Large wrapped PLSQL packages can fail with PLS-908
3109552	ORA-12805 possible due to send timeout
3109590	DBMS_XMLPARSER.PARSE procedure calls UTL_FILE for "http://" URL
3138618	Date format errors / wrong results on first SQL on table with check constraint on date column
3143435	JDBC Thin connecting to server with ASO and DCD gets NegativeArraySizeException
3150924	ORA-2149 specifying a subpartition clause in a SELECT
3156820	ORA-23309 during CREATE_MASTER_REPOBJECT or table with OBJECT columns as LOBs
3159124	EXP-68 even though locally managed tablespaces are not offline
3165930	False ORA-1436 from query with non connect by prior preceeding connect by prior
3174292	Proxy backup generates huge PLSQL code with many datafiles
3175001	ORA-1426 REBUILDing Text index with more than 255 partitions
3211371	OERI[ksfdgo1]/ ORA-27050 with many datafiles
3213745	ALTER SYSTEM SET SHARED_SERVERS can crash RAC instances
3230967	ORA-979 from complex view merge with TABLE() on outer query block
3236491	ORA-32332 possible during refresh of MVIEW
3237530	Intermittent ORA-25248 errors in alert file using AQ
3242079	Using quotation marks with PLSQL variable names can result in errors
3259441	ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
3263671	ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
3268331	ORA-27103 errors possible when using VLM
3276952	Export / import of nested table from dictionary to locally managed tablespace fails
3278020	ORA-942 creating MVIEW across dblink from 9i to 8i for object table
3285447	DBMS_STORAGE_MAP.MAP_ALL returns ORA-32504 for EMC Symmetrix disks
3288625	ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
3309646	ORA-942 from star transformation
3312423	Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values
3324661	Full export/import fails with IMP-17 / ORA-2494
3325395	ORA-130 can occur if Oracle tries to contact a local listener
3339218	ORA-26571 performing DML on a replicated table
3345208	ORA-28502 internal communication error on heterogeneous database link
3345441	Cannot load user workloads when workload query references views only
3352279	ORA-14093 / wrong results from subquery pruning with composite partitioned table
3352413	An ORA-8102 error can occur on ATEMPIND$ during a user UPDATE with CONSTRAINTS
3354447	UTL_FILE.FGETATTR returns ORA-1426 for files larger than 2Gb
3358440	AQ propagation fails with ORA-942 or OERI:16622 at the remote node
3361288	Export of XMLSCHEMA may fail with ORA-24324 in UTF8
3365045	Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
3367979	Distributed query on partition table fails with ORA-2021
3371684	SQLException "missing in or out parameter" when reusing a cached statement
3372915	Text query with bind variables in CONTAINS may raise false parse errors
3379917	Apply processes(reader, server) leak cursors (ORA-1000)
3385076	Complex object retrieval may fail with OCI-21700
3387554	Oracle Wallet Manager fails for some certificates
3390187	ORA-1403 on 2nd execution of PLSQL stored procedure with TABLE parameter
3393962	ORA-972 on query with UNION ALL and internally generated column name over DBLINK
3396600	ORA-274 Incorrect recovery option list during RECOVER when some files are skipped
3397811	ORA-29279 from UTL_SMTP with Stalker Internet Mail server
3398224	ORA-12015 on outer join MJV with decode statements
3404500	ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
3405682	ORA-23416 in logical standby database from non-key update on primary with trigger
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
3430870	ALTER TYPE of self referencing type body generates PLS-565 with trailing comments
3431498	extract and existsnode may ORA-29900 with three operands
3447478	ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
3447927	ORA-30937 using DBMS_XMLDOM
3448711	ORA-1722 can occur binding NULL bind values if event 10843 is set
3449951	ORA-1562 can occur on DBMS_LOGMNR_SESSION.PURGE_SESSION or DBMS_CAPTURE.ALTER_CAPTURE
3453107	ORA-16061 when archiving standby redo logs after failover
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
3466879	ORA-1401 inserting into audit trail when creating a Materialize View
3469389	SQLLDR direct path may fail with ORA-26094 / OERI[klaprs_30]
3471389	OCIBindByPos fails for PLSQL associate array bind with varchar2(4000)
3488761	SQLException "Closed Connection" from OracleXAConnection.getConnection()
3489963	ORA-1410 from select via synonym when re-created on other node
3492211	ORA-23308/ora-23309 replicating pre-created tables with LOB
3495629	False ORA-907 possible from inline view with ORDER BY
3497949	Wrong results or ORA-1410 using stored outlines for CONNECT BY query
3500369	OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
3511433	De-serializing a Java object in the Oracle JVM throws NullPointerException
3513071	ORA-30937 registering schema with attributes from user defined namespace
3516206	Fast refresh of materialized view fails with ORA-1406
3530618	JDBC Thin from Applet fails with AccessControlException "access denied"
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
3552655	URL link extraction can produce wrong URL with '=' leading to WKG-30008
3553962	ORA-18003 rebuilding an outline for SQL with leading spaces
3557842	ORA-903 with UNION ALL in a view
3558476	PLS-999 assigning a CLOB to a CHAR / VARCHAR2 formal with CHARACTER SET ANY_CS
3566478	ORA-928 can occur with star transformation with CONNECT BY
3569503	PQ may signal a false ORA-8103 under load
3572128	HARD storage array may report HARD errors
3576897	ORA-22804 inserting over a database link with select using CASE
3579567	Corrupt export exporting a compressed table with direct=y (IMP-9)
3587305	ORA-6511 from a cursor for loop with GOTO
3595731	PCB-S-00400 with FORMAT=TERMINAL and using DECIMAL-POINT
3597439	ORA-1153 starting managed recovery when an RMAN backup is running
3609791	SQLCODE -310 / incorrect SCALE over HS for numbers with zeroes after the decimal place
3617519	MGW to MQseries transformation fails with ORA-932
3618700	SQL apply/alter user/role fails with ORA-28003 / ORA-28221
3621886	JDBC XA cannot commit indoubt transction just after startup instance
3628621	ORA-6502 from DYNAMIC SQL in AL32UTF8
3631932	SYS_OP_PAR() fails with ORA-979
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
3649839	Intermittent ORA-12805 on internode parallel create/rebuild index
3656777	ODBC / OCI connection using TAF preconnect method gets ORA-1017
3656785	UnsupportedEncodingException writing out from Java Stored Procedure
3658039	ORA-6540 / shared pool memory use from EMON during PLSQL notification
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
3676271	ORA-1403 applying DML with delete cascade constraints
3701858	9.2 with NLS_LANG of zht16hkscs gets ORA-3106 to 10g server with ZHT16HKSCS2001
3733669	Ultrasearch crawl removes already crawled tokens
3766568	ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte
3769884	Apply aborts on first DML after handler changed when ORA-4068 encountered
3814018	PLS-801 [79110] creating a user defined type based on cursor%ROWTYPE
3857577	ORA-1280 on create_capture/add_table_rules for streams capture on RAC

Internal Error May Occur (ORA-600)

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
2392650	ORA-22324 / ORA-22328 / OERI:koputilcvto2n on ALTER TYPE to add an ATTRIBUTE
2445596	ORA-30746 / OERI:kkdoicst1 when DROP subtype validate with pk-based OID
2495540	OERI[kjcsrdp:5] on RAC instance shutdown
2525630	OERI:kokuciout_1 querying V$SQL_PLAN for a cursor with a TABLE() expression
2588469	OERI [15419] when calling the member procedure in a final subtype
2605276	OERI[qkadrv.ups2] using MERGE statement
2616719	OERI[kkojocol:2] using GROUPING SETS with STAR TRANSFORMATION
2664486	OERI:kgmgaocn1 calling "CALL" from PLSQL EXECUTE IMMEDIATE
2670788	OERI[qerixgetkey:optdesc] / dump from SELECT using AND-EQUAL with DESC index
2691348	ORA-600 [16049] from direct load into partitioned table with bitmap join index
2696674	Instance recovery may fail with ORA-600 [kjbrenou:clo]
2708874	OERI:KGHALP1 / ORA-4030 using FORALL with SAVE EXCEPTIONS
2723819	Direct SQLLOAD may fail (OERI:6937 / OERI:kcblnb_1) with small PCTFREE
2771042	OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy
2783416	OERI[qkaorderbypd 3] selecting ROWNUM with a WINDOW sort in parallel
2825918	OERI[kjbassume:rmo2] after RAC reconfiguration
2890002	OERI[17099] / OERI:gpga_mismatch using MTS on some platforms
2901988	PMON may crash the instance with OERI [k2gcbr:2] following ORA-2051
2912028	OERI:711 under prvt_access_advisor using Access Advisor
2914804	OERI:[kokbnp2] executing method in schema with same name as an object
2918138	OERI:kohdtf048 using pipelined PLSQL table functions
2982545	OERI[15819] from PQ with multi-table join
2987818	OERI [1153] possible in SMON in RAC
2997041	OERI[17271] when exiting session after running STAR query calling PLSQL
3024046	OERI[expcmo_strdef1] / Dump in / under expcmo for SQL using DBTIMEZONE
3027721	OERI[kclfusfake_4] possible in RAC
3032875	OERI:723 possible with chunks of type "KSXP freeable r"
3057951	Wrong histogram calculations when using DBMS_STATS resulting in OERI[19004]
3063167	OERI[qkswccrw:1] during create procedure using insert as select with CASE expressions
3072094	CATSEARCH query through a view fails with OERI [20084]
3076818	OERI[2000] during CR undo of array delete in IOT secondary index block
3087290	OERI[qcscpqbc1] possible from ANSI join
3089870	OERI[qcstxswrite1] with full outer join
3092006	OERI[kkqwrm_noref: colfdnf set] from "WITH" select using WINDOW functions
3104639	OERI[ksxpcncl3] possible on SHUTDOWN in RAC environment
3121424	OERI[qxidmgetrid:wrong typ_qeeOpt] on ALTER DB CHARACTERSET with domain index
3123232	OERI[ksuloget4] / dump selecting from V$SESSION_LONGOPS / OERI on "long op" operations
3132582	OERI[kokbnp2] [1031] possible on pipelined table functions and PLSQL REF cursor
3143531	OERI[kcbbic2_1] possible - instance crashes
3144710	OERI[526] querying V$ tables over shared server connection
3148830	Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
3171520	OERI [kclchkinteg_21] possible while evicting instance
3185750	OERI:ksxpcncl3 possible
3211371	OERI[ksfdgo1]/ ORA-27050 with many datafiles
3216432	PLSQL using recursive calls which open cursors may get OERI:KGIFLPUSH / 17278 / 17277
3238383	OERI[qmhsesskeybuf] can occur during an HTTP connection to XDB
3248893	OERI [17285] possible if TABLE() function invalidate
3262648	Logical Apply may OERI[krvuffl: memsize below zero]
3264527	OERI[12310] on SELECT with LEFT OUTER JOIN
3288625	ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
3293688	OERI[504] / OERI[510] using bitmap indexes with shared servers
3294293	OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
3295568	OERI[kkpapdimtolevel1] possible for parallel queries
3304290	OERI[kcbgtcr_13] scanning ASSM segments if cursor invalidated
3312256	OERI[kftts2bz_many_files] / wrong results after ALTER TABLE MOVE of partitioned table
3312664	OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
3315960	OERI:736 / dump (in kxsbndinf) re-executing SQL after an ORA-1461 failure
3317029	Dump (korfpoid) / OERI[kocpnsh014] / OERI[kwqidjqp0] from AQ in RAC
3326634	OERI[qertqgetcolumndef2] / OERI:15800 from parallel MERGE
3332578	Refresh of materialized view hangs refresh / results in OERI[kkzgajgd_of2]
3334402	OERI:kodpunp1 OERI:kope2_readstr232 can occur with large collections
3346154	OERI[17285] resuming suspended pipeline call
3347963	OERI [6120] during compressed IOT insert
3352869	OERI[kgmgcdty2] possibled from queries using TABLE() functions in views
3356103	OERI[opibnd0: oaccsid] possible from parallel query
3358440	AQ propagation fails with ORA-942 or OERI:16622 at the remote node
3358490	OERI[kqsccck:1] possible with query rewrite
3361118	OERI:[7999] / LOB corruption updating a LOB in a SERIALIZABLE transaction
3373950	Concurrent select/drop index on same table can cause OERI[12811]
3384299	OERI[kjbrrcon:cl] possible on buffer cache shrink in RAC
3385457	OERI [150] with event 28266
3388633	Logical standby apply may stop with OERI[17090]
3394481	OERI[knalfdequeuelcrs606] in apply fetch slave
3395856	Timing window in RAC IPC code can result in dump/hang/OERI[ksxpcncl3]
3400883	OERI[kjblconsign:md] possible in RAC
3400979	Dump of FILE_HDRS may hang or error (can result in OERI [2103])
3402567	OERI[koputilcvto2n: 2] during ALTER TABLE for object table
3407944	OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
3412999	OERI[kcrfrgv_scn6] on "alter database recover ... finish"
3424402	PLS-801 / dump in pevm_PUTX from PLSQL table of records with DEFAULT initialization
3430832	OERI[25012] in DML after ONLINE create index against PARTITIONED table
3439552	OERI[4406] possible in SMON using automatic undo management
3440376	OERI[kclfadb_2] / LMS crashes the instance
3446987	OERI[19942] after TRANSPORTING a TABLESPACE containing LOBS (converted from LONGS)
3449174	Attempt to supplementally log LONG column can OERI/dump
3452686	OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
3455357	OERI:voprvl1 can occur using TABLE() with OLS installed
3455402	Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
3455602	OERI[2886] can occur making tablespace READ / WRITE crashing the instance
3469389	SQLLDR direct path may fail with ORA-26094 / OERI[klaprs_30]
3469775	DBMS_XMLGEN.CONVERT can fail with OERI[17112]
3470037	OERI[xtycsr2] from FIRST_ROWS with a sub-query using GROUP BY
3471271	Dump / OERI[25012] when _old_connect_by_enabled = true
3475775	CKPT may fail with OERI[1621] during shutdown
3476435	OERI:koksadqb2 compiling a package containing CAST(MULTISET(collection subquery)))
3482748	LMS may die with OERI:kclfbbast_2
3484944	OERI[kjbrclo:gq] possible if a side-channel message is processed during process death
3489246	OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
3489963	ORA-1410 from select via synonym when re-created on other node
3492040	OERI selecting from V$LOGMNR_CONTENTS for long DDL
3496324	OERI[2886] changing tablespace from "read only" to "read write" access
3500369	OERI[kohdtf048] / ORA-21780 / Memory leak from PLSQL
3506973	OERI[kjblconsign:md] possible in LMS
3514664	OERI[504][ges process hash list] possible in RAC during diagnostics dump
3527223	OERI:kokegPinLob1 from SELECT with ORDER BY on table with CLOB
3532017	OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
3535712	OERI[3020] / ORA-10567 from RAC with standby in max performance mode
3536811	OERI[kcllkopb_6] possible in RAC
3542633	OERI[kjbstrec] in instance recovery in RAC
3546174	OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
3546575	OERI[qks3tCTT:1] possible using star transformation
3549693	OERI:[ktsircinfo_num1] during ALTER DATABASE OPEN READ ONLY
3551517	OERI[kcllrem_2] possible in RAC
3552489	OERI:kjbcropen:flockp possible if RAC process killed
3554319	OERI[kqludp2] can occur adding a RULE to a RULESET
3555003	View compilation hangs / OERI:17059 after DBMS_APPLY_ADM.SET_DML_HANDLER
3557906	OERI[qctcte1] from predicate move around
3560900	OERI[kcbchg1_3] during direct path insert
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]
3577772	OERI[kcbgkcbcr_1] possible from PQO
3589588	OERI[15201] if shared pool under load
3593228	OERI[1153] possible starting instance in RAC environment
3595110	OERI[12337] from multi-column INLIST with partitioned table
3601253	OERI[kclchkblk_3] possible accessing transported tablespace in RAC
3608038	OERI[kclshrshr_8] possible in RAC
3608307	OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
3613078	OERI[4097] from DML on TRANSPORTED tables with ASSM
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]
3621300	OERI[krvseds get obj] while handling thread enable/disable in logical standby
3625129	OERI[kopp2upic#329] possible querying a nested table
3630873	OERI[qks3tassert:1] can occur on "WITH" SQL when ROW_LOCKING=INTENT
3635331	Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
3636591	PMON may crash instance with OERI[1115]
3638080	OERI:1153 possible in RAC
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
3658974	OERI:12455 from parallel DML with bitmap index
3665925	PLS-801 [79110] possible compiling PLSQL with %ROWTYPE with TYPE
3666502	OERI[1236] can occur intermittently in a shared server
3675033	Reintroduction of RAC instance can result in hang / OERI:2103
3687456	OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE
3704314	OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash possible
3722208	OERI[kjzgpoll1] from DIAG process if ocssd shuts down
3724548	OERI[kglhdunp2_2] / OERI[1100] under high load
3741962	OERIs due to incorrect buffer cache latch cleanup
3744676	OERI[qmxarElemAt2] inserting XML document into XMLType table
3749490	KGL linked lists may become corrupt if process killed at specific time
3751874	OERI[25012] can occur when _old_connect_by_enabled set to true
3754773	OERI:kcbsor_2 block recovery failure can occur
3756960	OERI[17159] / instance crash possible with EVENT:10235 set
3759730	OERI:kssrmp1 with fix for BUG 3589588 if AUDIT_TRAIL=true
3780853	OERI[H_MK_FR_1] possible in RAC environments
3789406	OERI[17281][4068] when closing cursors for invalid PLSQL packages
3800634	OERI [kghstack_free1] [knlucanon:res_buf] can occur in Streams
3800644	OERI [kghstack_free1] [kniascg: cgpi_knictx] can occur in Streams
3802583	OERI:[kohcpi298] from enqueue for rule subscribers
3819836	OERI[1155] / instance crash possible
3851225	OERI:[kcsbcscn13] can occur under heavy load
3867789	PMON may crash the instance with an OERI[1155] when cleaning up

Process May Dump (ORA-7445) / Abend / Abort

1867670	Dump when using a trigger on an ADT or TIMESTAMP column
2214317	Dump (under lpmterm) possible
2218349	Using Multilevel collection over RPC (dblink) may dump/PLS-801
2219874	CTAS / ALTER range-list partitioned table can dump (in ctcpre)
2243979	Pipelined table functions may dump / give wrong results in SHARED SERVERs
2256943	Dump (in kohalw) selecting TEMPORARY LOB over a DBLINK
2293107	RegisterSchema dump in kotgttc() during create table for simplecontent
2322586	ORA-7445 [QERLTIDLM] using APPEND hint and INSTEAD OF triggers
2389017	Dump accessing X$KSLES
2549574	Dump (SIGFPE) can occur using FIRST_ROWS(k) optimization
2610353	Dump / memory corruption possible from remote select
2624824	extractValue() dumps / corrupts memory for values over 4k bytes long
2631217	Internal heap manager (KGH) may dump rather than signal an OERI 17xxx error
2665084	Dump [in qervwfetch] from SELECT FOR UPDATE with inline view
2670788	OERI[qerixgetkey:optdesc] / dump from SELECT using AND-EQUAL with DESC index
2684468	Dump [kkosbn] from FIRST_ROWS(N) optimization
2692323	Dispatcher may dump in/under ntexppst when under load
2730880	OCI trace uses global variables for trace context
2851970	Dump possible for SQL over DB LINK if temp table transformation occurs
2896849	Dump possible using NLS_SORT=french_m, canadian_m or danish_m
2897410	Dump (gslcsqbr_malloc) using DBMS_LDAP in SHARED SERVER mode
2901149	Dump (opiomc) in killed / idle time sniped session
2907118	Dump (qkexrxformopn_col) collecting statistics with DROPPED column/s
2953110	Dump (in nsoexc) for CONNECT BY query with START WITH block
2971238	Dump (kkeosl) running a query on a table with functional index
3010227	Dump possible in kkmevw
3024046	OERI[expcmo_strdef1] / Dump in / under expcmo for SQL using DBTIMEZONE
3029367	Dump (kkxcls2) following pipelined procedure call
3043199	Dump in lxsCnvNumStrToInt possible from TO_DATE in shift-sensitive character set
3047933	LOGON trigger may dump in RAC on first invokation
3055216	Dump possible in lxsCntXExc
3069714	Dump possible in ddfnetCFull from remote query
3071799	Dump possible during STARTUP of a RAC instance
3073650	Update / INSERT into ROWID pseudocolumn dumps
3077384	Use of fine grained auditing may dump while recursively accessing V$SQL_BIND_DATA
3085933	Semijoin elimination may dump if the subquery contains virtual column expression
3089870	OERI[qcstxswrite1] with full outer join
3096575	Wrong results for queries using RANK() with ORDER BY ascending
3105313	Dump[strlen] when performing a domain-index search with a UNION
3118504	Dump possible in ldxmfn using TO_CHAR
3123232	OERI[ksuloget4] / dump selecting from V$SESSION_LONGOPS / OERI on "long op" operations
3124081	SERVERERROR trigger may dump in qdesqltxt for some errors
3128021	Corrupt column data after EXCHANGE PARTITION with row dependencies
3130057	Dump (pfrdds) from concurrent execute/compile of PLSQL with C/java methods
3134318	Dump from non-join predicates with implicit type conversion and INLIST
3154636	Export may dump exporting triggers
3163264	Dump / memory corruption at logical standby for LOB table with trailing nulls
3167460	Dump in klcligprc() possible
3170389	Intermittent dump (in lxkLikeUTF8) possible from LIKE '%'
3170403	Dump possible in kgrdub2c
3171693	Dump (kksdip) can occur if shared pool is stressed
3179047	Dump possible in qkanindex
3195244	Dump propogating ADT messages to JMS type queue
3195907	JDBC client may dump under t2cDefineExecuteFetch after FAILOVER
3199908	Dump (in kkmmctbf) from a DELETE TRIGGER compiled in DEBUG mode
3220144	Dump possible in kollgdty
3222625	HS gateway may dump (in horsh) when doing an array fetch
3231814	Client may dump if AQ unregister fails and the subscription handle is freed
3241919	Analytic functions may dump in parallel
3250883	Inline view using functional index can give wrong results
3250970	Dump (in hokbrp) inserting into a remote table via transparent gateway
3253133	Dump (in evaopn2) from queries using a FUNCTIONAL INDEX with complex view merging
3265740	Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
3267299	Selecting filter_predicates from V$SQL_PLAN may dump
3269146	DML RETURNING with a DATE datatype may dump in the client
3273522	Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
3302372	Dump [qerixgetkey] / OERI[12411] from complex view merging
3304455	Dump possible in kkeargdesc/kkearg/kkefuncf during optimization
3315725	Dump [qmxtgGetOpqImageFromXob] when result of XMLTransform is null
3315960	OERI:736 / dump (in kxsbndinf) re-executing SQL after an ORA-1461 failure
3317029	Dump (korfpoid) / OERI[kocpnsh014] / OERI[kwqidjqp0] from AQ in RAC
3319215	TAF client may dump if failover occurs during authentication
3321767	Dump possible (in xtyqbcb) from CTAS with a SEQUENCE
3341264	Gateway dumps for update on NCHAR column for binds over 255 bytes long
3342768	Dump performing a hierarchical query on an inline view with a TABLE clause
3348437	Intermittent dump in kzrtevw() possible in OLS environment
3348585	Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
3354470	Dump possible during "alter database rename file"
3358065	Dump (kkoiop) using bitmap join index
3360868	Dump in kkoeqv with temp table transformation
3370917	Summary metadata corrupted during REFRESH if MVIEW has inline views
3371917	Query with LIKE operator can dump in lxkLikeFast
3387588	Dump (lnxdiv) updating partitioned table
3389734	Stack unwind code may dump if symbol cannot be found
3395856	Timing window in RAC IPC code can result in dump/hang/OERI[ksxpcncl3]
3407944	OERI[5254] / dump (ktagttl) or spin from Ctrl-C of a query
3411748	OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
3414440	Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
3418232	ProCobol application may dump at runtime using COMP1=INTEGER
3424402	PLS-801 / dump in pevm_PUTX from PLSQL table of records with DEFAULT initialization
3424847	OCI client code may dump during logon
3425196	Dump in sqldhb using V8 OCI XA with Precompiled code
3425329	executeBatch() dumps with > 32k batch
3432992	Dump possible using fine grained audit if error occurs
3449174	Attempt to supplementally log LONG column can OERI/dump
3451741	Dump (gxtsnGetPar) creating Text index with THEMES=YES
3453267	ANALYZE may dump in qmxGetFirstChild for XMLType with functional index
3453408	Intermittent dump (in lxkLikeMBNS) possible from LIKE '%' from JDBC
3467414	LIKE operations may dump in lxklike.. functions in UTF8/multibyte
3471271	Dump / OERI[25012] when _old_connect_by_enabled = true
3473315	Dump in lnxcpn from parallel ALTER INDEX REBUILD
3477127	Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB
3486019	Dump in kwqiclod possible using AQ
3488716	PLSQL RPC from >=9.2 to 8.0 instance may dump at the client side
3492949	Dump (qxuag_val2workarea) from select using user aggregate function
3512123	Dump (evaopn2) with BETWEEN predicate on PARTITIONED table
3515018	Dump (in msqopnws) on SELECT DISTINCT with PARALLEL BITMAP INDEX
3518624	PMON may dump in kglrfcl/kglrfst cleaning up a dead process
3524401	DBMS_DEBUG.GET_VALUE fails for package variables on larger packages
3528916	Logminer may dump with ROWNUM predicate and ASYNC IO used
3545539	Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
3553302	Dump (qmxluMoveToHead) selecting from schema with anyType stored as a CLOB
3561624	Dump possible from HASH join with large hash_area_size > about 18Mb
3564337	Dump possible in kopepwlen
3566056	Dump possible after failover
3566813	Dump from CTAS with UNION and ORDER BY of CHAR columns
3571054	Streams capture process may dump in RAC
3583215	Dump (qersoRowP) with complex view merging and subquery in SELECT list
3591119	Dump (in insape) from insert with UNION and too large column values
3594734	Dump when accessing HS table with over 20 indexes
3598341	Enabling constraints can lead to memory corruption / dumps
3607392	PMON may dump during cleanup
3608916	Dump / ORA-21527 selecting from XDB Schema
3611945	LMS may dump processing a BAST after a cache resize operation
3614299	Dump adding a subscriber with a rule containing literals with CURSOR_SHARING = FORCE|SIMILAR
3625392	wrong results / dump (evaopn2) with star transformation
3627170	Logical standby may dump / ORA-12805
3628474	Select on empty table with functional index may dump in kpobav
3630053	Dump (kkfipf) querying a table using a DESC index with OUTER join
3635177	Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
3648249	SQL may dump (in KKOGTP) during parse
3661254	Dump with partitioned tables and INLIST
3666045	Dump (drexqxs) from Text SELECT using CONTAINS with ORDER BY
3668077	"rollback to savepoint" in a distributed transaction dumps
3672876	Dump on execution of a MERGE statement in replication
3673420	Dump when function based index exists which includes "ROWID"
3675865	Dump (kgidmp / kgidlt) during CONTEXT index sync
3683056	Wrong results possible from nested loop join with index scan
3688894	Dump (msqpfn) from PQ select with remote function
3695271	Dump (kkojije) with bitmap index and multi column inlist
3729662	Dump (in eoref_resolve_xref) executing java Stored Procedure
3737149	OCILogon() may dump in multithreaded mode
3749490	KGL linked lists may become corrupt if process killed at specific time
3763027	Dump (in KKOJNP) possible parsing query with pushed join predicate
3779927	Dump (under qxidmid) from INSERT INTO with a DOMAIN index
3786302	ANSI join with correlated TABLE() clause fails (ORA-904)
3796792	Dumps possible inserting schema based instance document
3823774	Names 'dump_tnsnames' dumps if tnsnames.ora missing
3838121	Dump calling dbms_cdc_subscribe.subscribe()

Instance Startup

3071799	Dump possible during STARTUP of a RAC instance
3214975	Hang possible on STARTUP in RAC with RSM
3241689	Queue buffer not correctly initialized on instance restart
3248886	Continous 'restarting dead background process qmn0' message in alert.log
3275876	Memory corruption with RAC with large number of instances
3312664	OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
3549693	OERI:[ktsircinfo_num1] during ALTER DATABASE OPEN READ ONLY
3593228	OERI[1153] possible starting instance in RAC environment
3617060	Starting RAC instance with srvctl/gsd can cause ORA-1012/ORA-1034
3627263	Deadlock / hang during RAC instance startup
3635331	Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
3675033	Reintroduction of RAC instance can result in hang / OERI:2103

Migration / Upgrade / Downgrade

2729654	Downgrade from 10g with recreate controlfile can cause future upgrade problem
3238525	Upgrade from 9.0 can leave corrupt IND$ data for global temporary table indices
3263839	Upgrade from 8i -> 9.0 -> 9.2 does not update MVIEW dictionary fully
3312664	OERI[kcbrbo1] after downgrade from 9.2.x or higher to 8.1
3430486	"catpatch" does not check the installed version of components
3431498	extract and existsnode may ORA-29900 with three operands
3462254	interMedia INVALID after upgrade from 9.2.0.1 - 9.2.0.3 to 10g
3608307	OERI[7001] / dictionary corruption from upgrade/downgrade with materialized views
3685392	xmlrelod.sql missing which can cause downgrade errors

Performance Monitoring

1995145	Statspack snapshot can show poor performance
2171066	Negative values can occur in v$librarycache
2377173	Wrong results in sort-merge joins with GV$ views
2525630	OERI:kokuciout_1 querying V$SQL_PLAN for a cursor with a TABLE() expression
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
3267299	Selecting filter_predicates from V$SQL_PLAN may dump
3371796	Explain plan spins in kkorminl
3437636	"servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly
3472564	"CPU used by this session" wrong when using job queue processes
3720104	Fix for BUG 2276769 can cause SQL monitoring difficulties

Recovery

3544995+	LOB segments with "CACHE READS" generate no REDO even with the logging option
2904417	OERI[kcbr_media_3] from parallel media recovery
3297412	ORA-16067 during media recovery after logfile added
3297877	OERI[2036] due to bad redo from direct writes
3354470	Dump possible during "alter database rename file"
3475932	Cross instance archive log not generated remotely
3497588	Media recovery checkpoint slow when recovering a large number of datafiles
3572128	HARD storage array may report HARD errors
3635331	Stuck recovery (OERI:3020) / ORA-1172 on startup after a crash
3754773	OERI:kcbsor_2 block recovery failure can occur

ANSI Joins

2504168	Wrong results from query with ANSI outer join syntax and constant predicate
2618400	ORA-907 using ANSI JOIN with FROM clause subqueries
2711993	ANSI join with a set query block may produce wrong results
2846640	Ambiguous columns not signalled with ANSI join syntax (wrong results instead of error)
3087290	OERI[qcscpqbc1] possible from ANSI join
3089870	OERI[qcstxswrite1] with full outer join
3264527	OERI[12310] on SELECT with LEFT OUTER JOIN
3414440	Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
3545642	Wrong result when using LEFT OUTER joins and TABLE() operator
3632885	In FULL OUTER JOIN a NESTED LOOPS ANTI is used when unique index exists
3696879	Wrong results from ANSI query with subquery in the ON condition
3786302	ANSI join with correlated TABLE() clause fails (ORA-904)

Analytic SQL (Windowing etc..)

2510971	PERCENTILE_CONT() can produce wrong results with an ORDER BY
2616719	OERI[kkojocol:2] using GROUPING SETS with STAR TRANSFORMATION
2783416	OERI[qkaorderbypd 3] selecting ROWNUM with a WINDOW sort in parallel
2864055	Wrong results using DISTINCT in inline view using analytic functions
2921612	Query with anti/semi join against a partitioned table can give wrong results
3092006	OERI[kkqwrm_noref: colfdnf set] from "WITH" select using WINDOW functions
3096575	Wrong results for queries using RANK() with ORDER BY ascending
3187502	Wrong results from SQL with HAVING GROUPING
3241919	Analytic functions may dump in parallel
3294293	OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
3329128	Wrong results from SQL with GROUPING SETS and IS [NOT] NULL
3348585	Dump (in LNXMIN) using WINDOW functions with CASE/DECODE
3355043	The MIN analytic returns bad data when selecting from nested collection type
3492949	Dump (qxuag_val2workarea) from select using user aggregate function
3510094	Use of an analytic function skews the result from CONTEXT indextype SCORE operator
3533428	ORA-904 SYS_TBL$3$.ID running query with GROUP BY CUBE and CONNECT BY
3582445	Predicate on PARTITION BY clause of WINDOW function not pushed into view
3607226	No predicate pushing into UNION ALL view with analytic function/s

Application Context

3306667	Wrong length possible for value from SYS_CONTEXT()
3570286	OERI[733] from high use of application context (DBMS_SESSION.SET_CONTEXT)

Constraint Related

2858689	Wrong results possible from CHECK CONSTRAINTS which are not NULL SAFE
3097081	"ALTER TABLE x modify ..." cannot add certain column constraints (ORA-2253)
3275424	Array insert may report false constraint violations with row triggers
3352413	An ORA-8102 error can occur on ATEMPIND$ during a user UPDATE with CONSTRAINTS
3363424	Wrong results from query if base table as LPAD/RPAD/LTRIM/RTRIM check constraints
3418978	ORA-1 may be thrown immediately for a deferred constraint
3433964	Wrong result with deferred check constraint when table analyzed
3598341	Enabling constraints can lead to memory corruption / dumps
3635177	Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild
3676271	ORA-1403 applying DML with delete cascade constraints

Datatypes (LOBs/CLOB/BLOB/BFILE)

3544995+	LOB segments with "CACHE READS" generate no REDO even with the logging option
2256943	Dump (in kohalw) selecting TEMPORARY LOB over a DBLINK
2380066	Temporary LOB performance degrades with ADTs
2660148	LOB Index extent sizes may be larger than expected
2810530	ORA-22285 from DBMS_LOB.LOADFROMFILE
2817818	BLOB.length() returns a negative value when data exceeds 2gb with thin driver
2840895	ORA-22921 inserting into remote CLOB with varying width characterset
3127987	NCLOB data is corrupted after insert through JDBC
3141248	Temp LOB leak applying PLSQL operator to the LOB
3163264	Dump / memory corruption at logical standby for LOB table with trailing nulls
3166756	Self deadlock (ORA-60) possible on LOB index update
3194872	Using TEMP CLOB in TABLE function may fail with ORA-22922
3263671	ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
3288625	ORA-22621 / OERI:kopuigpfx1 using LOBs in OCI Extproc
3291851	EXP-3 exporting LOB from 9205 or higher DB with <9205 export
3309296	The retention value of a partitioned LOB is always 0
3310330	Select with ORDER BY over HS fails when table has long/blob datatype
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
3446987	OERI[19942] after TRANSPORTING a TABLESPACE containing LOBS (converted from LONGS)
3463669	Memory leak with LOB bind with JDBC OCI driver
3477127	Dump (kollgsz) when OCIStmtFetch2 fetches a NULL CLOB
3492211	ORA-23308/ora-23309 replicating pre-created tables with LOB
3498315	Insert CLOB datatype from single-byte database to UTF8 hangs
3527223	OERI:kokegPinLob1 from SELECT with ORDER BY on table with CLOB
3532017	OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
3556570	"select length(foo()) ..." leaks temp LOBs between rows
3602321	Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
3686945	Long CLOB data not updated correctly with LOB buffering in multibyte DB

Datatypes (Objects/Types/Collections)

2270510	IMP-58 / ORA-22337 importing evolved type object table
2380066	Temporary LOB performance degrades with ADTs
2392650	ORA-22324 / ORA-22328 / OERI:koputilcvto2n on ALTER TYPE to add an ATTRIBUTE
2445596	ORA-30746 / OERI:kkdoicst1 when DROP subtype validate with pk-based OID
2557089	OCI-21500 [kope2upic954] querying ADT
2588469	OERI [15419] when calling the member procedure in a final subtype
2669061	ORA-1007 exporting table with VARRAY
2711453	CONNECT BY on a collection type may return wrong results or no rows
2816062	Wrong result when using '+' as outer join on indexed REF column
2914804	OERI:[kokbnp2] executing method in schema with same name as an object
2929029	Wrong results comparing a REF type with != or <> in the WHERE clause
3054910	ALTER TYPE does not support change of codepoint semantics
3156820	ORA-23309 during CREATE_MASTER_REPOBJECT or table with OBJECT columns as LOBs
3194872	Using TEMP CLOB in TABLE function may fail with ORA-22922
3230967	ORA-979 from complex view merge with TABLE() on outer query block
3248893	OERI [17285] possible if TABLE() function invalidate
3276952	Export / import of nested table from dictionary to locally managed tablespace fails
3278020	ORA-942 creating MVIEW across dblink from 9i to 8i for object table
3342768	Dump performing a hierarchical query on an inline view with a TABLE clause
3385076	Complex object retrieval may fail with OCI-21700
3402567	OERI[koputilcvto2n: 2] during ALTER TABLE for object table
3430870	ALTER TYPE of self referencing type body generates PLS-565 with trailing comments
3455357	OERI:voprvl1 can occur using TABLE() with OLS installed
3465087	ORA-905 possible from CAST() over DB link if "AT" clause is a column name
3476435	OERI:koksadqb2 compiling a package containing CAST(MULTISET(collection subquery)))
3545642	Wrong result when using LEFT OUTER joins and TABLE() operator
3546174	OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
3625129	OERI[kopp2upic#329] possible querying a nested table
3643391	ORA-4043 "object does not exist" using a SYNONYM of a TYPE in JDBC
3786302	ANSI join with correlated TABLE() clause fails (ORA-904)

Datatypes (TIMESTAMP)

3120680	DatabaseMetaData.getTimeDateFunctions() can return wrong values for 8i DB
3141614	TIMESTAMPs can get wrong data if fraction of seconds is >9 digits long
3144878	oracle.sql.TIMESTAMP is not serializable
3222472	HS TIMESTAMP implementation does not allow fractions of a second
3663103	getTimestamp may return truncated time value using Calendar parameter

Direct Path Operations

2322586	ORA-7445 [QERLTIDLM] using APPEND hint and INSTEAD OF triggers
2691348	ORA-600 [16049] from direct load into partitioned table with bitmap join index
2708814	Fewer rows per block than expected from direct load with SQL functions
2723819	Direct SQLLOAD may fail (OERI:6937 / OERI:kcblnb_1) with small PCTFREE
2942185	Corruption occurs on direct path load into IOT with ADDED columns
3083905	Direct load may fail with error for NULL column data
3313274	Direct path load of LOBs can cause data loss/truncation in streams
3336551	SQLLDR direct path fails using SQL strings in the control file
3461768	SQLLDR direct path may reject good rows after character to RAW conversion error
3482332	Direct path loads may fail / corrupt space information
3560900	OERI[kcbchg1_3] during direct path insert
3568433	Apply gets unsupported LCR or no-data found error for partitioned tables

Global Temporary Tables

2964692	Wrong results with parallel index fast full scan on a global temporary table
3172456	Capture aborts when temporary table and CLOB are used in combination
3238525	Upgrade from 9.0 can leave corrupt IND$ data for global temporary table indices

Globalization Support (NLS)

2840895	ORA-22921 inserting into remote CLOB with varying width characterset
2896849	Dump possible using NLS_SORT=french_m, canadian_m or danish_m
2965256	ORA-12714 using SQL function on NVARCHAR2/NCHAR operands
2996631	Implicit conversion from nvarchar2 to varchar2 problems in PLSQL
3043199	Dump in lxsCnvNumStrToInt possible from TO_DATE in shift-sensitive character set
3121424	OERI[qxidmgetrid:wrong typ_qeeOpt] on ALTER DB CHARACTERSET with domain index
3127987	NCLOB data is corrupted after insert through JDBC
3138618	Date format errors / wrong results on first SQL on table with check constraint on date column
3170389	Intermittent dump (in lxkLikeUTF8) possible from LIKE '%'
3191700	WE8PC850 is missing some unicode mappings
3239634	Error message (ORA-1403) is not converted to client character set
3273357	Wrong results for Text queries with Japanese lexer with single byte spaces
3312423	Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values
3371861	NLS_DATE_FORMAT may change when not expected
3377754	"lxinst" fails when trying to have more than 127 "special uppercase" entries
3393350	NLS characters may be corrupted over DB link for NCHAR data with OCI7
3430426	ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
3447478	ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
3453408	Intermittent dump (in lxkLikeMBNS) possible from LIKE '%' from JDBC
3469640	Fixed width strings not blank padded over HS
3525717	HS errors from remote DB not translated to clients character set
3560623	JDBC IW8ISO8859P8 reports as "ISO-8859-8" instead of "ISO-8859-8-I"
3628621	ORA-6502 from DYNAMIC SQL in AL32UTF8
3630966	Internal NLS issue in lxiskip() for multibyte character sets
3642764	PGA corruption possible with CURSOR_SPACE_FOR_TIME if NLS parameters altered
3662892	Procobol errors for HOST VARIABLE / COLUMN NAME with multibyte character
3686945	Long CLOB data not updated correctly with LOB buffering in multibyte DB
3701858	9.2 with NLS_LANG of zht16hkscs gets ORA-3106 to 10g server with ZHT16HKSCS2001
3750885	Ultrasearch uses wrong character set for MAC database character sets

Hash Join

2619861	Wrong results from hash join on char=nchar columns
3216002	HASH JOIN ANTI / SEMI can use a lot of CPU / spin
3487338	Wrong results possible from hash join
3561624	Dump possible from HASH join with large hash_area_size > about 18Mb
3657023	OERI[kcblco_1] possible from HASH joins with migratable sessions
3672097	Wrong results HASH join of CHAR / NCHAR over database link

Literal Replacement (CURSOR_SHARING)

3128363	OCIAttrGet returns wrong size when CURSOR_SHARING=SIMILAR or FORCE
3132071	Wrong results possible with CURSOR_SHARING=FORCE|SIMILAR
3148830	Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
3406977	High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE
3614299	Dump adding a subscriber with a rule containing literals with CURSOR_SHARING = FORCE|SIMILAR
3668572	ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY

Merge SQL (MERGE .. USING)

2605276	OERI[qkadrv.ups2] using MERGE statement
2719742	Too many rows inserted by MERGE if a row is updated before the merge operation
3326634	OERI[qertqgetcolumndef2] / OERI:15800 from parallel MERGE
3530612	Dynamic partition pruning may not occur on MERGE
3672876	Dump on execution of a MERGE statement in replication

Online DDL

2761575	Logical standby may stop for "alter index rebuild online" DDL
3315378	A blocked ONLINE index rebuild can cause other DML to hang
3430832	OERI[25012] in DML after ONLINE create index against PARTITIONED table
3562032	Cancelled ONLINE index rebuild can deadlock with DML session
3566511	ONLINE index rebuild can cause DML sessions to hang.
3622875	False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
3635177	Dump [KXCCUIN] possible from DML with concurrent ONLINE index rebuild

Optimizer

2136549	Incorrect cardinality estimate with not equals and NULL values
2203759	Poor cardinality estimate for "IN" transformation using join with duplicate elimination
2417506	Wrong results from outer joined column comparison with operator
2423599	Incorrect cost estimation with bitmap index, range partition and nested loop
2495397	GATHER_INDEX_STATS fails against a GLOBAL RANGE PARTITIONED index
2524044	Wrong result possible from CONNECT BY with CBO
2549574	Dump (SIGFPE) can occur using FIRST_ROWS(k) optimization
2628067	Wrong results possible from anti-join
2639311	Wrong result with multi join key prefetsh
2670788	OERI[qerixgetkey:optdesc] / dump from SELECT using AND-EQUAL with DESC index
2684468	Dump [kkosbn] from FIRST_ROWS(N) optimization
2820066	CPU cost is computed when optimizer_index_cost_adj is set
2858689	Wrong results possible from CHECK CONSTRAINTS which are not NULL SAFE
2953803	"MONITORING" clause does not work for partitioned IOTs
3016085	GATHER_TABLE_STATS fails on IOT with bitmap indexes
3047105	Wrong results possible from query involving CONNECT BY and join
3085933	Semijoin elimination may dump if the subquery contains virtual column expression
3134318	Dump from non-join predicates with implicit type conversion and INLIST
3150750	DBMS_STATS auto_sample_size can produce poor estimated NDV
3159259	Histogram deleted by creating new index with compute statistics
3177513	Join not avoided using bitmap join index if UNIQUE index exists also
3177769	Wrong results OR predicates inside AND chains of OR predicates
3187502	Wrong results from SQL with HAVING GROUPING
3193835	Unnecessary partition scanning depending on predicate order
3210455	0 selectivity and cost for CTXXPATH index #
3230967	ORA-979 from complex view merge with TABLE() on outer query block
3239873	High CPU during parse of statements with many identical predicates
3262241	ORA-1422 executing DBMS_STATS.GATHER_SCHEMA_STATS('SYS')
3268237	CBO may not use transitive predicates for partition keys
3280226	ANALYZE to collect statistics may use more memory than expected
3286346	Rebuild partitioned index and exp/imp of statistics causes inconsistent stats
3289786	Suboptimal plan possible with inline view and binds (or replaced literals)
3291402	ESTIMATE_PERCENT may not be used when calling DBMS_STATS.GATHER_INDEX_STATS
3297301	DBMS_STATS gather of histogram statistics slow
3302372	Dump [qerixgetkey] / OERI[12411] from complex view merging
3304455	Dump possible in kkeargdesc/kkearg/kkefuncf during optimization
3317309	Bad plan choice due to poor selectivity for "col=:bind" or "col=expression" for single value column
3322366	Imported outlines are not used
3349903	Bind peeking does not work for partitioned objects with non-equality predicates
3352279	ORA-14093 / wrong results from subquery pruning with composite partitioned table
3352869	OERI[kgmgcdty2] possibled from queries using TABLE() functions in views
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
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
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
3427995	Stored outlines not created and not used when SQL has both INSERT and a set operation
3446722	Wrong results from CBO with constant predicates and CHAR = VARCHAR2 column
3466737	Memory corruption optimizing SQL with OR predicates
3470037	OERI[xtycsr2] from FIRST_ROWS with a sub-query using GROUP BY
3485930	Slow performance of DBMS_STATS with auto sample size
3497949	Wrong results or ORA-1410 using stored outlines for CONNECT BY query
3499674	CBO may overestimate cost of NL join with index
3516951	Poor execution plan with merge join cartesian with temp table transformation
3542588	Event 38041 used for bug fixes 3444115 and 3131551
3545209	Poor performance from semi join with NL to remote table
3546174	OERI[kcbgtcr_1] from subquery unnesting of a subquery containing a TABLE() function
3553962	ORA-18003 rebuilding an outline for SQL with leading spaces
3554954	Bind peeking overides _LIKE_WITH_BIND_AS_EQUALITY selectivity
3557842	ORA-903 with UNION ALL in a view
3557906	OERI[qctcte1] from predicate move around
3558780	Wrong cardinality estimated on table with an unnested subquery predicate
3559212	Wrong results possible from CBO with multi-table OR list
3565117	Cartesian join can occur due to not unnesting a subquery
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
3599966	Wrong results when multi-column SMJ used after semi-join elimination
3601653	Subquery partition pruning does not work with SYSDATE predicate/s
3607226	No predicate pushing into UNION ALL view with analytic function/s
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
3648249	SQL may dump (in KKOGTP) during parse
3649683	OERI:KGHALO2 / OERI:KGHALP1 on a query with large number of predicates
3668224	Bind peeking does not occur for predicates of the form COL <op> FUNC(:bind)
3690369	Incorrect cardinality estimation when using LIKE predicates
3695271	Dump (kkojije) with bitmap index and multi column inlist
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
3759730	OERI:kssrmp1 with fix for BUG 3589588 if AUDIT_TRAIL=true
3763027	Dump (in KKOJNP) possible parsing query with pushed join predicate
3815906	DBMS_STATS fails with ORA-909 in ntile() function
3822213	Explain plan with STAR transformation may spin in qkaPobs

Parallel Query (PQO)

2365168	Wrong results with PQO and partitioning
2663013	Queries with SYS_CONTEXT operator are not parallelized
2764655	V$SYSSTAT "logons cumulative" may be wrong if parallel query used
2783416	OERI[qkaorderbypd 3] selecting ROWNUM with a WINDOW sort in parallel
2929556	ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
2964692	Wrong results with parallel index fast full scan on a global temporary table
2982545	OERI[15819] from PQ with multi-table join
3033955	Wrong results from UNION ALL with correlated subquery
3109552	ORA-12805 possible due to send timeout
3150924	ORA-2149 specifying a subpartition clause in a SELECT
3241919	Analytic functions may dump in parallel
3273109	Wrong results possible for NULL in SELECT list for PQO or remote query
3273522	Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
3295568	OERI[kkpapdimtolevel1] possible for parallel queries
3306619	Semijoin elimination with parallel query returns wrong result
3318204	Parallel query gives wrong results with view
3356103	OERI[opibnd0: oaccsid] possible from parallel query
3384741	Wrong results from parallel query with redundant join criteria
3385243	Wrong results from PQ against partitioned tables
3437636	"servers highwater" in V$PX_PROCESS_SYSSTAT can be wrong briefly
3447383	Wrong results with parallel query and partition table join
3473315	Dump in lnxcpn from parallel ALTER INDEX REBUILD
3491603	Wrong ORDER BY from parallel execution
3515018	Dump (in msqopnws) on SELECT DISTINCT with PARALLEL BITMAP INDEX
3569503	PQ may signal a false ORA-8103 under load
3577772	OERI[kcbgkcbcr_1] possible from PQO
3605241	Enhanced diagnostic information for internode parallel query
3649839	Intermittent ORA-12805 on internode parallel create/rebuild index
3658974	OERI:12455 from parallel DML with bitmap index
3688894	Dump (msqpfn) from PQ select with remote function
3740073	Parallel insert allocates an extra buffer row source

Query Rewrite (Including Materialized Views)

1718232	CREATE SNAPSHOT fast with rowid on xmltype column fails
2455147	Query rewrite may not free allocated memory correctly
2468132	Bitmap join index logging not done for materialized view
2668225	DRG-100 [50935] / ORA-942 from text query on partitioned MVIEW
2950468	ALTER SNAPSHOT makes a readonly snapshot updatable
3083802	Complete refresh of an object materialized view can fail with ORA-942
3094453	Wrong values possible in single table aggregate materialized view
3236491	ORA-32332 possible during refresh of MVIEW
3263839	Upgrade from 8i -> 9.0 -> 9.2 does not update MVIEW dictionary fully
3278020	ORA-942 creating MVIEW across dblink from 9i to 8i for object table
3330412	ALTER MV CONSIDER FRESH raises ORA-12003
3330538	Query rewrite does not occur for table with RLS policy
3332578	Refresh of materialized view hangs refresh / results in OERI[kkzgajgd_of2]
3345441	Cannot load user workloads when workload query references views only
3355726	Create materialized view raises ORA-4021
3358490	OERI[kqsccck:1] possible with query rewrite
3370917	Summary metadata corrupted during REFRESH if MVIEW has inline views
3391999	ALTER MATERIALIZED VIEW CONSIDER FRESH can change the refresh method
3395198	Query rewrite may spin after partition exchange
3398224	ORA-12015 on outer join MJV with decode statements
3398485	Deadlock during on demand materialized view refresh (ORA-4020)
3404500	ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
3414440	Query rewrite may spin in qsmg_process_sqltxt for ANSI join in a view
3466879	ORA-1401 inserting into audit trail when creating a Materialize View
3477460	Query rewrite can return wrong results
3485997	MVIEW log may be populated by DML updating a column not covered by the log
3516206	Fast refresh of materialized view fails with ORA-1406
3644243	Create MVIEW on scalar subquery in SELECT list gives ORA-22818
3646305	ORA-942 from MVIEW refresh after dropping and recreating table
3654532	Spin possible from query rewrite with temp table transformation

Star Transformation

2616719	OERI[kkojocol:2] using GROUPING SETS with STAR TRANSFORMATION
2997041	OERI[17271] when exiting session after running STAR query calling PLSQL
3188637	Wrong result with star transformation and OUTER join
3309646	ORA-942 from star transformation
3412136	Poor plan (with merge join cartesian) with STAR transformation
3546575	OERI[qks3tCTT:1] possible using star transformation
3566478	ORA-928 can occur with star transformation with CONNECT BY
3625392	wrong results / dump (evaopn2) with star transformation
3649979	OERI[qesmmCValStat4] from star transformation
3822213	Explain plan with STAR transformation may spin in qkaPobs

Star Transformation With Temp. Tables

3360868	Dump in kkoeqv with temp table transformation
3412136	Poor plan (with merge join cartesian) with STAR transformation
3454814	Wrong results possible from STAR TRANSFORMATION
3516951	Poor execution plan with merge join cartesian with temp table transformation

Triggers

1867670	Dump when using a trigger on an ADT or TIMESTAMP column
2322586	ORA-7445 [QERLTIDLM] using APPEND hint and INSTEAD OF triggers
2820694	XA transaction rollback can cause SERVERERROR trigger to dump
2879641	BEFORE ROW TRIGGER produces corrupt data with INSERT from SORT MERGE JOIN
3047933	LOGON trigger may dump in RAC on first invokation
3124081	SERVERERROR trigger may dump in qdesqltxt for some errors
3199908	Dump (in kkmmctbf) from a DELETE TRIGGER compiled in DEBUG mode
3275424	Array insert may report false constraint violations with row triggers
3405682	ORA-23416 in logical standby database from non-key update on primary with trigger
3571946	DELETE trigger does not fire on delete with index scan
3605165	Hang/deadlock between sessions concurrently loading a cursor with INVALID trigger
3717619	Deadlock/hang possible due to concurrent cursor loads referencing same INVALID trigger
3766568	ORA-6502 (VALUE ERROR) during trigger execution with codepoint semantics in multibyte

Truncate

2014833	Deadlock possible from concurrent SELECT and TRUNCATE
3338673	TRUNCATE does not reset the NEXT_EXTENT value of a locally managed table migrated from dictionary managed

ASSM Space Management (Bitmap Managed Segments)

3785200*	Corruption possible in automatic space managed segments This bug is alerted in Note 281047.1
3771668+	Poor INSERT performance with ASSM
2921895	ASSM tablespace has large initial extent size for >=16k DB_BLOCK_SIZE
3064159	Sessions using ASSM segments may leak memory
3304290	OERI[kcbgtcr_13] scanning ASSM segments if cursor invalidated
3329096	Free space may not be used in an AUTO SPACE MANAGED segment
3430832	OERI[25012] in DML after ONLINE create index against PARTITIONED table
3613078	OERI[4097] from DML on TRANSPORTED tables with ASSM
3687456	OERI[ktspgetmyb-1] / Corrupt LOB if EXTENT size not multiple of LOB CHUNK SIZE

Bitmap Indexes

3293688	OERI[504] / OERI[510] using bitmap indexes with shared servers
3358065	Dump (kkoiop) using bitmap join index
3515018	Dump (in msqopnws) on SELECT DISTINCT with PARALLEL BITMAP INDEX
3622875	False ORA-1499 from ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
3658974	OERI:12455 from parallel DML with bitmap index
3695271	Dump (kkojije) with bitmap index and multi column inlist

Compressed Data Storage

3262424	ALTER TABLE NOCOMPRESS does not work for partitioned tables
3579567	Corrupt export exporting a compressed table with direct=y (IMP-9)

Compressed Key Index / IOT

3347963	OERI [6120] during compressed IOT insert
3629771	Wrong results possible from COMPRESS KEY INDEX SCAN

Domain Indexes

2893444	Internal SQL in the extensible optimizer does not always use bind variables
2909346	Domain indexes can produce recursive literal SQL (affects shared pool)
3094739	ORA-29908 / ORA-12801 using PQ with ancilliary operators such as CONTAINS / SCORE
3105313	Dump[strlen] when performing a domain-index search with a UNION
3121424	OERI[qxidmgetrid:wrong typ_qeeOpt] on ALTER DB CHARACTERSET with domain index
3162494	Dump (qcsfsqcn) querying XMLType column with VARRAY and domain index
3194997	DDL against domain indexes can use lots of memory
3200136	Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
3347339	Stored outline has "NO_ACCESS" instead of "INDEX" hint for domain index access
3545539	Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
3779927	Dump (under qxidmid) from INSERT INTO with a DOMAIN index

External Tables

3250195	KUP-4050 / memory leak from consecutive SELECTs against external table
3357740	Wrong results from external table in subquery
3748283	Small PGA memory leak in kpodscn for long running PLSQL against external tables

Function Based Index (Including DESC Indexes)

2907118	Dump (qkexrxformopn_col) collecting statistics with DROPPED column/s
2971238	Dump (kkeosl) running a query on a table with functional index
3250883	Inline view using functional index can give wrong results
3253133	Dump (in evaopn2) from queries using a FUNCTIONAL INDEX with complex view merging
3365045	Functional index on DATE column can depend on NLS_DATE_FORMAT (ORA-8102 on DML)
3396223	wrong results with function based index and DECODE function
3406611	Wrong results accessing data via a function based index
3410546	Function-based index metadata left in COL$ after column is dropped
3453267	ANALYZE may dump in qmxGetFirstChild for XMLType with functional index
3628474	Select on empty table with functional index may dump in kpobav
3630053	Dump (kkfipf) querying a table using a DESC index with OUTER join
3673420	Dump when function based index exists which includes "ROWID"

Index Only Tables (IOT)

2576703	IOT block corruption from insert after columns added to all-key IOT
2771042	OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy
2942185	Corruption occurs on direct path load into IOT with ADDED columns
2953803	"MONITORING" clause does not work for partitioned IOTs
2994527	DBA_TABLES.LOGGING not shown for IOTs
3076818	OERI[2000] during CR undo of array delete in IOT secondary index block
3347963	OERI [6120] during compressed IOT insert
3566124	OERI[insrow-1] during array insert with SAVE EXCEPTIONS and IOT
3566361	DBMS_IOT.NUMBER_TO_UROWID is slow

Partitioned Tables

1608474	ORA-2266 on EXCHANGE PARTITION
2219874	CTAS / ALTER range-list partitioned table can dump (in ctcpre)
2365168	Wrong results with PQO and partitioning
2495397	GATHER_INDEX_STATS fails against a GLOBAL RANGE PARTITIONED index
2668225	DRG-100 [50935] / ORA-942 from text query on partitioned MVIEW
2691348	ORA-600 [16049] from direct load into partitioned table with bitmap join index
2861999	Wrong query results after ALTER TABLE SPLIT PARTITION
2921194	ALTER TABLE allows wrong partition to be added into the existing table
2921612	Query with anti/semi join against a partitioned table can give wrong results
2929556	ORA-372 ORA-1110 inserting into partition with enable PARALLEL DML set
2953803	"MONITORING" clause does not work for partitioned IOTs
2967313	EXCHANGE PARTITION does nOt apply unless tables are qualified with schema name
3128021	Corrupt column data after EXCHANGE PARTITION with row dependencies
3150924	ORA-2149 specifying a subpartition clause in a SELECT
3160137	Import of partitioned Text index improperly parses parameters
3161122	Wrong results (no rows) when list partitioned table inner in nested loops join
3175001	ORA-1426 REBUILDing Text index with more than 255 partitions
3193835	Unnecessary partition scanning depending on predicate order
3262424	ALTER TABLE NOCOMPRESS does not work for partitioned tables
3265740	Corrupt column data after PARTITION maintenence with ROWDEPENDENCIES
3268237	CBO may not use transitive predicates for partition keys
3273522	Dump (qerpxsetparttq()+588] doing select on partitioned table parallel
3281907	Export / import of a composite partitioned table can appear to spin during IMPORT
3286346	Rebuild partitioned index and exp/imp of statistics causes inconsistent stats
3294293	OERI[12455],[pti:qkaqkn] on SELECT FOR UPDATE of partitioned table with WINDOW functions
3309296	The retention value of a partitioned LOB is always 0
3312256	OERI[kftts2bz_many_files] / wrong results after ALTER TABLE MOVE of partitioned table
3349903	Bind peeking does not work for partitioned objects with non-equality predicates
3352279	ORA-14093 / wrong results from subquery pruning with composite partitioned table
3367979	Distributed query on partition table fails with ORA-2021
3377931	SAVE EXCEPTIONS does not work reliably with a partitioned table
3385243	Wrong results from PQ against partitioned tables
3387588	Dump (lnxdiv) updating partitioned table
3395198	Query rewrite may spin after partition exchange
3400412	CBO may choose a more expensive HASH JOIN plan with no partition pruning
3424721	Hang/deadlock from ALTER INDEX REBUILD on partition with concurrent SQL
3430832	OERI[25012] in DML after ONLINE create index against PARTITIONED table
3512123	Dump (evaopn2) with BETWEEN predicate on PARTITIONED table
3530612	Dynamic partition pruning may not occur on MERGE
3595110	OERI[12337] from multi-column INLIST with partitioned table
3601653	Subquery partition pruning does not work with SYSDATE predicate/s
3643476	RENAME of partition/subpartition can throw ORA-54
3661254	Dump with partitioned tables and INLIST
3746423	Sub-optimal execution plan for range partitioned table with INLIST
4322477	Consecutive runs of Spatial query on partition table progressivly get slower

Read Only Tablespace/s

2642076	RMAN "duplicate" fails if too many files OFFLINE/in read-only mode
3455402	Concurrent DROP / ALTER TABLESPACE READ ONLY can corrupt the dictionary
3496324	OERI[2886] changing tablespace from "read only" to "read write" access

Space Management

2660148

LOB Index extent sizes may be larger than expected

Space Management (Locally Managed Tablespaces)

2481414	ALTER TABLESPACE ... DEFAULT COMPRESS reports ORA-10616
2921895	ASSM tablespace has large initial extent size for >=16k DB_BLOCK_SIZE
3159124	EXP-68 even though locally managed tablespaces are not offline
3276952	Export / import of nested table from dictionary to locally managed tablespace fails
3338673	TRUNCATE does not reset the NEXT_EXTENT value of a locally managed table migrated from dictionary managed

System Managed Undo (SMU)

3212131	Many 'undo segment' messages in the alert log
3439552	OERI[4406] possible in SMON using automatic undo management

Advanced / Secure Networking

3143435	JDBC Thin connecting to server with ASO and DCD gets NegativeArraySizeException
3212916	Exception in SSLReadRecord from JSSL client
3387739	Kerberos replay cache errors connecting between 32 / 64 bit instances on same host
3553251	User certificates with "Extended Key Usage" can fail
3889519	Errors on data transfer via SSL with security alert #68 installed

Database Link / Distributed

2218349	Using Multilevel collection over RPC (dblink) may dump/PLS-801
2256943	Dump (in kohalw) selecting TEMPORARY LOB over a DBLINK
2597829	Poor execution plan possible for remote inserts
2610353	Dump / memory corruption possible from remote select
2624328	Query over database link can return wrong results
2840895	ORA-22921 inserting into remote CLOB with varying width characterset
2851970	Dump possible for SQL over DB LINK if temp table transformation occurs
2876340	ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
2932269	Sessions hang on "resmgr:waiting in end wait" while session tries to connect over DBLINK
3031118	Wrong result joining a local table with a remote table
3061457	ORA-2019 from Jdbc Thin
3069714	Dump possible in ddfnetCFull from remote query
3110547	ORA-904 / wrong results from query over database link
3148830	Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar
3219124	DCD stops working if a DB LINK name is resolved via LDAP name resolution
3263671	ORA-2019 from INSERT INTO .. SELECT from remote LOB using a PUBLIC synonym
3273109	Wrong results possible for NULL in SELECT list for PQO or remote query
3278020	ORA-942 creating MVIEW across dblink from 9i to 8i for object table
3367979	Distributed query on partition table fails with ORA-2021
3393350	NLS characters may be corrupted over DB link for NCHAR data with OCI7
3393962	ORA-972 on query with UNION ALL and internally generated column name over DBLINK
3411748	OCI7 SELECT FOR UPDATE over DBLINK may dump client in kpuridalo1
3430426	ORA-1459 attempting to SELECT a LONG via a database link with multibyte using JDBC
3447478	ORA-6502 calling PLSQL over a DBLINK with RECORD parameters with UTF8/AL32UTF8
3456977	ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
3458438	Update a long >4k that affects more than 1 record over DB link hangs
3465087	ORA-905 possible from CAST() over DB link if "AT" clause is a column name
3498315	Insert CLOB datatype from single-byte database to UTF8 hangs
3512385	Wrong ROWID returned from SELECT over DBLINK when PREFETCH is on
3532017	OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
3545209	Poor performance from semi join with NL to remote table
3571263	Excessive build-up of distributed transaction locks (DX locks)
3576897	ORA-22804 inserting over a database link with select using CASE
3668077	"rollback to savepoint" in a distributed transaction dumps
3672097	Wrong results HASH join of CHAR / NCHAR over database link
3673561	READ_SCN may not advance even when there is no eager transaction
3676676	Ctrl-C/interrupt ignored for query over DB link
3688894	Dump (msqpfn) from PQ select with remote function
3700058	Rollback to a savepoint with a DB link can result in a full rollback

Gateways / Heterogeneous Services

3580447P*	AIX: HSODBC does not work in 9.2.0.5 on AIX platforms This bug is alerted in Note 269472.1
2546095	ORA-28528 executing DB2 stored procedure over HS link
2617729	Wrong rowcount for insert with subquery involving remote HS function
2918874	JDBC Thin against HS databases can fail with ORA-1002
3217204	Internal HS fix
3222472	HS TIMESTAMP implementation does not allow fractions of a second
3222625	HS gateway may dump (in horsh) when doing an array fetch
3250970	Dump (in hokbrp) inserting into a remote table via transparent gateway
3259441	ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
3296914	Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
3310330	Select with ORDER BY over HS fails when table has long/blob datatype
3341264	Gateway dumps for update on NCHAR column for binds over 255 bytes long
3345208	ORA-28502 internal communication error on heterogeneous database link
3469640	Fixed width strings not blank padded over HS
3525717	HS errors from remote DB not translated to clients character set
3579719	Wrong data length returned selecting CHAR column over HS
3594734	Dump when accessing HS table with over 20 indexes
3609791	SQLCODE -310 / incorrect SCALE over HS for numbers with zeroes after the decimal place
3617519	MGW to MQseries transformation fails with ORA-932
3692385	The default translation for UNION and UNION ALL is missing a space

Gateways / Transparent Gateway For Informix

3298136	Invalid table name data returned on describes with TG4IFMX
3647442	Literal comparison with NULL doe not work with Informix gateway

Gateways / Transparent Gateway For Sybase

3090426	A query over HS to Sybase with nested aggregates returns ORA-2603
3561468	Cannot use OUTER JOIN against SQL Server view
3694957	SQL Server REAL looses precision
3745531	Incorrect ALIASES for gateway involving a JOIN of local tables

Interoperability (Between Releases)

2876340	ORA-904 accessing a remote object from PLSQL (remote DB < 9i)
3120680	DatabaseMetaData.getTimeDateFunctions() can return wrong values for 8i DB
3296914	Using binds from 8i instance to a 9i instance to a 9i Gateway can hang
3456977	ORA-2046 using SQL with AUTOCOMMIT for DB link between 9i/10g and 8i
3488716	PLSQL RPC from >=9.2 to 8.0 instance may dump at the client side
3489246	OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
3532017	OERI:kokegPinLob1 possible inserting CLOB from 10g to 9.2
3701858	9.2 with NLS_LANG of zht16hkscs gets ORA-3106 to 10g server with ZHT16HKSCS2001

Network

2516787	Repeated ATTACH / DETACH can leak client memory if ADDRESS in ADDRESS_LIST uncontactable
3089971	Parameter not read for listeners with names like <listener>_<*>
3219124	DCD stops working if a DB LINK name is resolved via LDAP name resolution
3408829	TNS listener leaks memory if remote listener specified in LOCAL_LISTENER
3507883	Uneven connection distribution when PREFER_LEAST_LOADED_NODE is set to OFF
3543974	PROGRAM name may have a NULL value in Net connection packets

Oracle Names

3259441	ORA-28545 when trying to resolve gateway TNS alias through Oracle Names
3286122	Names proxy spins if subtree entry is "" and orclnetservice in root oraclecontext
3306350	Client connections using NAMES do not close the connection
3823774	Names 'dump_tnsnames' dumps if tnsnames.ora missing

Security ( Authentication / Privileges / Auditing )

3400967

IMP-17 / ORA-6550 importing a wrapped password verification function

Transparent Application Failover

2560983	SYSDBA does not failover when TAF is implemented
3195907	JDBC client may dump under t2cDefineExecuteFetch after FAILOVER
3224506	XA client using TAF may not failover correctly
3319215	TAF client may dump if failover occurs during authentication
3428146	For XA with JDBC in an RAC environment ensure we are synchronized before recover
3507464	XA rollback / commit do not handle RAC failover transparently
3566056	Dump possible after failover
3656777	ODBC / OCI connection using TAF preconnect method gets ORA-1017

XA / Distributed Transactions

3566945+	ENH: No block level locking for externally co-ordinated prepared transactions
2618770	JDBC connection obtained from XAConnection has autocommit off
2820694	XA transaction rollback can cause SERVERERROR trigger to dump
3224506	XA client using TAF may not failover correctly
3287202	Server trace file is produced if ORA-24767 is encountered in JDBC/XA
3425196	Dump in sqldhb using V8 OCI XA with Precompiled code
3428146	For XA with JDBC in an RAC environment ensure we are synchronized before recover
3488761	SQLException "Closed Connection" from OracleXAConnection.getConnection()
3507464	XA rollback / commit do not handle RAC failover transparently
3621886	JDBC XA cannot commit indoubt transction just after startup instance
3702868	XA trace file does not start a new trace file every day

Physical Standby Database / Dataguard

2347000	Archive logs may not be applied to the standby within the specified delay
2414110	Recover managed standby "finish skip" clause may fail
2820848	LGWR may not wait long enough (ORA-16163)
3082938	Failover using arch transport fails on RECOVER .. FINISH command
3199127	Local log archive destinations lost after switchover
3241257	ORA-326 on physical standby
3412999	OERI[kcrfrgv_scn6] on "alter database recover ... finish"
3453107	ORA-16061 when archiving standby redo logs after failover
3478079	RFS process keeps reporting "rfs: error state mode '8'" in alert log
3533351	FAL does not check available logs if some logs are not found
3535712	OERI[3020] / ORA-10567 from RAC with standby in max performance mode
3572299	Tablespace recovery of offline tablespace fails with OERI[kcrrlcmp.10]
3597439	ORA-1153 starting managed recovery when an RMAN backup is running
3639028	RMAN backups fail (ORA-19595) after Standby stopped / started

Advanced Queuing

3109964	Export 8i / import AQ queue can give ORA-24033 when enqueueing a message
3122154	AQ JMS receive(wait_time) does not return after wait_time
3148239	AQ PLSQL notification callback does not record an error when it fails
3168530	AQ order of messages may not be preserved
3195244	Dump propogating ADT messages to JMS type queue
3231814	Client may dump if AQ unregister fails and the subscription handle is freed
3237530	Intermittent ORA-25248 errors in alert file using AQ
3288732	AQ propagation can hold library cache locks longer than needed
3317029	Dump (korfpoid) / OERI[kocpnsh014] / OERI[kwqidjqp0] from AQ in RAC
3336594	High CPU use in QMON scanning DEF$ tables needlessly
3358440	AQ propagation fails with ORA-942 or OERI:16622 at the remote node
3456044	Poor AQ performance from multiple dequeuers performing rollback
3486019	Dump in kwqiclod possible using AQ
3554319	OERI[kqludp2] can occur adding a RULE to a RULESET
3588250	Do not report resignalled errors in AQ
3601748	JMS client exit leaves subscribers in AQ
3611423	PGA memory leak in AQ propagation process(J000)
3614299	Dump adding a subscriber with a rule containing literals with CURSOR_SHARING = FORCE|SIMILAR
3656306	JMS application may throw "UnsatisfiedLinkError: ociinit"
3658039	ORA-6540 / shared pool memory use from EMON during PLSQL notification
3802583	OERI:[kohcpi298] from enqueue for rule subscribers

Change Data Capture

3064971	ORA-54 when running DBMS_LOGMNR_CDC_PUBLISH.PURGE / change table keeps growing
3838121	Dump calling dbms_cdc_subscribe.subscribe()

JavaVM / JSP / Corba etc..

2422432	StructDescriptor.createDescriptor() does not honor definer's rights
3191604	DBA_JAVA_ARGUMENTS does not show all arguments for LAST method in a CLASS
3253770	ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
3312423	Oracle JVM ConversionBufferFullException can occur converting Strings for some NLS values
3511433	De-serializing a Java object in the Oracle JVM throws NullPointerException
3517854	External call from a Java procedure sometimes fails
3656785	UnsupportedEncodingException writing out from Java Stored Procedure
3729662	Dump (in eoref_resolve_xref) executing java Stored Procedure
3784687	Use of BigInteger can be slow

Job Queues

3240280	Jobs may suddenly stop although next_date <= sysdate
3427424	Jobs may stop running after 497 days uptime
3472564	"CPU used by this session" wrong when using job queue processes

LogMiner

3456259	V$LOGMNR_CONTENTS can get duplicate transaction start records for the same id
3492040	OERI selecting from V$LOGMNR_CONTENTS for long DDL
3528916	Logminer may dump with ROWNUM predicate and ASYNC IO used
3602321	Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
3733268	Streams / Logminer has problems resolving redo for rolled back incomplete row changes

Oracle Label Security

3218678	Using bad syntax for SA_POLICY_ADMIN.apply_table_policy can lead to ORA-4098 errors
3221661	SA_POLICY_ADMIN.enable_table_policy does not re-enable a previously disabled policy
3348437	Intermittent dump in kzrtevw() possible in OLS environment
3387932	OLS may return a HIDDEN column in place of a newly added column
3419794	INSERT / UPDATE DML less efficient than needed in OLS
3445982	Performance overhead using OLS insert_control with no labelling function
3455357	OERI:voprvl1 can occur using TABLE() with OLS installed
3517129	Small performance overhead for DML in OLS with check_control
3660908	Suboptimal OLS label tag caching

Oracle OLAP

2520040	Problems using concat dimensions with special characters
3257078	Memory leak in OLAP API
3320365	import of eif file never completes
3380940	"asym" selection on value based geography dim throws exception
3380981	asym query on aw value based measure hangs
3454824	Highheight cannot allocate memory for very large input
3485491	AWS can use excessive space
3491980	obj(awlist) on empty AQ dumps
3497649	Frequent deletion of AWS causes tablespace fragmentation
3498177	Dump in Geneva forecasting method 521
3498231	It is not possible to import eif file containing alias
3504463	sortDescending with nulls last ignores for top total measure case
3540228	AGGMAP ADD model sometimes gets incorrect results
3545392	Updating OLAP expression query dumps
3564130	asym bottom n% with appendvalues can be slow
3584964	accent character in like() operator throws XML exception
3612808	ORA-932 creating crosstab
3614873	Server may dump after several aw calc queries
3631932	SYS_OP_PAR() fails with ORA-979
3667108	Excessive memory allocated when constructing mdm model
3691588	OLAP EVERY function does not loop correctly
3742353	Excessive memory allocations in OLAP
3756701	OLAP "allstat" does not honor AW attached first

Oracle Text (Formerly interMedia Text)

2432123	INPATH against XML with attribute search (@) misses documents
2521729	CATSEARCH with INDEX_STEM=YES and GRAMMAR=CONTEXT with stemming misses hits
2668225	DRG-100 [50935] / ORA-942 from text query on partitioned MVIEW
2897997	Section searching of XML with mutibyte chars can returns wrong results
3072094	CATSEARCH query through a view fails with OERI [20084]
3094739	ORA-29908 / ORA-12801 using PQ with ancilliary operators such as CONTAINS / SCORE
3149380	Wrong results using stemming , fuzzy or soundex with % in a CONTAINS query
3160137	Import of partitioned Text index improperly parses parameters
3175001	ORA-1426 REBUILDing Text index with more than 255 partitions
3200136	Wrong results possible from MERGE JOIN CARTESIAN with DOMAIN INDEX
3210455	0 selectivity and cost for CTXXPATH index #
3273357	Wrong results for Text queries with Japanese lexer with single byte spaces
3305543	Periods ('.') are not accepted in XPATH names
3324698	Wrong tokens produced using numjoin and numgroup
3364962	Multiple forms support in user_lexer query procedure
3372915	Text query with bind variables in CONTAINS may raise false parse errors
3408192	Heavy concurrent DML scenarios can cause $R table to contain deleted rowids
3451741	Dump (gxtsnGetPar) creating Text index with THEMES=YES
3454019	Wrong results from wildcard in CATSEARCH / CONTEXT predicate with PREFIX INDEXING
3475827	CATSEARCH with wildcard (%) may dump
3495537	HTML Sectioner may improperly strip spaces from documents
3510094	Use of an analytic function skews the result from CONTEXT indextype SCORE operator
3545539	Dump under kgmexec->kglpnp using trusted callouts / domain indexes / Oracle Text
3649357	CTX_DOC.THEMES may not return all themes
3657757	CTX_DOC.MARKUP produces incorrect offsets for XML with CDATA tags
3666045	Dump (drexqxs) from Text SELECT using CONTAINS with ORDER BY
3675865	Dump (kgidmp / kgidlt) during CONTEXT index sync
3749394	SCORE() for fuzzy text operator different for functional versus index access

RAC (Real Application Clusters) / OPS

3544619P	Solaris: UDLM 3.3.4.6 is missing 9.2.0.5 Patch Set for Solaris 32bit
3917158P	ORA-29740 and a false instance eviction can occur
2246750	Cache recovery hang due to SMON deadlock in RAC
2377173	Wrong results in sort-merge joins with GV$ views
2377581	RMAN-6457 during duplicate target database with disabled threads
2495540	OERI[kjcsrdp:5] on RAC instance shutdown
2540942	LMS may spin in kjctr_rksxp() during simultaneous shutdown
2696674	Instance recovery may fail with ORA-600 [kjbrenou:clo]
2788036	Instance hang due to a noqueue request blocked at master
2825918	OERI[kjbassume:rmo2] after RAC reconfiguration
2826421	Hang/crash possible when using reliable transport with RAC
2987818	OERI [1153] possible in SMON in RAC
3003949	Improved diagnostics for instance eviction (ORA-29740)
3027721	OERI[kclfusfake_4] possible in RAC
3047933	LOGON trigger may dump in RAC on first invokation
3071799	Dump possible during STARTUP of a RAC instance
3104639	OERI[ksxpcncl3] possible on SHUTDOWN in RAC environment
3109552	ORA-12805 possible due to send timeout
3159113	Dead transactions take longer to rollback in RAC instance
3171520	OERI [kclchkinteg_21] possible while evicting instance
3185750	OERI:ksxpcncl3 possible
3213745	ALTER SYSTEM SET SHARED_SERVERS can crash RAC instances
3214975	Hang possible on STARTUP in RAC with RSM
3248886	Continous 'restarting dead background process qmn0' message in alert.log
3253770	ORA-4021 / "library cache pin" waits on RAC executing Java stored procedures
3268802	Additional diagnostics for deadlock in RAC environment
3275876	Memory corruption with RAC with large number of instances
3312874	USE_STORED_OUTLINES causes increased "library cache lock" requests in RAC
3316345	ENH: Enhance checks on interconnect blocks by a check for the correct DBA
3317029	Dump (korfpoid) / OERI[kocpnsh014] / OERI[kwqidjqp0] from AQ in RAC
3344325	broadcast-on-commit SCN scheme can have an excessively long timeout
3384299	OERI[kjbrrcon:cl] possible on buffer cache shrink in RAC
3395856	Timing window in RAC IPC code can result in dump/hang/OERI[ksxpcncl3]
3400883	OERI[kjblconsign:md] possible in RAC
3420610	RAC "BAST" leak can lead to instance hang
3428146	For XA with JDBC in an RAC environment ensure we are synchronized before recover
3432427	Dump possible in LGWR (in ksliwat) in RAC mode
3440376	OERI[kclfadb_2] / LMS crashes the instance
3452686	OERI[ktcrsp_1: drop/truncate not comp] possible in RAC at end of reconfiguration
3458197	DLM reconfiguration can hang after communication establishment
3475932	Cross instance archive log not generated remotely
3476477	RAC session can hang
3482748	LMS may die with OERI:kclfbbast_2
3484944	OERI[kjbrclo:gq] possible if a side-channel message is processed during process death
3490914	High CPU use during lock escalation retry
3506973	OERI[kjblconsign:md] possible in LMS
3507464	XA rollback / commit do not handle RAC failover transparently
3507703	V$DB_CACHE_ADVICE . ESTD_PHYSICAL_READ_FACTOR is incorrect on RAC
3509265	SHUTDOWN may hang with "waiting for instances to leave: N"
3514664	OERI[504][ges process hash list] possible in RAC during diagnostics dump
3535712	OERI[3020] / ORA-10567 from RAC with standby in max performance mode
3536811	OERI[kcllkopb_6] possible in RAC
3542633	OERI[kjbstrec] in instance recovery in RAC
3544142	It is possible for a process to be FROZEN while holding a latch
3551517	OERI[kcllrem_2] possible in RAC
3552489	OERI:kjbcropen:flockp possible if RAC process killed
3561040	LMS process may hang waiting for "KJC: wait for msg sends to complete"
3571054	Streams capture process may dump in RAC
3588448	Waits for 'global cache cr request' on RAC if UDP overflow occurs
3593228	OERI[1153] possible starting instance in RAC environment
3605241	Enhanced diagnostic information for internode parallel query
3608038	OERI[kclshrshr_8] possible in RAC
3611945	LMS may dump processing a BAST after a cache resize operation
3613126	ALTER DATABASE DATAFILE OFFLINE can cause OERI[kcfquewr_2] / crash in RAC
3615004	Corrupt backup / ORA-19675 using RMAN PROXY backup in RAC environment
3617060	Starting RAC instance with srvctl/gsd can cause ORA-1012/ORA-1034
3621300	OERI[krvseds get obj] while handling thread enable/disable in logical standby
3625370	CGS nested reconfiguration may hang
3626272	DLM can allocate too many message buffers when CLUSTER_DATABASE=false
3626463	Hang possible on 'ges inquiry response' after reconfiguration
3627263	Deadlock / hang during RAC instance startup
3628368	Diagnostic enhancement to help determine cause of heartbeat failures
3632400	LMS may hang in kslges() waiting for a post
3638080	OERI:1153 possible in RAC
3641398	OERI[kjbmiconsign:ds] possible in RAC
3646162	False deadlock (ORA-60) in a RAC environment / TM lock mode change
3649839	Intermittent ORA-12805 on internode parallel create/rebuild index
3675033	Reintroduction of RAC instance can result in hang / OERI:2103
3698501	Reconfiguration may reuse an old incarnation number
3704314	OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash possible
3722208	OERI[kjzgpoll1] from DIAG process if ocssd shuts down
3724485	Enqueue waits may occur with no obvious holder in RAC
3780853	OERI[H_MK_FR_1] possible in RAC environments
3851225	OERI:[kcsbcscn13] can occur under heavy load
3857577	ORA-1280 on create_capture/add_table_rules for streams capture on RAC
3867789	PMON may crash the instance with an OERI[1155] when cleaning up

Read Only Database

3549693

OERI:[ktsircinfo_num1] during ALTER DATABASE OPEN READ ONLY

Replication

3156820	ORA-23309 during CREATE_MASTER_REPOBJECT or table with OBJECT columns as LOBs
3339218	ORA-26571 performing DML on a replicated table
3492211	ORA-23308/ora-23309 replicating pre-created tables with LOB
3672876	Dump on execution of a MERGE statement in replication

Row Level Security / FGA

2771042	OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy
3077384	Use of fine grained auditing may dump while recursively accessing V$SQL_BIND_DATA
3330538	Query rewrite does not occur for table with RLS policy
3387932	OLS may return a HIDDEN column in place of a newly added column
3432992	Dump possible using fine grained audit if error occurs
3665042	SQL does not error if FGA with user declared handler raises an EXCEPTION

Shared Server (formerly MTS)

2243979	Pipelined table functions may dump / give wrong results in SHARED SERVERs
2692323	Dispatcher may dump in/under ntexppst when under load
2890002	OERI[17099] / OERI:gpga_mismatch using MTS on some platforms
2897410	Dump (gslcsqbr_malloc) using DBMS_LDAP in SHARED SERVER mode
3144710	OERI[526] querying V$ tables over shared server connection
3213745	ALTER SYSTEM SET SHARED_SERVERS can crash RAC instances
3234034	Database crash possible with shared servers
3293688	OERI[504] / OERI[510] using bitmap indexes with shared servers
3325395	ORA-130 can occur if Oracle tries to contact a local listener
3666502	OERI[1236] can occur intermittently in a shared server
3802873	LDAP connections can not be established from MTS dispatchers

Spatial Data

3202584	Wrong results possible from SDO_BUFFER
3588324	Wrong distance due to tolerance setting ( sdo_geom.sdo_distance )
3671977	ORA-6502 possible from SDO_CS.VIEWPORT_TRANSFORM
4322477	Consecutive runs of Spatial query on partition table progressivly get slower

Streams / Logical Standby

2346624	Drop capture does not clean up properly
2726322	DDL executed from job queues are not applied to logical standby
2761575	Logical standby may stop for "alter index rebuild online" DDL
2766894	Logical standby apply gives "no data found" if PK not enforced with index
2825427	Logical standby may dump (krvxsraucr)
2963357	Apply engine may hang when parallelism is set
2967313	EXCHANGE PARTITION does nOt apply unless tables are qualified with schema name
3035530	Insert stops apply engine after rename operation skipped
3038121	Propagation job stops with flow control
3061466	Logical standby switchover does not stop current transactions against original primary
3082401	Apply process fails to start after database is bounced (ORA-16081)
3117864	Logical standby apply stops with audit on synonym turned on (PLS-103)
3124406	Logical standby will not replicate DLL issued by DBMS_SQL
3136428	Logical standby does not support flashback flavor of select
3163264	Dump / memory corruption at logical standby for LOB table with trailing nulls
3172456	Capture aborts when temporary table and CLOB are used in combination
3200266	DDL marker contains wrong object name for drop index
3241689	Queue buffer not correctly initialized on instance restart
3262648	Logical Apply may OERI[krvuffl: memsize below zero]
3276299	Logical standby / streams do not work if _MAX_LOG_LOOKBACK > 4294
3313274	Direct path load of LOBs can cause data loss/truncation in streams
3352902	Logical apply may hang (library cache pin)
3369017	Logical standby switchover waits for active transactions
3370235	Corrupt data possible in logical standby
3371003	Logical standby apply hang (library cache pin waits)
3379917	Apply processes(reader, server) leak cursors (ORA-1000)
3381899	Logminer cannot handle multiple DDLs commiting at the same SCN
3382229	Reset of capture SCN after destination incomplete recovery does not work
3388633	Logical standby apply may stop with OERI[17090]
3390021	PGA memory leak in apply server
3394481	OERI[knalfdequeuelcrs606] in apply fetch slave
3401065	Logmnr may spill unnecessarily impacting performance
3405682	ORA-23416 in logical standby database from non-key update on primary with trigger
3443509	Large or PDML CTAS may be followed by logical standby apply 1403 failure
3445164	ORA-1722 (invalid number) starting Logical Standby Apply
3449174	Attempt to supplementally log LONG column can OERI/dump
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
3465718	Logical Standby may not honour SKIP commands for objects repeatedly created on the primary
3489316	Unnecessary tracing/debug calls occur during capture
3517698	Logical standby cannot support mining through application of a Patch Set
3540137	Logical standby apply may run slowly
3553331	Unnecessary trace overhead in Streams apply
3555003	View compilation hangs / OERI:17059 after DBMS_APPLY_ADM.SET_DML_HANDLER
3565109	Logminer may not be able to resolve log files with multiple archive destinations
3568433	Apply gets unsupported LCR or no-data found error for partitioned tables
3571054	Streams capture process may dump in RAC
3571724	Logical standby apply stops applying changes from primary
3599816	Propagation ACKS not received when flow control signalled from target database
3602321	Streams/logminer cannot handle partial rollback of a failed BULK BIND operation on a table with LOBS
3611423	PGA memory leak in AQ propagation process(J000)
3618700	SQL apply/alter user/role fails with ORA-28003 / ORA-28221
3621300	OERI[krvseds get obj] while handling thread enable/disable in logical standby
3627170	Logical standby may dump / ORA-12805
3641822	PDML (including DDL) can cause APPLY to stop
3642013	Logical standby may stop under certain workloads with eager transactions
3673561	READ_SCN may not advance even when there is no eager transaction
3676271	ORA-1403 applying DML with delete cascade constraints
3725208	Archive log rejected at logical standby
3731546	Logical standby does not handle transient duplicates in heap-organized tables
3733268	Streams / Logminer has problems resolving redo for rolled back incomplete row changes
3741539	Logical standby may apply DML from a DDL more than once
3751202	Streams capture fails to enqueue after restart
3754130	Captured_scn , applied_scn not updating / Logminer checkpoints not completing
3769884	Apply aborts on first DML after handler changed when ORA-4068 encountered
3779568	Bad CTAS marker when more than 2 redos generated for column information
3785754	Logminer does not maintain LOGMNR_COL$ properly (ORA-2437 on upgrade)
3799591	Logical standby may fail to reapply uncommitted transactions on a restart
3800634	OERI [kghstack_free1] [knlucanon:res_buf] can occur in Streams
3800644	OERI [kghstack_free1] [kniascg: cgpi_knictx] can occur in Streams
3845742	"krvxrofr: fatal error attempting to read archive redo log"
3857577	ORA-1280 on create_capture/add_table_rules for streams capture on RAC

Transportable Tablespaces

3446987	OERI[19942] after TRANSPORTING a TABLESPACE containing LOBS (converted from LONGS)
3489246	OERI[pitl1] / ORA-1498 ANALYZING table transported from 8.1.7 to 9.2.0
3601253	OERI[kclchkblk_3] possible accessing transported tablespace in RAC
3613078	OERI[4097] from DML on TRANSPORTED tables with ASSM
3641963	Transport of a table with LONG RAW and added columns is corrupt at target

XDB

2190254	XMLDOM.createelement(null,'') gives ORA-1405
2293107	RegisterSchema dump in kotgttc() during create table for simplecontent
2338704	Queries on collections stored in out-of-line tables are not view merged
2391278	ORA-22905 using PLSQL variable with TABLE(xmlsequence()...
2593883	XDB does not handle element names containing '.' correctly
2624824	extractValue() dumps / corrupts memory for values over 4k bytes long
2702653	XDB install / upgrade may be missing folder "/sys/apps"
2907034	High memory use / ORA-4030 loading XML via createresource()
2935712	DBUriServlet does not set content-length or transfer-encoding headers
2994547	OERI[qmxi_coll_upk] from concurrent manipulation of same LOB stream
3048590	Resource path update results in extra namespace
3086154	GROUP BY fails with ORA-979 for schema based XMLType table
3089052	OERI[qmsupdaterec1] possible when registered XML schema is validated
3109590	DBMS_XMLPARSER.PARSE procedure calls UTL_FILE for "http://" URL
3162494	Dump (qcsfsqcn) querying XMLType column with VARRAY and domain index
3172282	Dump possible applying XML operators on ACLs
3238383	OERI[qmhsesskeybuf] can occur during an HTTP connection to XDB
3248196	Schema registration with numerous REFS can spin / use excessive PGA memory
3281062	Export of xmlschema based table is slow
3315725	Dump [qmxtgGetOpqImageFromXob] when result of XMLTransform is null
3361288	Export of XMLSCHEMA may fail with ORA-24324 in UTF8
3362205	OCI-21500 [kohfrm505] inserting an XML document with invalid characters
3421087	Memory leak can occur when using DBMS_XMLGEN
3431498	extract and existsnode may ORA-29900 with three operands
3447927	ORA-30937 using DBMS_XMLDOM
3449245	getXML may produce incorrect hex character output
3450074	Inserting into a table defined as an XMLType leaks UGA memory
3453267	ANALYZE may dump in qmxGetFirstChild for XMLType with functional index
3469775	DBMS_XMLGEN.CONVERT can fail with OERI[17112]
3504323	DBMS_XMLDOM.cloneNode clones the wholes sub-tree in the XOB tree
3513071	ORA-30937 registering schema with attributes from user defined namespace
3518909	Session (UGA) memory not released after using DBMS_XMLPARSER
3536149	Element name in SQLX XmlElement() function limited to 30 characters
3553302	Dump (qmxluMoveToHead) selecting from schema with anyType stored as a CLOB
3596732	Schema registration can dump in qmxValidateSchemaDo
3608916	Dump / ORA-21527 selecting from XDB Schema
3617042	Index not used for XPATH of "long" element
3744676	OERI[qmxarElemAt2] inserting XML document into XMLType table
3796792	Dumps possible inserting schema based instance document

interMedia (Image)

3462254	interMedia INVALID after upgrade from 9.2.0.1 - 9.2.0.3 to 10g
3539130	IMG-705 when processing a TIFF image with fillorder lsb-to-msb
3546019	Cursor leak from interMedia image matching index inserts and updates
3713138	OrdHttpUploadFile.simpleFileName returns wrong filename if name contains a ']' character