| 2104780 |
ORA-4000 specifying PCTFREE when creating table in ASSM
|
| 3219117 |
LOB SEGMENT uses more space with ASSM
|
| 3279497 |
Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
|
| 3610777 |
Excessive CPU from INDEX insert into ASSM index segment
|
| 3857781 |
ASSM tablespace index branch split/relocate generates huge amount of undo
|
| 4055596 |
TRUNCATE of an auto space managed table with an index sets index block count wrong
|
| 4067168 |
Poor table scan PQ performance possible for ASSM segments
|
| 4188324 |
Wasted space possible in ASSM segments
|
| 4207520 |
DBMS_SPACE.SPACE_USAGE gives wrong results for ASSM LOB segment
|
| 4254666 |
LOB space in ASSM tablespace not reused effectively
|
| 4288876 |
Excessive redo / undo generation from insert/update with ASSM indexes
|
| 4464828 |
OERI[kcbgtcr_12] using ANALYZE on ASSM segment
|
| 4475314 |
DELETE then INSERT without commit on ASSM segment can be slow
|
| 4517470 |
Table corruption with RAC when ASSM managed and truncate used
|
| 4694312 |
Index inserts to ASSM segments can be slow
|
| 4887955 |
Unnecessary extent allocated in locally managed ASSM tablespace in RAC
|
| 2944274 |
DBMS_METADATA does not handle bitmap join indexes
|
| 3026986 |
Dump (kkpouoe_update_obj_entries) dropping a FAKE bitmap index
|
| 3219917 |
OERI:20083 a DOMAIN index in a rowid-to-bitmap conversion
|
| 3389359 |
OERI[12700] from invalid BITMAP OR in execution plan
|
| 3827085 |
Dump from multi-column inlist with bitmap join index
|
| 3929301 |
ORA-14642 on exchange partition
|
| 4350208 |
PGA memory leak associated with bitmap indexes
|
| 4421063 |
Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
|
| 4533389 |
ANALYZE INDEX VALIDATE STRUCTURE does not update INDEX_STATS for bitmap indexes
|
| 4695511 |
OERI[kxfqupp_bad_cvl] when creating bitmap index
|
| 4697632 |
OERI[atbbjie2] from exchange partition with bitmap join indexes
|
| 5015557 |
Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
|
| 5078743 |
Dump (in qkabxo) using bitmap access path in FIRST K ROWS
|
| 3494853 |
Unrelated triggers may be incorrectly dropped when dropping tables/views
|
| 3765119 |
ALTER TABLE ADD <col> with foreign key constraint does not validate existing rows
|
| 3983762 |
Audit followed by noaudit corrupts failure value in audit$
|
| 4246090 |
IOT corruption from buffered INSERT with function based index (ORA-8102)
|
| 4378206 |
Direct load of compressed table can load duplicate rows
|
| 4397882 |
Binding a collection of objects with certain data via PLSQL binds null
|
| 4496211 |
Wrong results after fast refresh of a partitioned materialized view
|
| 4515623 |
Update .. RETURNING with a trigger can produce corrupt column data
|
| 4630627 |
Direct load insert loads incorrect data
|
| 4711857 |
Exp/Imp of table with LONG swaps COMMENTS metadata
|
| 4714295 |
It is possible to drop an OLS group which is still in use in an existing label
|
| 4771052 |
INSTEAD-OF trigger does not update tables correctly over dblink
|
| 4775068 |
Deferred transactions not applied in the correct order when using parallel propagation
|
| 4995049 |
Invalid data inserted into schema based document
|
| 2283149 |
Hint on remote table may be lost
|
| 2902721 |
Dump [qkaPobs] from INSTEAD OF trigger on a view on a remote table
|
| 3060358 |
Open cursors using a sequence in a remote database are not closed (ORA-1000)
|
| 3413826 |
ORA-904 from MERGE SQL across database link
|
| 3547585 |
Using CONNECT BY over a database link to 8i can fail with ORA-1472
|
| 3828598 |
Wrong results with unnested remote subqueries
|
| 3901321 |
Dump during DDL on remote table with domain index
|
| 4127518 |
ORA-928 / ORA-2063 or dump (qkswcInlineQBC) when SET expression over a database link
|
| 4146079 |
Dump in xplInitCtx from remote mapped table in query
|
| 4177810 |
ORA-904 with non-column constants in FROM clause with PQ or remote SQL
|
| 4257473 |
ORA-920 can occur for SQL over a database link
|
| 4307318 |
No anti-join optimization for INSERT as SELECT with NOT IN subquery over db link
|
| 4308123 |
OERI[18117] on PREPARE if branch has updated remote site
|
| 4321119 |
ALTER MATERIALIZED VIEW causes ORA-32337 after DML via database link
|
| 4344210 |
Dump (kpobav) if remote mapped cursor rebuilt
|
| 4357668 |
Dump (k2ggse1) can occur during prepare of multi-branch transaction
|
| 4402255 |
Hang / dump possible using database link
|
| 4431181 |
Dump from SELECT if it changes from remote mapped to not
|
| 4451759 |
OERI:729 using session cached cursors with DB link
|
| 4490782 |
Unparse operations give wrong date for BC TO_DATE literals
|
| 4543879 |
OERI[OCIKDBLinkConn-8], [24327] from parallel distributed update
|
| 4581334 |
Cursors accessing remote tables may be repeatedly rebuilt and not used
|
| 4618265 |
DBMS_PLAN.display / plan_table shows wrong plan for remote queries with BINDs
|
| 4622095 |
Dump kkdlacd() when creating stored outline for DML against a remote table
|
| 4627237 |
autonomous_transaction with DB link to shared server can self deadlock on DX
|
| 4658456 |
ORA-920 from distributed query using CASE against remote table/s
|
| 4701527 |
Cursors not shared when executing procedures over a dblink
|
| 4703253 |
Wrong results from remote colocated join
|
| 4708037 |
ORA-904, ORA-2063 from query that uses TIME ZONE as a cast
|
| 4768022 |
ALTER TABLE can fail with ORA-60
|
| 4771052 |
INSTEAD-OF trigger does not update tables correctly over dblink
|
| 4964703 |
OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
|
| 4968994 |
Poor plan using SYSDATE in predicate over dblink
|
| 5043975 |
OERI[opixrm-1] [invalid handle] for remote cursor
|
| 5212539+ |
LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
|
| 2539368 |
ORA-12008 / ORA-1000 with MVIEW containing a CLOB with ON COMMIT REFRESH
|
| 2931779 |
False ORA-1555 accessing "cache read" LOBs in RAC
|
| 3219117 |
LOB SEGMENT uses more space with ASSM
|
| 3344331 |
OERI[504] can occur using INSTR on a LOB column
|
| 3448802 |
Exp / Imp / view problems if LOB tablespace blocksize different to table blocksize
|
| 3493456 |
Large LOB data is not applied correctly when running logical standby
|
| 3900290 |
Excessive memory spill in Streams for DDL transactions with LOB DMLs
|
| 4113930 |
Space reclaimation shows HW enqueue contention with concurrent insert of LOBs
|
| 4195693 |
LOB segment space in an ASSM tablespace is not reused effectively
|
| 4198000 |
ORA-22993 / unreadable LOB data with temp CLOB
|
| 4207520 |
DBMS_SPACE.SPACE_USAGE gives wrong results for ASSM LOB segment
|
| 4224765 |
REPLACE on a CLOB spins in kole_simple_string_match
|
| 4278912 |
ORA-24852 if cursor selecting BLOB is rebuilt
|
| 4280096 |
High buffer gets for insert into lob
|
| 4303122 |
Temporary lob is not reused when PLSQL calls Java in a loop
|
| 4387452 |
ORA-22922 trying to DEREF an object view
|
| 4401000 |
OERI[16608] during import of transportable tablespace
|
| 4431195 |
Temporary lob leak during domain index sync operations
|
| 4431273 |
LOB segment PCTVERSION space reclaimation wrong
|
| 4559728 |
Select lob from view loops / OERI [17059] if synonym dropped
|
| 4634368 |
Performance issues with LOBs during reclaimation
|
| 4642825 |
ORA-22922 "non existant lob value" from incomplete bulk fetch
|
| 4748597 |
Moving a LOB in a partitioned table fails to update IND$
|
| 5011764 |
OERI[ktsircinfo_num1] accessing a LOB
|
| 5017007 |
MVIEW LOB content incorrect after refresh
|
| 2606632 |
Insufficient privileges error after user is granted all on nested table column
|
| 2742598 |
Object types with circular references are not exported if not used in table
|
| 2844111 |
DBMS_METADATA gives wrong DDL for PLSQL objects with embedded comments
|
| 3518579 |
Table mode export does not export parent type
|
| 3936576 |
Dictionary corruption modifying ADT column to NOT SUBSTITUTABLE
|
| 3983923 |
Export of a partition with a nested table column exports all nested table rows
|
| 4035664 |
ORA-932 or ORA-904 from CAST in SQL statement in a PLSQL block
|
| 4044798 |
Dump (kkdcgkc) from DML dereferencing scoped REFs
|
| 4046842 |
Table level export/import can produce corrupt TYPE metadata
|
| 4060287 |
Memory leak in OCCI object column with object attribute
|
| 4068481 |
ALTER TABLE to add a nested table column to a partitioned table uses wrong tablespace
|
| 4121749 |
ORA-21779 / dump using TABLE functions / BULK collect
|
| 4186247 |
Bad export / IMP-8/IMP-9 when importing long user defined types
|
| 4242649 |
Object views are slower than they need be
|
| 4331352 |
Wrong results with nested tables and outer queries
|
| 4352808 |
Dump (kglpnal) / OERI:17252 / crash from PQ with TYPE columns
|
| 4387452 |
ORA-22922 trying to DEREF an object view
|
| 4431181 |
Dump from SELECT if it changes from remote mapped to not
|
| 4583492 |
Dump possible using ADT columns when table has many columns
|
| 4860003 |
Sqlplus dump / OCI-21500 [koxsihread1]
|
| 4873171 |
TYPEID does not match after recreate of type
|
| 4959569 |
OERI[kdic_create_journal_table_1] rebuilding REF index ONLINE
|
| 3987280 |
Concurrent GRANT / SET ROLE can hang / deadlock
|
| 4029101 |
Concurrent CREATE TABLE can deadlock (ORA-60)
|
| 4114238 |
Deadlock between dc_users and dc_usernames row cache lock enabling FK
|
| 4153150 |
Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation
|
| 4185270 |
PMON "failed to acquire row cache enqueue" cleaning a dead process
|
| 4275733 |
Deadlock between library cache lock and row cache lock from concurrent rename partition
|
| 4313246 |
PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
|
| 4329748 |
ORA-4020 / deadlock quiescing a replication group
|
| 4371923 |
SMON may deadlock on TX enqueue waits for updates to COL_USAGE$ in RAC
|
| 4416907 |
ORA-4020 from DO_DEFERRED_REPCAT_ADMIN with concurrent SQL
|
| 4446011 |
Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
|
| 4627237 |
autonomous_transaction with DB link to shared server can self deadlock on DX
|
| 4732503 |
Self-deadlock on TT enqueue
|
| 4768022 |
ALTER TABLE can fail with ORA-60
|
| 5012368 |
Undetected deadlock in RAC
|
| 2284163 |
Import may dump with indexfile option
|
| 2539145 |
Exempt access policy privilege not recognized by the export utility (false EXP-79)
|
| 2686629 |
IMP-58 / ORA-31000 during import of XML schema with maintainDOM=false
|
| 2742598 |
Object types with circular references are not exported if not used in table
|
| 3447032 |
DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
|
| 3448802 |
Exp / Imp / view problems if LOB tablespace blocksize different to table blocksize
|
| 3518579 |
Table mode export does not export parent type
|
| 3983923 |
Export of a partition with a nested table column exports all nested table rows
|
| 4046842 |
Table level export/import can produce corrupt TYPE metadata
|
| 4116981 |
Import may dump when importing triggers
|
| 4347949 |
ORA-1031 importing JAVA CLASS objects owned by SYS
|
| 4354488 |
Exp/imp can change the "logging" attribute of a subpartitioned table
|
| 4559546 |
Cannot used exp/imp of MVIEW with XMLTYPE column
|
| 4573912 |
ORA-24021 in DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE on 9i import of queue
|
| 4711857 |
Exp/Imp of table with LONG swaps COMMENTS metadata
|
| 4898699 |
Reverse key index with system generated name is not exported
|
| 5031489 |
ORA-1455 during full database export
|
| 2212987 |
Dictionary corruption can occur as function index allowed when it should not
|
| 2692199 |
ORA-12805 from PQ MERGE with update clause with a functional index
|
| 3975758 |
INLIST ITERATOR not used if column part of DESC index
|
| 4096288 |
Dump (nsoexc) parsing ANSI outer join with functional indexes
|
| 4198156 |
Index-only retrieval not chosen with IOT and function based index
|
| 4246090 |
IOT corruption from buffered INSERT with function based index (ORA-8102)
|
| 4486132 |
Query using function based index gives wrong results
|
| 4767699 |
Spin in qcsjFindFroInQbc for query with join and functional index
|
| 4869429 |
OERI[qkagby0.4] from PQ with functional index aggregate
|
| 4871743 |
OERI [kkfi.qbcvfr] creating view which uses ROWID of another view
|
| 4939157 |
Dump (evaopn2) using a functional index
|
| 5015557 |
Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
|
| 5045474 |
Optimizer may not use function based index with NLSSORT of a CHAR column
|
| 2991727 |
Error message text shows as "????" using shared server with nls_language is not AMERICAN
|
| 3830455 |
Memory corruption possible for invalid ISO2022 escape sequences
|
| 3935624 |
ORA-1401 when trying to insert into NVARCHAR2 field
|
| 4044836 |
ALTER SESSION to set an NLS parameter may fail silently
|
| 4102499 |
Corrupted data selecting CHAR(255) over gateway to multibyte database
|
| 4275234 |
ORA-911 (rare) on non default language database
|
| 4320012 |
Enhancement - Add support for Albania and Albanian in NLS
|
| 4371638 |
SQL that uses LIKEC can dump in lxcscom
|
| 4414296 |
csscan reports ORA-1455
|
| 4476695 |
OCI always performs NLS validation
|
| 4496189 |
V$SESSION.PROGRAM can contain partial MULTIBYTE characters
|
| 4527173 |
AQ$_JMS_TEXT_MESSAGE.SET_TEXT method does not work correctly with multi-byte character
sets
|
| 4648650 |
SGA NLS inconsistencies leading to OERI/dump/ORA-12705
|
| 4757902 |
SGA NLS handles may be read while inconsistent
|
| 4895590 |
JAVA API createXML() can corrupt multibyte charset input data
|
| 4918584 |
Handling a SQL DATE error in a PLSQL exception block may dump
|
| 4950241 |
DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS() fails with ORA-1403
|
| 4964703 |
OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
|
| 5045474 |
Optimizer may not use function based index with NLSSORT of a CHAR column
|
| 3308044 |
Dispatcher may spin if session issues Ctrl-C
|
| 3875044 |
"cache buffer chains" latch held by non existing process
|
| 4047167 |
RAC hang possible processing synchronized dump request
|
| 4114238 |
Deadlock between dc_users and dc_usernames row cache lock enabling FK
|
| 4164021 |
OERI [2103] during BACKUP CONTROLFILE to TRACE
|
| 4275733 |
Deadlock between library cache lock and row cache lock from concurrent rename partition
|
| 4312871 |
SMON deadlock in RAC cleaning non-existant objects
|
| 4401702 |
Database hang after OERI[4519] error
|
| 4480100 |
Latch contention for "row cache objects" latch covering DC_USERS
|
| 4520104 |
Database can hang when using resource manager
|
| 4672266 |
LMS hang waiting for 'kjc: wait for msg sends to complete' during shutdown
|
| 4732503 |
Self-deadlock on TT enqueue
|
| 4928144 |
Diagnostics for OERI[1113/4/5/KSSRMP1] can cause database hang
|
| 5016142 |
SMON rollback of large transactions blocks other actions
|
| 2698805 |
Direct path operations from SQL may hang
|
| 2878379 |
ALTER PACKAGE COMPILE can hang then OERI:17069 after many hours
|
| 3987280 |
Concurrent GRANT / SET ROLE can hang / deadlock
|
| 4153150 |
Deadlock on dc_rollback_segments from concurrent parallel load and undo segment creation
|
| 4290505 |
OCCI connection pool hangs when database is shut down / restarted
|
| 4313246 |
PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
|
| 4371923 |
SMON may deadlock on TX enqueue waits for updates to COL_USAGE$ in RAC
|
| 4402255 |
Hang / dump possible using database link
|
| 4446011 |
Hang with row cache lock deadlock from concurrent ALTER USER / TRUNCATE
|
| 4449644 |
"virtual circuit buffers" latch can be held by non-existant process
|
| 4459410 |
DBMS_OUTPUT.get_lines hangs "sql*net more data from client" with fix for bug 4216266
|
| 4618808 |
AQ operation requiring exclusive lib cache lock may hang
|
| 4627237 |
autonomous_transaction with DB link to shared server can self deadlock on DX
|
| 4695686 |
Materialized view refresh hangs if database in restricted mode
|
| 4721492 |
ALTER INDEX REBUILD may hang instead of signalling ORA-54
|
| 4752179 |
Hang when calling extproc and killing client application
|
| 4872999 |
RAC instance cannot get global enqueue
|
| 4926861+ |
Cannot use USE_INDIRECT_DATA_BUFFERS with RAC in 9.2.0.7
|
| 2852551 |
ORA-471 DBWR dies during db_cache_size reduction
|
| 3738117 |
LMS may dump followed by instance crash
|
| 3868748 |
Instance crashes when trying to use "_disable_logging"=true
|
| 3892704 |
During reconfiguration processes may fail with OERI:kjuocl1
|
| 4007599 |
LMS can fail with OERI[kjbenterdlm]
|
| 4164021 |
OERI [2103] during BACKUP CONTROLFILE to TRACE
|
| 4191731 |
OERI[GPGA_MISMATCH] / crash can occur on some platforms
|
| 4352808 |
Dump (kglpnal) / OERI:17252 / crash from PQ with TYPE columns
|
| 4384672 |
SMON may fail with ORA-27103 during recovery of failed RAC instance
|
| 4393878 |
OERI[kclchkping_2] in shared server / PMON
|
| 4450964 |
Instance crash (PMON dump in kglpndl) after killing a shadow process
|
| 4473142 |
OERI[kcoadd_size] can occur in RAC
|
| 4581385 |
Alter database datafile offline crashes instance with OERI:[kcbbxsv_2]
|
| 4607458 |
LMON crashes the instance if DIAG raises ORA-449
|
| 4684373 |
OERI[kjrfnd1] / crash in RAC
|
| 4859002 |
PMON crash cleaning up serially_reusable PLSQL
|
| 4863048 |
LMS OERI[kjbmpocr:dsb] / instance crash with RAC
|
| 4903532 |
RAC instance may be evicted as LMS may not process messages quickly enough
|
| 4931933 |
Improve DIAG process error handling for OS level IPC errors
|
| 5043858 |
Server accept handle leak can crash RAC instance
|
| 3565920 |
ORA-4030 on select from V$SHARED_POOL_RESERVED after resize
|
| 3649251 |
Memory leak from DBMS_XSLPROCESSOR.SelectSingleNode
|
| 4060287 |
Memory leak in OCCI object column with object attribute
|
| 4100130 |
Object level statistics may leak SGA memory on errors
|
| 4176732 |
OCI INSERT using OCI_BATCH_ERROR_MODE leaks client memory
|
| 4188472 |
Memory leak using DOMAIN indexes
|
| 4213922 |
OCIStmtExecute() memory leak/iteration in PLSQL external routine
|
| 4244083 |
PLSQL memory leak
|
| 4350208 |
PGA memory leak associated with bitmap indexes
|
| 4375655 |
Large in-list consumes excessive memory with zero length string in the inlist
|
| 4593539 |
UGA memory leak using java.lang.ref.References in stored Java
|
| 4659781 |
DBMS_XSLPROCESSOR.freestylesheet(xsl) leaks memory / file handles
|
| 4672865 |
Large memory use using package level SYS.LCR$_ROW_RECORD
|
| 4746146 |
Pro client memory leak reexecuting SQL after ORA-1422
|
| 4754475 |
Client memory leak calling PLSQL which executes ALTER SESSION
|
| 5004782 |
Memory leak on repeated connect/disconnect
|
| 5014219 |
Excess memory use for large SQL if there are many children
|
| 2286150 |
Memory corruption of 'cursor work heap' using GROUP BY
|
| 3053014 |
Memory corruption during/after query on IOT using subset of PK columns
|
| 3304884 |
Dump (kwrepfb) / memory corruption during evaluation/fetch of large rule sets
|
| 3320402 |
Single byte memory corruption (\0) from SYS_CONTEXT
|
| 3630523 |
Memory corruption / OERI from logminer handling of CTAS operations
|
| 3684772 |
DBMS_XMLGEN.CONVERT can cause memory corruption
|
| 3830455 |
Memory corruption possible for invalid ISO2022 escape sequences
|
| 3844195 |
OERI [17112] registering XML schemas with AnyTypes
|
| 3891092 |
Memory corruption on query
|
| 4047969 |
Memory corruption / OERI[17147] following a "kksfbc:hash" chunk
|
| 4121749 |
ORA-21779 / dump using TABLE functions / BULK collect
|
| 4148420 |
Wrong results / dump with table prefetch enabled
|
| 4180525 |
Logminer may dump in krvxsrlctx
|
| 4380928 |
ALTER MATERIALIZED VIEW LOG add filter columns may dump
|
| 4398475 |
Memory corruption from replicated table with self referencing FK constraints
|
| 4551592 |
Memory corruption using SYS_XMLAGG
|
| 4583492 |
Dump possible using ADT columns when table has many columns
|
| 4644425 |
SGA corruption on UPDATE with functional domain index
|
| 5059488 |
Memory corruption / dump from INDEX SKIP SCAN
|
| 2283149 |
Hint on remote table may be lost
|
| 2423502 |
Wrong cost estimation with non-prefix bitmap index and nested loop
|
| 2856990 |
Fixed table indexes are not used in some cases
|
| 2984492 |
Index skip scan not considered for LIKE predicates
|
| 3142337 |
OERI[15160] during optimization
|
| 3332598 |
OERI 15160 with OPTIMIZER_MODE=FIRST_ROWS_10
|
| 3393866 |
Wrong results possible from OUTER JOIN to a VIEW
|
| 3488546 |
Subquery in GROUP BY HAVING clause not merged
|
| 3593345 |
INSERT AS SELECT with UNION may dump if using CASE
|
| 3628118 |
Index range scan chosen for LIKE '%a%' predicate with a hint
|
| 3857117 |
Wrong results due to CBO choosing wrong index
|
| 3865608 |
Optimizer does not eliminate outer-join based on join predicate
|
| 3929215 |
Query with inlist can produce duplicate rows
|
| 3967276 |
DBMS_STATS.set_column_stats does not set histogram if NDV <= 2
|
| 3975758 |
INLIST ITERATOR not used if column part of DESC index
|
| 3977261 |
Dump (kkeccomp) when using an outer join
|
| 4055596 |
TRUNCATE of an auto space managed table with an index sets index block count wrong
|
| 4130446 |
ROWNUM predicate may not cause FIRST_ROWS(K) optimization
|
| 4134033 |
ORA-904 from DBMS_STATS.GATHER_TABLE_STATS
|
| 4198156 |
Index-only retrieval not chosen with IOT and function based index
|
| 4219175 |
Create outline with bind variable causes ORA-1790
|
| 4222212 |
Dump (qervwRestoreViewBufPtrs)
|
| 4226736 |
Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
|
| 4230236 |
Wrong result with first_rows(k) for bitmap access path
|
| 4235962 |
IN query transformed to semi-join can be slow
|
| 4244360 |
OERI[16515] during DBMS_STATS.gather_table_stats after split partition
|
| 4259955 |
Wrong results from subquery unnesting with COUNT() functions
|
| 4275716 |
Bad selectivity for predicates using functions over binds
|
| 4282228 |
Dump executing complex view merged query with subquery and DISTINCT
|
| 4294948 |
Cardinality estimation can be wrong first_rows(k) mode
|
| 4335559 |
OERI [kkojcio] during query optimization
|
| 4375655 |
Large in-list consumes excessive memory with zero length string in the inlist
|
| 4406309 |
Incorrectly scaled density with height-balanced histogram
|
| 4417410 |
Analyzing a single composite partition can be slow
|
| 4464828 |
OERI[kcbgtcr_12] using ANALYZE on ASSM segment
|
| 4479933 |
Index skip scan not considered for > or >= with bind variables
|
| 4483240 |
INLIST may use suboptimal index
|
| 4483951 |
Wrong results from MERGE JOIN with subquery predicate on right table with ROWID
|
| 4492257 |
Suboptimal plan possible
|
| 4493256 |
Wrong result possible from complex view merging of ALL/ANY/[NOT]IN subquery
|
| 4506312 |
RBO can produce unnecessary negation predicates during OR expansion with CHAR columns
|
| 4519016 |
Wrong cardinality for INLINE view
|
| 4523371 |
Dump (evaopn2) from query on unmerged inline view
|
| 4545463 |
CBO uses wrong partition for costing when pruning with bind peeking
|
| 4570598 |
Cheapest plan may be rejected in FIRST_ROWS
|
| 4573396 |
CBO does not account for chained rows
|
| 4584065 |
ORDERED hint may not give desired join order
|
| 4622095 |
Dump kkdlacd() when creating stored outline for DML against a remote table
|
| 4627335 |
ORA-904 error from DBMS_STATS against index with special character/s
|
| 4643524 |
Dump in kkoppar() during optimization with remote query block/s
|
| 4663804 |
Bad plan or long parse time possible
|
| 4711525 |
Parsing of bitmapped plans can be slow
|
| 4712638 |
OERI[15160] / dump [kkogbro]
|
| 4714706 |
ORA-1402 on insert into UNION JOIN VIEW with CHECK option
|
| 4743096 |
Dump (in vopqbc) from SQL with complex view
|
| 4752814 |
Wrong selectivity on comparision of VARCHAR2 column with CHAR variable
|
| 4772145 |
Gathering statistics on large indexes is slow
|
| 4900129 |
High CPU consumption during parse for unused CHECK constraints
|
| 4901231 |
Index skip scan not used although cheaper
|
| 4904838 |
INDEX_SS hint may not be honoured and skip scan costing wrong
|
| 4947787 |
SIGFPE from CBO FIRST_ROWS(k) optimization
|
| 4968994 |
Poor plan using SYSDATE in predicate over dblink
|
| 5005866 |
NULL first element is left in multicolumn inlist
|
| 5015557 |
Dump under kkoNewExtractedBMKey or qerixGetKey with bitmap plan and function based index
|
| 5043097 |
OERI [15160] during query optimization
|
| 5073703 |
Column value out of range message not shown in 10053 in 10104
|
| 5075054 |
CBO may dump in vopdup
|
| 5078743 |
Dump (in qkabxo) using bitmap access path in FIRST K ROWS
|
| 4458790+ |
ORA-6502 selecting MAX/MIN into a CHAR variable in PLSQL
|
| 2987613 |
OERI[17280] connecting/disconnecting after cancel (Ctrl-C) of a query
|
| 3170401 |
Dump (under peidxino) can occur
|
| 3986388 |
OERI:qcsalcd1 using ANSI join/s with pipelined function/s
|
| 4029857 |
TO_CHAR(null) can be treated as a typeless NULL in PLSQL (PLS-307)
|
| 4035664 |
ORA-932 or ORA-904 from CAST in SQL statement in a PLSQL block
|
| 4091504 |
Position of argument is reversed after revoke any procedure privileges
|
| 4121749 |
ORA-21779 / dump using TABLE functions / BULK collect
|
| 4182351 |
Wrong length returns from UNION ALL in a PLSQL block
|
| 4207886 |
Corruption occurs on object data when copying between variables in PLSQL
|
| 4244083 |
PLSQL memory leak
|
| 4247457 |
No error from select which calls PLSQL function should throw ORA-1422
|
| 4313246 |
PLSQL execution can hold dc_users row cache lock leading to hang / deadlocks
|
| 4397882 |
Binding a collection of objects with certain data via PLSQL binds null
|
| 4466869 |
ORA-14403 from bulk PLSQL operations after truncate operation
|
| 4480100 |
Latch contention for "row cache objects" latch covering DC_USERS
|
| 4502755 |
Accessing DBMS_XMLDOM.DOMDocument in PLSQL can dump
|
| 4542097 |
Dump (qcdoftcn or kotgtsch) from PLSQL when AUDIT_TRAIL set
|
| 4725022 |
Wrong results from a function call using a CONCAT of a NULL
|
| 4754475 |
Client memory leak calling PLSQL which executes ALTER SESSION
|
| 4859002 |
PMON crash cleaning up serially_reusable PLSQL
|
| 4888471 |
SELECT using PLSQL package function can fail with ORA-4068,4061,4065
|
| 4918584 |
Handling a SQL DATE error in a PLSQL exception block may dump
|
| 2747873 |
DBMS_SPACE.UNUSED_SPACE may fail with OERI:kcbgcur_9
|
| 2816302 |
Table with DROPed column shows in KU$_FHTABLE_VIEW
|
| 2844111 |
DBMS_METADATA gives wrong DDL for PLSQL objects with embedded comments
|
| 2944274 |
DBMS_METADATA does not handle bitmap join indexes
|
| 2977027 |
DBMS_METADATA generates incorrect DDL for local indexes
|
| 3221259 |
ORA-6502 from DBMS_STATS
|
| 3304884 |
Dump (kwrepfb) / memory corruption during evaluation/fetch of large rule sets
|
| 3447032 |
DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)
|
| 3967276 |
DBMS_STATS.set_column_stats does not set histogram if NDV <= 2
|
| 4226736 |
Wrong clustering factor when DBMS_STATS.GATHER_INDEX_STATS runs in parallel
|
| 4244360 |
OERI[16515] during DBMS_STATS.gather_table_stats after split partition
|
| 4459410 |
DBMS_OUTPUT.get_lines hangs "sql*net more data from client" with fix for bug 4216266
|
| 4476592 |
DBMS_REPAIR.REBUILD_FREELISTS does not uniformly allocate to each freelist group
|
| 4627335 |
ORA-904 error from DBMS_STATS against index with special character/s
|
| 4772145 |
Gathering statistics on large indexes is slow
|
| 2454206 |
Allocation of more than 256 PQ slaves fails on remote instance
|
| 2692199 |
ORA-12805 from PQ MERGE with update clause with a functional index
|
| 3745911 |
OERI:qernsRowP can occur in parallel query
|
| 3845730 |
Parallel query may fail with OERI[15819]
|
| 3917001 |
OERI:qkaPIdsqkn1 from PQ of partitioned table
|
| 4041253 |
ORA-12805 trying to execute a query in parallel
|
| 4067168 |
Poor table scan PQ performance possible for ASSM segments
|
| 4177810 |
ORA-904 with non-column constants in FROM clause with PQ or remote SQL
|
| 4197915 |
CAST( x as number(n)) fails in PQ slaves with ORA-1727 with cursor_sharing
|
| 4214079 |
ORA-12801 / ORA-934 can occur in Parallel Query
|
| 4243628 |
ORA-960 from parallel CTAS
|
| 4249628 |
Range list partitioned tables may get serial plans with LIKE on subpartitioning column
|
| 4299620 |
Wrong results from PQ with HASH join
|
| 4336528 |
PQ may be slower than expected (timeouts on "PX Deq: Signal ACK")
|
| 4352808 |
Dump (kglpnal) / OERI:17252 / crash from PQ with TYPE columns
|
| 4384780 |
OERI[qkaOrderByPD 3] from parallel distinct outer join with ROWNUM
|
| 4409977 |
Insert into a partition with bitmap indexes can corrupt the index (ORA-1499)
|
| 4417371 |
TIMESTAMP columns loose fractional seconds in PQ
|
| 4483396 |
ORA-979 not a group by expression from PQ slave
|
| 4543879 |
OERI[OCIKDBLinkConn-8], [24327] from parallel distributed update
|
| 4544805 |
ORA-918 from PQ slave
|
| 4695511 |
OERI[kxfqupp_bad_cvl] when creating bitmap index
|
| 4869429 |
OERI[qkagby0.4] from PQ with functional index aggregate
|
| 4901155 |
Dump from PQ with large number of columns with over 1001 indexes
|
| 4927605 |
Wrong results from PQ execution of "NULLIF"
|
| 4944262 |
Parallel CTAS fails with ORA-12704 using CAST function
|
| 2423502 |
Wrong cost estimation with non-prefix bitmap index and nested loop
|
| 3020305 |
Dump (kkpamrget) from star join with anti-joins
|
| 3133151 |
OERI:qergiStart2 on create index with partitioned table
|
| 3359137 |
Dump (in kglobpc) can occur during exchange partition
|
| 3384512 |
ORA-1 during fast refresh of ROWID based MVIEW after TRUNCATE PARTITION on base table
|
| 3448802 |
Exp / Imp / view problems if LOB tablespace blocksize different to table blocksize
|
| 3780505 |
OERI[6302]/corrupt index creating functional index from existing local index
|
| 3865814 |
OERI:kghalo2 from INSERT APPEND to composite partitioned table
|
| 3917001 |
OERI:qkaPIdsqkn1 from PQ of partitioned table
|
| 3929301 |
ORA-14642 on exchange partition
|
| 3936808 |
ORA-26082 from SQLLOAD of multiple partitions with DIRECT=Y
|
| 3983923 |
Export of a partition with a nested table column exports all nested table rows
|
| 4044738 |
OERI:qkaPIdsqkn1 adding referential constraint to partitioned table
|
| 4068481 |
ALTER TABLE to add a nested table column to a partitioned table uses wrong tablespace
|
| 4197704 |
OERI:7005 from queries involving partitions and TIMESTAMPs
|
| 4203874 |
Dictionary corruption after DROP partition (can cause OERI:17059)
|
| 4221789 |
ORA-14642 during EXCHANGE PARTITION after DROP/ADD column
|
| 4231921 |
Truncate partition tables leaks SGA memory
|
| 4249628 |
Range list partitioned tables may get serial plans with LIKE on subpartitioning column
|
| 4275733 |
Deadlock between library cache lock and row cache lock from concurrent rename partition
|
| 4307033 |
Multi-column partition pruning needs leading columns
|
| 4354488 |
Exp/imp can change the "logging" attribute of a subpartitioned table
|
| 4381316 |
Local TEXT index invalidated when truncating a partition
|
| 4389673 |
SKIP_UNUSABLE_INDEXES does not take effect for unusable subpartitions
|
| 4421063 |
Exchange partition fails with ORA-14098 with 2 or more bitmap join indexes
|
| 4461334 |
Index subpartitions do not inherit index level logging attribute
|
| 4466869 |
ORA-14403 from bulk PLSQL operations after truncate operation
|
| 4496211 |
Wrong results after fast refresh of a partitioned materialized view
|
| 4502066 |
Crash during rebuild of partition domain index leaves index unusable
|
| 4524089 |
Wrong results / no data from temp table transformation with partitioned table
|
| 4545463 |
CBO uses wrong partition for costing when pruning with bind peeking
|
| 4697632 |
OERI[atbbjie2] from exchange partition with bitmap join indexes
|
| 4726573 |
Secondary index on global partitioned IOT is not used
|
| 4748597 |
Moving a LOB in a partitioned table fails to update IND$
|
| 4888264 |
Wrong results from select on partitioned table with NULL in multicolumn inlist
|
| 5011764 |
OERI[ktsircinfo_num1] accessing a LOB
|