NB | Bug | Fixed | Description |
| 14456124 | 12.1.0.0 | Predicate push may not occur with cursor sharing |
| 14053457 | 11.2.0.4, 12.1.0.0 | ORA-917 parsing SQL with indicator binds with CURSOR_SHARING |
| 12723295 | 11.2.0.4, 12.1.0.0 | ORA-600 [qerixGetKey:optdesc] with function based index and CURSOR_SHARING |
| 9877960 | 11.2.0.4, 12.1.0.0 | ORA-600 or similar using CURSOR_SHARING with HS connections |
| 14087914 | 12.1.0.0 | Wrong results from ExistsNode with CURSOR_SHARING |
+ | 13550185 | 11.2.0.2.BP17, 11.2.0.3.4, 11.2.0.3.BP06, 12.1.0.0 | Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools |
| 13023854 | 11.2.0.4, 12.1.0.0 | Long parse time / hang for SQL with nested CASE expressions with CURSOR_SHARING enabled |
| 12862170 | 12.1.0.0 | INSERT ALL fails with ORA-600[kkslhsh1] with CURSOR_SHARING enabled / High Version Count on HASH_MATCH_FAILED |
| 12797420 | 11.2.0.3.3, 11.2.0.3.BP07, 12.1.0.0 | "library cache: mutex X" waits on DB instance handle with CURSOR_SHARING |
| 12649442 | 11.2.0.2.8, 11.2.0.2.BP18, 11.2.0.3, 12.1.0.0 | ORA-7445 [kxscod] with CURSOR_SHARING=FORCE or SIMILAR |
| 12596444 | 11.2.0.2.7, 11.2.0.2.BP17, 11.2.0.3.BP08, 12.1.0.0 | Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION) |
| 12534597 | 12.1.0.0 | Bind Peeking is disabled for remote queries |
| 12374212 | 11.2.0.2.8, 11.2.0.2.BP18, 11.2.0.3, 12.1.0.0 | Assorted dump , internal errors, memory corruptions with cursor_sharing = force |
| 12345980 | 11.2.0.3, 12.1.0.0 | high parse time with cursor_sharing=force when session_cached_cursors set |
| 12334286 | 11.2.0.3, 12.1.0.0 | High version counts with CURSOR_SHARING=FORCE (BIND_MISMATCH and INCOMP_LTRL_MISMATCH) |
| 11858021 | 11.2.0.3, 12.1.0.0 | ORA-600 [kpoal8-1] using DG4DRDA with CURSOR_SHARING=force |
| 11806961 | 11.2.0.3, 12.1.0.0 | ORA-600 [kkspsc0: basehd] using CURSOR_SHARING |
| 11738259 | 11.2.0.2.7, 11.2.0.2.BP17, 11.2.0.3, 12.1.0.0 | ORA-600 [kghssgfr2] using CURSOR_SHARING=FORCE |
| 11714159 | 11.2.0.3, 12.1.0.0 | ORA-917 occurs with CURSOR_SHARING even if patch:9877980 is applied - superseded |
| 11076030 | 11.2.0.3, 12.1.0.0 | Wrong results for XDB when CURSOR_SHARING enabled |
| 11069199 | 11.2.0.2.2, 11.2.0.2.BP06, 11.2.0.3, 12.1.0.0 | ORA-600 [kksObsoleteCursor:invalid stub] with CURSOR_SHARING = SIMILAR | FORCE if fix 10187168 present |
| 11063191 | 11.2.0.2.7, 11.2.0.2.BP17, 11.2.0.3.2, 11.2.0.3.BP04, 12.1.0.0 | ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive "KKSSP^nn" memory |
| 10126094 | 11.2.0.2.3, 11.2.0.2.BP08, 11.2.0.3, 12.1.0.0 | ORA-600 [kglLockOwnersListAppend-ovf] from literal replacement on SQL issued from PLSQL |
| 10013170 | 11.2.0.3, 12.1.0.0 | ORA-600 [736] from literal replacement with a "WAIT n" clause |
* | 9877980 | 11.2.0.2.8, 11.2.0.2.BP18, 11.2.0.3, 12.1.0.0 | ORA-7445[kkslMarkLiteralBinds] / Assorted Errors on 11.2.0.2 if cursor sharing is enabled - Affects RMAN |
| 9877964 | 11.2.0.3, 12.1.0.0 | ORA-600 [19003] raised by LIKE :BIND in query |
| 9680430 | 11.2.0.3, 12.1.0.0 | High version count with CURSOR_SHARING = FORCE due to CBO transformation |
| 9548104 | 11.2.0.2, 12.1.0.0 | OERI [qcsfbdnp:1] instead of ORA-1788 with cursor sharing |
| 9413962 | 11.2.0.2, 12.1.0.0 | Many child cursors / ORA-600 [opixrb-3.0] [2005] [ORA-02005] binding literal for remote RPI |
| 9411496 | 11.2.0.2, 12.1.0.0 | ORA-979 on GROUP BY query with CURSOR_SHARING set |
| 9362218 | 11.2.0.2, 12.1.0.0 | Literals replaced by binds when CURSOR_SHARING=EXACT |
| 9348402 | 12.1.0.0 | OERI [kks-hash-collision] can occur with CURSOR_SHARING=FORCE|SIMILAR |
| 9223586 | 11.2.0.2, 12.1.0.0 | Problems with variable length NCHAR literals with cursor sharing |
| 9031183 | 11.2.0.2, 12.1.0.0 | ORA-1722 with CURSOR_SHARING=SIMILAR and with NCHAR |
| 9008904 | 11.2.0.2, 12.1.0.0 | Dump (audTransFro) with CURSOR_SHARING |
| 8913729 | 11.2.0.2, 12.1.0.0 | ORA-979 with CURSOR_SHARING=SIMILAR or FORCE |
| 8545377 | 11.2.0.2, 12.1.0.0 | ORA-1780 with CURSOR_SHARING on XML queries |
| 8246445 | 11.2.0.2, 12.1.0.0 | Query rewrite not working for multi-MV rewrite with literal replacement |
| 5751866 | 11.2.0.2 | Wrong Results with CASE and CURSOR_SHARING |
| 9767674 | 10.2.0.5.5 | Dump [kkslmtl] using CURSOR_SHARING - superceded |
| 8794693 | 11.2.0.2 | Dump [kkscsmtl] using literal replacement (CURSOR_SHARING) |
| 8491399 | 11.2.0.1 | Adaptive Cursor Sharing does not match the correct cursor version for queries using CHAR datatype |
| 8453245 | 11.2.0.1 | Many child cursors with CURSOR_SHARING = FORCE |
| 8264642 | 11.2.0.1 | ORA-600 [kkexbindopn0] with CURSOR_SHARING = SIMILAR |
| 7651092 | 11.2.0.1 | ORA-1000 with Literal Replacement, EXECUTE IMMEDIATE and CURSOR_SHARING_EXACT hint (affects DBMS_STATS) |
| 7516867 | 10.2.0.5, 11.1.0.7.1, 11.2.0.1 | Intermittent Wrong results from literal replacement with fix for bug 6163785 |
| 7272297 | 10.2.0.4.1, 10.2.0.5, 11.1.0.7, 11.2.0.1 | Memory corruption / OERI[17114] / OERI[17125] with literal replacement |
| 7212120 | 11.1.0.7, 11.2.0.1 | Session cursor cache not used properly when CURSOR_SHARING=force/similar |
| 6337716 | 10.2.0.5, 11.1.0.7, 11.2.0.1 | Wrong max column size for NULL strings with literal replacement |
| 5757106 | 10.2.0.4, 11.1.0.7, 11.2.0.1 | OERI[15851] selecting aggregate of a constant with literal replacement |
| 4071519 | 10.2.0.5, 11.1.0.7, 11.2.0.1 | GROUP BY query with CURSOR_SHARING fails with ORA-1802 |
| 3461251 | 11.1.0.7, 11.2.0.1 | V$SQL_SHARED_CURSOR shows all N with CURSOR_SHARING |
| 7296258 | 10.2.0.5, 11.1.0.7.1 | Intermittent Wrong results from literal replacement and remote objects |
| 6163785 | 10.2.0.5, 11.1.0.7 | Intermittent Wrong Results with dblink and cursor_sharing |
| 8202234 | | Intermittent Wrong Results with dblink and cursor_sharing |
| 5863277 | 10.2.0.4, 11.1.0.6 | ORA-1008 from SQL on second run when cursor_sharing=similar/force |
| 5762750 | 10.2.0.4, 11.1.0.6 | ORA-907 when cursor_sharing is enabled |
| 5476507 | 10.2.0.4, 11.1.0.6 | OERI[15868] / OERI[15160] can occur with cursor sharing |
| 5364819 | 10.2.0.4, 11.1.0.6 | OERI[kkslpbp:1] when using literal replacement |
| 5254759 | 10.2.0.4, 11.1.0.6 | ORA-12801/ORA-1008 occurs on a parallel query with bind variables |
| 5177766 | 10.2.0.4, 11.1.0.6 | OERI[17059] with SESSION_CACHED_CURSORS |
| 5155885 | 10.2.0.4, 11.1.0.6 | OERI[kkslgbv0] with CURSOR_SHARING=similar |
+ | 5146740 | 10.2.0.4, 11.1.0.6 | Wrong results with bind variables/CURSOR_SHARING |
| 5082178 | 10.2.0.4, 11.1.0.6 | Bind peeking may occur when it should not |
| 5055175 | 10.2.0.3, 11.1.0.6 | Dump [kkslpkp] using literal replacement with timezone literals - superceded |
| 4867724 | 10.2.0.5, 11.1.0.6 | Literal replacement limits column names to 30 characters |
| 4698156 | 10.2.0.3, 11.1.0.6 | ORA-12850 querying GV$ views when CURSOR_SHARING=FORCE |
| 4607460 | 9.2.0.8, 10.2.0.3, 11.1.0.6 | Dump [opipls] when CURSOR_SHARING = SIMILAR | FORCE |
| 4513695 | 10.2.0.4, 11.1.0.6 | Poor performance for SELECT with ROWNUM=1 with literal replacement |
| 4458226 | 9.2.0.8, 10.1.0.5, 10.2.0.2, 11.1.0.6 | High version count with cursor_sharing=force |
| 4456646 | 10.2.0.2, 11.1.0.6 | Dump (kxscod/memcmp) using literal replacement |
| 4451881 | 9.2.0.8, 10.2.0.2, 11.1.0.6 | OERI[kkslhsh1] from Insert as SELECT |
| 4436832 | 10.2.0.4, 11.1.0.6 | False ORA-979 "not a group by expression" with literal replacement |
| 4359367 | 10.1.0.5, 10.2.0.2, 11.1.0.6 | High version_count with cursor sharing |
| 4254094 | 10.2.0.3, 11.1.0.6 | OERI[qerrmObnd1][932] possible for queries over DB links |
| 4202503 | 10.2.0.4, 11.1.0.6 | Parse errors possible using CONTAINS with cursor_sharing=similar/force |
| 4200541 | 10.2.0.3, 11.1.0.6 | Parse error when CURSOR_SHARING=FORCE|SIMILAR with user binds |
| 3880881 | 9.2.0.8, 10.2.0.2, 11.1.0.6 | Dump (kkslMarkLiteralBinds) using cursor sharing |
| 2837580 | 10.2.0.4, 11.1.0.6 | Dump if SQL has > ~35000 literals |
| 13349665 | 10.2.0.5.6 | ORA-600 [kkslmtl-valnotfound] with fix for bug 9767674 (eg After applying PSU 10.2.0.5.5) |
| 3980673 | 9.2.0.8, 10.1.0.5, 10.2.0.1 | Literal replacement may dump (kkslpbp) if user binds have names like SYS_B_xx |
| 3842253 | 9.2.0.7, 10.1.0.4, 10.2.0.1 | Dump (kgghash) using literal replacement |
| 3819834 | 9.2.0.7, 10.1.0.4, 10.2.0.1 | Dump (kkslflb) with literal replacement |
| 3818541 | 9.2.0.7, 10.1.0.4, 10.2.0.1 | CURSOR_SHARING=force does not work if SQL has an NVL or DECODE predicate |
| 3737955 | 10.1.0.4, 10.2.0.1, 9.2.0.7 | Long parse times for long inlists / many AND/OR terms |
| 3668572 | 9.2.0.6, 10.1.0.4, 10.2.0.1 | ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY |
| 3645694 | 10.1.0.5, 10.2.0.1 | Poor plan from SQL with literal replacement and LIKE .. ESCAPE .. |
| 3406977 | 9.2.0.6, 10.1.0.3, 10.2.0.1 | High version count in V$SQL due to binds marked as non-data with CURSOR_SHARING=FORCE |
| 3148830 | 9.2.0.6, 10.1.0.3, 10.2.0.1 | Select over database link fails with OERI[opixmp-7] if CURSOR_SHARING=similar |
| 3128363 | 9.2.0.6, 10.1.0.4 | OCIAttrGet returns wrong size when CURSOR_SHARING=SIMILAR or FORCE |
| 3007574 | 9.2.0.5 | OERI:15212 using CURSOR_SHARING=FORCE with database links |
| 5526018 | | Dump [kkslpbp] / OERI[kkslpbp:1] with materialized view and literal replacement |
| 3132071 | 9.2.0.6, 10.1.0.2 | Wrong results possible with CURSOR_SHARING=FORCE|SIMILAR |
| 3045623 | 9.2.0.5, 10.1.0.2 | OERI[kkslhsh1] possible with CURSOR_SHARING=FORCE |
| 2958096 | 9.2.0.5, 10.1.0.2 | Using XMLType / objects over DBLINKS with CURSOR_SHARING may dump |
| 2843601 | 9.2.0.5, 10.1.0.2 | DML across a dblink fails with ORA-24370 if cursor_sharing is enabled |
| 2643579 | 9.2.0.4, 10.1.0.2 | ORA-7445 [kxspoac] using CURSOR_SHARING=FORCE (or similar) |
| 2620541 | 9.2.0.5, 10.1.0.2 | ORA-7445 [KXSPOAC] can occur on DML using CURSOR_SHARING |
| 2508702 | 9.2.0.3, 10.1.0.2 | ORA-7445 [KKSLHIB] with CURSOR_SHARING=FORCE with INTO clause |
| 2474192 | 9.2.0.3, 10.1.0.2 | OERI:[OPIBND1] on CREATE of TEXT INDEX with CURSOR_SHARING |
| 2442125 | 9.2.0.3, 10.1.0.2 | Wrong results from PQ which compares a CHAR column to a BIND variable |
| 2308292 | 9.0.1.4, 9.2.0.2, 10.1.0.2 | ORA-7445 [kkslhib] for INTO <bind> using CURSOR_SHARING and SESSION_CACHED_CURSORS |
| 2273604 | 9.0.1.4, 9.2.0.2, 10.1.0.2 | CURSOR_SHARING=FORCE may not share cursors using a BETWEEN clause with CBO |
| 2052836 | 8.1.7.4, 9.0.1.4, 9.2.0.2, 10.1.0.2 | Client dump possible using CALL statement with CURSOR_SHARING=FORCE |
| 4197915 | 9.2.0.8 | CAST( x as number(n)) fails in PQ slaves with ORA-1727 with cursor_sharing |
| 3614299 | 9.2.0.6 | Dump adding a subscriber with a rule containing literals with CURSOR_SHARING = FORCE|SIMILAR |
| 2442097 | 9.2.0.2 | INSERTS into USER-DEFINED TYPES with CURSOR_SHARING=FORCE does not share cursors |
| 2237610 | 9.2.0.2 | OERI:[kgskbwt1] / OERI:[kskbind1] possible using CURSOR_SHARING |
| 2300719 | 9.0.1.4, 9.2.0.1 | Spin possible in PRSGNT when CURSOR_SHARING=SIMILAR |
| 2262665 | 8.1.7.4, 9.0.1.4, 9.2.0.1 | ORA-7445 [kkslpbp] possible with CURSOR_SHARING=FORCE |
| 2259787 | 9.0.1.4, 9.2.0.1 | Dump possible in EXPCMPBND() with CURSOR_SHARING and GROUPING SETS |
| 2154645 | 9.0.1.3, 9.2.0.1 | Spin in KKSFBC possible when CURSOR_SHARING=FORCE |
| 1947974 | 9.0.1.2, 9.2.0.1 | False ORA-1008 possible using EXECUTE IMMEDIATE with CURSOR_SHARING=SIMILAR |
| 1840199 | 9.0.1.2, 9.2.0.1 | OERI:EVAGGSID-1 possible using user defined aggregates (UDAG) with CURSOR_SHARING=FORCE|SIMILAR |
| 1782025 | 8.1.7.4, 9.2.0.1 | Client may dump/error using DML RETURNING with CURSOR_SHARING=FORCE|SIMILAR |
| 1777504 | 8.1.7.4, 9.0.1.4, 9.2.0.1 | Hang possible with CURSOR_SHARING=FORCE (or SIMILAR in 9i) |
| 1764925 | 9.0.1.4, 9.2.0.1 | OERI:QCTSTC2O1 possible using CURSOR_SHARING = SIMILAR |
| 2159152 | 8.1.7.4, 9.0.1.0 | Cursors not shared with CURSOR_SHARING=FORCE if it has a transitive predicate |
| 1538450 | 8.1.7.3, 9.0.1.0 | Dump in KXSPOAC possible CURSOR_SHARING=FORCE set |
| 1365873 | 8.1.7.2, 9.0.1.0 | OERI:17182 / CGA corruption with CURSOR_SHARING=FORCE |
| 1358871 | 8.1.7.3, 9.0.1.0 | CURSOR_SHARING=FORCE may dump if first bind is a literal |
| 984251 | 8.1.7.2, 9.0.1.0 | CURSOR_SHARING=FORCE can cause ORA-29909 when using an ANCILLARY OPERATOR |
| 2485018 | | OERI:[KKSLGOP1] from SQL issued over a DBLINK with CURSOR_SHARING |
| 2221407 | 8.1.7.4 | ORA-3106 / OERI:15212 using BINDS over DBLINK with CURSOR_SHARING=FORCE |
| 1545473 | 8.1.7.2, 9.0.1.0 | ORA-979 possible using CURSOR_SHARING=FORCE with GROUP BY & ORDER BY & LITERALS |
| 1111796 | 8.1.7.0 | Dump possible from CURSOR_SHARING=FORCE |
| 984132 | 8.1.7.0 | Literal in cursor expression can CORE DUMP with CURSOR_SHARING=FORCE |