| Category | Fixed | BugNo | Description |
|---|---|---|---|
| Corruption | 9201 | 1805146* | DROP Functional index does not clean up dictionary - Can cause corrupt export file |
| 9201 | 1281962+ | Media recovery after ORA-1578 on rollback can cause logical inconsistency | |
| 9201 | 1811914+ | Instance CRASH during ALTER TABLESPACE...READ ONLY can corrupt datablocks / require media recovery | |
| 9201 | 1950099+ | Function based index not updated after DIRECT LOAD | |
| 9201 | 1950279+ | Network disconnect from no-data-loss STANDBY can corrupt PRIMARY ONLINE redo logs | |
| 9201 | 2177181+ | Data corruption possible as RAC recovery can incorrectly decide no recovery is needed | |
| 9201 | 1273906 | OERI:12628 / ORA-2149 / Corrupt dictionary from DDL on PARTITIONED table via a synonym | |
| 9201 | 1347809 | Corrupt data possible using setNull(n,java.sql.Types.DATE) with batch executes | |
| 9201 | 1456397 | DBV: DBV-100 using DBVERIFY against a file with no filename extension | |
| 9201 | 1487313 | Triggers may see incorrect :NEW column values for constant columns in array inserts | |
| 9201 | 1531976 | Bytes may be lost inserting multibyte data > 4k in length | |
| 9201 | 1622924 | PDML Update SET=(subquery) may set data to NULL | |
| 9201 | 1656136 | DBVERIFY may incorrectly report TEMPORARY tablespace blocks as corrupt | |
| 9201 | 1803203 | DROP USER CASCADE may drop a different users TRIGGERS | |
| 9201 | 1804299 | Rollback of Direct load can corrupt BITMAP managed segments / ORA-8103 | |
| 9201 | 1813850 | DBMS_REPAIR.CHECK_OBJECT / ANALYZE .. VALIDATE may report a valid block as corrupted on some platforms | |
| 9201 | 1817813 | PLSQL Bulk INSERT NULL into TEMP table may insert bad data | |
| 9201 | 1837529 | OERI:KFTR2BZ_1/OERI:25012 from CREATE sub-partitioned local INDEX ONLINE | |
| 9201 | 1846487 | MASTER-DETAIL DATASTORE with BINARY=NO may corrupt text at buffer boundaries | |
| 9201 | 1847798 | DBV may spin when SEGMENT_ID & USERID specified | |
| 9201 | 1879479 | Export / import of WRAPPED PLSQL may corrupt the source | |
| 9201 | 1901844 | ROLLBACK to a NAMED SAVEPOINT with a DBLINK can result in a FULL ROLLBACK | |
| 9201 | 1912952 | ANALYZE TABLE .. VALIDATE STRUCTURE .. ONLINE may report false ORA-01499 | |
| 9201 | 1970629 | Index corruption possible if owning table / partition is TRUNCATED | |
| 9201 | 1982858 | Corrupt block / OERI:kcoapl_blkchk from block level recovery if SMON recovering same TX | |
| 9201 | 1984822 | Concurrent execution on tightly coupled transaction branches can cause logical corruption | |
| 9201 | 2058459 | ALTER TABLE allows you to add a LOB column to Hash Partitioned IOT | |
| 9201 | 2068275 | RMAN VALIDATE...CHECK LOGICAL incorrectly reports block corruption (ORA-19661) | |
| 9201 | 2070167 | DBV spins reporting same block corrupt if block type is bad | |
| 9201 | 2076247 | Loader may load incorrect NUMBER values for PACKED DECIMAL data | |
| 9201 | 2097405 | RENAME command can mess up the tablename of related triggers | |
| 9201 | 2124693 | Array insert .. select can lose data if the cursor is invalidated | |
| 9201 | 2131767 | Parallel create of FUNCTIONAL INDEX on PARTITION table can product corrupt index (ORA-8102) | |
| 9201 | 2134477 | DBA_DATA_FILES shows wrong values after failed resize which signalled ORA-3298 | |
| 9201 | 2140287 | Data corruption possible with CTAS or INSERT..SELECT across a DB link | |
| 9201 | 2151364 | DIRECT load of IOT can produce a corrupt IOT | |
| 9201 | 2161512 | INSERT /*+ APPEND*/ into table with FUNCTIONAL INDEX loads corrupt data | |
| 9201 | 2165461 | Direct load to table with DESCENDING index may cause subsequent ORA-8102 errors | |
| 9201 | 2188100 | Crash possible due to error in cluster block check code | |
| 9201 | 2199718 | 9.2 client to pre-9.2 server updating NUMBER and DATE columns can corrupt the NUMBER | |
| Recovery | 9201 | 1811914+ | Instance CRASH during ALTER TABLESPACE...READ ONLY can corrupt datablocks / require media recovery |
| 9201 | 1888033+ | ARCH Archival of threads with same SEQ# may use wrong first/next SCN | |
| 9201 | 1904199+ | OERI:KTEOPRPECT-1 possible using system managed undo - db will not start | |
| 9201 | 1950279+ | Network disconnect from no-data-loss STANDBY can corrupt PRIMARY ONLINE redo logs | |
| 9201 | 1034871 | BACKUP CONTROLFILE TO TRACE output is wrong if using BACKUP/STANDBY Controlfile | |
| 9201 | 1418532 | Parallel transaction recovery may be abandoned | |
| 9201 | 1504967 | ORA-8103 possible on READ ONLY standby after TRUNCATE on primary | |
| 9201 | 1656080 | ORA-3217 on TSPITR clone export if primary database has TEMPFILEs | |
| 9201 | 1781183 | OERI:2888 / OERI:KCFTRO_READ_WRITE / OERI:kcftro_in_trans trying to make a tablespace READ ONLY | |
| 9201 | 1795668 | ORA-328 on "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH" | |
| 9201 | 1795928 | OERI:KSIRES_1 possible if RFS process dies in RAC in Instant Protection Mode | |
| 9201 | 1797551 | OERI:1237 possible setting up MTS primary DB in Data Guard Broker configuration | |
| 9201 | 1809786 | Standby database may fail to open on same node as primary (ORA-1102) | |
| 9201 | 1905771 | OERI:KCRRGS2.2 possible on log switch with closed standby database | |
| 9201 | 1920673 | Standby database recovery may fail (End-of-redo error possible) in delayed protection mode | |
| 9201 | 1992254 | OERI:ksfdchkfob1 / OERI:17585 on recovery if first logfile member has bad header | |
| 9201 | 2000675 | QUOTA_SIZE restriction for LOG_ARCHIVE_DEST_N should not be enforced on STANDBY databases | |
| 9201 | 2041334 | OERI:2765 adding LOGFILE to STANDBY database if COMPATIBLE is different | |
| 9201 | 2055972 | OERI:2749 possible on OPEN RESETLOGS / ACTIVATE STANDBY (some platforms only) | |
| 9201 | 2083080 | ORA-1679 possibly activating standby if it has been opened READ ONLY | |
| 9201 | 2151468 | Switchover to primary (from standby) may hang if background recovery session is active | |
| 9201 | 2169363 | ORA-1172 possible after instance is evicted from the cluster | |
| Advanced / Secure Networking | 9201 | 1519547 | ORA-12592: TNS BAD PACKET possible with MTS and checksum (ASO) |
| 9201 | 1744109 | SSL Callouts may dump using MTS (in nzjsWrite or nzjsRead) | |
| 9201 | 1810324 | SHA-1 ASO crypto checksumming adapter reports internal errors on some platforms | |
| 9201 | 1824205 | OracleSSLInputStream.available() throws NullPointerException after SSLSocket closed | |
| 9201 | 1868595 | OracleSSLCredential.setWallet() throws NullPointerException if wallet has no private key | |
| 9201 | 1888480 | DCE is not included in Oracle9i Release 1 | |
| 9201 | 1980091 | Oracle Kerberos Adapter does not work with Microsoft KDC | |
| 9201 | 1988305 | Memory leak (can affect MOD_OSSL) | |
| 9201 | 2007128 | C_Digest symbol conflict between BCERT 1.0.1 and nCipher PKCS #11 | |
| 9201 | 2017172 | Allow value Tag in Domain Component (DC) to be VT_PRINTABLE_STRING | |
| 9201 | 2105083 | JavaSSL may crash in multithreaded programs (in a write call) | |
| 9201 | 2173809 | Add support for nCipher SSL HW accelerator | |
| 9201 | 2282201 | Multithreaded JavaSSL may dump when connection is closed | |
| Advanced Queuing | 9201 | 1663288* | ALTER TYPE / Running CATALOG invalidates Queues (ORA-24085) |
| 9201 | 1634098 | Using one QueueReceiver per dequeue operation leaks memory | |
| 9201 | 1736057 | Improved error information for AQ transformation errors | |
| 9201 | 1794770 | ORA-22998 propogating multibyte data using HTTP propogation | |
| 9201 | 1810693 | Transactional queues not locking all messages in a transaction group | |
| 9201 | 1824997 | AQJMSREADME.TXT instructions are incorrect for 9i | |
| 9201 | 1837850 | AQ of ADTs can leak TEMP lobs | |
| 9201 | 1855575 | AQxmlPublishRequest.getAutoCommit() may throw an exception | |
| 9201 | 1859206 | OCISubscriptionPost may cause server if using OCI_SUBSCR_NAMESPACE_AQ | |
| 9201 | 1859533 | Core dump possible repeatedly adding/removing a Rule based subscriber | |
| 9201 | 1875675 | ENH: Add support for SOAP messages to AQ XML SERVLET | |
| 9201 | 1898954 | RAW payload > 32K may dequeue incorrect data with AQ HTTP propogation | |
| 9201 | 1926312 | ORA-1007 on dequeue on transactional queue | |
| 9201 | 1949082 | REG$ not altered and DBMS_AQIN invalid after downgrading from 817 to 816 | |
| 9201 | 1992401 | SNP processes may dump (SIGFPE dump in KWQJAQ) when using AQ | |
| 9201 | 1995501 | getAttempts() method is not public | |
| 9201 | 2006514 | Removing AQ subscriber with non-null rules leaves enqueued messages | |
| 9201 | 2013550 | Temp Lob leak on enqueue/dequeue of message with transformation function | |
| 9201 | 2086729 | Memory leak using JMS API to AQ | |
| 9201 | 2127802 | ALTER SYSTEM SET AQ_TM_PROCESSES=0 may not stop QMN if issued just after STARTUP | |
| 9201 | 2135817 | Running OJMS with old JDK (1.1.X) can dump using the OCI driver | |
| 9201 | 2146152 | ORA-2019 scheduling propagation on a private database link | |
| 9201 | 2196276 | AQ propogation from 32 to 64 bit Oracle may dump | |
| Bitmap Indexes | 9201 | 1726833 | OERI:13013 / Dump in kdudcp from UPDATE using range scan converted to BITMAPS |
| 9201 | 1741117 | PDML to bitmap key of a partition table with row movement hangs | |
| 9201 | 1751186 | Wrong results / dump in qerixGetKey using bitmap indexes | |
| 9201 | 1834495 | OERI:12337 possible with many OR predicates on bitmap index prefix column | |
| 9201 | 1872985 | Dump / OERI:25012 from BITMAP CONVERSION of INDEX on GLOBAL TEMPORARY TABLE | |
| 9201 | 1904696 | ORA-1502 possible for valid BITMAP JOIN INDEX during maintenence | |
| 9201 | 1916487 | OERI:[QERBCROP KSIZE] possible from CREATE BITMAP INDEX on TO_DATE function | |
| 9201 | 1991341 | Wrong results possible from ROWID predicate with Bitmap Index FFS | |
| 9201 | 2006940 | Partition pruning ignores predicates at individual nodes of a BITMAP tree | |
| 9201 | 2024128 | Wrong results from FIRST_ROWS with Oracle Text query and BITMAP operation | |
| 9201 | 2065386 | Mem. Corruption / OERI:KGHFRE2 / OERI:17172 possible using bitmap indexes | |
| 9201 | 2114246 | Memory leak and long parse time for Part View with INLIST bitmap predicates | |
| Crash - Issues likely to cause an Instance to crash | 9201 | 1651530 | SMON may die with OERI:16224 crashing the instance |
| 9201 | 1787333 | Instance crashes if SERVICE_NAMES is set to an invalid string | |
| 9201 | 1829370 | OERI:4415 possible using XA to OPS or RAC with DBLINKS | |
| 9201 | 1839490 | DB may crash on startup for large SHARED_POOL_SIZE with many processors | |
| 9201 | 1877506 | PMON may crash in nscon if ORACLE_TRACE_ENABLE=TRUE and EPC_DISABLED=TRUE | |
| 9201 | 1941674 | ALTER SYSTEM SET SERVICE_NAMES=''; causes PMON to die | |
| 9201 | 1951929 | ORA-7445 in KQRGCU/kqrpfr/kqrpre possible | |
| 9201 | 2004227 | OERI:KCBKLLRBA_3 possible in CKPT in RAC | |
| 9201 | 2071313 | OERI:KSXPWAIT10 possible | |
| 9201 | 2143767 | SMON may dump (in KQLDVIU) trying to clean up non-existent objects | |
| 9201 | 2179527 | Failed ALTER SYSTEM to change an INIT.ORA parameter may lead to instance crash | |
| 9201 | 2188100 | Crash possible due to error in cluster block check code | |
| DB-Link / Distributed | 9201 | 1836101+ | Memory Corruption from distributed query / query with binds (OERI:17114/17xxx/dump in kkecdn/kgh*/kke*) |
| 9201 | 2124536+ | PLSQL CURSOR over DBLINK uses first BIND value each execution of the cursor | |
| 9201 | 914652 | ORA-2041 possible for DB LINK with XA / Microsoft Transaction Server / ODBC | |
| 9201 | 1485853 | Wrong Res / ORA-1008/ORA-2063 using DUPLICATE BIND variables over a DB link | |
| 9201 | 1551563 | ORA-7445 re-executing SQL with BINDS against SYNONYM which was REMOTE but is now LOCAL | |
| 9201 | 1698153 | Multibyte: CTAS between different CHARSET databases may not BLANK PAD CHAR columns | |
| 9201 | 1698784 | False ORA-980 if PLSQL references a SYNONYM pointing to a REMOTE PUBLIC SYNONYM | |
| 9201 | 1781184 | Implicit cursors using a remote table may cause XA error 100 | |
| 9201 | 1798042 | JDBC Thin gets "Bigger type length than maximum" using DBLink with character set conversion | |
| 9201 | 1803724 | ORA-28030 using current user DBLINKS in LDAP root context | |
| 9201 | 1829370 | OERI:4415 possible using XA to OPS or RAC with DBLINKS | |
| 9201 | 1901844 | ROLLBACK to a NAMED SAVEPOINT with a DBLINK can result in a FULL ROLLBACK | |
| 9201 | 1904254 | ORA-1008 possible from 9i -> 8i over DB Link with Bind variables | |
| 9201 | 1913494 | OERI:4400 possible from DBLINK after an error (eg: ORA-3106) | |
| 9201 | 1913626 | ORA-3106 possible from INSERT APPEND of REMOTE sequence | |
| 9201 | 1964934 | Memory corruption possible using INSERT /*+ APPEND */ over DBLINK | |
| 9201 | 1978040 | Operations from PLSQL over DBLINK to 8i may dump (ORA-7445) in KGLOBLD | |
| 9201 | 2073266 | ORA-1555 from a distributed query may be reported as OERI[QERRMOFBU1][1555] | |
| 9201 | 2097294 | Wrong results possible from SELECT over DBLINK using HASH JOIN | |
| 9201 | 2102779 | Query over DBLINK with DRIVING_SITE hint and BINDS can hang (affects snapshot refresh) | |
| 9201 | 2140287 | Data corruption possible with CTAS or INSERT..SELECT across a DB link | |
| 9201 | 2143268 | ORA-1457 possible fetching NUMBER(x,y) data over a DBLINK using OCI7 | |
| 9201 | 2157906 | ORA-2064 possible from insert over DB LINK fetching from loopback DBLINK | |
| 9201 | 2166337 | Insert from 9i to 8i using loopback database link may hang / dump | |
| 9201 | 2222694 | ORA-3106/ORA-1455/ORA-1426 possible for OCI_EXACT_FETCH array fetch over dblink | |
| 9201 | 2248904 | Memory corrupt possible during optimization of distributed query | |
| Domain Indexes | 9201 | 1747270 | OERI:QXIMCOC4 can be signalled on a memory error when using a DOMAIN index |
| 9201 | 1756779 | CBO may not choose a domain index when it should | |
| 9201 | 1853518 | Optimizer may not choose best plan if there is a join, BITMAP and DOMAIN index | |
| 9201 | 1853830 | OERI:KCBGTCR_4 possible if DOMAIN index dropped while in use by another query | |
| 9201 | 1885605 | ORA-30558 [COLFRO1] creating a Function based Domain Index using a Type Constructor | |
| 9201 | 1906189 | ORA-7445 [KKDCACR] possible from DML on table with locally partitioned DOMAIN index | |
| 9201 | 1987122 | Drop / recreate of FUNCTION based DOMAIN index signals ORA-604 / ORA-1 | |
| 9201 | 1989120 | OERI:QEROIFIRSTPART2 from UNION ALL of tables with DOMAIN INDEXES on them (affects Oracle Text) | |
| 9201 | 2052936 | ORA-1418 possible from PQ slave for table with DOMAIN index | |
| 9201 | 2096777 | CBO may not choose functional invokation of DOMAIN INDEX functions | |
| 9201 | 2171944 | Dump in QXIMSCC possible if Domain Index ODCIIndexStart errors | |
| 9201 | 2186975 | Low CONTAINS() function cost if DB_BLOCK_SIZE>2K can lead to non-DOMAIN INDEX access path | |
| Export/Import | 9201 | 1805146* | DROP Functional index does not clean up dictionary - Can cause corrupt export file |
| 9201 | 2093524+ | IMPORT with TOUSER=non_existing_user DROPs tables in the connected users SCHEMA | |
| 9201 | 1387619 | Export in 8.0/8i/9i is slower than Oracle 7 export of the same data | |
| 9201 | 1477959 | OERI:6193 possible from DIRECT EXPORT of tables containing ROWID columns | |
| 9201 | 1532659 | IMP-9 importing TYPE if OBJECT IDENTIFIER clause contains a NEWLINE character | |
| 9201 | 1586249 | Corrupt export from indexed clustered table with trailing nulls (IMP-9 on import) | |
| 9201 | 1686987 | OERI:6191 possible from direct path export (with trailing NULL columns) | |
| 9201 | 1748965 | NLS: Import may fail for SQL > 64Kb when translation is required | |
| 9201 | 1770571 | EXP-56 / OERI:[kpotcprc: depth exceeded] possible exporting ANYDATA columns | |
| 9201 | 1776167 | Import can overwrite the .DMP file if LOG filename same as DUMP name / IMP-50 | |
| 9201 | 1794683 | OERI:kkzugekdl:1 possible during import of MV log / snapshot log | |
| 9201 | 1796876 | Cannot import FGA (fine grain access) policies with QUOTES in predicate | |
| 9201 | 1802004 | EXP-8/ORA-1406/EXP-0 exporting a table with ALL DML options on RLS | |
| 9201 | 1805407 | ORA-1422 from DBMS_RULE_EXIMP possible on export | |
| 9201 | 1814421 | Importing CREATE UNDO or CREATE TEMPORARY Tablespace may report false ORA-901 | |
| 9201 | 1820663 | Direct export can duplicate some columns and omit others | |
| 9201 | 1866891 | Ecport may dump if an IO error occurs when exporting LOB data | |
| 9201 | 1874468 | Export may fail with ORA-1406 when exporting object type definitions. | |
| 9201 | 1879479 | Export / import of WRAPPED PLSQL may corrupt the source | |
| 9201 | 1930790 | Oracle7 export errors with EXP-11 against a 9i database | |
| 9201 | 1999033 | ORA-1455 possible when exporting associations | |
| 9201 | 1999156 | Export uses wrong GRANT command on JAVA SOURCE / RESOURCE (ORA-4042 on import) | |
| 9201 | 2040507 | IMP-46 / IMP-40 possible attempting to import MVS export to another platform | |
| 9201 | 2045838 | Primary Key based REF columns cannot be imported to 9i from an 8i export file | |
| 9201 | 2067904 | ORA-931 during import of triggers on tables with unusual characters in their name | |
| 9201 | 2070046 | IMP-20 possible importing COMPRESSED KEY IOT from a direct export | |
| 9201 | 2085606 | IMP TOUSER of a table in a READ ONLY tablespace errors with ORA-1647 | |
| 9201 | 2089034 | Export / Import of composite partitioned table looses SUBPARTITIONS clause | |
| 9201 | 2093328 | EXP-56 / ORA-1406 exporting partitioned table with default values > 2000 bytes | |
| 9201 | 2095320 | Import memory leak importing BFILE data | |
| 9201 | 2102655 | EXP-10 using mixed case schemaname in TABLES= clause | |
| 9201 | 2106151 | Table COMMENTS not exported correctly if table has UNUSED columns | |
| 9201 | 2110573 | ORA-439 attempting to IMPORT partitioned table into non-partitioned table without PARTIONING option | |
| 9201 | 2128560 | IMP-82 from table with ROWID column between EBCDIC <-> ASCII | |
| FailSafe | 9201 | 1711405 | AVLCSPPK.SH / AVLCSTPK.SH do not test for success correctly |
| 9201 | 1778408 | PFSSETUP sets incorrect permissions on subdirectories in TNS_ADMIN | |
| 9201 | 1787091 | SAVSETUP.SH does not work on some platforms | |
| 9201 | 1822529 | Cannot start OPFS with PFSCTL with multiple volume groups | |
| 9201 | 1849311 | RECYCLE is not prevented within PFS_RECYCLE_INTERVAL if recycling | |
| 9201 | 1849447 | PFS_RECYCLE_INTERVAL cannot be adjusted | |
| 9201 | 1924885 | Change to Oracle Instance monitor (oracle_up) method | |
| 9201 | 2156346 | ORACLE_SERVICE.env file generated by pfssetup has incorrect path | |
| Function Based Index (including DESC indexes) | 9201 | 1950099+ | Function based index not updated after DIRECT LOAD |
| 9201 | 1664189 | Query rewrite does not occur if base table has a FUNCTIONAL index on it | |
| 9201 | 1791101 | Wrong results possible using functional index on an IOT | |
| 9201 | 1838517 | Wrong result possible from Complex_View_Merging with Functional Index | |
| 9201 | 1859386 | Query with BITMAP FUNCTIONAL INDEXES may dump | |
| 9201 | 1916487 | OERI:[QERBCROP KSIZE] possible from CREATE BITMAP INDEX on TO_DATE function | |
| 9201 | 1962308 | CREATE of FUNCTION-BASED INDEX may error with ORA-4020 | |
| 9201 | 1976615 | OERI:15212 possible creating FUNCTION BASED index in PARALLEL | |
| 9201 | 1979393 | ORA-1733 possible after a FUNCTIONAL INDEX on the table has been dropped | |
| 9201 | 1987514 | Rebuild partitioned functional index performs full table scan | |
| 9201 | 2096565 | Wrong results possible when column in query has a DESCENDING index on it | |
| 9201 | 2097926 | Dump possible from query using Function based index with MVIEW and QUERY_REWRITE_INTEGRITY=TRUSTED | |
| 9201 | 2112604 | OERI:KDICWPRE_0 attempting to create FUNCTION BASED INDEX on ADT expression | |
| 9201 | 2118514 | ORA-7445 [RWORIRW2] from GROUP BY & ORDER BY on same FUNCTIONALLY INDEXED column | |
| 9201 | 2131767 | Parallel create of FUNCTIONAL INDEX on PARTITION table can product corrupt index (ORA-8102) | |
| 9201 | 2161512 | INSERT /*+ APPEND*/ into table with FUNCTIONAL INDEX loads corrupt data | |
| 9201 | 2194204 | Partition Views do not support functional indexes | |
| 9201 | 2231419 | Wrong results possible using ORDER BY/GROUP BY with functional index | |
| 9201 | 2255124 | AND-EQUAL with FUNCTIONAL index may dump / spin | |
| Gateways / Heterogeneous Services | 9201 | 1747320 | ENH: HS should write to the ALERT log when DD changes are made |
| 9201 | 1752554 | OERI:17182 selecting DB2 DATA TYPE of CHAR over HS | |
| 9201 | 1802744 | DB2 error messages not propogated through gateway to user | |
| 9201 | 1819588 | HS qualifies DB2 tables with 'PUBLIC.' if the supplied schemaname is 6 characters long (ORA-942) | |
| 9201 | 1948420 | ORA-3113 from PLSQL access LONG data over HS | |
| 9201 | 1949094 | Fetching DB2 Graphic data though HS errors | |
| 9201 | 2102253 | OERI:17271 / ORA-604 / ORA-1843 from Informix gateway | |
| 9201 | 2147175 | Multi threaded HS agent may crash | |
| 9201 | 2152752 | Memory corruption / OERI:17182 possible fetching CHAR from DB2 over HS | |
| Hangs / Spins | 9201 | 1927642+ | DROP TABLE can hang if PLSQL block access that table over a DB link (9i<->8i) |
| 9201 | 1204608 | Select from V$LATCH may hang / dump after RESOURCE_MANAGER_PLAN change | |
| 9201 | 1614857 | OERI:12869 / Hang possible after using ALTER TYPE with the INVALIDATE option | |
| 9201 | 1685119 | OERI:KCBLIBR_USER_FOU / hang when interrupt (Ctrl-C) of PQ using STAR_TRANSFORMATION | |
| 9201 | 1701374 | WinNT: Indexing with URL_DATASTORE on Windows leaks sockets - can appear to hang | |
| 9201 | 1703940 | ALTER INDEX REBUILD ONLINE of a REPLICATED object HANGS on "null event" | |
| 9201 | 1732852 | Instance hangs after an OERI:KCBLIBR_1 | |
| 9201 | 1741117 | PDML to bitmap key of a partition table with row movement hangs | |
| 9201 | 1744993 | ORA-4020/hang/dump from ALTER TYPE .. INVALIDATE using SUPERTYPE/SUBTYPE | |
| 9201 | 1749376 | Spin in kksfbc accessing Object view DEPENDING on table which had "ALTER TABLE UPGRADE" | |
| 9201 | 1752178 | ORA-1461/hang binding SQLT_LNG (LONG) with multibyte data | |
| 9201 | 1772992 | Dispatcher / Shared server may hang for 30-60 seconds | |
| 9201 | 1775685 | DML may spin while tablespace is put into HOT BACKUP mode | |
| 9201 | 1777504 | Hang possible with CURSOR_SHARING=FORCE (or SIMILAR in 9i) | |
| 9201 | 1784544 | Using Resource Manager with MTS can lead to HANG scenarios | |
| 9201 | 1791840 | Hang possible on database UNQUIESCE using shared servers | |
| 9201 | 1794448 | Deadlock in dictionary cache possible | |
| 9201 | 1796229 | Spin possible with shift sensitive charset using relative field positioning | |
| 9201 | 1799190 | Java clients using OracleTypeADT / OracleNamedType may hang | |
| 9201 | 1809480 | Create index / CTAS on BITMAP managed segments may hang/dump | |
| 9201 | 1819585 | ALTER PACKAGE .. COMPILE may hang for 8/8i client to 9i server | |
| 9201 | 1827047 | Startup of multiple instances may hang | |
| 9201 | 1833961 | OUT only PLSQL parameters can cause hang/error when passed using associative notation | |
| 9201 | 1841387 | SHUTDOWM IMMEDIATE may take > 60 seconds with no active transactions | |
| 9201 | 1842403 | Using PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY=AUTO can cause SPIN | |
| 9201 | 1863344 | Writing 0 bytes in JavaSSL causes a spin | |
| 9201 | 1865917 | ORA-4031 / high CPU from OR expansion of negated predicates with RBO | |
| 9201 | 1876878 | SHUTDOWN may take a LONG time due to full table scans of OBJ$ | |
| 9201 | 1879081 | PMON cannot cleanup a dead process holding the CI lock | |
| 9201 | 1887179 | Inserting into multibyte DB may hang if byte count equals column maximum | |
| 9201 | 1906596 | PQ may hang when query involves ORDER BY, SUBQUERY and UNION-ALL | |
| 9201 | 1907317 | Spin (in kksfbc) when creating child cursor if dependent object stays invalid | |
| 9201 | 1912308 | Concurrent MV complete refresh may cause a deadlock | |
| 9201 | 1912951 | OCIStmtExecute may hang binding >2000 byte OUT CHAR parameter in multibyte | |
| 9201 | 1916409 | Hang possible in OPS due to expired timeout | |
| 9201 | 1930501 | Foreground processes may spin / hold latch too long during instance recovery | |
| 9201 | 1956339 | JDBC Thin may hang sending lots of NULL data over multibyte | |
| 9201 | 1961643 | Hang possible in multibyte when modify CHAR columns length with NLS_LENGTH_SEMANTICS=CHAR | |
| 9201 | 1970332 | LIKE predicate in multibyte may spin in evalkp | |
| 9201 | 1975287 | Spin in KKOADDPRD possible for some SQL constructs | |
| 9201 | 1990082 | Create MVIEW on a query with a RANK function and a PARTITION clause spins | |
| 9201 | 2002214 | Excessive memory use / spin if PUSH_JOIN_PREDICATE=TRUE | |
| 9201 | 2034260 | Hang during startup after ticket starvation in LMON in RAC setup | |
| 9201 | 2041979 | Session may spin if an index is dropped while being accessed by another session | |
| 9201 | 2064923 | RAC hang possible due to lock context leak filling the shared pool | |
| 9201 | 2070167 | DBV spins reporting same block corrupt if block type is bad | |
| 9201 | 2102779 | Query over DBLINK with DRIVING_SITE hint and BINDS can hang (affects snapshot refresh) | |
| 9201 | 2114246 | Memory leak and long parse time for Part View with INLIST bitmap predicates | |
| 9201 | 2138185 | Timing window can lead to hang with global cache lock escalation | |
| 9201 | 2145004 | CTX_DOC.HIGHLIGHT() may spin highlighting a nested WITHIN text query | |
| 9201 | 2152574 | Hang possible due to ungranted global cache S to X escalation | |
| 9201 | 2154645 | Spin in KKSFBC possible when CURSOR_SHARING=FORCE | |
| 9201 | 2166337 | Insert from 9i to 8i using loopback database link may hang / dump | |
| 9201 | 2175616 | Hang possible if process being cleaned up by PMON | |
| 9201 | 2180461 | geteConnection() may hang in FIXED_WAIT_SCHEME if all connections are in use | |
| 9201 | 2183194 | PMON may not be able to cleanup dead session waiting on 'GLOBAL CACHE BUSY' | |
| 9201 | 2193404 | LMS may spin in kclpdcl() for a period of time | |
| 9201 | 2208570 | ORA-4030 / ORA-4031 / spin during query optimization with STAR TRANSFORMATION and unmergable view | |
| 9201 | 2229490 | Spin (in KDGGCS) possible inserting into a CLUSTER - generates lots of REDO/UNDO | |
| 9201 | 2245790 | Parse may appear to spin (in kkquccae/kkquwhr) | |
| 9201 | 2255124 | AND-EQUAL with FUNCTIONAL index may dump / spin | |
| 9201 | 2257703 | Hang possible during instance mount | |
| 9201 | 2302828 | Hang possible using temp table STAR_TRANSFORMATION (can hang SMON) | |
| 9201 | 2317497 | Spin possible while holding hash latch | |
| Hash Join | 9201 | 1818824 | OERI:15599 possible from hash join |
| 9201 | 1839080 | Memory leak possible using HASH join (ORA-4030) | |
| 9201 | 2046222 | OERI:KGHALO possible from HASH JOIN under a FIRST_ROWS hint | |
| Index Only Tables (IOT) | 9201 | 1770978 | Select with NOT EXISTS against IOT may fail |
| 9201 | 1791101 | Wrong results possible using functional index on an IOT | |
| 9201 | 1791258 | CONNECT BY on IOT can cause SGA memory corruption | |
| 9201 | 1798562 | False ORA-1 / dump from non-unique index on IOT | |
| 9201 | 1867959 | PARALLEL clause ignored for CTAS of IOT with NOT NULL constraints | |
| 9201 | 1931510 | Corrupt data possible from PDML on IOT with column reordering | |
| 9201 | 2058459 | ALTER TABLE allows you to add a LOB column to Hash Partitioned IOT | |
| 9201 | 2070046 | IMP-20 possible importing COMPRESSED KEY IOT from a direct export | |
| 9201 | 2074969 | ANALYZE on IOT UNIQUE SECONDARY INDEX with PK size > 129 may dump | |
| 9201 | 2151364 | DIRECT load of IOT can produce a corrupt IOT | |
| JDBC | 9201 | 984040 | getUpdateCount() does not behave correctly (as per the JDBC spec) |
| 9201 | 1326191 | V$SESSION.OSUSER is always 'ORACLE' using JDBC Thin | |
| 9201 | 1344959 | ENH: JDBC OCI driver add support for TIMESTAMP datatype | |
| 9201 | 1347809 | Corrupt data possible using setNull(n,java.sql.Types.DATE) with batch executes | |
| 9201 | 1527668 | Slow performance with object types and the JDBC OCI driver | |
| 9201 | 1534867 | Unsuccessful JDBC OCI connect attempt leaks client memory | |
| 9201 | 1548205 | SQLException: Invalid args to setRowBufferAt when Inserting into an empty Updateable Resultset | |
| 9201 | 1660225 | oracle.sql.NUMBER( java.lang.Float ) constructor rounds the FLOAT value | |
| 9201 | 1668134 | "Protocol Violation" from JDBC THIN if account password has expired | |
| 9201 | 1722692 | getString() does not return number strings in scientific notation | |
| 9201 | 1724593 | ENH: OracleConnection.pingDatabase() added | |
| 9201 | 1724964 | JDBC Thick Client Memory leak reusing statements which reference object types | |
| 9201 | 1741133 | NullPointerException in oracle.sql.ZONEIDMAP.getID from TIMESTAMPTZ constructor | |
| 9201 | 1752043 | ResultSetMetaData getScale() method can return incorrect SCALE for ADT NUMBER attributes | |
| 9201 | 1753705 | OERI:7005 / ORA-3115 querying an internal ROWID from a table | |
| 9201 | 1755028 | JDBC Thin: ORA-1008 updating LONG RAW using updateBinaryStream() | |
| 9201 | 1776242 | Client memory corruption / ORA-24392 using JDBC Thick | |
| 9201 | 1778960 | Introduce constructors to make TIMESTAMP types from String | |
| 9201 | 1779081 | TIMESTAMPTZ.TIMESTAMPTZ(Connection, Timestamp) uses DB time zone instead of session | |
| 9201 | 1782860 | getStringFunctions()/getSystemFunctions() etc return includes unwanted blank characters | |
| 9201 | 1786589 | JDBC/OCI signals unexpected ORA-1403 for SELECT of expressions over 255 characters long | |
| 9201 | 1794964 | Stylesheet with two <XSL:KEY>'s defined produces unexpected results | |
| 9201 | 1798042 | JDBC Thin gets "Bigger type length than maximum" using DBLink with character set conversion | |
| 9201 | 1799190 | Java clients using OracleTypeADT / OracleNamedType may hang | |
| 9201 | 1808525 | Excessive memory use by oracle.sql.NUMBER.toString() | |
| 9201 | 1815060 | The max length parameter of registerOutParameter() is ignored | |
| 9201 | 1824205 | OracleSSLInputStream.available() throws NullPointerException after SSLSocket closed | |
| 9201 | 1846617 | OracleConnection.setReadOnly(true) throws an SQLException | |
| 9201 | 1855575 | AQxmlPublishRequest.getAutoCommit() may throw an exception | |
| 9201 | 1863344 | Writing 0 bytes in JavaSSL causes a spin | |
| 9201 | 1868371 | stmt.setCHAR() does not convert from the CHAR objects charset to the DB charset | |
| 9201 | 1868595 | OracleSSLCredential.setWallet() throws NullPointerException if wallet has no private key | |
| 9201 | 1869822 | PreparedStatement.clearParameters() clears the whole batch rather than the current row | |
| 9201 | 1883191 | TIMESTAMPTZ & TIMESTAMPLTZ constructors treat Callendar as DBTIMEZONE | |
| 9201 | 1889187 | Oracle Enterprise Manager is not able to monitor JDBC drivers | |
| 9201 | 1889247 | JDBC/NativeXA improvements to support JDBC NativeXA feature in JTA | |
| 9201 | 1891210 | getInt calls NUMBER.toLong instead of NUMBER.toInt. | |
| 9201 | 1915539 | ArrayIndexOutOfBoundsException possible binding PLSQL table parameters | |
| 9201 | 1944389 | Hang / broken pipe error writing to output stream of Process from Runtime.exec | |
| 9201 | 1950686 | OracleStatement.getStringValue() for NUMBERs is limited to 38 characters | |
| 9201 | 1956339 | JDBC Thin may hang sending lots of NULL data over multibyte | |
| 9201 | 1961652 | JDBC thin connections as SYSOPER or SYSDBA are case sensitive (ORA-28009) | |
| 9201 | 1968849 | JDBC DMS Metrics do not have Noun types set. | |
| 9201 | 1975258 | Memory leak during JMS receive of Bytes/Object/Text/Stream message | |
| 9201 | 1993670 | OracleConnection setStmtCacheSize(n) causes JDBC exceptions | |
| 9201 | 1995501 | getAttempts() method is not public | |
| 9201 | 2013416 | JDBC connection cache has no timeout mechanism | |
| 9201 | 2018316 | getConnection() on connection cache may fail due to case sensitivity | |
| 9201 | 2025627 | "Statement Caching is not enabled" exception possible in JDBC | |
| 9201 | 2041941 | JDBC fetching SUBTYPES from the database is slow | |
| 9201 | 2059408 | JDBC "Not a collection image" Exception accessing Object with collection attribute | |
| 9201 | 2071718 | JDBC datasource metrics have same name for different DataSources values | |
| 9201 | 2086729 | Memory leak using JMS API to AQ | |
| 9201 | 2090177 | Dump possible in multithreaded JDBC OCI client with JDK 1.3 | |
| 9201 | 2100350 | OracleConnectionCacheImpl CacheInactivityTimeout does not work | |
| 9201 | 2100385 | Inactivity timeout does not work for XAConnections | |
| 9201 | 2100396 | Transaction isolation level not reset if a second logical connection is made | |
| 9201 | 2105083 | JavaSSL may crash in multithreaded programs (in a write call) | |
| 9201 | 2118014 | ORA-03115 from JDBC thin describing a table containing a TIMESTAMP based datatype | |
| 9201 | 2135817 | Running OJMS with old JDK (1.1.X) can dump using the OCI driver | |
| 9201 | 2140668 | ORA-6502 Reading CLOB data from multibyte DB with JDBC Thin | |
| 9201 | 2145632 | ORA-3113 / ORA-3114 should map to XAException.XAER_RMFAIL under JDBC XA | |
| 9201 | 2148404 | OracleStatement property to allow max_size argument to defineColumnType() to be in CHARACTERS | |
| 9201 | 2171758 | Performance slow using DMS enabled JDBC class files | |
| 9201 | 2180461 | geteConnection() may hang in FIXED_WAIT_SCHEME if all connections are in use | |
| 9201 | 2218716 | OracleConnectionCacheImpl spins using FIXED_WAIT_SCHEME on MAX+1 connection | |
| 9201 | 2221449 | ORA-24756/ORA-24776 on COMMIT after recovering IN-DOUBT/PREPARED transactions | |
| 9201 | 2223633 | JDBC may not remove metrics data (DMS) resulting in OutOfMemoryError | |
| 9201 | 2282201 | Multithreaded JavaSSL may dump when connection is closed | |
| 9201 | 2293575 | False ORA-17085 possible in JDBC with SELECT .. FOR UPDATE | |
| Java / SQLJ / JSP / Corba etc.. | 9201 | 1744109 | SSL Callouts may dump using MTS (in nzjsWrite or nzjsRead) |
| 9201 | 1753705 | OERI:7005 / ORA-3115 querying an internal ROWID from a table | |
| 9201 | 1813840 | 'CREATE JAVA SYSTEM' may dump in JOE_RUN_VM() | |
| 9201 | 1851174 | ORA-600 possible calling SQLJTYPE STATIC method from a PLSQL block | |
| 9201 | 1911129 | ORA-29545 possible loading Java code into the server | |
| 9201 | 1957400 | 9i Listener may not service connections to all GIOP endpoints | |
| 9201 | 1999156 | Export uses wrong GRANT command on JAVA SOURCE / RESOURCE (ORA-4042 on import) | |
| 9201 | 2004622 | OJMS administrative objects need to be Serializable | |
| 9201 | 2016464 | ALTER SESSION SET CURRENT_SCHEMA does not work for KPRB Java driver | |
| 9201 | 2024894 | OERI:17099 possible during java transaction forget | |
| 9201 | 2048552 | JAR files containing PRIVATE FINAL methods cannot be loaded | |
| 9201 | 2064575 | ORA-29516 possible from Java stored procedure accessing large ADTs | |
| 9201 | 2125960 | ORA-972 from GRANT EXECUTE with a long identifier | |
| 9201 | 2187432 | RMJVM does not clean up fully - can lead to ORA-604 errors on DDL | |
| LDAP / Oracle Internet Directory | 9201 | 1532611 | DBMS_LDAP leaks private memory |
| 9201 | 1794936 | DB needs to be bounced to use LDAP password-authenticated enterprise users | |
| 9201 | 1803724 | ORA-28030 using current user DBLINKS in LDAP root context | |
| 9201 | 1953494 | ENH: Provide new DBMS_LDAP_UTL package | |
| 9201 | 2032496 | DBMS_LDAP_UTL.GET_SUBSCRIBER_PROPERTIES() does not return default user properties | |
| 9201 | 2127189 | Authenticate may issue unnecessary LDAP calls | |
| 9201 | 2127217 | DBMS_LDAP_UTL does not work properly with non-UTF8 databases | |
| 9201 | 2179451 | DBMS_LDAP_UTL.GET_USER_PROPS_AND_AUTH does not return user properties if the password is about to expire | |
| LOB Related (CLOB/BLOB/BFILE) | 9201 | 681179 | Parallel TO_LOB(LONG) may dump |
| 9201 | 1219547 | ORA-942 accessing a LOB attribute of an ADT obtained from INSERT .. RETURNING | |
| 9201 | 1226565 | OERI:KXTOTOLC_LOBOPT accessing LOB column in a trigger eg: :NEW.LOB_COLUMN | |
| 9201 | 1668041 | Incorrect LOB block data may be read when using CACHE READS - many possible errors (eg: ORA-1555) | |
| 9201 | 1671601 | ORA-1555 ORA-22924 possible on LOBs inserted via TO_LOB | |
| 9201 | 1754786 | Pro/OCI DML RETURNING an ARRAY of LOB Locators dumps in TTCLD2I | |
| 9201 | 1766640 | ORA-22921 from LIKE / INSTR on CLOB column with Varying width Charset | |
| 9201 | 1828250 | OCCI may report errors for objects with LOB attributes (eg: ORA-22275) | |
| 9201 | 1838828 | DBMS_REDEFINITION.START_REDEF_TABLE can return ORA-904 is using TO_CLOB/BLOB | |
| 9201 | 1869016 | Transporting a tablespace containing LOB data fails (IMP-3 / ORA-22854) | |
| 9201 | 1923593 | "lobdemo1.pc" may dump | |
| 9201 | 2013550 | Temp Lob leak on enqueue/dequeue of message with transformation function | |
| 9201 | 2058459 | ALTER TABLE allows you to add a LOB column to Hash Partitioned IOT | |
| 9201 | 2086108 | TEMP LOB leak passing TEMP LOBS in recursive SQL ("lob ctl struct" grows) | |
| 9201 | 2140668 | ORA-6502 Reading CLOB data from multibyte DB with JDBC Thin | |
| 9201 | 2141807 | TEMPORARY LOB leak - affects Oracle Text | |
| 9201 | 2159322 | More LOBSEGMENT space is used for ENABLE STORAGE IN ROW than required | |
| 9201 | 2199391 | ADD/SPLIT [SUB]PARTITION can result in LOB partition in wrong tablespace | |
| 9201 | 2202283 | ORA-2220 error importing a Transportable Tablespace export with table containing LOB columns | |
| Large file / memory issues (Eg: 2Gb) | 9201 | 1759763 | KUP-4039 accessing EXTERNAL TABLE files > 2GB |
| LogMiner | 9201 | 1774044 | START_LOGMNR( with DBMS_LOGMNR.COMMITTED_DATA_ONLY may show rolled back data |
| 9201 | 1786093 | LOGMINER does not support NCHAR/NVARCHAR2/NCLOB | |
| 9201 | 1809875 | NLS: ORA-1843 possible from START_LOGMNR for some NLS territories | |
| 9201 | 1830805 | DBMS_LOGMNR.ADD_LOGFILE may incorrectly report ORA-1339 (LOGFILE_TOO_OLD) | |
| 9201 | 1830826 | ORA-01283 from dbms_logmnr.mine_value() | |
| 9201 | 1830836 | Dump possible from dbms_logmnr.mine_value() | |
| 9201 | 1840243 | ORA-3113 possible during DBMS_LOGMNR_D.BUILD on some platforms | |
| 9201 | 1841494 | Select from X$LGMR_CONTENTS sometimes dumps data to a trace file | |
| 9201 | 1857469 | DDL for Log Miner may not get writted into the redo stream | |
| 9201 | 1897764 | ORA-1332 possible from Log Miner (START_LOGMNR) for some values of COMPATIBLE | |
| 9201 | 2169057 | Logminer may show a piece of REDO/UNDO more than once if it spans rows in LOGMNR_CONTENTS | |
| 9201 | 2175055 | CTAS / IAS against V$LOGMNR_CONTENTS may dump | |
| 9201 | 2224620 | V$LOGMNR_CONTENTS may show object-ids if tables exist with dictionary names | |
| 9201 | 2246053 | V$LOGMNR_CONTENTS.SQL_REDO/UNDO may not display CHAR columns using DDL_DICT_TRACKING | |
| MERGE .. USING | 9201 | 1764657 | OERI:qkaUpsertRowVector4 possible from MERGE sql with AND in the ON clause |
| 9201 | 1801127 | MERGE with DIRECT LOAD INSERT and UPDATE may allocate wrong extent size | |
| 9201 | 1970507 | OERI:QCTCTEL / OERI:18096 from OUTER JOIN in MERGE USING clause in PLSQL | |
| Memory Corruption | 9201 | 1836101+ | Memory Corruption from distributed query / query with binds (OERI:17114/17xxx/dump in kkecdn/kgh*/kke*) |
| 9201 | 1542218 | Heap corruption (OERI:17182/dump in kghfrf) using very large collections | |
| 9201 | 1682090 | INDEX_JOIN hint can cause memory corruption if _INDEX_JOIN_ENABLED=false | |
| 9201 | 1744786 | Cursor work heap corruption from CONNECT BY PRIOR | |
| 9201 | 1748759 | Client memory corruption / dump (eg: in ttcfopr) using pre-fetch | |
| 9201 | 1752554 | OERI:17182 selecting DB2 DATA TYPE of CHAR over HS | |
| 9201 | 1776242 | Client memory corruption / ORA-24392 using JDBC Thick | |
| 9201 | 1783136 | XMLType.createXML may cause heap corruption | |
| 9201 | 1791258 | CONNECT BY on IOT can cause SGA memory corruption | |
| 9201 | 1828649 | PGA memory corruption possible using adaptive direct reads | |
| 9201 | 1847583 | Client memory corruption/dump using large value_sz for OCIDefineByPos with OCI_DYNAMIC_FETCH | |
| 9201 | 1850374 | SYNC_INDEX on Shared Server (MTS) can corrupt memory | |
| 9201 | 1859905 | Intermittent dump / client memory corruption | |
| 9201 | 1944822 | OCI-21500 / Client memory corruption when inserting subtype object into supertype table in OCI/OCCI | |
| 9201 | 1964934 | Memory corruption possible using INSERT /*+ APPEND */ over DBLINK | |
| 9201 | 1968635 | OERI:KCOAPL_BLKCHK / buffer cache corruption from CR rollback | |
| 9201 | 1978077 | Memory corruption during QUERY REWRITE if select list has operator on top of aggregate | |
| 9201 | 1987654 | Compiling a PLSQL block with an INDICATOR clause can corrupt memory | |
| 9201 | 1995026 | OERI:17112 / heap corruption from Oracle Trace with MTS & Large Pool | |
| 9201 | 2048336 | OERI:150 / Memory corruption from interrupted STAR TRANSFORMATION | |
| 9201 | 2065386 | Mem. Corruption / OERI:KGHFRE2 / OERI:17172 possible using bitmap indexes | |
| 9201 | 2118808 | Memory corruption passing > 36 character schama.name to DBMS_REDEFINITION.START_REDEF_TABLE | |
| 9201 | 2126096 | Session heap corruption from LIKE :bind ESCAPE '/' if :bind ends in the escape character | |
| 9201 | 2137629 | Memory corruption possible with PREDICATE comparing character column to NUMBER constant | |
| 9201 | 2152752 | Memory corruption / OERI:17182 possible fetching CHAR from DB2 over HS | |
| 9201 | 2170912 | OERI:KGHFRE2 / dump / memory corruption selecting JAVA source from DBA_SOURCE | |
| 9201 | 2176277 | SGA corruption possible from "kill -9" of shadow as PMON cleanup incorrect (rare) | |
| 9201 | 2208113 | Dump / memory corruption possible using USER FILTER for 10K document | |
| 9201 | 2212389 | OERI:25012 / Cursor frame memory corruption when cursor with BINDS aged out / reloaded | |
| 9201 | 2248904 | Memory corrupt possible during optimization of distributed query | |
| Migration / Upgrade / Downgrade | 9201 | 1880694+ | Upgrade from 8i to 9i can mess up multibyte data (eg: UTF8) |
| 9201 | 1732626 | ENH: Reduce INVALIDATIONS and recompilations required when installing patch sets | |
| 9201 | 1799630 | ORA-942 from SMON for SMON_SCN_TIME during upgrade from 8.1.6 | |
| 9201 | 1802432 | Migration from V7->816/817 gives OERI:KCOAPL_BLK for clusters with FREELISTS | |
| 9201 | 1810131 | ENH: Parallel version of UTLRP.SQL (utlrcmp) | |
| 9201 | 1871365 | C0801070.SQL does not run CATHS.SQL - DBMS_HS_UTL invalid after upgrade from 817 | |
| 9201 | 1931735 | Upgrade to 9i may fail with OERI:15456 / ORA-4045 on DBMS_OUTPUT | |
| 9201 | 1944351 | UTLIP may fail due to lack of rollback space | |
| 9201 | 1949082 | REG$ not altered and DBMS_AQIN invalid after downgrading from 817 to 816 | |
| 9201 | 1950073 | UTLIP.SQL does not exit on severe errors | |
| 9201 | 2008043 | Text searches may dump for database migrated between 64bit and 32bit | |
| 9201 | 2167326 | ORA-4031 possible during patch set upgrade scripts | |
| 9201 | 2181296 | Text CONTAINS() queries may dump if database is upgraded from 32 to 64 bit | |
| NLS (National Language Support) | 9201 | 1880694+ | Upgrade from 8i to 9i can mess up multibyte data (eg: UTF8) |
| 9201 | 1333333 | OERI:84 on TO_DATE using ARABIC HIJRAH calendar | |
| 9201 | 1531976 | Bytes may be lost inserting multibyte data > 4k in length | |
| 9201 | 1606920 | Multiple sessions over one connection may use wrong NLS language if a session changes their language | |
| 9201 | 1698153 | Multibyte: CTAS between different CHARSET databases may not BLANK PAD CHAR columns | |
| 9201 | 1748965 | NLS: Import may fail for SQL > 64Kb when translation is required | |
| 9201 | 1752178 | ORA-1461/hang binding SQLT_LNG (LONG) with multibyte data | |
| 9201 | 1766640 | ORA-22921 from LIKE / INSTR on CLOB column with Varying width Charset | |
| 9201 | 1775470 | Wallet Mgr: "Starting" message appears in English for non-english locales | |
| 9201 | 1785216 | Using MATCHES with CLOB parameter on multibyte charset dumps | |
| 9201 | 1785217 | NLS: OWM show some messages without NLS translation | |
| 9201 | 1787575 | Dump in drexqrprs possible using CTXRULE CLOB api in multibyte | |
| 9201 | 1789212 | Wrong results from interMedia WITHIN queries on XML documents in Multibyte | |
| 9201 | 1796229 | Spin possible with shift sensitive charset using relative field positioning | |
| 9201 | 1798042 | JDBC Thin gets "Bigger type length than maximum" using DBLink with character set conversion | |
| 9201 | 1809875 | NLS: ORA-1843 possible from START_LOGMNR for some NLS territories | |
| 9201 | 1838006 | Incorrect UNIQUE conflict handling for NCHAR/NVARCHAR etc. | |
| 9201 | 1845370 | SUBSTR2(),SUBSTR4(),SUBSTRC() may dump for UTF8 | |
| 9201 | 1866343 | NLS: Ultra Search Query API results may be returned in hexadecimal format | |
| 9201 | 1868371 | stmt.setCHAR() does not convert from the CHAR objects charset to the DB charset | |
| 9201 | 1887179 | Inserting into multibyte DB may hang if byte count equals column maximum | |
| 9201 | 1910476 | SUBSTRB blank pads fractional characters in multibyte | |
| 9201 | 1912951 | OCIStmtExecute may hang binding >2000 byte OUT CHAR parameter in multibyte | |
| 9201 | 1914259 | SQLPLUS: Setting NLS_DATE_FORMAT in ALTER SESSION within a function does not change the date format | |
| 9201 | 1918207 | Create MVIEW against pre-9i release gives wrong column lengths in multibyte | |
| 9201 | 1940915 | ORA-1401 from STATPACK.SNAP in multibyte environment | |
| 9201 | 1953883 | NEXT_DAY function returns wrong day for NLS_TERRITORIES with first day of week between Tuesday - Saturday | |
| 9201 | 1961643 | Hang possible in multibyte when modify CHAR columns length with NLS_LENGTH_SEMANTICS=CHAR | |
| 9201 | 2123221 | Snapshot refresh may not update CHAR columns in multibyte DB from singlebyte master | |
| 9201 | 2130307 | V$SQLTEXT shows incorrect data if 64th byte is start of a multibyte character | |
| 9201 | 2148404 | OracleStatement property to allow max_size argument to defineColumnType() to be in CHARACTERS | |
| 9201 | 2152876 | Array insert may be slow with multibyte characterset (affects ProCobol PICX=VARCHAR2) | |
| 9201 | 2216344 | False ORA-6502 possible using PIPELINED function returning a TYPE in MULTIBYTE | |
| Network | 9201 | 1688500 | Prespawned servers crash when OPS is configured |
| 9201 | 1690759 | Spurious ORA-12571 possible using BEQUEATH connection if write is interrupted | |
| 9201 | 1707919 | FAILOVER: Number of preconnnect processes increases with each detach/attach | |
| 9201 | 1738764 | NETMGR may give error on menu options for locale=KO | |
| 9201 | 1857191 | Listener not updated with session disconnects in a timely manner | |
| 9201 | 1865284 | FAILOVER: Multithreaded OCI/JDBC-thick client with TAF may hang on failover | |
| 9201 | 1880986 | 9i listener rejects connect attempts to 8i database (ORA-12516) | |
| 9201 | 1887060 | Listener may erroneously register MIBs for oraPrespawnedSrvTable | |
| 9201 | 1887304 | Multiple sessions timeout is not handled with CONNECTION POOLING | |
| 9201 | 1895573 | Obsolete version of TRCASST is shipped with Oracle9i Release 1 | |
| 9201 | 1899297 | DCD (SQLNET.EXPIRE_TIME) does not work for dispatchers (shared server) | |
| 9201 | 1903062 | ENH: Millisecond precision for timestamps in Network trace files | |
| 9201 | 1943960 | TNS-04002 on CMAN startup if CMAN.ORA has many rules in RULE_LIST | |
| 9201 | 1953704 | Net client with SDU size > server SDU may report "bad packet error" | |
| 9201 | 1956339 | JDBC Thin may hang sending lots of NULL data over multibyte | |
| 9201 | 1958867 | FAILOVER: ORA-1008 possible after failover of statement using BINDS | |
| 9201 | 1965005 | SET SAVE_CONFIG_ON_STOP causes a dump if SID_LIST in LISTENER.ORA exceeds 2048 bytes | |
| 9201 | 1994886 | RAC load balancing does not work if a bunch of connect requests arrive together | |
| 9201 | 1999339 | False TNS-12154 error possible from multithreaded Net8 client | |
| 9201 | 2101945 | Dump in nszgclient for some RAW connections | |
| 9201 | 2128784 | Slow connect times possible with long TNS description strings | |
| 9201 | 2134254 | Connection load balancing does not work for DEDICATED connections | |
| OCCI | 9201 | 1828225 | OCCI Cache size may be exceeded appearing as a memory leak |
| 9201 | 1828239 | Add setNull() method to classes Ref<T> and RefImpl | |
| 9201 | 1828250 | OCCI may report errors for objects with LOB attributes (eg: ORA-22275) | |
| 9201 | 1921355 | OCCI Dump inserting persistent object when some attributes not specified | |
| 9201 | 1944822 | OCI-21500 / Client memory corruption when inserting subtype object into supertype table in OCI/OCCI | |
| 9201 | 1972829 | OCCI: OCI-22625 possible from OCCI setVectorOfPObjects method | |
| 9201 | 1989913 | OCCI: REF gets object from the cache even after a COMMIT | |
| 9201 | 2082790 | OCCI objects with string attributes can leak memory | |
| 9201 | 2129479 | Destruction of a newly created unflushed object may crash | |
| 9201 | 2186438 | Cannot create OCCI environment with both OBJECT and THREADED_MUTEXED | |
| OCI | 9201 | 911959 | OCI client may dump updating more than one LONG column with dynamic binds and callbacks |
| 9201 | 1238084 | Pro/OCI clients single row select may use more server CPU than < 8.1 | |
| 9201 | 1529221 | OCIDescribeAny describe of a NO_SUCH_USER.OBJ describes PUBLIC.OBJ if NO_SUCH_USER does not exist | |
| 9201 | 1647014 | OCIStmtExecute may fail for DML operations with iteration > 32767 | |
| 9201 | 1672862 | OCIDateTimeGetTimeZoneOffset()/OCIDateTimeGetTimeZoneName() return incorrect results for TIMESTAMP WITH LOCAL TIME ZONE | |
| 9201 | 1748759 | Client memory corruption / dump (eg: in ttcfopr) using pre-fetch | |
| 9201 | 1752178 | ORA-1461/hang binding SQLT_LNG (LONG) with multibyte data | |
| 9201 | 1754786 | Pro/OCI DML RETURNING an ARRAY of LOB Locators dumps in TTCLD2I | |
| 9201 | 1761391 | Array fetch into OCIString can return truncated data | |
| 9201 | 1801240 | OCIDescribeAny dumps describing Package procedure with NO arguments in an Oracle7 server | |
| 9201 | 1810915 | Process may dump if you using OCISubstriptionRegister and have not initialized with OCI_EVENTS | |
| 9201 | 1845953 | OCIRefFromHex can leak client side memory | |
| 9201 | 1847583 | Client memory corruption/dump using large value_sz for OCIDefineByPos with OCI_DYNAMIC_FETCH | |
| 9201 | 1858026 | OCIAnyData does not handle character data correctly | |
| 9201 | 1859206 | OCISubscriptionPost may cause server if using OCI_SUBSCR_NAMESPACE_AQ | |
| 9201 | 1894578 | EXEC SQL DESCRIBE from 8i client to 9i server may return no information | |
| 9201 | 1899861 | DATE column set to NULL if bind length is > 1333 using obndrv in OCI7 | |
| 9201 | 1912951 | OCIStmtExecute may hang binding >2000 byte OUT CHAR parameter in multibyte | |
| 9201 | 1927245 | OCIDefineByPos dumps using a statement handle from a detached session | |
| 9201 | 1978606 | OCIStmtExecute() does not error for invalid statement handle - affects ProC | |
| 9201 | 2002954 | ORA-1810 / ORA-1821 possible in multithreaded OCI clients | |
| 9201 | 2033552 | XA_OPEN does not support OCI_EVENTS so OCISubscriptionRegister may dump / ORA-1010 | |
| 9201 | 2065385 | Array insert with OCI_BATCH_ERRORS may dump or OERI:kcoapl_blkchk | |
| 9201 | 2124163 | "kgepop: no error frame to pop to for error 21522" using OCITypeByName | |
| 9201 | 2126389 | OERI:KPOSCWS0 possible using OCIStmtFetch2 (Scrollable cursors) | |
| 9201 | 2143268 | ORA-1457 possible fetching NUMBER(x,y) data over a DBLINK using OCI7 | |
| 9201 | 2176225 | Complex object retrieval may dump (in kgghash) using OCIObjectArrayPin() | |
| 9201 | 2178041 | ORA-255 or ORA-65280 fetching zero length CLOB column with OCIStmtFetch2() | |
| 9201 | 2205899 | Core dump instead of ORA-1008 possible in an OCI7 client | |
| 9201 | 2222694 | ORA-3106/ORA-1455/ORA-1426 possible for OCI_EXACT_FETCH array fetch over dblink | |
| Objects (Types/Collections) | 9201 | 1219547 | ORA-942 accessing a LOB attribute of an ADT obtained from INSERT .. RETURNING |
| 9201 | 1333526 | ORA-4031 / Poor performance using persistent Object data types | |
| 9201 | 1509738 | ADT data can exceed the declared column length | |
| 9201 | 1532659 | IMP-9 importing TYPE if OBJECT IDENTIFIER clause contains a NEWLINE character | |
| 9201 | 1542218 | Heap corruption (OERI:17182/dump in kghfrf) using very large collections | |
| 9201 | 1614857 | OERI:12869 / Hang possible after using ALTER TYPE with the INVALIDATE option | |
| 9201 | 1744993 | ORA-4020/hang/dump from ALTER TYPE .. INVALIDATE using SUPERTYPE/SUBTYPE | |
| 9201 | 1749376 | Spin in kksfbc accessing Object view DEPENDING on table which had "ALTER TABLE UPGRADE" | |
| 9201 | 1752043 | ResultSetMetaData getScale() method can return incorrect SCALE for ADT NUMBER attributes | |
| 9201 | 1779374 | SIGFPE in PKRCD() possible after ALTER TYPE name COMPILE BODY | |
| 9201 | 1789460 | ALTER TYPE to NOT FINAL succeeds when it should not | |
| 9201 | 1808362 | ALTER TABLE UPGRADE may dump after ALTER TYPE INVALIDATE | |
| 9201 | 1812331 | Describe of an ADT NUMBER column shows SCALE of 0 (rather than -127) | |
| 9201 | 1817835 | ALTER TYPE FINAL or NOT FINAL does not generate an intermediate version | |
| 9201 | 1859208 | OERI:[qctVCO:csform] possible from CREATE VIEW FORCE with invalid column name and CAST operator | |
| 9201 | 1860325 | Dump possible changing a TYPE from NOT FINAL to FINAL | |
| 9201 | 1873968 | FULL JOIN of TABLE() functions may ORA-942 or dump | |
| 9201 | 1874370 | Repeated object method invokation can result in OERI:KOHDTF048 | |
| 9201 | 1885605 | ORA-30558 [COLFRO1] creating a Function based Domain Index using a Type Constructor | |
| 9201 | 1945390 | Dump (in KOCGPN2) creating a table of SUBTYPE with no attributes | |
| 9201 | 1981897 | Dump in KOPUTILASSERT possible using large collections | |
| 9201 | 2030252 | Dump possible un-nesting a table (using TABLE() clause) | |
| 9201 | 2045838 | Primary Key based REF columns cannot be imported to 9i from an 8i export file | |
| 9201 | 2048399 | OERI:KDIC_MARK_INDEX_DISABLED1 possible on DROP TYPE FORCE if an index uses the type | |
| 9201 | 2059408 | JDBC "Not a collection image" Exception accessing Object with collection attribute | |
| 9201 | 2064575 | ORA-29516 possible from Java stored procedure accessing large ADTs | |
| 9201 | 2076285 | Dump in UPDPRE with TRIGGER on table containing an OBJECT (ADT) | |
| 9201 | 2112604 | OERI:KDICWPRE_0 attempting to create FUNCTION BASED INDEX on ADT expression | |
| 9201 | 2136476 | OERI:KKXPITYP1 possible on select from TABLE() operations | |
| 9201 | 2172005 | ORA-600[koktalt_dep_tabs2] possible on ALTER TYPE .. CASCADE with REF dependency | |
| 9201 | 2176225 | Complex object retrieval may dump (in kgghash) using OCIObjectArrayPin() | |
| 9201 | 2212979 | Dump in PLSQL referencing a TABLE.COLLECTION.METHOD outside of SQL | |
| 9201 | 2230365 | Memory leak possible using TABLE() clause | |
| 9201 | 2241810 | Dump (in kokmeoc) possible from CURSOR() select | |
| Optimizer | 9201 | 1836101+ | Memory Corruption from distributed query / query with binds (OERI:17114/17xxx/dump in kkecdn/kgh*/kke*) |
| 9201 | 1689678 | ORA-979 when PARTITION_VIEW_ENABLED=TRUE and query with literals references ANALYZED tables | |
| 9201 | 1753899 | DBMS_STATS can fail (ORA-904) for a table with a security policy on it | |
| 9201 | 1756779 | CBO may not choose a domain index when it should | |
| 9201 | 1767528 | CBO may not choose INDEX SKIP SCAN plan even if it is cheaper | |
| 9201 | 1767537 | CBO does not use INDEX SKIP SCAN even if hinted (INDEX_SS) for non-equality predicate with a BIND | |
| 9201 | 1772967 | ORA-28604 possible if ROWID to BITMAP CONVERSION used in plan (no bitmap index) | |
| 9201 | 1776046 | Dump in KKECDN possible for queries involving DB Links | |
| 9201 | 1853518 | Optimizer may not choose best plan if there is a join, BITMAP and DOMAIN index | |
| 9201 | 1873616 | ENH: Allow descending partition scan for ORDER BY | |
| 9201 | 1873824 | DBMS_STATS.GATHER_SYSTEM_STATS(Pname=>'MBRC') returns too high a value | |
| 9201 | 1895950 | High parse times for statements with many identical AND predicates when QUERY_REWRITE_ENABLED=TRUE | |
| 9201 | 1939611 | Wrong selectivity estimate for some AND/OR combinations | |
| 9201 | 1946566 | OERI:15160 possible from join of 5 or more table when CBO attempts STAR | |
| 9201 | 1964948 | Parallel DDL can have detrimental effect on performance (reduced data clustering) | |
| 9201 | 1968802 | Wrong selectivity estimate for IN lists | |
| 9201 | 1969051 | LIKE predicates with ESCAPE clause may be inefficient | |
| 9201 | 2002214 | Excessive memory use / spin if PUSH_JOIN_PREDICATE=TRUE | |
| 9201 | 2010341 | Poor plan possible using Partition View with histogram statistics | |
| 9201 | 2057888 | Dump possible if AND_EQUAL hint has only one index listed | |
| 9201 | 2096698 | CBO may pick NL with FTS on right side when there is a better option | |
| 9201 | 2096753 | Estimated cardinality of a PHRASE text query is much too high | |
| 9201 | 2096777 | CBO may not choose functional invokation of DOMAIN INDEX functions | |
| 9201 | 2098120 | Transitive predicates may not be generated for outer joins | |
| 9201 | 2137509 | Dump possible in KKEPSL | |
| 9201 | 2139592 | CBO may choose bad plan (NL in place of SMJ) when PARTITION_VIEW_ENABLED=TRUE | |
| 9201 | 2147764 | Cardinality of 1 for text query with PHRASE containing STOP WORDS | |
| 9201 | 2148391 | CBO may choose a bad plan if ORDER BY contains a virtual column | |
| 9201 | 2155728 | SUBQUERY UNNESTING can lead to NON-MERGABLE views | |
| 9201 | 2179389 | NOT EXISTS may produce a slow anti-join plan | |
| 9201 | 2179497 | Cardinality for ROWID predicates is incorrect | |
| 9201 | 2186975 | Low CONTAINS() function cost if DB_BLOCK_SIZE>2K can lead to non-DOMAIN INDEX access path | |
| 9201 | 2222773 | Over-estimation of GROUP BY cardinality for INLIST column - can lead to bad plan | |
| 9201 | 2245790 | Parse may appear to spin (in kkquccae/kkquwhr) | |
| 9201 | 2248904 | Memory corrupt possible during optimization of distributed query | |
| Oracle Label Security | 9201 | 1831783 | ORA-12443 from disable / enable of a policy on a schema |
| 9201 | 1855568 | Disabled POLICIES are not caches properly on startup giving false ORA-12416 | |
| 9201 | 1897345 | Dump accessing OLS labels after proxy authentication | |
| 9201 | 1949851 | ORA-7445[zllcstda] accessing tables with security labels through Proxy Authentication | |
| 9201 | 1995514 | SA_USER_ADMIN.SET_USER_LABEL allows default row label to dominate the default label | |
| 9201 | 2060263 | SA_USER_ADMIN.SET_DEFAULT_LABEL() method does not reset DEFAULT_ROW_LABEL property | |
| 9201 | 2101173 | Dropping an OLS policy on a table with an active transaction prevents logins | |
| 9201 | 2101355 | Policy names which are 30 characters long are unusable (ORA-12446) | |
| 9201 | 2149694 | False ORA-28117 possible from referential constraint if parent has fine grained security policy | |
| 9201 | 2149987 | Some OLS SYNONYMS are not setup correctly | |
| 9201 | 2149996 | Incorrect OLS errors setting compartments/groups before levels | |
| Oracle Names | 9201 | 855400 | Names cache is never checkpointed |
| Oracle Text (formerly interMedia Text) | 9201 | 1272708 | Wrong results from Stemming with accented characters when text index has BASE_LETTER preference |
| 9201 | 1416954 | INSO_FILTER can use strange characters in place of double quotes in WORD documents | |
| 9201 | 1417113 | CHARSET Filter does not index all documents if there is a NULL in the indexed column | |
| 9201 | 1417233 | DRG-10599 possible using CONTAINS with an OUTER JOIN | |
| 9201 | 1514175 | INSO_FILTER may hang/spin/dump filtering certain WORD documents | |
| 9201 | 1622287 | INSO_FILTER can fail to filter certain Microsoft Word documents | |
| 9201 | 1649834 | Non-deterministic output from CTX_DOC.THEMES for documents with no tokens | |
| 9201 | 1695046 | ITEXT: Incorrect results possible using PERIOD (.) as a PRINTJOIN | |
| 9201 | 1701374 | WinNT: Indexing with URL_DATASTORE on Windows leaks sockets - can appear to hang | |
| 9201 | 1707340 | "FULL_THEMES" parameter affects output Weights in CTX_DOC.THEMES | |
| 9201 | 1710157 | ORA-1000 / OERI:QXIMCOC4 from ORed CONTAINS clauses using SCOREs | |
| 9201 | 1731490 | ITEXT: OERI:KGHFRF1 possible from multiple Text index DDL operations in same session | |
| 9201 | 1746462 | Indexing a table with many NULL values and low index memory may be very slow | |
| 9201 | 1762455 | Cannot text index URLs over 256 characters long using URL_DATASTORE | |
| 9201 | 1772810 | JAPANESE lexer may leak private memory | |
| 9201 | 1774791 | ORA-1480 occurs when indexing UTF8 data by Japanese VGRAM lexer | |
| 9201 | 1776022 | ORA-02291 can occur when creating a relation with CTX_THES package | |
| 9201 | 1777186 | INSO_FILTER cannot filter some Japanese Microsoft Powerpoint documents | |
| 9201 | 1777333 | INSO_FILTER on Japanese PDF document may produce corrupt output | |
| 9201 | 1784333 | ITEXT: "KOC KOCDS" memory leak | |
| 9201 | 1784337 | ITEXT: "KOL VARRAY" memory leak | |
| 9201 | 1785216 | Using MATCHES with CLOB parameter on multibyte charset dumps | |
| 9201 | 1787245 | CTX_DOC.MARKUP using PATH_SECTION_GROUP may dump for XML document with attribute sections | |
| 9201 | 1787575 | Dump in drexqrprs possible using CTXRULE CLOB api in multibyte | |
| 9201 | 1789212 | Wrong results from interMedia WITHIN queries on XML documents in Multibyte | |
| 9201 | 1789667 | INSO_FILTER output may be corrupt for certain character sets / platforms | |
| 9201 | 1794996 | Cannot create a text index on a table with RLS (DBMS_RLS.ADD_POLICY) (ORA-1031) | |
| 9201 | 1797677 | Trusted callouts may leak memory when invoked from PLSQL (affects Oracle Text) | |
| 9201 | 1808727 | ALTERNATE_SPELLING & COMPOSITE preferences may not find all token occurrences | |
| 9201 | 1819825 | INSO_FILTER TIMEOUT defaults to 0 rather than 120 | |
| 9201 | 1827674 | INSO_FILTER fails to filter specific Microsoft Word documents (DRG-11207) | |
| 9201 | 1833641 | CTX_DOC.HIGHLIGHT may return the wrong offset using Japanese Lexer | |
| 9201 | 1840606 | Text indexing PDF files is slow (compared to 8i) | |
| 9201 | 1842817 | CREATE TEXT INDEX may dump on UTF8 with PATH_SECTION_GROUP/AUTO_SECTION_GROUP | |
| 9201 | 1844732 | Dump possible (QXOPQXEX) using CONTAINS on XMLTYPE column | |
| 9201 | 1846487 | MASTER-DETAIL DATASTORE with BINARY=NO may corrupt text at buffer boundaries | |
| 9201 | 1847653 | Create / Sync of a URL datastore index leaks memory / OERI:kghfrf1 | |
| 9201 | 1850374 | SYNC_INDEX on Shared Server (MTS) can corrupt memory | |
| 9201 | 1852436 | Text index on LONG column may index incorrect tokens | |
| 9201 | 1854248 | INSO_FILTER sometimes garbles Turkish characters in PDF documents | |
| 9201 | 1878160 | ITEXT: Missing results possible from wild card section search (X% WITHIN section) | |
| 9201 | 1880469 | Markup using CHINESE_VGRAM_LEXER may produce incorrect markup | |
| 9201 | 1890968 | CREATE text index may dump for tokens > 64 bytes long after alternate spelling expansion | |
| 9201 | 1895490 | CHINESE LEXER incurs a memory leak per document | |
| 9201 | 1906797 | Long running SYNC may dump (in lxscop/drsxsqr) | |
| 9201 | 1911882 | CTX_DOC.MARKUP on variable width charset DB (eg: UTF8) may dump | |
| 9201 | 1953964 | ITEXT: Wrong results possible with alternate spelling for phrases with accented chars | |
| 9201 | 1955568 | Full OPTIMIZE may fail with DRG-50608 | |
| 9201 | 1961451 | CATSEARCH with 2 phrases gives incorrect results | |
| 9201 | 1977071 | TEXT: ALTERNATE_SPELLING and BASE_LETTER lexer preference can give wrong results | |
| 9201 | 1978117 | CTXKBTC dumps when a phrase in thesaurus already exists in the knowledge base | |
| 9201 | 1987692 | Creation of interMedia Text index can use excessive CPU | |
| 9201 | 1989120 | OERI:QEROIFIRSTPART2 from UNION ALL of tables with DOMAIN INDEXES on them (affects Oracle Text) | |
| 9201 | 1995294 | Wildcard text queries very slow with function based index on $I table | |
| 9201 | 2003476 | OERI:KSKBIND1 possible using Resource Manager, MTS and trusted callouts (eg: Oracle Text) | |
| 9201 | 2021043 | FULL optimize on index with PATH_SECTION_GROUP may fail with DRG-50608 | |
| 9201 | 2024128 | Wrong results from FIRST_ROWS with Oracle Text query and BITMAP operation | |
| 9201 | 2052473 | DRJOBDML.SQL is missing a COMMIT causing the DBMS_JOB not to run | |
| 9201 | 2054163 | Dump (in qcopgcty) from ANALYZE of text indexed XMLTYPE column | |
| 9201 | 2070377 | Text queries using ABOUT and ctx_doc.themes() with THEME_LANGUAGE=FRENCH miss some themes | |
| 9201 | 2077438 | Oracle Text "field section" searches (WITHIN) always return cardinality 1 to CBO | |
| 9201 | 2079575 | Large PGA memory leak possible creating TEXT index | |
| 9201 | 2084597 | UGA memory leak possible using Oracle Text CONTAINS() operator | |
| 9201 | 2088609 | INSO_FILTER cannot filter some PDF documents | |
| 9201 | 2096436 | CONTAINS('HASPATH ..' query can dump in DRYUEW | |
| 9201 | 2096753 | Estimated cardinality of a PHRASE text query is much too high | |
| 9201 | 2096777 | CBO may not choose functional invokation of DOMAIN INDEX functions | |
| 9201 | 2100695 | Missing results using CONTAINS INPATH on XML with nested elements of same name | |
| 9201 | 2110339 | Incorrect results from ABOUT operator in CTX_DOC.MARKUP | |
| 9201 | 2115494 | Phrase search using nested WITHIN on XML document can return false hits | |
| 9201 | 2141807 | TEMPORARY LOB leak - affects Oracle Text | |
| 9201 | 2145004 | CTX_DOC.HIGHLIGHT() may spin highlighting a nested WITHIN text query | |
| 9201 | 2147764 | Cardinality of 1 for text query with PHRASE containing STOP WORDS | |
| 9201 | 2150312 | OERI:7001 on FULL optimize of index with PREFIX indexing and field/attribute sections | |
| 9201 | 2163874 | DRG-10836 occurs creating CTXRULE index on nested WITHIN query | |
| 9201 | 2163879 | Setting visible flag to FALSE does not affect MATCHES search CTXRULE index | |
| 9201 | 2165690 | Dump possible creating Text index | |
| 9201 | 2167018 | "drdefpt" contains two incorrect Portuguese stopwords | |
| 9201 | 2181296 | Text CONTAINS() queries may dump if database is upgraded from 32 to 64 bit | |
| 9201 | 2186366 | INSO_FILTER may fail to filter large PDF documents | |
| 9201 | 2186975 | Low CONTAINS() function cost if DB_BLOCK_SIZE>2K can lead to non-DOMAIN INDEX access path | |
| 9201 | 2205449 | Sync / Create Text index on multibyte database may dump | |
| 9201 | 2205749 | JAPANESE_LEXER does not convert multibyte lowercase to upper case | |
| 9201 | 2208113 | Dump / memory corruption possible using USER FILTER for 10K document | |
| 9201 | 2213345 | ORA-600 [koksghds1] creating Text index on DETAIL_DATASTORE with XMLTYPE text column | |
| 9201 | 2215898 | Creation of Text index on STANDARD EDITION with no storage clause fails | |
| 9201 | 2221598 | LONG columns values may not Text index correctly | |
| 9201 | 2229432 | No error logged if INSO_FILTER times out (certain platforms) | |
| PL/SQL | 9201 | 1927642+ | DROP TABLE can hang if PLSQL block access that table over a DB link (9i<->8i) |
| 9201 | 2124536+ | PLSQL CURSOR over DBLINK uses first BIND value each execution of the cursor | |
| 9201 | 2195963+ | SQL in Invokers Rights PLSQL may run in wrong schema if CURRENT_SCHEMA is changed | |
| 9201 | 340156 | DROP TABLE in dynamic PLSQL does not free space until PLSQL call finishes | |
| 9201 | 937156 | PLS-801 [22016] / [22052] possible from invalid TABLE() clause in PLSQL | |
| 9201 | 1227266 | Wrong results possible in PLSQL using uninitialized BINDS in SQL | |
| 9201 | 1340394 | PLSQL BULK collect of REFs can dump (in kpcocrpc) | |
| 9201 | 1378317 | Dynamic SQL RETURNING INTO clause ignores CONSTRAINTS on the Bind variables | |
| 9201 | 1402425 | Passing an oversized parameter to a %TYPE formal parameter may dump / ORA-600 | |
| 9201 | 1534197 | OERI:15212 from EXECUTE IMMEDIATE with binds but no USING clause | |
| 9201 | 1542218 | Heap corruption (OERI:17182/dump in kghfrf) using very large collections | |
| 9201 | 1584970 | OERI:[PFRI.C:KGI_SRCTX] using PRAGMA SERIALLY_REUSABLE and package variables | |
| 9201 | 1698784 | False ORA-980 if PLSQL references a SYNONYM pointing to a REMOTE PUBLIC SYNONYM | |
| 9201 | 1732626 | ENH: Reduce INVALIDATIONS and recompilations required when installing patch sets | |
| 9201 | 1742457 | PLS-103 as PLSQL treats certain words as RESERVED words instead of keywords | |
| 9201 | 1747011 | Mem leak / ORA-4030 binding repeatedly in a PLSQL loop | |
| 9201 | 1776037 | PLS-801 [1002] possible compiling large SQL statements (>=2048) in PLSQL | |
| 9201 | 1790922 | ORA-7445 [PEVM_NCAL] possible after recompile of natively compiled PLSQL | |
| 9201 | 1797677 | Trusted callouts may leak memory when invoked from PLSQL (affects Oracle Text) | |
| 9201 | 1802230 | OERI:KOHRSC153 / OERI:KOHRSC154 using PLSQL with bind variables | |
| 9201 | 1809728 | False PLS-452 possible | |
| 9201 | 1819585 | ALTER PACKAGE .. COMPILE may hang for 8/8i client to 9i server | |
| 9201 | 1826681 | FORMS4W, FORMS40 and FORMS_OLE packages may not compile | |
| 9201 | 1826819 | PLS-801 [82605] possible using REF CURSOR RPC parameter in UPI mode (FORMS) | |
| 9201 | 1833961 | OUT only PLSQL parameters can cause hang/error when passed using associative notation | |
| 9201 | 1853375 | UTLRP in PERSONAL Edition gives ORA-1403 | |
| 9201 | 1859620 | DEMO_PLSQL.MK is incorrect on some platforms | |
| 9201 | 1883649 | Dump / ORA-22806 / OERI:15212 from WHERE :bind IN ( subquery ) | |
| 9201 | 1892192 | DBMS_DEBUG.DEBUG_ON immediate parameter does not work | |
| 9201 | 1901453 | PQ from within a PLSQL exception handler resignals original exception | |
| 9201 | 1903656 | PLSQL may produce incorrect results when running PQ with bind variables | |
| 9201 | 1930275 | Client side PLSQL may dump using Objects in UPI mode | |
| 9201 | 1947974 | False ORA-1008 possible using EXECUTE IMMEDIATE with CURSOR_SHARING=SIMILAR | |
| 9201 | 1960839 | OCIbreak()/Ctrl-C does not cancel out of PLSQL when using IN BAND breaks | |
| 9201 | 1964387 | OERI:17274 possible on statements after package recompiled | |
| 9201 | 1966518 | PLSQL LENGTH() function returns incorrect value for strings containing CHR(0) | |
| 9201 | 1970507 | OERI:QCTCTEL / OERI:18096 from OUTER JOIN in MERGE USING clause in PLSQL | |
| 9201 | 1978040 | Operations from PLSQL over DBLINK to 8i may dump (ORA-7445) in KGLOBLD | |
| 9201 | 1978190 | TIME, TIMESTAMP and INTERVAL arguments do not constraint actual string parameter values | |
| 9201 | 1980308 | Cannot assign values to TIMESTAMP columns in BEFORE triggers | |
| 9201 | 1987654 | Compiling a PLSQL block with an INDICATOR clause can corrupt memory | |
| 9201 | 1995907 | False PLS-306 possible from overloaded function/procedure | |
| 9201 | 2004646 | Conversion between RAW and LONG not done correctly in PLSQL | |
| 9201 | 2012348 | SQL%BULK_ROWCOUNT may be incorrect when not using SAVE EXCEPTIONS | |
| 9201 | 2014879 | CREATE or REPLACE of INVALID object should not INVALIDATE dependents | |
| 9201 | 2015342 | ALTER SESSION SET CURRENT_SCHEMA may not work in definers rights procedure | |
| 9201 | 2059647 | Dump (in pfrins) possible if SQL strings in PLSQL stored objects are specific sizes | |
| 9201 | 2098083 | TRACEDEMO.SQL uses CONNECT INTERNAL | |
| 9201 | 2108733 | Wrapped PLSQL may not signal an error during compilation when it should | |
| 9201 | 2114383 | Dump in PEPLMUFC_UNREG_FROM_CLEANUP using SERIAL REUSABLE packages compiled NATIVE | |
| 9201 | 2114777 | LPAD/RPAD in PLSQL with length > 65535 pad to the wrong length | |
| 9201 | 2116362 | Bind information passed to the server on each execute in UPI mode | |
| 9201 | 2125563 | PLS-00631 not generated on some platforms when expected | |
| 9201 | 2133014 | OERI:qcsrwae1 possible from "<plsql expression> BETWEEN col1 and col2" in PLSQL | |
| 9201 | 2171214 | Dump in xtyTabFunAddOrd() possible passing too few select columns to REF parameter in PLSQL | |
| 9201 | 2180094 | ORA-1401 possible during CREATE PACKAGE / PROCEDURE | |
| 9201 | 2212979 | Dump in PLSQL referencing a TABLE.COLLECTION.METHOD outside of SQL | |
| 9201 | 2216092 | False ORA-6502 passing RAW actual to VARCHAR2/LONG OUT/IN OUT formal parameter | |
| 9201 | 2216344 | False ORA-6502 possible using PIPELINED function returning a TYPE in MULTIBYTE | |
| 9201 | 2222081 | Exceeding OPEN_CURSORS in dynamic SQL (from PLSQL) may dump instead of ORA-1000 | |
| 9201 | 2231515 | DATA_LENGTH in ALL/USER_ARGUMENTS not shown for VARCHAR2 data in %TYPE parameters | |
| 9201 | 2251070 | USERENV('xxx') in PLSQL can return wrong value for 8 digits or more | |
| PL/SQL (DBMS Packages) | 9201 | 1532611 | DBMS_LDAP leaks private memory |
| 9201 | 1815150 | UTL_HTTP's timeout does not always wait for the full timeout duration | |
| 9201 | 1869025 | False timeouts possible from UTL_HTTP, UTL_SMTP, UTL_TCP, etc... | |
| 9201 | 1895615 | UTL_TCP.CLOSE_CONNECTION does not flush its output | |
| 9201 | 1913205 | Dump possible from UTL_HTTP Post with Chunked data encoding | |
| 9201 | 1940915 | ORA-1401 from STATPACK.SNAP in multibyte environment | |
| 9201 | 1969411 | ORA-6502 instead of ORU-10028 possible for large strings passed to DBMS_OUTPUT.PUT_LINE | |
| 9201 | 1977543 | Dump possible making HTTPS request with UTL_HTTP | |
| 9201 | 2096244 | "DBMS_SESSION.REINITIALIZE" can cause server side dumps | |
| 9201 | 2118808 | Memory corruption passing > 36 character schama.name to DBMS_REDEFINITION.START_REDEF_TABLE | |
| 9201 | 2171190 | UTL_ENCODE converts CR to LF and LF to CR characters | |
| PLSQL External Procedures (EXTPROC) | 9201 | 2140501 | Passing PLSQL collection to EXTPROC dumps rather than signalling an error |
| Parallel Query (PQO) | 9201 | 681179 | Parallel TO_LOB(LONG) may dump |
| 9201 | 1020403 | ORA-29900 possible from PQ using extensible ANCILLARY-PRIMARY operators | |
| 9201 | 1149123 | If SESSIONS_PER_USER is limited PQ slaves dump ORA-2391 trace files | |
| 9201 | 1387406 | Partition elimination may not occur for Nested Loops join in Parallel | |
| 9201 | 1622924 | PDML Update SET=(subquery) may set data to NULL | |
| 9201 | 1685119 | OERI:KCBLIBR_USER_FOU / hang when interrupt (Ctrl-C) of PQ using STAR_TRANSFORMATION | |
| 9201 | 1700705 | Partition elimination may not occur in PQO with single row subquery again the partition key | |
| 9201 | 1711227 | OERI:[QKAGBY0.4] DOING SELECT WITH DEGREE > 1 AND GROUP BY | |
| 9201 | 1722308 | OERI:XTYCSR2 possible on PQO nested loops of subqueries with local part index | |
| 9201 | 1731165 | Parallel Nested Loops Semi/Anti join may give wrong results | |
| 9201 | 1741117 | PDML to bitmap key of a partition table with row movement hangs | |
| 9201 | 1746797 | Wrong results possible from PQ with SET operations in correlated subquery | |
| 9201 | 1759227 | PQ may return wrong results selecting a COUNT(aggregate) column from a view | |
| 9201 | 1793533 | Wrong results possible from PQO with GROUP BY (affected by SORT_AREA_SIZE) | |
| 9201 | 1805863 | Incorrect results for PQ with multiple INV. DIS functions | |
| 9201 | 1812115 | Internode Parallel Query may be slow | |
| 9201 | 1832457 | Wrong results possible from PQ INDEX_FFS of global partitioned index with Nested Loops | |
| 9201 | 1844776 | PQ slave may die (in kkpamHRGet) with GROUP BY on composite partitioned table | |
| 9201 | 1865075 | Unexpected ORA-01438 possible from PQ slave | |
| 9201 | 1867959 | PARALLEL clause ignored for CTAS of IOT with NOT NULL constraints | |
| 9201 | 1869511 | OERI:QERTQTABLEALLOCA possible from PQ on READ-ONLY database | |
| 9201 | 1906596 | PQ may hang when query involves ORDER BY, SUBQUERY and UNION-ALL | |
| 9201 | 1931510 | Corrupt data possible from PDML on IOT with column reordering | |
| 9201 | 1934327 | SIGFPE possible from Parallel Query | |
| 9201 | 1935292 | OERI:KCBGTCR_12 etc.. doing STAR QUERY with TEMP TABLE TRANSFORMATION in IPQ | |
| 9201 | 1941435 | Dump in MSQOPNWS possible from SELECT DISTINCT in parallel | |
| 9201 | 1964948 | Parallel DDL can have detrimental effect on performance (reduced data clustering) | |
| 9201 | 1976615 | OERI:15212 possible creating FUNCTION BASED index in PARALLEL | |
| 9201 | 1992414 | ORA-12801 / ORA-932 possible from PQ referencing a colunn with a DESCENDING index | |
| 9201 | 1993268 | Unnecessary temp table buffer cache flushing with PQO | |
| 9201 | 2002197 | OERI:KCBZPB_1 possible in PQ slave | |
| 9201 | 2004590 | OERI:rworupo.1 from Concatenation of ROLLUP with MAX/MIN aggregate in PQ | |
| 9201 | 2032196 | Wrong results possible using TIMESTAMP column predicate in Parallel Query | |
| 9201 | 2052936 | ORA-1418 possible from PQ slave for table with DOMAIN index | |
| 9201 | 2094996 | OERI:KXFREXTINFO2 possible from PQ against table in locally managed tablespace | |
| 9201 | 2097719 | ORA-01799 possible from PQ of STAR TRANSFORMED query block with an outer join | |
| 9201 | 2101576 | ORA-600 [KKDCACR2] possible from PDML with CHECK CONSTRAINTS | |
| 9201 | 2105419 | ORA-8103 possible from PQ on bitmap managed segments with concurrent inserts | |
| 9201 | 2131767 | Parallel create of FUNCTIONAL INDEX on PARTITION table can product corrupt index (ORA-8102) | |
| 9201 | 2165200 | Query portion of INSERT .. SELECT containing a set operator does not run in PARALLEL | |
| 9201 | 2168107 | OERI:15819 possible from PQ query with NL join of views | |
| Partition Views (PV) | 9201 | 1764305 | ORA-7445 in KKECCF from SELECT or ANALYZE of a partitioned table or view |
| 9201 | 1844545 | Partition View not recognised is base table columns are UNUSED or have FUNCTIONAL INDEX | |
| 9201 | 1869512 | Dump possible (in kkeccf) selecting from Partitioned Views OR Tables | |
| 9201 | 2010341 | Poor plan possible using Partition View with histogram statistics | |
| 9201 | 2114246 | Memory leak and long parse time for Part View with INLIST bitmap predicates | |
| 9201 | 2194204 | Partition Views do not support functional indexes | |
| Partitioned Tables | 9201 | 1216223 | MAXVALUE keyword HIGH_VALUE column of DBA_TAB_PARTTIONS is not capitalized |
| 9201 | 1273906 | OERI:12628 / ORA-2149 / Corrupt dictionary from DDL on PARTITIONED table via a synonym | |
| 9201 | 1387406 | Partition elimination may not occur for Nested Loops join in Parallel | |
| 9201 | 1700705 | Partition elimination may not occur in PQO with single row subquery again the partition key | |
| 9201 | 1722308 | OERI:XTYCSR2 possible on PQO nested loops of subqueries with local part index | |
| 9201 | 1741117 | PDML to bitmap key of a partition table with row movement hangs | |
| 9201 | 1764305 | ORA-7445 in KKECCF from SELECT or ANALYZE of a partitioned table or view | |
| 9201 | 1801171 | Dump possible from INLIST on range/list partition column if no matching partition exists | |
| 9201 | 1832457 | Wrong results possible from PQ INDEX_FFS of global partitioned index with Nested Loops | |
| 9201 | 1834530 | OERI:25012 / wrong results after EXCHANGE PARTITION with indexes with different FREELIST /FREELIST GROUPS | |
| 9201 | 1837529 | OERI:KFTR2BZ_1/OERI:25012 from CREATE sub-partitioned local INDEX ONLINE | |
| 9201 | 1844776 | PQ slave may die (in kkpamHRGet) with GROUP BY on composite partitioned table | |
| 9201 | 1869512 | Dump possible (in kkeccf) selecting from Partitioned Views OR Tables | |
| 9201 | 1873616 | ENH: Allow descending partition scan for ORDER BY | |
| 9201 | 1890073 | ALTER INDEX REBUILD with PCTFREE on HASH [sub]partition should signal ORA-14185 | |
| 9201 | 1906189 | ORA-7445 [KKDCACR] possible from DML on table with locally partitioned DOMAIN index | |
| 9201 | 1912886 | Partition SPLIT can take a long time for low partition keys with many partitions | |
| 9201 | 1913372 | OERI:KAUUPD:2 possible from PARTITIONED table update with row movement enabled | |
| 9201 | 1964879 | OERI:ATBACE0 from ALTER TABLE EXCHANGE PARTITION between COMPOSITE and HASH partitioned tables | |
| 9201 | 1964948 | Parallel DDL can have detrimental effect on performance (reduced data clustering) | |
| 9201 | 1975902 | Failed DIRECT load into a composite partitioned table leaves unexpected ROWS inserted | |
| 9201 | 1987514 | Rebuild partitioned functional index performs full table scan | |
| 9201 | 2006940 | Partition pruning ignores predicates at individual nodes of a BITMAP tree | |
| 9201 | 2019981 | Poor plan possible for queries with joins to partitioned tables | |
| 9201 | 2058987 | OERI:SRSGET_1 possible for query against partitioned table | |
| 9201 | 2089034 | Export / Import of composite partitioned table looses SUBPARTITIONS clause | |
| 9201 | 2093328 | EXP-56 / ORA-1406 exporting partitioned table with default values > 2000 bytes | |
| 9201 | 2104034 | Missing rows possible from multi-column INLIST containing partition key | |
| 9201 | 2110573 | ORA-439 attempting to IMPORT partitioned table into non-partitioned table without PARTIONING option | |
| 9201 | 2121887 | ORA-7445 [KKEHSL] possible with GLOBAL PARTITIONED INDEX and COLUMN HISTOGRAMS | |
| 9201 | 2131767 | Parallel create of FUNCTIONAL INDEX on PARTITION table can product corrupt index (ORA-8102) | |
| 9201 | 2141535 | ORA-604/ORA-942 possible from query against partitioned table | |
| 9201 | 2162632 | ORA-7445 from concurrent ANALYZE .. STATISTICS / CREATE INDEX against partitioned table | |
| 9201 | 2199391 | ADD/SPLIT [SUB]PARTITION can result in LOB partition in wrong tablespace | |
| 9201 | 2206492 | ORA-1502 possible for ALTER TABLE MODIFY PARTITION for list/composite list partitioned table | |
| Performance | 9201 | 1238084 | Pro/OCI clients single row select may use more server CPU than < 8.1 |
| 9201 | 1396578 | ""% Non-Parse CPU" shows the wrong value in STATSPACK output | |
| 9201 | 1647363 | Enhancement to reduce contention on ROW CACHE OBJECTS latch | |
| 9201 | 1662642 | DROP (non unique) INDEX invalidates views which depend on the affected base table | |
| 9201 | 1745591 | ENH: Improved speed when using the GROUPING_ID function | |
| 9201 | 1746462 | Indexing a table with many NULL values and low index memory may be very slow | |
| 9201 | 1749606 | ENH: Enhancements to subquery unnesting to improve performance | |
| 9201 | 1810131 | ENH: Parallel version of UTLRP.SQL (utlrcmp) | |
| 9201 | 1819214 | Reduce latch hold time for "row cache objects" latch | |
| 9201 | 1840606 | Text indexing PDF files is slow (compared to 8i) | |
| 9201 | 1847782 | Contention for the "longop free list" latch | |
| 9201 | 1865917 | ORA-4031 / high CPU from OR expansion of negated predicates with RBO | |
| 9201 | 1885959 | Refined version of fix for Bug:1410679 | |
| 9201 | 1886884 | Insert performance degrades with long master freelists | |
| 9201 | 1895220 | More physical reads per transaction than in single instance mode | |
| 9201 | 1967363 | Increased index block gets / "cache buffer chains" contention in 8i/9i | |
| 9201 | 1978514 | TKPROF reports ORA-439 on EXPLAIN of statements with a RETURNING clause | |
| 9201 | 1985605 | GRANT operations can be very slow (compared to Oracle7) | |
| 9201 | 1987692 | Creation of interMedia Text index can use excessive CPU | |
| 9201 | 2012482 | ENH: Faster GROUP BY for multi-column GROUP BY clauses | |
| 9201 | 2041699 | Child library cache latch contention using PLSQL functions in large selects | |
| 9201 | 2073194 | V$FILESTAT.READTIM / WRITETIM not maintained for files in TEMPORARY tables | |
| 9201 | 2079526 | "free buffer waits" / LRU latch contention possible on write intensive systems | |
| 9201 | 2123080 | Sessions may wait longer than needed for CI-14-5 (release unused sort segment space) | |
| 9201 | 2143634 | Statspack does not class "QUEUE MESSAGE" as an IDLE wait event | |
| 9201 | 2161961 | TKPROF sorts incorrectly using the sort=... command line parameter | |
| 9201 | 2209891 | Multi-table direct load can be slow (compared to Oracle8) | |
| Pro* Precompiler | 9201 | 1818530+ | Applications using non-array EXEC SQL OPEN / FETCH may dump |
| 9201 | 753989 | ProCobol: EXEC SQL INCLUDE before WORKING-STORAGE SECTION generated bad code | |
| 9201 | 954153 | SQLCODE may have wrong error if declared outside DECLARE SECTION | |
| 9201 | 1238084 | Pro/OCI clients single row select may use more server CPU than < 8.1 | |
| 9201 | 1399147 | Semantic error for PLSQL indexed table method when Precompiler connects to higher version DB | |
| 9201 | 1715819 | PARSE=PARTIAL cannot handle trigraph directives (eg: ??=define) | |
| 9201 | 1748759 | Client memory corruption / dump (eg: in ttcfopr) using pre-fetch | |
| 9201 | 1754786 | Pro/OCI DML RETURNING an ARRAY of LOB Locators dumps in TTCLD2I | |
| 9201 | 1781184 | Implicit cursors using a remote table may cause XA error 100 | |
| 9201 | 1885959 | Refined version of fix for Bug:1410679 | |
| 9201 | 1894578 | EXEC SQL DESCRIBE from 8i client to 9i server may return no information | |
| 9201 | 1949580 | ProCobol: Bad code generated if EXEC CICS / EXEC DCSQL omits ending period (.) | |
| 9201 | 1978606 | OCIStmtExecute() does not error for invalid statement handle - affects ProC | |
| 9201 | 1980047 | ProC may dump when using VALUE semantics with ANSI dynamic SQL | |
| 9201 | 1985041 | ProCobol files precompiled after 09/Sep/2001 may not compile on some platforms | |
| 9201 | 2021052 | ProCobol: DESCRIBE BIND VARIABLES may dump / hang / signal ORA-2111 | |
| 9201 | 2023714 | ORA-24374 possible using 9i client against 8i server | |
| 9201 | 2052584 | XA with SQLLIB (Pro) in a DLL may error if the DLL is unloaded before ending the transaction | |
| 9201 | 2083243 | Pro client dump allocating a descriptor if database is shutdown / restarted | |
| 9201 | 2093408 | PCC-S-2201 trying to precompile "CASE WHEN" or "FOR UPDATE .. WAIT" clauses | |
| 9201 | 2093437 | "UPDATE OF ... WAIT" causes a precompiler error (PCC-S-02201) | |
| 9201 | 2152876 | Array insert may be slow with multibyte characterset (affects ProCobol PICX=VARCHAR2) | |
| 9201 | 2158504 | Precompiler cannot open INCLUDE files with spaces in the configuration file | |
| 9201 | 2181813 | PROCOBOL writes calls to SQLSTRD in double quotes | |
| Query Rewrite (including Materialized Views) | 9201 | 1951578+ | Wrong results from Query Rewrite with date folding on dates with TIME values |
| 9201 | 1492527 | ORA-904 creating object-relational MV if WHERE has dotted column name | |
| 9201 | 1664189 | Query rewrite does not occur if base table has a FUNCTIONAL index on it | |
| 9201 | 1794683 | OERI:kkzugekdl:1 possible during import of MV log / snapshot log | |
| 9201 | 1839705 | Query rewrite may not occur when using non-trivial analytics | |
| 9201 | 1865755 | MV Refresh may dump in kkzgeuti_pred | |
| 9201 | 1866481 | Query rewrite may produce the wrong plan on some platforms | |
| 9201 | 1873265 | SELECT COUNT(*) with QUERY_REWRITE and empty MV returns NULL instead of 0 | |
| 9201 | 1898834 | Query rewrite may give incorrect results for outer joins | |
| 9201 | 1912308 | Concurrent MV complete refresh may cause a deadlock | |
| 9201 | 1918207 | Create MVIEW against pre-9i release gives wrong column lengths in multibyte | |
| 9201 | 1978077 | Memory corruption during QUERY REWRITE if select list has operator on top of aggregate | |
| 9201 | 1990082 | Create MVIEW on a query with a RANK function and a PARTITION clause spins | |
| 9201 | 2012448 | Improve query rewrite support for multiple hierarchies | |
| 9201 | 2018031 | ORA-955 possible on create Materialized View | |
| 9201 | 2041981 | ORA-30353 creating an MVIEW with a CAST operator in the select list | |
| 9201 | 2047492 | Materialized view refresh in parallel can fail with ORA-12838 | |
| 9201 | 2062029 | Multi-hierarchy MV create may dump | |
| 9201 | 2090725 | Unnecessary text based rewrite for UNION-ALL expanded query block (slow parse) | |
| 9201 | 2092554 | OERI:qctcte1 / ORA-979 from multi-hierarchy query using materialized view | |
| 9201 | 2097926 | Dump possible from query using Function based index with MVIEW and QUERY_REWRITE_INTEGRITY=TRUSTED | |
| 9201 | 2098080 | Query rewrite not performed ROLLUP required with WINDOW FUNCTION | |
| 9201 | 2117417 | Query rewrite does not occur if the query contains a GROUPING_ID function | |
| 9201 | 2131442 | ORA-1722 / strange errors if UNION REWRITE attempted but text would be > 64K | |
| 9201 | 2135945 | Query rewrite may not occur if DECODE used | |
| 9201 | 2184811 | MV rewrite with NULL/NOT NULL predicates may give incorrect results | |
| 9201 | 2263600 | Query may not rewrite when expected | |
| RAC (Real Application Clusters) | 9201 | 1888033+ | ARCH Archival of threads with same SEQ# may use wrong first/next SCN |
| 9201 | 2177181+ | Data corruption possible as RAC recovery can incorrectly decide no recovery is needed | |
| 9201 | 1413023 | OERI:[KJBRRCON:!SEND] possible | |
| 9201 | 1688500 | Prespawned servers crash when OPS is configured | |
| 9201 | 1739726 | OERI:[KJBRRCFWST:WIWR] and similar errors from LMON during reconfiguration | |
| 9201 | 1746869 | OERI:2103 possible during reconfiguration | |
| 9201 | 1771729 | OERI:[KJBMPASSUME:!RES] possible from reconfiguration | |
| 9201 | 1771750 | OERI:[KJBRPICKC:HP1] / lots of KJX_B_UPDMASTER messages | |
| 9201 | 1774085 | OERI:[KJBMPWR:4!RMD] possible in LMS process | |
| 9201 | 1795668 | ORA-328 on "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH" | |
| 9201 | 1795928 | OERI:KSIRES_1 possible if RFS process dies in RAC in Instant Protection Mode | |
| 9201 | 1806435 | Timeout for GLOBAL CACHE operations in RAC too short | |
| 9201 | 1812115 | Internode Parallel Query may be slow | |
| 9201 | 1815042 | Unnecessary hold of library cache latch in RAC or OPS environments | |
| 9201 | 1817589 | Sessions waiting on log flush events may wait longer than needed | |
| 9201 | 1827047 | Startup of multiple instances may hang | |
| 9201 | 1829370 | OERI:4415 possible using XA to OPS or RAC with DBLINKS | |
| 9201 | 1840929 | Buffer cache recovery may be delayed for 5 minutes during reconfiguration | |
| 9201 | 1856768 | ORA-600 [sigcomerr:!ctx] possible during database mount | |
| 9201 | 1857643 | PMON may die (in kjuef) if a user session is killed | |
| 9201 | 1867625 | Out of shared pool might cause OERI:[ksicget_3][KJUSERSTAT_NOSPACE]. | |
| 9201 | 1880815 | Speed up DMLs for objects using bitmap segments for RAC | |
| 9201 | 1890584 | OERI:[KZCKINI: NZDSI_INITIALIZE] possible starting RAC instance | |
| 9201 | 1891379 | "KCL FREELIST LATCH" latch contention under heavy load | |
| 9201 | 1891438 | Enhancement: Batch together remote messages when possible | |
| 9201 | 1891494 | ENH: Speed up instance & crash recovery for RAC | |
| 9201 | 1893205 | High CPU consumption by LMS process | |
| 9201 | 1895220 | More physical reads per transaction than in single instance mode | |
| 9201 | 1916409 | Hang possible in OPS due to expired timeout | |
| 9201 | 1925137 | LMS may dump in kclpbi() due to corrupt downconvert list | |
| 9201 | 1930501 | Foreground processes may spin / hold latch too long during instance recovery | |
| 9201 | 1935292 | OERI:KCBGTCR_12 etc.. doing STAR QUERY with TEMP TABLE TRANSFORMATION in IPQ | |
| 9201 | 1938745 | OERI:KCVGCF_01 possible from PQ on READ ONLY database | |
| 9201 | 1961484 | OERI:KCLRCLR_5 possible | |
| 9201 | 1965909 | ORA-4030 / PGA memory leak in LMS process leading to instance crash | |
| 9201 | 1966718 | Select of data after a node failure but before rollforward completes is slow | |
| 9201 | 1974816 | OERI:[kjblpwr:sc] possible after cluster reconfiguration | |
| 9201 | 1994886 | RAC load balancing does not work if a bunch of connect requests arrive together | |
| 9201 | 1998727 | OERI:[KJCCGMB:1] possible after reconfiguration | |
| 9201 | 2000029 | OERI:KCLCHKBLK_3 possible in RAC after reconfiguration | |
| 9201 | 2004227 | OERI:KCBKLLRBA_3 possible in CKPT in RAC | |
| 9201 | 2034093 | OERI:[KJBFLUSHCLAIM:!GMP] possible | |
| 9201 | 2034260 | Hang during startup after ticket starvation in LMON in RAC setup | |
| 9201 | 2064923 | RAC hang possible due to lock context leak filling the shared pool | |
| 9201 | 2065232 | RAC - Space in BITMAP managed segments freed in one instance not used in another instance | |
| 9201 | 2071313 | OERI:KSXPWAIT10 possible | |
| 9201 | 2099811 | LRM-00101 possible for <INSTANCE_NAME>.THREAD parameter | |
| 9201 | 2114262 | Sun: Real Application Cluster Guard fails on Sun cluster 3.0 | |
| 9201 | 2116883 | Row cache lock poll time too high in RAC / OPS environments | |
| 9201 | 2128016 | LMON may OERI:[KJRCHC:RESP] after shutdown of another instance | |
| 9201 | 2134254 | Connection load balancing does not work for DEDICATED connections | |
| 9201 | 2138185 | Timing window can lead to hang with global cache lock escalation | |
| 9201 | 2149535 | Instance may crash with OERI:KCLFLUSHED_1 | |
| 9201 | 2150609 | "ALTER SYSTEM SET parameter=value SID='*'" does not set value on all instances | |
| 9201 | 2151668 | OERI:[KJFCRFG:!QRY] during reconfiguration | |
| 9201 | 2152574 | Hang possible due to ungranted global cache S to X escalation | |
| 9201 | 2161450 | OERI:[KJBRCHKPI:PI2] possible | |
| 9201 | 2162644 | LMD process size increases gradually over time | |
| 9201 | 2169363 | ORA-1172 possible after instance is evicted from the cluster | |
| 9201 | 2177225 | Foreground may read a block from disk even though master has S locked block | |
| 9201 | 2183194 | PMON may not be able to cleanup dead session waiting on 'GLOBAL CACHE BUSY' | |
| 9201 | 2184879 | OERI:[KJBRCVT:!GR] possible | |
| 9201 | 2185142 | High number of posts from LMD to LMS | |
| 9201 | 2190654 | ORa-64 possible trying to set _LM_TICKETS to a large value | |
| 9201 | 2193404 | LMS may spin in kclpdcl() for a period of time | |
| 9201 | 2195051 | "GSD" process can be hard to find as "GSD" does not appear in the process name | |
| 9201 | 2195446 | LMS may use 100% CPU slowing the system | |
| 9201 | 2195525 | Dynamic resourece mastering is turned ON by default | |
| 9201 | 2215948 | OERI:[kjuinc:resp2inq] possible | |
| 9201 | 2244761 | ENH: More diagnostics required for stuck "GLOBAL CACHE S TO X" conversions | |
| 9201 | 2257703 | Hang possible during instance mount | |
| RMAN (Recovery Manager) | 9201 | 878554 | PLS-00553 possible from some RMAN operations if TARGET database not open |
| 9201 | 1530744 | RMAN may not recognise READ ONLY tablespace on restore after a RESETLOGS | |
| 9201 | 1803611 | RMAN-6056 possible on "BACKUP DATABASE" on duplicated database with READ ONLY tablespaces | |
| 9201 | 1819338 | "BACKUP ARCHIVELOG...DELETE INPUT" fails if single log cannot be deleted | |
| 9201 | 1821301 | RMAN backup to filesystem file is slow when using disk IO slaves | |
| 9201 | 1843698 | ORA-235 possible in RMAN | |
| 9201 | 1856783 | Errors possible from concurrent RESYNC operations against the same catalog | |
| 9201 | 1885412 | RMAN-600 internal error on STARTUP if SGA >= 4G | |
| 9201 | 1919567 | RMAN TSPITR fails if the tablespace name is an RMAN keyword (RMAN-600 [15120]) | |
| 9201 | 2038416 | RMAN may delete valid backup pieces if a backup fails / is aborted | |
| 9201 | 2068275 | RMAN VALIDATE...CHECK LOGICAL incorrectly reports block corruption (ORA-19661) | |
| 9201 | 2071872 | RMAN-20087 possible from RMAN RESYNC | |
| 9201 | 2095366 | BACKUP DATABASE fails if non-standard blocksize tablespace has been EXCLUDEd from backups | |
| 9201 | 2108357 | RMAN LIST wrongly shows INCREMENTAL LEVEL 0 backups as FULL backups1 | |
| 9201 | 2174697 | RMAN incremental backup performance degrades over time in NOCATALOG mode | |
| 9201 | 2312344 | RMAN does not create STANDBY REDO logs on standby when creating a standby database | |
| Replication | 9201 | 1816973+ | Complete Refresh of a READ ONLY table at middle tier deletes all rows table at the back end |
| 9201 | 1820082 | Mem Cor / Dump possible from DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT | |
| 9201 | 1836291 | RESUME_MASTER_ACTIVITY after RELOCATE_MASTERDEF fails with ORA-23419 | |
| 9201 | 1838006 | Incorrect UNIQUE conflict handling for NCHAR/NVARCHAR etc. | |
| 9201 | 1852241 | ORA-7445 [KKDLGOB] / Dump on CREATE SNAPSHOT/MVIEW with ROWID for remote table | |
| 9201 | 1892888 | ORA-6502 possible from SWITCH_SNAPSHOT_MASTER | |
| 9201 | 2031979 | OERI:KZASPS1 calling DBMS_REDEFINITION.START_REDEF_TABLE with AUDIT_TRAIL enabled | |
| 9201 | 2102779 | Query over DBLINK with DRIVING_SITE hint and BINDS can hang (affects snapshot refresh) | |
| 9201 | 2123221 | Snapshot refresh may not update CHAR columns in multibyte DB from singlebyte master | |
| Resource Leaks (eg: Memory Leak) | 9201 | 1532611 | DBMS_LDAP leaks private memory |
| 9201 | 1534867 | Unsuccessful JDBC OCI connect attempt leaks client memory | |
| 9201 | 1634098 | Using one QueueReceiver per dequeue operation leaks memory | |
| 9201 | 1674074 | Leak of "ktatt" memory chunks possible (OERI:729) on failed creation of a TEMP segment | |
| 9201 | 1701374 | WinNT: Indexing with URL_DATASTORE on Windows leaks sockets - can appear to hang | |
| 9201 | 1724964 | JDBC Thick Client Memory leak reusing statements which reference object types | |
| 9201 | 1743183 | Small memory leak in UGA when repeatedly using TEMP segments | |
| 9201 | 1747011 | Mem leak / ORA-4030 binding repeatedly in a PLSQL loop | |
| 9201 | 1764208 | SQLPLUS memory leak during DESCRIBE | |
| 9201 | 1772810 | JAPANESE lexer may leak private memory | |
| 9201 | 1775445 | Multi-threaded XA client which spawns threads which do xa_end(TMSUSPEND) leak memory | |
| 9201 | 1777022 | Statement duration memory may not be freed at the end of the statement | |
| 9201 | 1784333 | ITEXT: "KOC KOCDS" memory leak | |
| 9201 | 1784337 | ITEXT: "KOL VARRAY" memory leak | |
| 9201 | 1787503 | Cursor leak using OCIBreak/OCIReset in non-blocking mode | |
| 9201 | 1788529 | Memory leak per SET_CONTEXT for globally accessed contexts | |
| 9201 | 1797677 | Trusted callouts may leak memory when invoked from PLSQL (affects Oracle Text) | |
| 9201 | 1808525 | Excessive memory use by oracle.sql.NUMBER.toString() | |
| 9201 | 1808970 | WinNT: Multithreaded OCI/XA client memory leak | |
| 9201 | 1828225 | OCCI Cache size may be exceeded appearing as a memory leak | |
| 9201 | 1837850 | AQ of ADTs can leak TEMP lobs | |
| 9201 | 1839080 | Memory leak possible using HASH join (ORA-4030) | |
| 9201 | 1845953 | OCIRefFromHex can leak client side memory | |
| 9201 | 1847653 | Create / Sync of a URL datastore index leaks memory / OERI:kghfrf1 | |
| 9201 | 1891703 | ORA-4030/ memory growth from UPDATE .. SET=(subquery) with PLSQL function calls | |
| 9201 | 1895490 | CHINESE LEXER incurs a memory leak per document | |
| 9201 | 1900411 | Memory Leak for NTIER authentication sessions | |
| 9201 | 1939447 | TEMPLOB generated by xmltype.createXML() not freed until session ends | |
| 9201 | 1988305 | Memory leak (can affect MOD_OSSL) | |
| 9201 | 1992367 | Huge memory use from query with Nested Loops against DBA_FREE_SPACE | |
| 9201 | 2002214 | Excessive memory use / spin if PUSH_JOIN_PREDICATE=TRUE | |
| 9201 | 2013550 | Temp Lob leak on enqueue/dequeue of message with transformation function | |
| 9201 | 2064923 | RAC hang possible due to lock context leak filling the shared pool | |
| 9201 | 2079575 | Large PGA memory leak possible creating TEXT index | |
| 9201 | 2082790 | OCCI objects with string attributes can leak memory | |
| 9201 | 2084597 | UGA memory leak possible using Oracle Text CONTAINS() operator | |
| 9201 | 2086108 | TEMP LOB leak passing TEMP LOBS in recursive SQL ("lob ctl struct" grows) | |
| 9201 | 2086729 | Memory leak using JMS API to AQ | |
| 9201 | 2095029 | Memory leak / growth for some queries using repeatedly restarted index scans | |
| 9201 | 2095320 | Import memory leak importing BFILE data | |
| 9201 | 2096011 | XSL PROCESSOR and STYLESHEET hold onto references to input document elements (mem growth) | |
| 9201 | 2104071 | ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS) | |
| 9201 | 2114246 | Memory leak and long parse time for Part View with INLIST bitmap predicates | |
| 9201 | 2141807 | TEMPORARY LOB leak - affects Oracle Text | |
| 9201 | 2160558 | Repeated SELECT FOR UPDATE / COMMIT leaks client memory | |
| 9201 | 2162644 | LMD process size increases gradually over time | |
| 9201 | 2209289 | SMON may grow in size (memory leak) | |
| 9201 | 2218440 | Severe memory leak/growth using EXTERNAL tables. | |
| 9201 | 2223633 | JDBC may not remove metrics data (DMS) resulting in OutOfMemoryError | |
| 9201 | 2230365 | Memory leak possible using TABLE() clause | |
| 9201 | 2232456 | Memory leak in XDK | |
| 9201 | 2282158 | Large memory use possible for large XML documents (XMLParser) | |
| SQL*Loader | 9201 | 1950099+ | Function based index not updated after DIRECT LOAD |
| 9201 | 332285 | "ROWS LOADED" information may be wrong is SPACE errors occur during conventional LOAD | |
| 9201 | 1671668 | Direct LOAD with Primary Key constraint dumps in SOREND() if duplicate rows exist | |
| 9201 | 1796229 | Spin possible with shift sensitive charset using relative field positioning | |
| 9201 | 1834723 | Direct load of an Object (or REF) may signal OERI:6937 / OERI:kcblrr_1 | |
| 9201 | 1931093 | SQLLoader SKIP option with VAR file processing skips too many records | |
| 9201 | 1975902 | Failed DIRECT load into a composite partitioned table leaves unexpected ROWS inserted | |
| 9201 | 2018969 | Direct Load using ROWS option shows poor performance (compared to earlier releases) | |
| 9201 | 2053981 | LDR-510 error misleading if data is in the controlfile | |
| 9201 | 2055319 | Loader may report the wrong number of rows loaded if a space error occurs | |
| 9201 | 2076247 | Loader may load incorrect NUMBER values for PACKED DECIMAL data | |
| 9201 | 2114432 | OERI:6937 / LDR-961 / OERI:kcblrr_1 from DIRECT PATH load | |
| 9201 | 2151364 | DIRECT load of IOT can produce a corrupt IOT | |
| 9201 | 2165461 | Direct load to table with DESCENDING index may cause subsequent ORA-8102 errors | |
| 9201 | 2204819 | Loader OPTION with leading zeroes cause subsequent OPTIONS to be ignored | |
| 9201 | 2209891 | Multi-table direct load can be slow (compared to Oracle8) | |
| SQL*Plus | 9201 | 1275529 | DESCRIBE <table> shows NUMBER when FLOAT was used |
| 9201 | 1329845 | SET LINESIZE may dump SQLPLUS | |
| 9201 | 1397704 | SQLPLUS may dump executing SQL files with lines over 4096 characters long | |
| 9201 | 1479508 | SQLPLUS SP-0642 / Dump where schema.package_name over 30 characters | |
| 9201 | 1723633 | SQLPLUS may dump using the BREAK command | |
| 9201 | 1744175 | ENH: SP2-750 error is now reported if SQLPLUS fails to open the SP1 message file | |
| 9201 | 1751168 | CTRL-C does not cancel parallel recovery in SQLPLUS | |
| 9201 | 1754311 | SQLPLUS may dump executing SQL files with lines over 4096 characters long | |
| 9201 | 1764208 | SQLPLUS memory leak during DESCRIBE | |
| 9201 | 1777627 | SQLPLUS ORA-24327 connecting to remote DB connects to local DB | |
| 9201 | 1778036 | SQLPLUS may report ORA-1005 for invalid TNS ALIASes | |
| 9201 | 1815878 | SP2I message files missing some Italian messages | |
| 9201 | 1852419 | SQLPLUS cannot handle quoted passwords | |
| 9201 | 1887376 | SQLPLUS START command may garble a multibyte filename | |
| 9201 | 1903571 | SQLPLUS may dump if server connection dies | |
| 9201 | 1914259 | SQLPLUS: Setting NLS_DATE_FORMAT in ALTER SESSION within a function does not change the date format | |
| 9201 | 1925208 | SQLPLUS @SQLFILE fails on Windows platforms when path is longer than 80 characters | |
| 9201 | 1934520 | SQLPLUS silenty truncates SUBSTITUTION variables to 240 bytes long | |
| 9201 | 2015932 | AUTOTRACE EXPLAIN has incorrect indentation in HTML mode | |
| 9201 | 2026644 | SQLPLUYS may dump on SHOW ERRORS command | |
| 9201 | 2042623 | Invalid HTML possible from DESCRIBE of object types | |
| 9201 | 2058213 | iSqlplus output may be incorrectly spaced | |
| 9201 | 2115438 | SQLPLUS dumps on Windows platforms if installed path longer than 80 characters | |
| 9201 | 2126131 | iSqlplus HELP background color is GRAY on some browsers | |
| 9201 | 2145362 | SQLPLUS can dump with "internal heap error 17112" if Ctrl-C used at logon | |
| SQLJ | 9201 | 1710136 | SQLJ errors repeating bind variable names in a single statement |
| Security | 9201 | 1980225* | Trace file security issue. |
| 9201 | 2121935* | User Privileges Vulnerability in Oracle9i Database Server | |
| 9201 | 1231172 | ENHANCEMENT: Add "REPLACE oldpassword" clause to ALTER USER command | |
| 9201 | 1393786 | Failed EXTERNAL USER identification then tries global user identification | |
| 9201 | 1668134 | "Protocol Violation" from JDBC THIN if account password has expired | |
| 9201 | 1715529 | ORA-2002/ORA-1461 from AUDIT CREATE TRIGGER when creating a LOGON TRIGGER | |
| 9201 | 1753899 | DBMS_STATS can fail (ORA-904) for a table with a security policy on it | |
| 9201 | 1769881 | Proxy authentication for a mapped schema fails (ORA-28150/ORA-1017) | |
| 9201 | 1794996 | Cannot create a text index on a table with RLS (DBMS_RLS.ADD_POLICY) (ORA-1031) | |
| 9201 | 1796876 | Cannot import FGA (fine grain access) policies with QUOTES in predicate | |
| 9201 | 1837942 | DBA users cannot delete from FGA_LOG$ | |
| 9201 | 1838845 | ORA-1018/ORA-28273/ORA-28275 for PAGU login after setting nickname attribute | |
| 9201 | 1954607 | False ORA-28117 using VPD policy with check option on table with self referencing constraint | |
| 9201 | 1987871 | ORA-1461 if FGA SQL Text exceeds 4K in length | |
| 9201 | 1989478 | ORA-1979 on logon with default roles with nested password protected roles | |
| 9201 | 2050195 | Unnecessary re-parses for VPD predicates on each execute | |
| 9201 | 2057970 | ORA-29506 creating JAVA from table column with VPD policy on the table | |
| 9201 | 2138457 | AUDIT RENAME may not audit the first rename | |
| 9201 | 2156319 | VPD slower in 9i than 8i - add parameters to control policy execution | |
| 9201 | 2188890 | Dump (in auddft) using "ALTER LIBRARY" when AUDIT_TRAIL=DB | |
| Shared Pool | 9201 | 1333526 | ORA-4031 / Poor performance using persistent Object data types |
| 9201 | 1742027 | Identical SQL/PLSQL using different Array sizes are not shared | |
| 9201 | 1815042 | Unnecessary hold of library cache latch in RAC or OPS environments | |
| 9201 | 1819214 | Reduce latch hold time for "row cache objects" latch | |
| 9201 | 1865917 | ORA-4031 / high CPU from OR expansion of negated predicates with RBO | |
| 9201 | 2041699 | Child library cache latch contention using PLSQL functions in large selects | |
| 9201 | 2104071 | ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS) | |
| 9201 | 2129178 | Using NULL or an empty string ('') in an INLIST can cause ORA-4031 / waste shared pool memory | |
| 9201 | 2167326 | ORA-4031 possible during patch set upgrade scripts | |
| 9201 | 2244789 | ORA-4031 / excessive shared pool usage from query with full outer join / union | |
| Shared Server (formerly MTS) | 9201 | 1519547 | ORA-12592: TNS BAD PACKET possible with MTS and checksum (ASO) |
| 9201 | 1685490 | Dump (kohfrem/kohfrm) possible at logoff when using cartridges (mainly affects Shared Servers on Windows) | |
| 9201 | 1772992 | Dispatcher / Shared server may hang for 30-60 seconds | |
| 9201 | 1784544 | Using Resource Manager with MTS can lead to HANG scenarios | |
| 9201 | 1791840 | Hang possible on database UNQUIESCE using shared servers | |
| 9201 | 1793898 | OERI:17018 possible with MTS , RESOURCE_LIMIT=TRUE and IDLE_TIME > 0 | |
| 9201 | 1829370 | OERI:4415 possible using XA to OPS or RAC with DBLINKS | |
| 9201 | 1850374 | SYNC_INDEX on Shared Server (MTS) can corrupt memory | |
| 9201 | 1874554 | Shared server may dump (in kmcfsq) or OERI:504 | |
| 9201 | 1899297 | DCD (SQLNET.EXPIRE_TIME) does not work for dispatchers (shared server) | |
| 9201 | 1913320 | Shared server connections may not establish | |
| 9201 | 2002005 | PMON may shut down all available shared servers with large idle times. | |
| 9201 | 2003476 | OERI:KSKBIND1 possible using Resource Manager, MTS and trusted callouts (eg: Oracle Text) | |
| 9201 | 2028024 | CUR_XXX columns of V$DISPATCHER_RATE contain zero values | |
| Space Management | 9201 | 1881188+ | User file names may be mistakenly considered as OMF files (Oracle Managed Files) |
| 9201 | 340156 | DROP TABLE in dynamic PLSQL does not free space until PLSQL call finishes | |
| 9201 | 1491152 | Incorrect extent sizes used for non-default BLOCK SIZE tablespaces | |
| 9201 | 1801127 | MERGE with DIRECT LOAD INSERT and UPDATE may allocate wrong extent size | |
| 9201 | 1886884 | Insert performance degrades with long master freelists | |
| 9201 | 1919383 | ORa-1450 possible from ONLINE index rebuild into target tablespace with different BLOCKSIZE | |
| 9201 | 1923347 | OERI:15593 occurs using TEMPORARY TEMP tablespace if segment needs >64K extents | |
| 9201 | 1933580 | Recreating the controlfile makes TEMPFILES unusable (ORA-25153) | |
| 9201 | 1937847 | Space may be lost if migration of a tablespace to LOCALLY MANAGED is aborted | |
| 9201 | 2011859 | ORA-29339 trying to "CREATE TABLESPACE" with 32K blocksize | |
| 9201 | 2054025 | OERI:2662 possible on new TEMPORARY index block | |
| 9201 | 2069429 | Dump possible from reverse key compressed concatenated index | |
| 9201 | 2159322 | More LOBSEGMENT space is used for ENABLE STORAGE IN ROW than required | |
| 9201 | 2192583 | Extension of large System Managed Undo segment may dump | |
| 9201 | 2199391 | ADD/SPLIT [SUB]PARTITION can result in LOB partition in wrong tablespace | |
| Space Management - Bitmap Managed | 9201 | 1804299 | Rollback of Direct load can corrupt BITMAP managed segments / ORA-8103 |
| 9201 | 1809480 | Create index / CTAS on BITMAP managed segments may hang/dump | |
| 9201 | 1880815 | Speed up DMLs for objects using bitmap segments for RAC | |
| 9201 | 1955151 | OERI:711 possible allocating an extent to a bitmap segment | |
| 9201 | 2002628 | Direct load into bitmap segment can be slow if segment owner has QUOTA on owning tablespace | |
| 9201 | 2002631 | First scan after a direct load into a BITMAP SEGMENT is slow | |
| 9201 | 2065232 | RAC - Space in BITMAP managed segments freed in one instance not used in another instance | |
| 9201 | 2089657 | OERI:[KTSPEMAP-D] possible selecting from bitmap managed table | |
| 9201 | 2105419 | ORA-8103 possible from PQ on bitmap managed segments with concurrent inserts | |
| 9201 | 2107340 | Collection of BITMAP SEGMENT managed bug fixes | |
| 9201 | 2157568 | OERI:KCBGTCR_4 possible from query if segment in BITMAP tablespace is TRUNCATED | |
| 9201 | 2163991 | ORA-372 on SELECT from AUTO space managed segment in READONLY tablespace | |
| 9201 | 2194182 | ORA-604 / ORA-1000 possible querying space information for BITMAPPED tablespace | |
| 9201 | 2214167 | OERI:25012 / wrong results possible after TRUNCATE of bitmap managed index | |
| Spatial Data | 9201 | 1788877 | Function based RTREE index may return wrong results if LAYER_GTYPE=POINT |
| 9201 | 1839234 | SDO_GEOM.RELATE may fail with UNKNOWN MASK | |
| 9201 | 1849689 | Incorrect results possible from SDO_UNION two polygons | |
| 9201 | 1922618 | SDO_TUNE.EXTENT_OF does not fill in the SRID field | |
| 9201 | 1939478 | Cannot build geodetic index if gedetic srid is set | |
| 9201 | 1939494 | SDO_CENTROID using geometry with very close vertices may return wrong answer | |
| 9201 | 1943188 | SDO_UNION can generate an incorrect GTYPE for disjoint geometries | |
| 9201 | 1954292 | SDO_GEOM.RELATE with DETERMINE mask may return COVEREDBY incorrectly | |
| 9201 | 1967291 | SDO_CONVEXHULL may not return the convexhull | |
| 9201 | 1986266 | Dump possible using SDO_RELATE | |
| 9201 | 1993160 | SDO_MIGRATE.TO_CURRENT in 9i requires 8i format tolerance values | |
| 9201 | 2004111 | SDO_CS.VIEWPORT_TRANSFORM gives wrong results when view_port for the whole world | |
| 9201 | 2006913 | Dump passing negative offset to SDO_LRA_OFFSET_GEOM_SEGMENT | |
| 9201 | 2018407 | Tolerance not used consistently for WITHIN_DISTANCE operator | |
| 9201 | 2071793 | SDO_INTERSECT RELATE does not work correctlt for some geometries | |
| 9201 | 2123062 | SDO_WITHIN_DISTANCE signals ORA-13019 if the distance beyond bounds in the Metadata | |
| 9201 | 2163960 | MDGEN and MDLEXR packages are not cleaned up on upgrade | |
| Special Datatypes | 9201 | 1344959 | ENH: JDBC OCI driver add support for TIMESTAMP datatype |
| 9201 | 1672862 | OCIDateTimeGetTimeZoneOffset()/OCIDateTimeGetTimeZoneName() return incorrect results for TIMESTAMP WITH LOCAL TIME ZONE | |
| 9201 | 1741133 | NullPointerException in oracle.sql.ZONEIDMAP.getID from TIMESTAMPTZ constructor | |
| 9201 | 1778960 | Introduce constructors to make TIMESTAMP types from String | |
| 9201 | 1779081 | TIMESTAMPTZ.TIMESTAMPTZ(Connection, Timestamp) uses DB time zone instead of session | |
| 9201 | 1883191 | TIMESTAMPTZ & TIMESTAMPLTZ constructors treat Callendar as DBTIMEZONE | |
| 9201 | 1978190 | TIME, TIMESTAMP and INTERVAL arguments do not constraint actual string parameter values | |
| 9201 | 1980308 | Cannot assign values to TIMESTAMP columns in BEFORE triggers | |
| 9201 | 2032196 | Wrong results possible using TIMESTAMP column predicate in Parallel Query | |
| 9201 | 2118014 | ORA-03115 from JDBC thin describing a table containing a TIMESTAMP based datatype | |
| Star Transformation | 9201 | 1587619 | Wrong results possible from STAR TRANSFORMATION and SEMIJOIN |
| 9201 | 1685119 | OERI:KCBLIBR_USER_FOU / hang when interrupt (Ctrl-C) of PQ using STAR_TRANSFORMATION | |
| 9201 | 1768110 | OERI[KKOJOCOL:2]/OERI:150 possible from STAR TRANSFORMATION with correlated SUBQUERY | |
| 9201 | 1935292 | OERI:KCBGTCR_12 etc.. doing STAR QUERY with TEMP TABLE TRANSFORMATION in IPQ | |
| 9201 | 1946566 | OERI:15160 possible from join of 5 or more table when CBO attempts STAR | |
| 9201 | 1956846 | ORA-7445[EVAOPN2] possible from STAR TRANSFORMATION if SUBQUERY_PRUNING enabled | |
| 9201 | 1970504 | STAR_TRANSFORMATION_ENABLED = TRUE can get a sub-optimal plan | |
| 9201 | 1995384 | STAR_TRANSFORMATION_ENABLED=TRUE can cause wrong results | |
| 9201 | 2048336 | OERI:150 / Memory corruption from interrupted STAR TRANSFORMATION | |
| 9201 | 2072348 | OERI:[KKOJOCOL:2] from STAR TRANSFORMATION with duplicate table aliases | |
| 9201 | 2080984 | OERI:QES3TPINTT2 possible using GROUPING SET query with TEMP TABLE TRANSFORMATION | |
| 9201 | 2097719 | ORA-01799 possible from PQ of STAR TRANSFORMED query block with an outer join | |
| 9201 | 2102177 | Wrong results possible STAR_TRANSFORMATION_ENABLED=TRUE when TEMP table is generated | |
| 9201 | 2144870 | STAR TRANSFORMATION (FACT hint) may be ignored | |
| 9201 | 2170565 | Wrong results possible from STAR_TRANSFORMATION_ENABLED=TRUE temp table transformation | |
| 9201 | 2172983 | Wrong results / Dump from STAR_TRANSFORMATION of concatenated bitmap row source | |
| 9201 | 2208570 | ORA-4030 / ORA-4031 / spin during query optimization with STAR TRANSFORMATION and unmergable view | |
| 9201 | 2241746 | "FACT" hint may be ignored when valid - STAR TRANSFORMATION not used | |
| 9201 | 2251373 | Poor performance / CARTESIAN merge from TEMP TABLE STAR transformation | |
| 9201 | 2302828 | Hang possible using temp table STAR_TRANSFORMATION (can hang SMON) | |
| Transportable Tablespaces | 9201 | 1371820 | OERI:4506 possible against transported tablespace |
| 9201 | 1754947 | EXP-8 / ORA-6502 exporting many tablespaces with TRANSPORT_TABLESPACE=Y | |
| 9201 | 1869016 | Transporting a tablespace containing LOB data fails (IMP-3 / ORA-22854) | |
| 9201 | 2026728 | Enhancement: Allow transport of locally managed tablespaces between platforms | |
| 9201 | 2143665 | OERI:KTFDTSEX1 importing transportable tablespace with Oracle7 format datafiles | |
| 9201 | 2165601 | OERI:4097 possible on objects in read only transported tablespace | |
| 9201 | 2202283 | ORA-2220 error importing a Transportable Tablespace export with table containing LOB columns | |
| Ultra Search | 9201 | 1759582 | Misleading error message "Incompatible Version" if user does not exist |
| 9201 | 1833932 | Ultra Search does not work in Standard Edition | |
| 9201 | 1858025 | Crawler does not recognise FILE URLs on NT (due to backslash filenames) | |
| 9201 | 1866343 | NLS: Ultra Search Query API results may be returned in hexadecimal format | |
| 9201 | 1867379 | Ultra Search login page text may appear as "?" characters for some NLS environments | |
| 9201 | 1879129 | Additional tokens may occur for a document after crawling | |
| 9201 | 1881678 | NLS: Incorrect autodetected language for Chinese documents | |
| 9201 | 1900306 | Ultra Search performs bad query expansion when using asterisk wildcard | |
| 9201 | 1990549 | SQLException accessing "Queries Statistics" or "Top 50 Queries" | |
| 9201 | 2026958 | EMAIL rendering may not work due to truncated email URL | |
| 9201 | 2054828 | Document filtering may fail for some database character sets | |
| Wallet Manager | 9201 | 1775470 | Wallet Mgr: "Starting" message appears in English for non-english locales |
| 9201 | 1785217 | NLS: OWM show some messages without NLS translation | |
| 9201 | 1786190 | Wallet Mgr: NullPointerException thrown pasting certificate into Import Certificate Dialog | |
| 9201 | 1840244 | OWM/mkwallet may crash if certificate has a Name | |
| 9201 | 1919257 | Wallet is not picked up from default file system location | |
| 9201 | 1938389 | Win95: Saving Wallet to Registry does not work | |
| Wrong Results | 9201 | 1813837+ | pred1 OR pred2 can give wrong results if pred2 is a subset of pred1 |
| 9201 | 1951578+ | Wrong results from Query Rewrite with date folding on dates with TIME values | |
| 9201 | 2117360+ | V$SESSION_WAIT.WAIT_TIME may be "0" when the session is not actually waiting | |
| 9201 | 1227266 | Wrong results possible in PLSQL using uninitialized BINDS in SQL | |
| 9201 | 1249631 | V$SESSION.SQL_ADDRESS is not cleared when a cursor is unmapped | |
| 9201 | 1272708 | Wrong results from Stemming with accented characters when text index has BASE_LETTER preference | |
| 9201 | 1378709 | Blank trimming is not done properly on array fetches.1 | |
| 9201 | 1396578 | ""% Non-Parse CPU" shows the wrong value in STATSPACK output | |
| 9201 | 1417113 | CHARSET Filter does not index all documents if there is a NULL in the indexed column | |
| 9201 | 1485853 | Wrong Res / ORA-1008/ORA-2063 using DUPLICATE BIND variables over a DB link | |
| 9201 | 1587619 | Wrong results possible from STAR TRANSFORMATION and SEMIJOIN | |
| 9201 | 1649834 | Non-deterministic output from CTX_DOC.THEMES for documents with no tokens | |
| 9201 | 1660225 | oracle.sql.NUMBER( java.lang.Float ) constructor rounds the FLOAT value | |
| 9201 | 1672862 | OCIDateTimeGetTimeZoneOffset()/OCIDateTimeGetTimeZoneName() return incorrect results for TIMESTAMP WITH LOCAL TIME ZONE | |
| 9201 | 1673506 | V$SGASTAT value for "shared pool free memory" may be incorrect | |
| 9201 | 1684431 | Wrong results possible from COMPOSITE INDEX RANGE SCAN | |
| 9201 | 1692225 | Non default CPU_PER_CALL can cause 'CPU used by this session' to show high values | |
| 9201 | 1695046 | ITEXT: Incorrect results possible using PERIOD (.) as a PRINTJOIN | |
| 9201 | 1731165 | Parallel Nested Loops Semi/Anti join may give wrong results | |
| 9201 | 1742564 | ORA-1424 / Wrong results for LIKE .. ESCAPE .. which can be replaced with "=" with UNION view | |
| 9201 | 1744625 | Wrong results from INLIST iterator in subquery with correlated columns in INLIST | |
| 9201 | 1746797 | Wrong results possible from PQ with SET operations in correlated subquery | |
| 9201 | 1751186 | Wrong results / dump in qerixGetKey using bitmap indexes | |
| 9201 | 1752043 | ResultSetMetaData getScale() method can return incorrect SCALE for ADT NUMBER attributes | |
| 9201 | 1759227 | PQ may return wrong results selecting a COUNT(aggregate) column from a view | |
| 9201 | 1761391 | Array fetch into OCIString can return truncated data | |
| 9201 | 1761432 | Dictionary information for ARGUMENT$ includes PROCEDURE name when it should not | |
| 9201 | 1761901 | V$LATCH_MISSES.SLEEPS column is not incremented for all latches | |
| 9201 | 1768995 | Wrong results if indexed column has a start key (> or >=) AND an IS NULL predicate | |
| 9201 | 1774044 | START_LOGMNR( with DBMS_LOGMNR.COMMITTED_DATA_ONLY may show rolled back data | |
| 9201 | 1789212 | Wrong results from interMedia WITHIN queries on XML documents in Multibyte | |
| 9201 | 1791101 | Wrong results possible using functional index on an IOT | |
| 9201 | 1793533 | Wrong results possible from PQO with GROUP BY (affected by SORT_AREA_SIZE) | |
| 9201 | 1805863 | Incorrect results for PQ with multiple INV. DIS functions | |
| 9201 | 1808727 | ALTERNATE_SPELLING & COMPOSITE preferences may not find all token occurrences | |
| 9201 | 1808846 | Wrong results possible from duplicate bind names when bound by position | |
| 9201 | 1814148 | Incorrect results possible when NLS_SORT != BINARY | |
| 9201 | 1830949 | Wron Res possible from Anti join for single row subquery | |
| 9201 | 1831416 | V$BUFFER_POOL PREV_SIZE / PREV_BUFFERS updated even if RESIZE fails | |
| 9201 | 1832457 | Wrong results possible from PQ INDEX_FFS of global partitioned index with Nested Loops | |
| 9201 | 1834530 | OERI:25012 / wrong results after EXCHANGE PARTITION with indexes with different FREELIST /FREELIST GROUPS | |
| 9201 | 1838517 | Wrong result possible from Complex_View_Merging with Functional Index | |
| 9201 | 1849689 | Incorrect results possible from SDO_UNION two polygons | |
| 9201 | 1852436 | Text index on LONG column may index incorrect tokens | |
| 9201 | 1854275 | V$SYSSTAT may show non-sense high values if RESOURCE_LIMIT=true and PQ used | |
| 9201 | 1858047 | Common subexpression elimination can cause wrong results for negative predicates | |
| 9201 | 1863608 | False ORA-1400 possible using non-unique composite index to enforce a primary key constraint | |
| 9201 | 1866616 | Wrong results possible from SUBQUERY containing NVL( aggregate_function ,n ) | |
| 9201 | 1878160 | ITEXT: Missing results possible from wild card section search (X% WITHIN section) | |
| 9201 | 1894578 | EXEC SQL DESCRIBE from 8i client to 9i server may return no information | |
| 9201 | 1898834 | Query rewrite may give incorrect results for outer joins | |
| 9201 | 1898954 | RAW payload > 32K may dequeue incorrect data with AQ HTTP propogation | |
| 9201 | 1916422 | WRONG RESULT WITH COST BASED OPTIMIZER WITH HASH CLUSTERED TABLE | |
| 9201 | 1939494 | SDO_CENTROID using geometry with very close vertices may return wrong answer | |
| 9201 | 1941178 | Using an ANALYTIC FUNCTION in a HEIRARCHICAL QUERY causes LEVEL pseudocolumn to be 1 | |
| 9201 | 1953883 | NEXT_DAY function returns wrong day for NLS_TERRITORIES with first day of week between Tuesday - Saturday | |
| 9201 | 1953964 | ITEXT: Wrong results possible with alternate spelling for phrases with accented chars | |
| 9201 | 1960058 | LIKE on CONCATENATED index may not return rows when it should | |
| 9201 | 1961451 | CATSEARCH with 2 phrases gives incorrect results | |
| 9201 | 1966518 | PLSQL LENGTH() function returns incorrect value for strings containing CHR(0) | |
| 9201 | 1977071 | TEXT: ALTERNATE_SPELLING and BASE_LETTER lexer preference can give wrong results | |
| 9201 | 1979734 | FULL OUTER JOIN of > 2 tables may produce incorrect results | |
| 9201 | 1991341 | Wrong results possible from ROWID predicate with Bitmap Index FFS | |
| 9201 | 1992400 | Wrong results possible using INLIST ITERATOR with CORRELATED variable in the inlist | |
| 9201 | 1995384 | STAR_TRANSFORMATION_ENABLED=TRUE can cause wrong results | |
| 9201 | 1998113 | Wrong results from SET operations with WINDOW functions in different branches | |
| 9201 | 1999556 | SELECT FOR UPDATE SKIP LOCKED may miss rows | |
| 9201 | 2024128 | Wrong results from FIRST_ROWS with Oracle Text query and BITMAP operation | |
| 9201 | 2032196 | Wrong results possible using TIMESTAMP column predicate in Parallel Query | |
| 9201 | 2033324 | Wrong results from BITMAP access of B*TREE index with all NULLABLE columns | |
| 9201 | 2059318 | CONNECT BY query with ORDER SIBLINGS BY column DESC returns too few rows | |
| 9201 | 2070377 | Text queries using ABOUT and ctx_doc.themes() with THEME_LANGUAGE=FRENCH miss some themes | |
| 9201 | 2095381 | SHARED_POOL_SIZE in V$PARAMETER may show the incorrect value | |
| 9201 | 2096565 | Wrong results possible when column in query has a DESCENDING index on it | |
| 9201 | 2097294 | Wrong results possible from SELECT over DBLINK using HASH JOIN | |
| 9201 | 2102177 | Wrong results possible STAR_TRANSFORMATION_ENABLED=TRUE when TEMP table is generated | |
| 9201 | 2104034 | Missing rows possible from multi-column INLIST containing partition key | |
| 9201 | 2115494 | Phrase search using nested WITHIN on XML document can return false hits | |
| 9201 | 2117839 | Bad date values / dump possible using TRUNC() as a GROUP BY key with GROUPING SETS | |
| 9201 | 2126283 | Bad sort order possible with RBO using ASC NULLS FIRST / DESC NULLS LAST | |
| 9201 | 2128245 | V$RESOURCE_LIMIT.LM_CACHE_RESS/GESS_CACHE_RESS shows the wrong value | |
| 9201 | 2130307 | V$SQLTEXT shows incorrect data if 64th byte is start of a multibyte character | |
| 9201 | 2162759 | ADDR/KADDR columns of V$LOCK/V$TRANSACTION_ENQUEUE may be incorrect | |
| 9201 | 2170565 | Wrong results possible from STAR_TRANSFORMATION_ENABLED=TRUE temp table transformation | |
| 9201 | 2170929 | USER_SOURCE_TAB_COLUMNS shows schema of CHANGE table not the SOURCE table | |
| 9201 | 2172876 | Wrong results from HASH CLUSTER using CHAR datatype KEY column/s | |
| 9201 | 2184811 | MV rewrite with NULL/NOT NULL predicates may give incorrect results | |
| 9201 | 2189327 | LPAD/RPAD with length > 65535 pads to wrong length in SQL | |
| 9201 | 2214167 | OERI:25012 / wrong results possible after TRUNCATE of bitmap managed index | |
| 9201 | 2221598 | LONG columns values may not Text index correctly | |
| 9201 | 2231419 | Wrong results possible using ORDER BY/GROUP BY with functional index | |
| 9201 | 2231515 | DATA_LENGTH in ALL/USER_ARGUMENTS not shown for VARCHAR2 data in %TYPE parameters | |
| 9201 | 2251070 | USERENV('xxx') in PLSQL can return wrong value for 8 digits or more | |
| XA / Distributed Transactions | 9201 | 914652 | ORA-2041 possible for DB LINK with XA / Microsoft Transaction Server / ODBC |
| 9201 | 1775445 | Multi-threaded XA client which spawns threads which do xa_end(TMSUSPEND) leak memory | |
| 9201 | 1781184 | Implicit cursors using a remote table may cause XA error 100 | |
| 9201 | 1808970 | WinNT: Multithreaded OCI/XA client memory leak | |
| 9201 | 1829370 | OERI:4415 possible using XA to OPS or RAC with DBLINKS | |
| 9201 | 1889247 | JDBC/NativeXA improvements to support JDBC NativeXA feature in JTA | |
| 9201 | 1984822 | Concurrent execution on tightly coupled transaction branches can cause logical corruption | |
| 9201 | 2033552 | XA_OPEN does not support OCI_EVENTS so OCISubscriptionRegister may dump / ORA-1010 | |
| 9201 | 2052584 | XA with SQLLIB (Pro) in a DLL may error if the DLL is unloaded before ending the transaction | |
| 9201 | 2100385 | Inactivity timeout does not work for XAConnections | |
| 9201 | 2145632 | ORA-3113 / ORA-3114 should map to XAException.XAER_RMFAIL under JDBC XA | |
| 9201 | 2187288 | ORA-600[12316] trying to PREPARE a OCI_TRANS_NOMIGRATE transaction | |
| 9201 | 2221449 | ORA-24756/ORA-24776 on COMMIT after recovering IN-DOUBT/PREPARED transactions | |
| XML / XDK | 9201 | 1532178 | OERI:kopuopkl1 / ORA-31012 possible from XPATH operator in XPATH expression |
| 9201 | 1724863 | ORA-932 if DBMS_XMLGEN is passed a CURSOR() expression | |
| 9201 | 1731454 | Sporadic "NAMESPACE PREFIX USED BUT NOT DECLARED" error | |
| 9201 | 1736840 | HTML tags may be incorrectly parsed for entity references | |
| 9201 | 1739150 | Generate ' for single quotes instead of &APOS; | |
| 9201 | 1783136 | XMLType.createXML may cause heap corruption | |
| 9201 | 1783875 | Invalid XML from VARCHAR2 inside a collection | |
| 9201 | 1787245 | CTX_DOC.MARKUP using PATH_SECTION_GROUP may dump for XML document with attribute sections | |
| 9201 | 1794964 | Stylesheet with two <XSL:KEY>'s defined produces unexpected results | |
| 9201 | 1826973 | XPATH expressions using PRECEDING or FOLLOWING may fail | |
| 9201 | 1838067 | Invalid XPATH expressions can cause a dump / incorrect data | |
| 9201 | 1844732 | Dump possible (QXOPQXEX) using CONTAINS on XMLTYPE column | |
| 9201 | 1855575 | AQxmlPublishRequest.getAutoCommit() may throw an exception | |
| 9201 | 1875675 | ENH: Add support for SOAP messages to AQ XML SERVLET | |
| 9201 | 1885222 | DECIMAL-FORMAT DIGIT AND PATTERN-SEPARATOR NOT IMPLEMENTED IN ORACLE XSL | |
| 9201 | 1889521 | //LINEITEMS_ROW[PART/@PARTID = "GG765"] style constructs may not return data | |
| 9201 | 1891841 | ORA-22275 possible using EXTRACT() | |
| 9201 | 1900443 | XSQLConfig.xml cannot be found in XSQL global servlet on OC4J | |
| 9201 | 1939447 | TEMPLOB generated by xmltype.createXML() not freed until session ends | |
| 9201 | 1945048 | XSLT may crash processing document containing elements created by LpxCreate* routines | |
| 9201 | 1955074 | Update of Oracle Schema Processor to W3C Recommendation | |
| 9201 | 1971090 | XSLProcess did not support multiple class loaders - unexpected XSL-1045 | |
| 9201 | 1991492 | False XSD-2035 possible from XML Schema validator | |
| 9201 | 2054163 | Dump (in qcopgcty) from ANALYZE of text indexed XMLTYPE column | |
| 9201 | 2060389 | XMLLOAD.SQL does not create a public synonym for XSLPROCESSOR | |
| 9201 | 2091268 | LPX-406 / dump processing stylesheet WITH-PARAM using $variable without binding | |
| 9201 | 2096011 | XSL PROCESSOR and STYLESHEET hold onto references to input document elements (mem growth) | |
| 9201 | 2104071 | ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS) | |
| 9201 | 2120784 | ORA-24345 possible parsing XML if the error to be reported exceeds 512 bytes | |
| 9201 | 2130299 | XML schema processor does not check for duplication of local definitions | |
| 9201 | 2138361 | NullPointerException using XSL processor with certain MATCH pattern | |
| 9201 | 2232456 | Memory leak in XDK | |
| 9201 | 2282158 | Large memory use possible for large XML documents (XMLParser) | |
| Year 2000 / Date limit Issues | 9201 | 1985041 | ProCobol files precompiled after 09/Sep/2001 may not compile on some platforms |
| Dumps / Abends | 9201 | 1526601 | ORACLE_SID of 16 characters cause utilities to dump on Windows platforms |
| 9201 | 1766871 | Dump in lxplset possible | |
| 9201 | 1779351 | Dump in SQNPRS possible during semantic analysis | |
| 9201 | 1779368 | Explain plan of UPDATE VIEW may dump (in KKMMCTBF) | |
| 9201 | 1782025 | Client may dump/error using DML RETURNING with CURSOR_SHARING=FORCE|SIMILAR | |
| 9201 | 1784673 | ORA-7445 / dump from CREATE / ALTER table using TREAT directive | |
| 9201 | 1832802 | Dump (in qcitrans) possible using shared servers | |
| 9201 | 1834952 | ORA-7445 on accessing table X$KCFTIO on some platforms | |
| 9201 | 1856332 | Dump (in KKORNVL) possible using NVL/DECODE predicate | |
| 9201 | 1856678 | SQL with ROLLUP, WINDOW an CASE expressions may dump | |
| 9201 | 1936433 | ORA-01461 on INSERT .. RETURNING VALUES causes next INSERT to dump | |
| 9201 | 1947584 | Buffer overflow possible KDRREB() | |
| 9201 | 1993439 | Dump in ktusta possible during extension of offline SMU undo segment | |
| 9201 | 1993859 | Dump in KSQEQH possible | |
| 9201 | 2004336 | COUNT(NOT_NULL_COLUMN) may dump (QERIXGETKEY) if column referenced in WHERE clause | |
| 9201 | 2103726 | ORA-7445 (kkeccomp) possible from queries with predicates using user-defined functions | |
| 9201 | 2110054 | Select COUNT(*) from a nested complex view with GROUP BY in inner view may dump in evaopn2 | |
| 9201 | 2132976 | Queries with CUBE and PERCENTILE may dump in <Function:evacom> | |
| 9201 | 2134501 | ALTER INDEX SPLIT/REBUILD or MOVE IOT may dump in KDICDRV under heavy shared pool load | |
| 9201 | 2136414 | Dump in QCDLGTD possible during select from a view owned by another user | |
| 9201 | 2194281 | Dump (in vopwho) possible for SQL using PLSQL function as connecting condition to SUBQUERY | |
| 9201 | 2197403 | Dump instead of ORA-1427 possible if select subquery returns >1 row | |
| 9201 | 2220597 | ORA-7445 [kpolon] possible trying to connect to a SHUTDOWN database | |
| Errors & Internal Errors | 9201 | 1055420 | ORA-14452 when trying to DROP a GLOBAL TEMPORARY TABLE if a using session has been KILLED |
| 9201 | 1230798 | Concurrent ALTER TABLESPACE READ ONLY can fail with ORA-60 | |
| 9201 | 1306324 | Dynamically changing Event:10270 can cause OERI:252 / dumps | |
| 9201 | 1335603 | PLS-00553 using BIND variable in SQLPLUS session which has just issued STARTUP | |
| 9201 | 1395086 | OERI:6731 possible on update of chained row locked by a DEAD transaction | |
| 9201 | 1402161 | OERI:4411/OERI:4454 on long running job | |
| 9201 | 1409835 | OERI:16609 / OERI:16608 possible on operations which involve constraints | |
| 9201 | 1586509 | OERI:KSUWAITSYSEVENT1 possible from Forms clients | |
| 9201 | 1712645 | OERI:729 space leak possible if DROP COLUMN is interrupted | |
| 9201 | 1747270 | OERI:QXIMCOC4 can be signalled on a memory error when using a DOMAIN index | |
| 9201 | 1748384 | OERI:qksopOptASJLf1 / dump in kkeajsel with ALWAYS_SEMI_JOIN=MERGE/HASH with SUBQUERY containing OR of correlated variable | |
| 9201 | 1776045 | ORA-2070 if CUBE is used in GROUPING SETS with TRUNC on DATE | |
| 9201 | 1777175 | OERI:kcbgcur_12 / OERI:kcbgcur_6 / OERI:kchkinteg-1 possible if accessing a table which is being DROPPED | |
| 9201 | 1778127 | OERI:7005 possible using WITH clause with subquery containing a DATE function | |
| 9201 | 1784708 | OERI:KCBGTCR_1/OERI:25012 accessing LONG / LONG RAW in a HASH CLUSTER | |
| 9201 | 1788648 | OERI:25012 [2147483647] possible selecting from certain V$ views | |
| 9201 | 1789753 | OERI:12455 [QKADELUPD] possible on EXPLAIN PLAN | |
| 9201 | 1790875 | OERI:[QSMEMCRG_MERGE_COMPLEX_RANGES-2] can occur | |
| 9201 | 1794739 | OERI:7001 possible on CREATE VIEW when OBJAUTH$.SEQUENCE# exceeds 65535 | |
| 9201 | 1800016 | DB may not start with large LARGE_POOL_SIZE and multiple CPUs (ORA-704) | |
| 9201 | 1804676 | OERI:KCBGCUR_9 possible from ONLINE REBUILD INDEX with concurrent DML | |
| 9201 | 1807292 | OERI:711 possible opening database after CONTROLFILE recreated with wrong DB_BLOCK_SIZE | |
| 9201 | 1809974 | OERI:[qks3tCTT:1] from GROUPING SETS query with correlated SUBQUERY in HAVING clause | |
| 9201 | 1810737 | OERI:KCBBNWA2 possible if the number of QUADS exceeds max DBW processes | |
| 9201 | 1812162 | OERI:KSFDCHKFOB1 possible on exit when multiple sessions in one connection | |
| 9201 | 1818676 | Sessions exceeding PROFILE resource limits may raise OERI:17034 / OERI:17281 | |
| 9201 | 1820448 | ORA-7445[strncpy] possible on SELECT from X$KSMSP | |
| 9201 | 1824061 | Creating ODM datafiles > 4Gb errors (ORA-959/ORA-19502) | |
| 9201 | 1827660 | OERI:[kdiss_pin_hdr: too many] possible from index skip scan | |
| 9201 | 1830760 | ORA-30497 from DENSE_RANK with GROUPING SETS | |
| 9201 | 1840199 | OERI:EVAGGSID-1 possible using user defined aggregates (UDAG) with CURSOR_SHARING=FORCE|SIMILAR | |
| 9201 | 1840238 | OERI:KKQGRWRAGGS.1 possible using user defined aggregates (UDAG) | |
| 9201 | 1858632 | OERI:4512 possible inserting into a table with an index | |
| 9201 | 1877874 | OERI:QERIXTIGET1 possible querying an empty GLOBAL TEMPORARY table with an index | |
| 9201 | 1915018 | ALTER VIEW .. COMPILE which references ROWID fails with ORA-1446 | |
| 9201 | 1924045 | OERI:kkqgUnpAgg.2 possible using GROUPING SETS | |
| 9201 | 1924156 | ORA-00600 [KTSPFMTRNG-NBLKS] | |
| 9201 | 1953407 | OERI:[KQLBLFC-1] during crash recovery / slow startup times possible | |
| 9201 | 1955307 | SMON may self-deadlock (ORA-60) shrinking a rollback segment in SMU mode | |
| 9201 | 1957195 | OERI:KTSIRCINFO_NUM1 / OERI:KTSSDRP1 possible after concurrent ALTER INDEX REBUILD on same index | |
| 9201 | 1963828 | False ORA-02014 possible from SELECT FOR UPDATE with scalar subquery | |
| 9201 | 1968477 | ORA-64 possible for large values of DB_FILES | |
| 9201 | 1968815 | OERI:25012 possible from SMON following DROP TABLESPACE command | |
| 9201 | 1969320 | ORA-1400 errors omit the column name if SELECT privilege on table is missing | |
| 9201 | 1974219 | ALTER TABLE MODIFY column from INTEGER to FLOAT signals ORA-1440 | |
| 9201 | 1977016 | False ORA-01436 possible using CONNECT BY with OR clauses | |
| 9201 | 1978137 | OERI:sorexallo_1 from ROLLUP query with aggregates in a subquery | |
| 9201 | 1985111 | OERI:26599 possible when shortname translation occurs in a recursive session | |
| 9201 | 1990056 | Add a new internal error (to check for the issue in Bug:1711803) | |
| 9201 | 1998455 | OERI:KCBGTCR_4 possible from long running DDL if referenced object dropped/truncated | |
| 9201 | 2009622 | OERI:730 / DBW may die with ORA-603 on shutdown | |
| 9201 | 2034543 | ORA-979 from a HIERARCHICAL QUERY with a subquery containing a GROUP BY clause | |
| 9201 | 2035267 | OERI:KCBGCUR_9 possible during TEMP space operations | |
| 9201 | 2060131 | OERI:13009 possible from 'SELECT FOR UPDATE .. NOWAIT' | |
| 9201 | 2061289 | "COMMIT COMMENT" with no comment signals ORA-2236 | |
| 9201 | 2100837 | OERI:QCTCTE1 possible using INLIST predicates | |
| 9201 | 2103658 | OERI:6034 possible inserting into table with PK enforced with non-unique index | |
| 9201 | 2103881 | ALTER INDEX REBUILD ONLINE gives ORA-604 / ORA-903 / ORA-911 if "username" starts with a number/special character | |
| 9201 | 2126287 | ORA-604 / ORA-918 from WITH clause and UNION | |
| 9201 | 2138486 | OERI:KCBKLBC_3 possible due to race condition | |
| 9201 | 2144889 | ORA-604/ORA-1 possible during ALTER TABLE DROP COLUMN | |
| 9201 | 2166556 | SKIP_UNUSABLE_INDEXES=TRUE may use an existing cursor which uses the index (ORA-1502) | |
| 9201 | 2171343 | OERI:2023 can occur | |
| 9201 | 2175605 | OERI:QERNSROWP possible from SELECT DISTINCT with duplicate constant strings | |
| 9201 | 2175923 | STATSPACK: ORA-1476 from sprepsql.sql if the Physical Reads is zero | |
| 9201 | 2179919 | ORA-600 [12325] from WHERE ROWID clause against table in an inline view | |
| 9201 | 2184731 | OERI:25012 possible from index prefetch | |
| 9201 | 2189615 | OERI:25012 / OERI:504 [cache buffers chains] selecting from certain V$ tables | |
| 9201 | 2205764 | ORA-7445[KDIMOD0] possible from fix for bug:2103658 | |
| 9201 | 2216959 | False ORA-1791 possible using duplicate binds | |
| 9201 | 2224067 | OPEN_LINKS cannot be set to "0" | |
| Miscellaneous | 9201 | 1618967 | Stopping ARC process generates a trace file |
| 9201 | 1685172 | Control characters in access parameter strings may be ignored | |
| 9201 | 1775864 | DBA|ALL|USER_CONSTRAINTS views show wrong DELETE_RULE for ON DELETE SET NULL | |
| 9201 | 1777185 | DBMS_BACKUP_RESTORE keeps a file handle open (OFFLINE files cannot be deleted) | |
| 9201 | 1805782 | ENH: Admin scripts to use CREATE OR REPLACE instead of DROP / CREATE | |
| 9201 | 1829282 | SET_CONTEXT long attribute (over 4K) dumps when referenced by SYS_CONTEXT | |
| 9201 | 1853830 | OERI:KCBGTCR_4 possible if DOMAIN index dropped while in use by another query | |
| 9201 | 1875283 | SHUTDOWN IMMEDIATE does not recognise Managed Recovery state | |
| 9201 | 1890826 | Query on ORACLE_LOADER EXTERNAL TABLE does not close the log file on error | |
| 9201 | 1937543 | 9.0 Forms clients get ORA-1075 on logon after a logoff | |
| 9201 | 1954743 | Improvements to OTS when all transaction branches at same site | |
| 9201 | 1973738 | DBA/USER/ALL_PUBLISHED_COLUMNS views missing | |
| 9201 | 1998977 | GROUPING distinguisher operators are slow in a ROLLUP query | |
| 9201 | 2012139 | PK constraint violation can roll back all rows in ARRAY insert | |
| 9201 | 2027986 | LIKE :bind1 ESCAPE :bind2 does not work properly | |
| 9201 | 2048627 | Dropping a users DEFAULT tablespace drops temporary table indexes | |
| 9201 | 2054079 | IO error causes all files in the tablespace to be taken offline | |
| 9201 | 2082866 | GRANULE SIZE does not get larger after increasing SGA_MAX_SIZE | |
| 9201 | 2082901 | ALTER SYSTEM DISCONNECT SESSION causes ORA-3113 rather than ORA-28 | |
| 9201 | 2085332 | ORA-2394 can occur using RESOURCE_LIMIT=true even if logical_reads_per_session = unlimited | |
| 9201 | 2109788 | PGA_AGGREGATE_TARGET can be set above 4000GB | |
| 9201 | 2114497 | CREATE OR REPLACE SYNONYM may not update the TIMESTAMP in the dictionary | |
| 9201 | 2131983 | ENH: Make library cache pin cleanup code more robust | |
| 9201 | 2139813 | Primary Key / Unique validation sub-optimal | |
| 9201 | 2143637 | ORA-4031 possible starting the cache advisory | |
| 9201 | 2194653 | IOException possible creating Oracle Schema / Oracle Context |
Spin possible while holding hash latch
RMAN does not create STANDBY REDO logs on standby when creating a standby database. Workaround: 1. Do not create standby redo logs on the primary database. 2. Recreate standby redo logs on the standby database:
Hang possible using temp table STAR_TRANSFORMATION (can hang SMON)
This is a follow on from Bug:1577800: A false ORA-17085 is possible in JDBC with SELECT .. FOR UPDATE.
Multithreaded JavaSSL may dump when connection is closed.
Eg: A second thread may die in
oracle.security.ssl.OracleSSLSocketInputStream.sslInputStreamRead
against the closed socket.
Large memory use possible for large XML documents
Query may not rewrite when expected
Cluster hang possible with the message "Name Service frozen" in the LMON trace file. This hang can occur during instance mount.
Core dumps or spins are possible from queries using functional indexes and an and-equals access path.
Poor performance possible on queries that undergo temporary table star transformation if a star plan is chosen - the execution plan may include a CARTESIAN merge join nd the FACT table may not be last in the join order. Workaround: Set <Parameter:STAR_TRANSFORMATION> = TEMP_DISABLE
This problem is introduced in Oracle 9.0.1.
When executing USERENV('SESSIONID') from within PL/SQL,
if the correct value has 8 or more digits, the reported value
will be incorrect (missing low-order digits).
The same problem can occur with 'ENTRYID', 'SCHEMAID',
and 'INSTANCE' arguments to USERENV (all of which return numeric
results)
This problem is related to Bug:1836101. Memory corrupt possible during optimization of distributed query.
If DBMS_LOGMNR.START_LOGMNR() is called with a flat file dictionary and the DDL_DICT_TRACKING option then the SQL_REDO/SQL_UNDO columns of V$LOGMNR_CONTENTS will not display columns of type CHAR (all flavors).
Parse may appear to spin (in kkquccae/kkquwhr)
ORA-4031 / excessive shared pool usage from query with full outer join / union.
ENHANCEMENT: More diagnostics required for stuck "GLOBAL CACHE S TO X" conversions
Dump (in kokmeoc) possible from CURSOR() select
A star transformation may not always occur when the "FACT" hint is used and all physical conditions are met.
Memory leak in XDK
This problem is introduced in 8.1.7.3 and 9.0.1.2. The DATA_LENGTH in USER/ALL/DBA_ARGUMENTS shows as NULL for VARCHAR2 elements in %TYPE parameters.
Wrong results possible using ORDER BY/GROUP BY with functional index
Memory leak can occur for SQL using TABLE() clauses
Spin (in KDGGCS) possible when inserting into a CLUSTER. The looping code generates lots of REDO/UNDO. (this is a quite a rare scenario)
On some platforms (mainly Microsoft platforms) no error is logged if INSO_FILTER times out
If user objects have names like dictionary tables (eg: SCOTT.USER$) then Log Miner may loose dictionary information and report object id's instead of table names in <View:V$LOGMNR_CONTENTS>
This problem is introduced in 8.1.7.0. It is not possible to set <Parameter:OPEN_LINKS> to ZERO
JDBC may not remove metrics data (DMS) resulting in OutOfMemoryError
Over-estimation of GROUP BY cardinality is possible for an "inlist column" . This can lead to a suboptimal plan.
ORA-1455/ORA-1426 or ORA-3106 can occur if an EXACT ARRAY FETCH over a DBLINK returns more or less than the arraysize number of rows. This occurs using OCIStmtExecute() call with OCI_EXACT_FETCH mode.
Exceeding OPEN_CURSORS in dynamic SQL (from PLSQL) may dump instead of signalling ORA-1000
LONG column values may not be handled correctly leading to truncated values, dropped tokens, missed documents during query, etc. This problem is not consistently reproduceable between machines as it is caused by uninitialised memory.
ORA-24756/ORA-24776 possible on COMMIT after recovering IN-DOUBT/PREPARED transactions
ORA-7445 [kpolon] possible trying to connect to a SHUTDOWN database
OracleConnectionCacheImpl in FIXED_WAIT_SCHEME mode spins once the maximum number of allowed connections is reached and a new connect request is made.
Severe memory leak/growth using EXTERNAL tables.
This is a regression introduced in 8173 / 9012 by the fix for bug:1808846.
ORA-1791 can occur when using a bind variable name in the
body of the SQL statement as well as in the ORDER BY clause.
Eg:
declare
BINDA varchar2(10);
b varchar2(10);
begin
select distinct decode(deptno,10,BINDA,'other') into b
from emp where empno=7900
order by decode(deptno,10,BINDA,'other');
end;
/
Executing a pipelined function which returns a TYPE including a character-length semantics field against a multibyte database may result in incorrect ORA-6502 errors.
Passing a RAW actual to a VARCHAR2/LONG IN OUT/OUT formal parameter throws ORA-6502 incorrectly.
ORA-600 [kjuinc:resp2inq] possible
When trying to create an index with no storage clause, Text tries to automatically add a "compress" clause to the $X, etc. index. This fails on Standard Edition as it does not support key compressed indexes. Also, one internal index ? DR_UNIQ_THS_PHRASE ? cannot be created, possibly leading to duplicate thesaurus phrases.
TRUNCATING a bitmap managed index with large extents can lead to ORA-600 [25012] errors and wrong results.
When trying to create an index using master-detail datastore, and the detail table text column is a SYS.XMLTYPE, the index creation will fail with per-doc errors showing an ORA-600 [koksghds1]
PL/SQL does not flag references to collection methods
gotten from database tables outside of SQL statements
resulting in a dump (in pfrins).
eg: j := tbl.col1.FIRST;
(where col1 is a nested table or varray)
would not be flagged.
This problem is introduced in Oracle9i. Cursor frame memory corruption can occur if a cursor using BIND variables is aged out and reloaded. This can often show up as an ORA-600 [25012] error.
This problem is introduced in Oracle9i. Direct load of multiple tables in the same SQLLOAD control file can be very slow when compared to Oracle8i or earlier especially if some of the loaded tables have very few data rows matching their WHEN clause.
SMON may grow in size due to a memory leak.
Infinite recursion occurs during query optimization if a query contains an unmergeable view, and the view optimization involves star transformation , and the query is being probed for summary rewrite (or any other case involving evaluation of the view cardinality) . This can show up as a spin, ORA-4030 or ORA-4031 error
A core dump or memory overwrite can occur when using a USER FILTER and the filtered document size is exactly 10K.
ALTER TABLE MODIFY PARTITION DROP/ADD VALUES for a list or composite list partitioned table one can encounter "ORA-1502: index 'x' or partition of such index is in unusable state"
Core dump instead of ORA-1008 possible in an OCI7 client
This problem appears as a regression in 9.0.1.3 or in earlier releases if a one-off fix for bug:2103658 has been applied. ORA-7445[KDIMOD0] possible from fix for bug:2103658.
When lowercase alphabetical words are given, JAPANESE_VGRAM_LEXER converts them to uppercase and store them to $I table as token. But JAPANESE_LEXER doesn't convert them if the word is multibyte lowercase alphabetical words.
Sync / Create index on multibyte database may dump
In the OPTIONS clause, if the SKIP value (or any numerical value) has multiple preceding zeroes, then SQL*Loader ignores other entries in the OPTIONS clause after SKIP.
An ORA-2220 error can occur when importing a Transportable Tablespace export which contains a table containing LOB columns. This prevents the tablespace from being transported.
Updating a NUMBER column and DATE column using any 9.2 OCI client talking to a pre-9.2 server can corrupt the NUMBER column on UPDATE.
ADD [SUB]PARTITION and SPLIT [SUB]PARTITION can result in one of the LOB partitions (the first one) ending up in a different tablespace.
Dump instead of ORA-1427 for array updates with select-subquery if the sub-query returns more than one row.
AQ propagation from 32 to 64 bit machines can dump
Using invokers rights (IR) procedures, executing a SQL statement when current_schema has one value, and then executing the same SQL statement again with a different current_schema setting can result in the second execution of the SQL statement affecting the first schema, not the second.
Dynamic resourece mastering is turned ON by default. Workaround: Set _lm_dynamic_remastering=false
This problem is introduced in 9i. Under load CPU utilization of the LMS background process may increase to 100%. This can cause interactive response of the database to slow down.
"GSD" process can be hard to find as "GSD" does not appear in the process name.
The Oracle Schema or Oracle Context with fail to create when running one of the programs which create them (eg: Oracle Net Configuration Assistant or OID Configuraton Assistant). Sometime an "IOException: Too many open files" will be reported.
Queries with subqueries and a PLSQL function in
the connecting condition sometimes dump (in vopwho).
eg: select * from emp e1
where PLSFUNCTION(e1.empno) <>
(select count(*) from emp e2 where e1.empno = e2.empno)
Partition Views do not support functional indexes. This fix allows partition views to be used with functional indexes.
ORA-604 / ORA-1000 possible whilst querying space information for bitmapped tablespaces.
LMS may spin in kclpdcl() for a period of time, but will normally free up eventually.
When using System Managed Undo (SMU) extension of a very large undo segment may dump while adding an extent map block.
Setting the underscore parameter _lm_tickets to a large value
may cause the object size error.
Note: This parameter should not be set unless advised to do
so by Oracle Support.
ORA-600 [25012] / ORA-600 [504] .. [cache buffers chains] can occur selecting from certain V$ tables which are based on X$KTCXB. Eg: V$LOCK or V$TRANSACTION
LPAD/RPAD with length > 65535 pads to wrong length in SQL. It pads to length modulus 65536.
Dump (in auddft) using "ALTER LIBRARY" when <Parameter:AUDIT_TRAIL> is set to "DB".
Crash possible in KDB4_DUP_KEYS() due to error in block checking code for clusters.
RMJVM does not clean up all objects correctly. This can cause errors on table DDL. eg: ORA-604: error occurred at recursive SQL level 1 ORA-29540: class oracle/CDC/PublishApi does not exist
This problem is introduced in 9.0. ORA-600[12316] on PREPARE of a transaction started with the OCI_TRANS_NOMIGRATE flag.
When DB_BLOCK_SIZE is >2k, CBO may not use domain index access path due to constant low function cost of CONTAINS().
Cannot create OCCI environment with both OBJECT and THREADED_MUTEXED.
eg:
env = Environment::createEnvironment
(Environment::Mode((Environment::OBJECT|Environment::THREADED_MUTEXED)));
does not initialize the environment in both OBJECT and THREADED_MUTEXED
mode as would be expected.
INSO_FILTER may fail to filter large PDF documents
High number of posts from LMD to LMS (send proxy)
ORA-600 [kjbrcvt:!gr] possible. Workaround: Set _lm_direct_sends=lkmgr
If an MV is eligible to rewrite Query Q, and it has an "IS NULL" or "IS NOT NULL" predicate and has some other predicate on the same column (Except null and not null predicates) then the query is wrongly rewritten with MV producing incorrect results.
ORA-600 [25012] possible from index prefetch. Workaround: Set _db_file_noncontig_mblock_read_count=1
PMON may not be able to cleanup dead session waiting on 'GLOBAL CACHE BUSY'. This can lead to a hang scenario as the blocking resource can never be freed.
PROCOBOL writes calls to SQLSTRD in double quotes
ORA-3113 can occur if the databse is upgraded from 32 to 64 bits and the CONTAINS() operator is used.
If the JDBC cache scheme is FIXED_WAIT_SCHEME, then if all connections are in use a call to getConnection() will hang.
The creation of a stored PLSQL package/procedure may fail with an ORA-1401 if it contains a CURSOR with a SELECT of an expression over 30 characters long.
ORA-600 [12325] from a query with a ROWID reference in a WHERE clause for a ROWID of a table inside an inline view.
After a server process fails during changing values of an initialization parameter which could accept multiple values by an ALTER SYSTEM statement PMON may die and crash the instance.
Cardinality for ROWID predicates is incorrect
The GET_USER_PROPS_AND_AUTH function in DBMS_LDAP_UTL does not return the user properties if the user's password is about to expire.
NOT EXISTS may produce slow anti-join plan in CBO if the subquery is un-nested when it could be used as an index filter.
ORA-255 or ORA-65280 fetching zero length CLOB column (eg: with OCIStmtFetch2() )
A foreground process may read a block from disk even though the master has a S locked block.
In some cases RAC recovery may decide that no recovery is needed, when redo does need to be applied. This can lead to data corruption.
If an oracle foreground process is killed with "kill -9" when at a particular point in the code and SGA heap corruption can occur when PMON cleans up the dead process. This is quite a rare timing scenario.
ORA-7445 / Dump in kgghash possible using OCIObjectArrayPin() for complex object retrieval.
ORA-1476 occurs when running sprepsql.sql(statspack) if the Physical Reads is zero.
This problem is introduced in 9i. After a process death that is being cleaned up by PMON, some queries may hang.
@ This problem is introduced in 9i (I think) ORA-600 [QERNSROWP] possible for SELECT DISTINCT queries with duplicate constant strings in the select list when a NOSORT query plan is chosen. Workaround: Set <event:10119> to disable no-sort fetch
If Start_logmnr() is called with the DDL_DICT_TRACKING option, a 'create table as select' or 'insert as select' query against v$logmnr_contents may dump.
RMAN incremental backup performance degrades over time in NOCATALOG mode.
Add support for nCipher SSL HW accelerator
Star_transformation_enabled=true (or temp_disable) can produce wrong results (or dump) if a fact table has a concatenated bitmap index and star transformation is performed for at least 2 columns of the concatenated bitmap index. This can also occur if a bitmap conversion of a concatenated B*Tree index occurs.
HASH clusters using a KEY with CHAR columns can return wrong results.
ALTER TYPE ... CASCADE may signal ORA-600[koktalt_dep_tabs2], when the type has a REF dependency to a table with nested table(s).
Dump in QXIMSCC possible if Domain Index ODCIIndexStart errors
In a multi-threaded system that creates and destroys a large number of statements a large performance degredation may be seen when using a DMS enabled JDBC classes file.
ORA-600 [2023] can occur
Dump in xtyTabFunAddOrd() for some queries when an insufficient number of select list columns are passed to a PLSQL function taking a REF cursor parameter .
Package utl_encode generates and read CR where LF should be, and vice versa. This affects all encode and decode functions.
USER_SOURCE_TAB_COLUMNS shows the schema name of the owner of the change table, not the owner of the source table.
Selecting java source code from DBA|USER|ALL_SOURCE can sometimes cause an Ora-600 to be raised or a core dump due to a memory corruption.
STAR_TRANSFORMATION_ENABLED=TRUE can produce wrong results if a temporary table is created for a dimension ,which is referenced in and OR-predicate, and the OR-predicate references other tables as well.
ORA-1172 possible after an instance is evicted from a cluster.
If the sql_redo or sql_undo column of logmnr_contents spans multiple rows, a piece of the sql_redo or sql_undo may be repeated.
ORA-600 [15819] in PQ possible due to the merging of underlying views of a nested-loop join.
9.0 catpatch.sql, which is used for patchset upgrades, includes a mechanism "CREATE OR REPLACE" a no-op if the source of the objects being replaced exactly matches the new source. For PL/SQL objects, the existing source needs to be loaded into memory for source comparison. Prior to this bugfix the source was loaded into SGA. As a consequence large contiguous chunks of SGA memory gets allocated for the source. This may cause some "CREATE OR REPLACE" operations to fail with ORA-4031 errors. Workaround: Increase the SGA size.
drdefpt.sql includes two incorrect stopwords for Portuguese: 'ati' should be 'ate' 'prsximo' should be 'proximo'
After setting the parameter skip_unsable_indexes to true a query may still use an unusable index and fail with ORA-1502 if the query matches a sharable cursor already in the shared pool. Likewise it is possible for a query to skip unusable indexes when it should not.
This problem is introduced in 9i. An insert from 9i to 8i table which uses self loopback dblink on 9i may hang or dump.
Dump possible creating Text index
A select or analyze on objects in a transported tablespace may result in ORA-600 [4097] if the tablespace has been read only ever since before the upgrade to V8.x.
ORA-8102 possible on delete / update of a row in a table having a DESCENDING index, which was loaded using SQL*Loader direct load.
Query portion of an INSERT SELECT containing a set operator does not run parallel
Selecting from a table on read-only tablespace which was created as 'SEGMENT SPACE MANAGEMENT AUTO' results in ORA-372
MDGEN and MDLEXR packages are not cleaned up on upgrade.
Setting visible flag to FALSE does not affect MATCHES search CTXRULE index
DRG-10836 occurs creating CTXRULE index on nested WITHIN query
ADDR/KADDR column in V$LOCK and V$TRANSACTION_ENQUEUE may not be correct
LMD process size increases monotonously.
ORA-7445 reported when analyzing a partitioned table while an index is being created on the same table concurrently.
This problem is introduced in Oracle9i. TKPROF sorts incorrectly using the sort=... command line parameter
INSERT /*+APPEND*/ into a table with functional indexes inserts incorrect data into some of the columns.
ORA-600 [KJBRCHKPI:PI2] possible
Repeated SELECT FOR UPDATE and COMMIT can leak client side memory.
More LOBSEGMENT space is used for ENABLE STORAGE IN ROW than required when the LOB data does not fit inline.
Precompiler canot open INCLUDE file with spaces in the configuration file.
This problem is introduced in Oracle9i. Inserting over a database link to an 8i database using a SELECT with a loopback database link results in an ORA-2064. Eg: Insert into tab@8ilink select * from tab@loopback_link.
If a table stored in a bitmapped tablespace is truncated whilst a query is running against dictionary space information (eg: DBA_SEGMENTS) an ORA-600 [kcbgtcr_4] may occur.
The ORACLE_SERVICE.env file generated by pfssetup has incorrect path
As of Oracle9i, queries against Fine Grained Access enabled objects always execute the policy function to make sure most up to date predicate is used for each policy (unless the policy function is defined with STATIC_POLICY=TRUE). This enhancement enables users whose security policies do not return different predicates within a database session to eliminate re-execution of the policy. A new hidden init.ora parameter _dynamic_rls_policies can be set to FALSE to reduce the execution overhead. For deployment environments where latest application context value is always the desired value the new hidden parameter _app_ctx_vers can be set to FALSE.
SUBQUERY UNNESTING can lead to NON-MERGABLE views
Spin in KKSFBC possible when CURSOR_SHARING=FORCE
Array insert may be slow with multibyte characterset (affects ProCobol PICX=VARCHAR2)
Integrating server may error with ORA-600[17182] on executing COMMIT after fetching a CHAR field from DB2 database through HS.
Hang possible on "global cache S to X" escalation where all downconverts are complete and the escalation is grantable but is not granted.
ORA-600 [KJFCRFG:!QRY] during reconfiguration
Switchover to primary may hang if there is a background managed
recovery session active.
Workaround:
Cancel managed recovery and then do the switchover.
Direct load of an IOT with OVERFLOW can produce a corrupt IOT.
ALTER SYSTEM SET parameter=value sid='*' does not set the value on all instances.
FULL optimize may fail with ORA-600 [7001] when run on an index with prefix indexing and either field sections or attribute sections
Inappropriate error messages possible while setting compartments/groups, before setting levels or dropping unauthorized compartments/groups
Some OLS SYNONYMS are not setup correctly
Under Oracle Label Security option, update or insert of a child row may fail unexpectedly with "ORA-28117: integrity constraint violated - parent record not found" if the parent has some fine-grained security policies.
Instance may crash with ORA-600 [KCLFLUSHED_1]
Enhancement: The defineColumnType() method of oracle.jdbc.OracleStatement has a max_size argument which by default is interpretted in BYTES. This enhancement adds a property to allow the max_size value to be specified in CHARACTERS for multibyte environments.
CBO misses cost reduction due to sort elimination if the ORDER by clause contains a virtual column (such as a Text SCORE() column). In case of FIRST_k_ROWS mode CBO could miss a good plan.
Cardinality for CONTAINS() querying a phrase containing one or more stopwords shows a cardinality of 1 when the actual cardinality is alot bigger.
Multi threaded HS agent may crash
Scheduling propagation on a private database link results in ORA-2019.
ORA-3113 / ORA-3114 should map to XAException.XAER_RMFAIL under JDBC XA
SQLPLUS can dump with "internal heap error 17112" if Ctrl-C used at logon
CTX_DOC.HIGHLIGHT() may spin highlighting a nested WITHIN text query
ORA-604 / ORA-1 can occur during ALTER TABLE DROP COLUMN (while recursive sql is updating col_usage$).
It is not always possible to force star transformation using the FACT hint due to cost checks on the proposed fact table.
Following an upgrade SMON may core dump while trying to cleanup objects marked as non-existent in the database where new fixed objects have been introduced in the new Oracle version that share the same name.
Transporting a tablespace that still has files in Oracle7 format can result in an ORA-600:[ktfdtsex1] when importing the metadata.
ORA-4031 possible trying to start the Cache Advisory during run time. Workaround: Set db_cache_advice to READY in the parameter file. This will reserve memory for the cache advisory and avoid having to perform a runtime allocation. Before the measurement interval, set db_cache_advice to ON (via alter system). Once measurement is complete, transition back to READY.
Statspack does not class "QUEUE MESSAGE" as an IDLE wait event
ORA-1457 possible when trying to fetch the numeric data over a database link using OCI7 for NUMBER(x,y) columns. Workaround: Redefine the column as NUMBER with no scale/precision
TEMPORARY LOB leak can occur, especially when using USER DATASTOREs in Oracle Text.
Select containing a partition table may signal ORA-604 / ORA-942
Reading CLOB data from multibyte database (eg:UTF8) with JDBC Thin may signal ORA-6502
Passing a PLSQL collection (varray or nested table) to EXTPROC dumps rather than reporting that this is not supported.
This problem is introduced in 8172. Data corruption possible with CTAS or INSERT..SELECT across a DB link where one of the SELECTed items is a literal constant
Primary Key / Unique validation is sub-optimal when there is a non-unique index already on the key.
@ This problem is introduced in 8170 with the fix for bug:1223775. CBO may use Nested Loops (NL) instead of Sort Merge Join when PARTITION_VIEW_ENABLED=TRUE leading to sub-optimal plans in some cases.
ORA-600 [KCBKLBC_3] possible due to race condition
Auditing RENAME statements may fail to audit the first RENAME after the audit is turned on . Workaround: Flush the shared pool after the AUDIT RENAME is executed.
When using match pattern as *[*], XSL processor may throw a null pointer exception.
Timing window can lead to a hang with a stuck global cache lock escalation. Eg: Session stuck forever on "global cache s to x"
Memory corruption can occur when a query has a predicate comparing a character column with numeric constant. Workaround: Set "_use_column_stats_for_function"= FALSE
Dump possible in KKEPSL
ORA-600 [KKXPITYP1] possible on select from TABLE() operations
Dump in QCDLGTD possible during select from a view owned by another user
Query rewrite may not occur if DECODE used
Running OJMS with old JDK (1.1.X) can dump using the OCI driver.
During an alter index split/rebuild or a move of an IOT, a process might core dump (in KDICDRV) should the library cache information be flushed out of memory.
A datafile resize (shrink) will fail if the tablespace
to which the datafile belongs is in backup mode.
We correctly report error:
ORA-3298: cannot shrink datafile
However the values in the dictionary are incorrectly
updated to the new values regardless of this error.
For cross registered cluster configurations that do not enable shared servers, most connections will be routed to one node.
Some predicates such as " <plsql expression> BETWEEN column1 and column2" fail with ORA-600[qcsrwae1]
Queries with CUBE and PERCENTILE may dump in <Function:evacom>
ENHANCEMENT: Make library cache pin cleanup code more robust. In cases of process death it is possible for a library cache pin to be left in a state which will cause PMON to crash. This enhancement should make this less likely to happen.
ORA-08102 index key not found possible on UPDATE of a PARTITION table with a FUNCTIONAL INDEX if the partition index was created in PARALLEL as the index is corrupt.
Union-rewrite may result in ORA-1722 or strange errors if the union-rewrite would produce a text over 64K long.
V$SQLTEXT.sql_text and V$SQLTEXT_WITH_NEWLINES.sql_text show the incorrect value or unreadable characters if the 64th byte of sql_text is the first byte of a multibyte character.
XML schema processor does not check for duplication of local definitions
The destructor of OCCIRef may dump if it points to a newly created object which has not yet been flushed.
An empty string or NULL in an INLIST can cause excessive shared pool memory use / ORA-4031 due to OR-expansion.
Connect data (tns address string) with a length greater than 230 characters, in conjunction with pre 9i MTS (8.1.x or 8.0.x) can cause connections to take a long time
Importing a table containing ROWID columns into an ASCII database from an EBCDIC format dump file (or vice versa) fails with IMP-00082
V$RESOURCE_LIMIT.LM_CACHE_RESS/GESS_CACHE_RESS may show the wrong value.
LMON might encounter ORA-600[kjrchc:resp] just after the shutdown of another instance.
ALTER SYSTEM SET AQ_TM_PROCESSES=0 may not shutdown QMN processes if issued immediately after database startup.
Internationalized characters for attribute values are not retrieved correctly via DBMS_LDAP_UTL if the OID database is not UTF8.
Authenticate may issue unnecessary LDAP calls.
An ORA-600 [KPOSCWS0] may be signalled if an application uses OCIStmtFetch2 to fetch from a scrollable cursor when there are trailing nulls.
SQL statement using WITH clause with a UNION signals ORA-604 / ORA-918: column ambiguously defined
Rows may be returned in the wrong order if the rule-based optimizer is used for a query with special sort options (eg ASC NULLS FIRST) if the sort gets replaced with an index scan.
iSqlplus background color is GRAY on some browsers
When running under MTS, corruption of the SGA can occur. When running dedicated then PGA corruption can occur. This is caused by a LIKE expression which had as its last character set to the escape character. For example: select dname from dept where dname like :bv escape '/' with :bv containing 'ACC/'. Workaround: Do not use patterns which end in the escape character
This problem is introduced in 9.0. 'ORA-00972' may be returned when issuing a 'GRANT EXECUTE' statement with a long identifier in a 9.0 java-enabled database (with 'compatible' set to '9.0.0')
On some platforms, a PLS-631 may not be issued where it should have been.
An ARRAY insert .. select operation can silently lose data if the cursor is invalidated whilst the statement is executing. Eg: If the cursor is flushed from the shared pool. This silent loss of data is effectively a logical corruption of the data.
This problem is introduced in 9.0. PLSQL CURSOR selecting over a database link and using a BIND variable does not uses the first value of the bind for subsequent executions of the cursor.
If OCITypeByName() is called when the connection to the server is invalid the client program errors with "kgepop: no error frame to pop to for error 21522"
Dbms_snapshot.refresh fails to update CHAR type rows in the snapshot site in a UTF8 character set database if the master is a single byte character set.
A number of sessions may wait longer than needed for the CI-14-5 lock (Release unused space from Sort Segments).
SDO_WITHIN_DISTANCE on projected data signals ORA-29902 / ORA-13213 / ORA-13019: coordinates out of bounds if the distance extends beyond the bounds specified in the user_sdo_geom_metadata.
This problem is introduced in Oracle9i (9.0.1). There is a user privileges vulnerability in Oracle9i Database Server.. See <Note:185074.1> on Metalink
ORA-7445 [KKEHSL] possible with GLOBAL PARTITIONED INDEX and COLUMN HISTOGRAMS present
ORA-24345 possible parsing XML if the error to be reported exceeds 512 bytes.
Online redefine using DBMS_REDEFINITION.START_REDEF_TABLE() of a table whose combined schema name and table name length exceeds 36 characters causes a memory corruption and may signal a false error.
ORA-7445 [RWORIRW2] possible from GROUP BY & ORDER BY on the same columns where one of the included columns is indexed with a FUNCTION BASED index
ORA-3115 possible from JDBC Thin describing a table with
TIMESTAMP based columns ('INTERVAL YEAR TO MONTH' and
'INTERVAL DAY TO SECOND'). Note that JDBC Thin does not
support access of these datatypes but should not report
ORA-3115 just describing a table containing them.
Dump / bad data values possible using a
TRUNC function as a GROUP BY key in an inner
query block with GROUPING SETS.
eg: select e1, e2
from (select ename as e1, trunc(hiredate) as e2
from emp
group by grouping sets(ename, trunc(hiredate)));
Query rewrite does not occur if the query contains a GROUPING_ID function.
This problem is introduced in 9.0.1.0. V$SESSION_WAIT.WAIT_TIME should be 0 (zero) when a session is waiting for the listed event but in 9.0 releases a value of 0 can occur when a session waited a short time (<10mS) for the listed event. This is a notable issue as many scripts may use the WAIT_TIME column to determine which sessions are on CPU and which are waiting. Workaround: Use V$SESSION_WAIT.STATE to see if the session is waiting.
The row cache poll time in the foreground for acquiring an instance lock is too big (60 seconds). This is a problem since the foreground could miss a post from LCK0 before it goes to sleep thus waiting 60 seconds unneccessarily.
Bind information is passed to the server on each execute in UPI mode even if that information has not changed so need not be passed.
Phrase searching using nested WITHIN on XML document can returns false hits.
SQLPLUS dumps when Oracle software is installed in a path longer than 80 characters on Windows platforms.
This problem is introduced in Oracle9i Release 1. PLSQL LPAD / RPAD with length >65535 actually pad to the specified length modulo 65536.
CREATE OR REPLACE SYNONYM may not update the TIMESTAMP in the dictionary.
This problem is introduced in 9i. When loading into a (partitioned) table in direct path, with multiple INTO TABLE clauses referring to the same table and different columns of the table being loaded depending on the WHEN clause, SQL*Loader may report ORA-600 [6937] / SQL*loader-961 / ORA-600 [kcblrr_1]
Dump in PEPLMUFC_UNREG_FROM_CLEANUP possible using serially reusable packages compiled native.
Sun: Real Application Cluster Guard fails on Sun cluster 3.0
A query involving partition view with inlist bitmap predicates against the view takes extremely long time to optimize, and optimization causes high consumption of PGA memory.
ORA-600 [kdicwpre_0] possible during create FUNCTION BASED INDEX with an ADT expression
It is not possible to precreate a non-partitioned table and import a partitioned table into it if the partitioning option is not enabled in the database (ORA-439 signalled)
Incorrect results from ABOUT operator in CTX_DOC.MARKUP
Select count(*) from a nested and complex view with GROUP BY in inner views may dump in <Function:evaopn2> .
Attempting to set pga_aggregate_target over 4000Gb should error with ORA-4032 but no error is signalled.
Wrapped PLSQL does not error when forward references
are used in SQL for PLSQL functions when it should.
Unwrapped PLSQL errors as expected.
Eg: create or replace package pkg6a as
cursor c is select f(dummy) from dual;
function f(arg NUMBER) return NUMBER;
end;
/
is expected to error, but does not if wrapped.
RMAN LIST command incorrectly shows level-0 backups as full backups.
Collection of BITMAP SEGMENT managed bug fixes
Column comments are not exported correctly if there are UNUSED columns in the table. Column COMMENTS may be lost after import.
ORA-8103 possible from PQ on bitmap managed segments with concurrent inserts.
JavaSSL may crash in multi-threaded programs in a call to write.
ORA-4031 / excessive "miscellaneous" shared pool use possible due to a single process acquiring a large number of PINS on a single library cache object. This is known to affect the XML parser.
A query using a multi-column INLIST (or OR list), where one of the columns in the INLIST is the partition key of the table, may prune the wrong partitions resulting in too few rows.
ALTER INDEX "username".indexname REBUILD ONLINE signals and ORA-604 / ORA-903 / ORA-911 error if the "username" begins with a non-alphabetic first character. This is also the case if connected as "username" and using "ALTER INDEX indexname REBUILD ONLINE".
This problem is introduced in 9.0. ORA-7445 (in kkeccomp) possible from queries which have predicates that use user-defined functions. Workaround: Set event 10106 level 1
When inserting into a table with primary key constraint enforced via a non-unique index an ORA-600 [6034] may be reported.
Select over database link 9i -> 8i using a DRIVING_SITE hint and binds after having done a describe (OCI_DESCRIBE_ONLY) on the same query can hang. This issue can cause snapshot REFRESH to hang.
Export / Import do not support mixed case USERNAMES in the specification of a TABLE in the TABLES= clause. This can result in a false "EXP-00010: <schema_name> is not a valid username" error.
Creating a new module for informix gateway using the generic connectivity in OWB 9i results in the errors - ORA-604 & ORA-1843 with a trace file showing ORA-600 [17271]
Wrong results possible STAR_TRANSFORMATION_ENABLED=TRUE when TEMP table is generated. Workaround: Use STAR_TRANSFORMATION_ENABLED=TEMP_DISABLE
Dump possible in <Function:nszgclient> for some RAW connections
ORA-600 [KKDCACR2] possible from PDML with CHECK CONSTRAINTS
Policy names which are 30 characters long are unusable (ORA-12446 errors)
Dropping an OLS policy on a table with an active transaction prevents logins. The only way to repair the problem is to end the transaction, and then drop the policy. Until both occur, no new logins can happen.
ORA-600 [QCTCTE1] possible using INLIST predicates
CONTAINS() query using INPATH operator on XML document with nested elements with the same name misses some hits.
When you change the transaction isolation level to say, SERIALIZABLE on logical connection CONN1 and then later you obtained logical connection CONN2 it is possible that CONN2 inherits the SERIALIZABLE behavior set for CONN1, even though that's not desired.
When using the JDBC cache to cache XAConnections using the XAConnectionCacheImpl datasource then the inactivity timeout does not close the XAConnections after a period of inactivity.
When using the JDBC cache, OracleConnectionCacheImpl, the inactivity timeout on physical connections (PooledConnection) does not work. (Inactivity timeout is turned on by setting the cache property CacheInactivityTimeout or by calling its set/get methods.)
LRM-00101 possible for <INSTANCE_NAME>.THREAD parameter
A change was introduced in 817 which means that transitive predicates are not always generated in the presence of outer joins.
The demo file 'tracedemo.sql' uses 'connect internal' to connect to the database.
Query rewrite does not occur for rollup operations if there is a window function present.
A core dump can occur in qerixGetKey() if a query uses a function based index when there is a Materialized View on the base table and QUERY_REWRITE_ENABLED=TRUE.
Parallel execution of star transformed query block with an outer join may produce a parse error (ORA-1799).
The RENAME statement can mess up the tablename in the trigger definition of related triggers. This is effectively a dictionary corruption. This can show up as symptoms such as: 1. incorrect table name in ***_triggers.DESCRIPTION column 2. Import failing with ORA-942 when creating the trigger 3. ORA-972 on a later rename table
Wrong results possible with select over dblink involving single byte/multibyte databases and a hash join.
CBO may choose not to use functional invokation
of DOMAIN INDEX functions when it would be quicker
then a DOMAIN INDEX scan.
eg: For Text queries of the form:
select date from table where contains(col, 'dog')>0
order by date desc ;
The estimated cardinality of an Oracle Text index when processing a phrase query may be much too high.
CBO may pick Nested Loops (NL) with a Full Table Scan on right side when a hash join or sort-merge-join would be a better option (to avoid repeated full table scans).
Queries on tables having descending indexes sometimes dump during runtime or give incorrect results. The column with the descending index has to appear in the query.
CONTAINS('haspath(//<element tag> = "<any stopword>")')>0 returns
an ORA-3113 error and dumps in DRYUEW.
Using dbms_session.reinitialize, especially under high load conditions, may result in server-side core dumps.
XSL PROCESSOR and STYLESHEET hold on to references to input document elements leading to potential memory growth.
This problem is introduced in 9011. Parameter SHARED_POOL_SIZE may not show the value actually specified in the init.ora file but may show a higher value.
RMAN cannot backup the database when excluding a tablespace which is of a non-standard block size.
Import memory leak importing BFILE data
This problem is introduced in 817. Memory leak / growth for some queries using repeatedly restarted index scans.
This problem is introduced in 9012. ORA-600 [kxfrExtInfo2] is encountered while doing parallel query on a table in a locally managed tablespace.
IMPORT with TOUSER=non_existing_user DROPs tables in the connected users SCHEMA. This can result in lost
PROC generates a precompiler error when the new SQL syntax
"UPDATE OF ... WAIT" is used in an embedded sql statement.
eg: PCC-S-02201, Encountered the symbol "wait" when expecting
one of the following ...
Precompilation of Pro*C programs with SQL using 'case when' or 'for update of ... wait ...' fails with PCC-S-2201 error.
Export fails with error ORA-1406 during export of partition tables when default value of the column is more than 2000 bytes.
OERI:qctcte1 / ORA-979 from multi-hierarchy query using materialized view.
Processing of a stylesheet with "with-param" element reference using $variable without bindings can dump or signal LPX-0406
Slow parse time due to unnecessary text based rewrite for UNION-ALL expanded query block.
Dump possible in multithreaded JDBC OCI client with JDK 1.3
Select on a bitmap segment space managed table can encounter ORA-600 [ktspemap-d] / ORA-600 [ktspemap-b] internal errors.
Export / Import of a composite partitioned table loses the associated value of SUBPARTITIONS and defaults to 1.
INSO_FILTER cannot filter some PDF documents
Memory leak using JMS API to AQ
TEMP LOB leak passing TEMP LOBS in recursive SQL ("lob ctl struct" grows)
The count in V$TEMPORARY_LOBS can be seen to increase.
Import of a table that was created in a read only tablespace will fail with ORA-1647, cannot allocate space in it, instead of importing it into the default tablespace of the user specified in the TOUSER clause.
RESOURCE_LIMIT = true can result in ORA-2394 even if logical_reads_per_session is set to unlimited
UGA memory leak possible using Oracle Text CONTAINS() operator
When a database is shutdown and restarted while an application is allocating and deallocating descriptors a core dump occurs while allocating a descriptor.
ORA-1679 can occur when activating a standby database if it has previously been opened in read only mode, and then mounted .
Alter system disconnect session results in ORA-3113 rather than ORA-28 when running under MTS.
Granule size does not get larger after increasing sga_max_size
OCCI objects with string attributes can leak memory
ORA-600 [QES3TPINTT2] possible from a GROUPING SET query using TEMP TABLE TRANSFORMATION
This problem is introduced by the fix for Bug:1987692. It only affects 8.1.7.2 where the above fix has been applied. When creating index or synchronizing a Text index a large memory leak can occur in the PGA. Size of memory leak is proportional to size of data being indexed/synchronized.
"free buffer waits" / LRU latch contention possible on write intensive systems.
If a Text query expression includes a FIELD SECTION search, the cardinality returned to the optimizer is always 1.
Dump possible in <Function:updpre> if a trigger references an ADT column but the main DML statement only references some fields of the ADT column.
Loading PACKED DECIMAL data into a column of type NUMBER sometimes loads incorrect values.
When analyzing a unique secondary index defined on an index-organized table with primary key size > 129 bytes, the server process may dump.
Distributed queries can get ORA-1555 but may report this as an ORA-600 [QERRMOFBU1] [1555].
The READTIM and WRITETIM columns of V$FILESTAT are not maintained for datafiles belonging to a temporary tablespace. Workaround: Use TEMPFILE files for temporary tablespaces.
Star_transformation_enabled=true can cause ORA-600[KKOJOCOL:2] if a query involves at least one view and there are duplicate table aliases in use.
Some combinations of recovery commands can generate two offline ranges which have the same offline scn but a different online scn. In this situation RMAN cannot resync the controlfile information into the recovery catalog and fails with RMAN-20087.
This problem is introduced in 9.0.
JDBC DMS datasource metrics all have the same name even if the name of the DataSources are set to unique values
LMS process may die with ORA-600 [KSXPWAIT10] in a RAC cluster under load.
Text queries using ABOUT and ctx_doc.themes() against THEME_LANGUAGE=French knowledge base do not use all appropriate themes.
DBV loops infinitely on the same block reporting it as corrupt when the block type is corrupt.
IMP-20 possible importing COMPRESSED KEY IOT from a direct export.
This problem is introduced in 9.0. Dump possible from a reverse key concatenated compressed index.
RMAN VALIDATE BACKUPSET...CHECK LOGICAL may incorrectly report that "Undo data block" blocks are corrupt. (ORA-19661)
This problem is introduced in 8170 and 901.
Exporting a trigger on a table with an unusual tablename
will cause IMP-3 / ORA-931 errors during import.
Eg: If the table contains "/" or similar characters
such as "/lolo/tab"
Memory corruption or internal errors (eg: ORA-600 [KGHFRE2] / ORA-600 [17172]) can occur then using bitmap indexes when there are more stop keys than start keys.
This problem is introduced in 8171. When using array inserts in OCI_BATCH_ERRORS mode in 8.1.7.1 and up, the server will sometimes encounter ora-600[kcoapl_blkchk] error if block checking is on (or may dump without it).
RAC - Space in BITMAP managed segments freed in one instance not used in another instance
In RAC mode a lock context leak can cause the shared pool to be filled with lock contexts resulting in a hang with a process holding the KCL instance latch.
ORA-29516 possible from Java stored procedure accessing large ADTs
Multi-hierarchy MV create may dump
Issuing 'commit comment;' or 'commit work comment;' with no comment text signals an "ORA-2236: invalid file name"
XMLLOAD.SQL does not create a public synonym for XSLPROCESSOR
SA_USER_ADMIN.SET_DEFAULT_LABEL() method does not reset the DEFAULT_ROW_LABEL property
ORA-600 [13009] occurs on 'select for update ... nowait' if the row spans multiple blocks and the head piece is locked but it is not possible to get a row lock on a subsequent row piece (eg: due to all ITLs being in use and no space to get a new ITL)
Dump (in pfrins) possible if SQL strings in PLSQL stored objects are specific sizes
"java.sql.SQLException: Internal Error: Image is not a collection image" is thrown whenever an Object with an attribute as collection is selected using JDBC (thin or thick)
Hierarchical queries with "ORDER SIBLINGS BY <column> DESC" clause can return incorrect results (too few of records). Workaround: Remove the ORDER SIBLINGS clause
ORA-600[srsget_1] can occur when running query on partition table.
ALTER TABLE allows you to add a LOB column to Hash Partitioned IOT when it should signal an error instead as LOB columns in such tables are not supported. This is effectively a dictionary corruption which can cause problems with subsequent operations on the table.
iSqlplus output may be incorrectly spaced
ORA-29506 possible creating JAVA from table column with VPD policy on the table.
Dump possible when AND_EQUAL hint has only one index.
Workaround: Correct the hint as it must specify at
least 2 indexes
ORA-600 [2749] is possible on OPEN RESETLOGS or on ACTIVATE STANDBY DATABASE on certain platforms (such as MVS) due to rounding up of file sizes on such platforms.
In special cases, SQL*LOADER reports wrong number of loaded rows when a space error and a data-dependent error occur.
Document filtering may fail if the database character set is not one of the following: JA16EUC, JA16SJIS, US7ASCII, WE8ISO8859P1, EE8ISO8859P2,SE8ISO8859P3,NEE8ISO8859P4,CL8ISO8859P5, AR8ISO8859P6,EL8ISO8859P7,IW8ISO8859P8,WE8ISO8859P9, WE8MACROMAN8,CL8MACCYRILLICS,TR8MACTURKISHS, ZHS16CGB231280,ZHT16BIG5,KO16KSC5601
ANALYZE .. COMPUTE STATISTIC for a table with an XMLTYPE column which is Text indexed results in a dump (in qcopgcty)
When an IO error occurs on a file DBW takes all files in the tablespace offline - it should only offline the affected file.
ORA-600 [2662] possible on new TEMPORARY index block
SQL*LOADER-510 error misleading if the erroring data is in the loaded controlfile
ORA-1418 possible from a PQ Slave for query on a table with a domain index
When using XA, sqllib and the Pro*c code is in a DLL , and the DLL is downloaded before ending the transaction an application error occurs.
DRJOBDML.SQL is missing a COMMIT causing the DBMS_JOB not to run
Unnecessary re-parse of cursors occurs for VPD predicates at execution time (a reparse occurs for each execution)
If a user's default tablespace is dropped with the INCLUDING CONTENTS option then indexes for any temporary table are also dropped, though the temporary table is not dropped at this time.
JAR files containing PRIVATE FINAL methods cannot be loaded
DROP TYPE .. FORCE may error with ORA-600 [kdic_mark_index_disabled1] if an index has been built using the type.
An internal error or a user interrupt of a Star Transformation query may cause OERI[150] and trash the process stack. When this happens, the subsequent stray memory writes may cause random memory corruptions including possible writes into the buffer cache or other SGA areas. This can only occur when the star transformation generates TEMP tables. Workaround: Set STAR_TRANSFORMATION to FALSE or TEMP_DISABLE.
Materialized view refresh in parallel can fail with ORA-12838
With a FIRST_ROWS hint, when probe and build tables of a hash join are swapped, an ORA-600 [KGHALO],[0x0] can occur.
Tables containing primary key based REF column data in Oracle8i cannot be exported and then imported into Oracle9i as 9i rejects the rows on import.
HTML output for DESCRIBE of object types may be invalid.
This problem is introduced in 9i. "ORA-30353: expression not supported for query rewrite" is signalled when attempting to create a materialized view with a CAST operator in the select list.
A spin can occur when an index is dropped while being accessed by other sessions. This leads to continuing access to the root block of that index and the creation of many "clone" buffers for that block.
Code which fetches objects which are subtypes from the database using JDBC run slowly. A large number of entries are created in the cacheDescriptor instance variable in the oracle.jdbc.driver.OracleConnection that is used for the retrieval.
Contention for a child library cache latch from location "kglget: child: KGLDSBYD" when performing heavy selects of pseudo columns implmented as PLSQL functions.
If a standby database is set at a different compatibility release than the primary then adding a standby logfile fails with internal error ORA-600 [2765]
IMP-46 / IMP-40 possible attempting to import MVS export to another platform
If a backup fails, RMAN may delete valid backup pieces.
Class violation internal errors such as ORA-600 [kcbgcur_9] are possible during TEMP space operations.
ORA-979 can occur if a GROUP BY is used in a sub-query of a heirarchical CONNECT BY loop.
Hang during startup after ticket starvation in LMON
ORA-600 [KJBFLUSHCLAIM:!GMP] possible
XA_OPEN does not support OCI_EVENTS so OCISubscriptionRegister
may dump or signal ORA-1010
This fix adds a new XA open string parameter: "Events"
Usage: Events=true/false in the XA open string.
Events
true/false
Specifies whether the application is going to use events.
The default value is False. If the application is going
to use events, then this option should be True.
Usage note: if threads are also being used (Threads=t in
the xa_open string), then each thread must make its own
connection to the database. Since the notifier runs in
a separate thread, it will need to make a connection,
either through xa_open or normal connect, if it needs
to access the database.
An execution plan with a bitmap access on the top of a full b*tree index scan can produce a wrong result , if all the columns of the b*tree index are nullable.
DBMS_LDAP_UTL.GET_SUBSCRIBER_PROPERTIES() does not return default user properties.
Wrong results possible using TIMESTAMP column predicate in Parallel Query
ORA-00600 [KZASPS1] possible calling DBMS_REDEFINITION.START_REDEF_TABLE with AUDIT_TRAIL enabled
Dump possible un-nesting a table (using TABLE() clause)
V$DISPATCHER_RATE may show zero values for CUR_* columns
This problem is introduced in 9i. LIKE with binds and the ESCAPE option does not work properly. Eg: "LIKE :bind1 ESCAPE :bind2"
The display URL used for email documents may be truncated, resulting in email rendering being broken.
An auto segment space managed tablespace cannot be plugged in to a different platform. This is an enhancement - this ablity is not supported on releases without this fix.
SQL*PLus may dump on a 'show errors' command for an errored PL/SQL block, which contains comments between the package type and package name.
"Statement Caching is not enabled" exception possible in JDBC (thick or thin drivers) for OracleConnectionPoolDataSource()
ORA-600[17099] possible during java transaction forget
Wrong results possible from Oracle Text queries with FIRST_ROWS hint if CBO chooses a bitmap operation in the query execution plan.
ORA-24374 possible using 9i PRO* client against an 8i server
Pro Cobol Dynamic Method 4 application with DESCRIBE BIND VARIABLES statement may core dump, hang or get ORA-2111 at runtime.
FULL optimize on an index with PATH_SECTION_GROUP may fail with DRG-50608: unexpected end of data errors
Poor execution plans are possible for queries with joins to partitioned tables, where the join could result in partition pruning, after setting optimizer_index_caching > 0.
This problem is introduced in 9.0. Direct Load using ROWS option shows poor performance when compared to earlier releases.
Tolerance is not being consistenly used in the "within_distance" operator. . Workaround: Set the tolerance to 0 in the user_sdo_geom_metadata.
Calls to getConnection() on the connection cache data source may fail, when invoked with user/passwd names whose case does not match with that set in the data source properties. Also an "invalid argument exception" may be thrown if setCacheScheme() is invoked with string cache names.
Create Materialized view may fail with ORA-955 if the view was previously created and dropped.
Allow value Tag in Domain Component (DC) to be VT_PRINTABLE_STRING
ALTER SESSION SET CURRENT_SCHEMA does not work for KPRB Java driver
AUTOTRACE EXPLAIN has incorrect indentation in HTML mode
If a "alter session set current_schema=<SOME_USER>" is done from a definer's rights procedure/trigger owned by the **same** <SOME_USER>, then the alter session doesn't take effect. This is incorrect because the session itself might be running as <SOME_OTHER_USER>.
@ Originally incorrectly listed as fixed in 9012. CREATE or REPLACE does not need to INVALIDATE dependents if the object being replaced is already INVALID (as the dependents will already be INVALID). This can improve performance of CREATE or REPLACE of an INVALID object with many dependents.
Temp Lob leak on enqueue/dequeue of message with transformation function which returns an ADT that contains a TEMP LOB.
JDBC connection cache has no timeout mechanism
ENH: Faster GROUP BY for multi-column GROUP BY clauses. This fix introduces a hidden <parameter:gby_onekey_enabled>. _gby_onekey_enabled should be set to TRUE to enable this feature. It causes GROUP BY operations to use less calls to "memcmp" when checking for different grouping keys when using multiple columns as the key.
Improve query rewrite support for multiple hierarchies
SQL%BULK_ROWCOUNT may be incorrect when not using SAVE EXCEPTIONS
Array insert to table where the primary key is implemented using a non-unique index rolls back all rows on hitting a constraint violation, rather than leave the rows already inserted in the table.
ORA-29339 trying to "CREATE TABLESPACE" with 32K blocksize even though a pool is configured.
CBO may choose an inefficient plan if a query references a partition view whose base columns have statistics gathered with histograms.
OERI:730 / DBW may die with ORA-603 on shutdown. This does not affect the shutdown of the database itself (the shutdown is a clean shutdown).
Text searches may dump for database migrated between 64bit and 32bit. This occurs for functional invokation of the CONTAINS (and other) operator.
A core dump can occur when running a program which is linked to both libclntsh.so and nCipher PKCS #11 code due to a symbol clash for the symbol "C_Digest".
Partition pruning ignores predicates at individual nodes of a BITMAP tree. This can affect performance.
A core dump is generated when calling sdo_lrs.offset_geom_segment on a closed LRS linestring and passing a negative offset.
Removing an AQ subscriber with non null rules does not remove the already enqueued messages with non null rules.
Conversions from RAW to LONG (or vice versa) are not done with a RAW2HEX-type conversion as expected.
OJMS administrative objects: connection factories and destinations should be Serializable so that they can be set across the network to application clients of OC4J.
Concatenation of ROLLUP query with max/min aggregate run in parallel gives ORA-600 [rworupo.1]
Execution of a query having count(column) in a select list may dump (in QERIXGETKEY) if the column has NOT NULL constraint, is referenced in WHERE clause, and the query block is merged with a view query block.
CKPT may die with ORA-600 [kcbkllrba_3] in a RAC environment.
SDO_FILTER and SDO_RELATE with an ANYINTERACT
mask give the wrong results when the window
is the view_port for the whole world:
SDO_CS.VIEWPORT_TRANSFORM(mdsys.sdo_geometry(2003,0,NULL,
mdsys.sdo_elem_info_array(1,1003,3),
mdsys.sdo_ordinate_array(-180.00,-90.00,180.00,90.00)),8307).
ORA-600[KSKBIND1] may be signalled if using both Resource Manager and Shared Servers (MTS) with trusted callouts (eg: Oracle Text).
ORA-1810 or ORA-1821 can occur in multithreaded OCI clients
First scan after direct load into bitmap segments is slow.
Large parallel direct loads are slow when bitmap segments are used and the owner of the segments has a finite quota on the tablespace containing segments.
push_join_predicate = TRUE can cause a huge memory consumption and spinning during a query optimization if a "pushed" view has multiple instances of the base table columns.
ORA-600 [KCBZPB_1] possible in PQ slave
When the number of shared servers that remain bound is greater than or equal to the configured optimal number of shared servers and no requests arrive on the common queue or are completed for some time, PMON may shutdown all of the shared servers that are waiting on the common queue. This can result in a significantly degraded response time when a new request arrives.
QUOTA_SIZE restriction for LOG_ARCHIVE_DEST_N does not make sense in a STANDBY database so should not be enforced.
ORA-600 [KCLCHKBLK_3] possible in RAC after reconfiguration
SELECT .. FOR UPDATE SKIP LOCKED may miss rows when the columns involved come soley from an index
Multithreaded Net8 client might get a false TNS-12154 error during the name resolution.
Export uses incorrect syntax for GRANT operations for JAVA SOURCE and JAVA RESOURCE objects. This shows up as ORA-4042 errors at import time.
ORA-1455 possible when exporting associations
Grouping distinguisher operators in the form of gid + bin_to_num(0,0,grouping(col1),grouping(col2)...) in an insert statement with ROLLUP run siginificantly slower than the insert statement without the operator.
ORA-600 [KJCCGMB:1] possible after reconfiguration
Processes executing long running DDL statements may return an ORA-600 [kcbgtcr_4] when one of the referenced objects is dropped or truncated by another session. With the fix an ORA-8103 error is raised instead.
Wrong results are possible from queries against
views with set operations that have window functions
in different branches.
Eg: select ro from
(
select '1' dummy, row_number() over(order by dummy) ro from dual
union all
select '1' dummy, row_number() over(order by dummy) ro from dual
)
where ro is null;
return 2 rows.
PL/SQL may incorrectly give a PLS-306 (wrong number or type of arguments) error where some overloadings of a given identifier are first declared after but in the same scope as the reference.
When there is a default label and default row label set using "sa_user_admin.set_user_label()", then the procedure is allowing default row label to dominate default label.
getAttempts() method is not public
Wrong results are possible from queries with star transformation using temporary tables if there are multi-table joins against a fact table column. Workaround: Set star_transformation_enabled = temp_disable
Doing wildcard queries on CONTEXT indexes where there is also a function-based index on the $I table is very slow.
This problem is introduced in 817 (unconfirmed). OERI:17112 / heap corruption from Oracle Trace with MTS & Large Pool Workaround: Turn off Oracle Trace if it is not being used.
RAC load balancing does not work if a bunch of connect requests arrive at the same time and the nodes are currently equally loaded.
Dump in KSQEQH possible
Setting a cache size with OracleConnection setStmtCacheSize() causes JDBC exceptions on subsequent SQL operations. Workaround: Set the cache size to 0 (disabled).
Dump in ktusta possible during extension of offline system managed undo segment (SMU).
Unnecessary temp table buffer cache flushing with PQO. Can impact performance.
SDO_MIGRATE.TO_CURRENT in 9i requires 8i format tolerance values in the user_sdo_geom_metadata view
ORA-932 can occur in parallel query slaves if the query being run had a join where there is a descending index on one of the columns.
SNPx processes may dump (with SIGFPE in kwqjaq) when AQ is used.
A query involving an inlist optimization may return a wrong result if the inlist contains a correlation variable, and the first element of the inlist is a constant. Workaround: Disable the inlist iterator by setting <Event:10157>
Statements which use a NESTED LOOPS join with the right table as X$KTFBFE uses large amounts of PGA memory. This internal view is referenced from <View:DBA_FREE_SPACE>
If a database has multiple logfile members and if the first logfile member has a corruption in the file header, recovery will fail with internal error ORA-600[ksfdchkfob1], even though there might be perfectly good redolog members which could be used for recovery.
False XSD-2035 possible from XML Schema validator
Wrong results possible from ROWID predicate with Bitmap Index FFS.
Eg: select /*+ index_ffs(foo foo_bm_ix) */ count(*) from foo
where rowid is null;
can return rows when it should not.
When the login user of Ultra Search admin GUI is different from the instance owner(e.g. Login as 'wksys' and use the instance 'wk_inst' which is created by the user 'wk_test'), then an SQL Exception is thrown when accessing 'Queries Statistics' and 'Top 50 queries' JSP pages.
Creating a Materialized view based on a query having RANK function with PARTITION clause spins.
Add an internal error to check for bad internal values to enable early detection of variants of the issue in Bug:1711803
OCCI: Ref of an object gets the object from the local cache
if the object has been modified and committed. It should
get the object from the database in case some other
application has modified the object since the commit.
ORA-1979 on logon with default roles having nested, password protected roles. Workarounds: Do not use the "all except" syntax; or Do not make the child role password authorised.
A compound query (UNION ALL) against parent tables that have DOMAIN indexes defined against them may signal ORA-600 [qeroiFirstPart2]. This affects Oracle Text indexes.
There is a memory leak in nzosGetBase64CertChain() which is used in MOD_OSSL.
ORA-1461 possible with Fine Grained Access control if the SQL text length exceeds 4K
This problem is introduced in Oracle 8.1.7. Creation of interMedia Text index can use excessive CPU compared to 8.1.6 especially when there are large numbers of distinct text tokens being indexed.
Compiling a PL/SQL block with either
:bindvar INDICATOR :indvar
or
:bindvar INDICATOR var
syntax will corrupt memory.
While rebuilding a partition of a functional index (B*Tree) which is local partitioned , partition pruning is not used on the underlying table . Also indexes on the underlying table are not used so a FULL TABLE SCAN occurs for the rebuild.
This problem occurs with the fix for bug:1805146 installed. Drop and recreate of a function-based domain index returns ORA-604 / ORA-1.
A core dump can occur when a relate query is issued against LRS points with a 3D R-tree index (sdo_indx_dims=3).
GRANT operations can be very slow (compared to Oracle7)
ORA-600 [26599] possible when shortname translation occurs in a recursive session. eg: On a recursive GRANT.
Procobol generated files after 09/SEP/2001 have compilation problems on some platforms (eg: on NT & OS/390).
The branches in a tightly-coupled distributed transaction can erase each other's work if executing in parallel leading to logical corruption. Workaround: 1. Serialize access to the branches. or 2. Use loosely-coupled transactions.
Block corruption / ORA-600 [kcoapl_blkchk] can occur if a user session performs block level recovery when it encounters a dead transaction, and SMON is simultaneously cleaning up the same transaction.
Dump in KOPUTILASSERT() possible using very large collections.
Cannot assign values to TIMESTAMP columns in BEFORE triggers
An unauthorized user can cause trace file output to overwrite or append to a file owned by the oracle owner if the oracle executable has the setuid bit set.. See <Note:163727.1> on Metalink
Oracle Kerberos Adapter does not work with Microsoft KDC
Pro*C may dump when using VALUE semantics with ANSI dynamic SQL
FULL OUTER JOIN of > 2 tables may produce incorrect results.
ORA-1733 possible from SQL after a FUNCTIONAL INDEX on the target table has been dropped.
OCIStmtExecute() returns no error with invalid statement handle. Hence Client application continue process even though statement handle is invalid. It should return ORA-24337. This problem also affects Pro* 8i clients using EXEC SQL IMMEDIATE. Workaround: Reallocate statement handle, if OCIStmtPrepare() fails. In Pro precompile with RELEASE_CURSOR=YES.
TKPROF reports ORA-439 on EXPLAIN of statements with a RETURNING clause
When a function call takes a formal parameter of type TIME, TIMESTAMP or INTERVAL, and that parameter type has no explicit constraints, ANSI says that the default constraints for the type must be used. The constraints are not applied if the ACTUAL parameter passed is a string literal.
ROLLUP query with distinct aggregates and SUM aggregate in a subquery gives internal error ORA-600 [sorexallo_1].
Core dump in CTXKBTC executable when a phrase in the thesaurus already exists in the knowledge base.
Memory corruption can occur during summary rewrite if a select list has an operator on a top of aggregation. Eg: SUM(minutes)/60
This problem is introduced in 9i. Operations from PLSQL over DBLINK to 8i may dump (ORA-7445) in KGLOBLD
Dump possible making HTTPS request with UTL_HTTP.
Text indexes with both alternate_spelling and base_letter lexer preferences can produce incorrect query results.
This problem is introduced in Oracle 9.0. ORA-1436 can occur incorrectly if a CONNECT BY predicate contains an OR clause and the OR clause appears after the PRIOR predicates.
ORA-600 [15212] possible creating a FUNCTION BASED index in PARALLEL.
If direct Loader is terminated by a space failure
then discontinuous rows may be saved when loading
into a (composite) partitioned table.
eg: row 101,104,108 may have been loaded but 102,103,105 etc...
may not have been loaded making it difficult to resume
the load using SKIP=X
Spin in KKOADDPRD possible for some SQL constructs.
ObjectFree needs to be called for BytesMessages. Memory leak during JMS receive of Bytes/Object/Text/Stream message when using OCI JDBC driver
ORA-600 [kjblpwr:sc] possible after cluster reconfiguration
This problem is introduced in 8170. ALTER TABLE MODIFY COLUMN datatype from integer to float may raise an ORA-1440
DBA/USER/ALL_PUBLISHED_COLUMNS views missing
OCI-22625 possible from OCCI setVectorOfPObjects method
XSLProcessor has been fixed to use currentThread.getContextClassLoader() to support multi-class loader. Without this fix it is possible to get unexpected "XSL-1045 class not found errors" in some environments.
This problem is introduced in Oracle9i. Truncate operations on tables or partitions with indexes can leave an incorrectly formatted index root block. This can lead to internal errors or strange index growth. This fix does not correct the corrupt indexes which must be rebuilt.
ORA-600 [QCTCTEL] / ORA-600 [18096] can occur from OUTER JOIN in MERGE USING clause in PLSQL.
A sub-optimal plan can be generated if STAR_TRANSFORMATION_ENABLED=true as CBO uses the wrong value for the number of distinct values in a generated TEMP table. Workaround: Set STAR_TRANSFORMATION_ENABLED=temp_disable (although that may not be able to get as good a plan as TRUE could have gotten)
Query with LIKE clauses on a UTF8(multi-byte) database table may spin forever in evalkp(). This only happens if the LIKE pattern contains invalid multibyte characters.
ORA-6502 instead of ORU-10028 possible for large strings passed to DBMS_OUTPUT.PUT_LINE.
ORA-1400 fails to report the offending column name if there is no SELECT privilege on the table.
Index start/stop keys are wrongly generated if a predicate contains a LIKE operator with an ESCAPE character . This can result in poor performance of the statement.
JDBC's DMS metrics do not have Noun types set. This shows as "[type = n/a]" in generated DMS metadata docs or dump files.
SMON may signal an ORA-600[25012] caused by a race condition between the background blocksize sanity check and a foreground tablespace drop operation.
Wrong selectivity estimate for IN lists
With block checking on, the server could encounter ORA-600[kcoapl_blkchk] during consistent read rollback. Without block checking, this may cause a buffer cache corruption.
This problem is introduced in 9.0.1. ORA-64 can occur for large values of DB_FILES
This problem is introduced in 815 and 901. Index root blocks may be repeatedly pinned/unpinned showing as increased block gets for many queries. This can cause performance degradation.
SDO_CONVEXHULL may not return the convexhull
In a RAC environment select of data after a node failure but before that nodes logs have been rolled forward cause the select to be very slow.
PLSQL LENGTH() function returns incorrect value for strings containing CHR(0).
Eg: length('X' || chr(0)) should be 2, but with this bug returns 1 in PLSQL.
PGA memory leak in the LMS process which can lead to an ORA-4030 error then an instance crash.
SET SAVE_CONFIG_ON_STOP causes a dump if SID_LIST in LISTENER.ORA exceeds 2048 bytes
Two parallel slave sets may be used for parallel partition maintenance DDL (such as alter table move partition parallel 2) when only one is needed - this can result in reduced clustering of the data which can lead to plan changes after the move operation.
Insert-direct-load (INSERT /*+ APPEND */) should not be allowed over any form of loopback database link, not even as a statement within a PLSQL block acting on local tables but executed via an RPC over a loopback database link, or memory corruptions can occur. With this fix the INSERT executes as a normal insert (not direct-load).
'Alter table exchange partition' between a composite partitioned table and a hash partitioned table can signal ORA-600[atbace0]. Workaround: Create tables where the hashed key order is the same as a column order.
ORA-600 [17274] possible on statements after package has been recompiled
A false ORA-02014 is possible from SELECT FOR UPDATE with scalar subquery.
eg:
select ename from
(select ename from emp where deptno=(select 20 from dual))
for update of ename;
ORA-4020 may be signalled on CREATE of a FUNCTIONAL INDEX, especially if the function includes %TYPE variables. Workaround: A possible workaround is to replace all %TYPE constructs in the function with explicit type information.
JDBC thin connections as SYSOPER or SYSDBA are case sensitive. Using UPPER case values for SYSOPER or SYSDBA may cause an unexpected ORA-28009 error.
A hang is possible in a multibyte database (eg: UTF8) from ALTER TABLE MODIFY a CHAR column length with NLS_LENGTH_SEMANTICS=CHAR.
ORA-600 [KCLRCLR_5] possible
CATSEARCH gives incorrect results when text search string is of the form
("word1 word2" "word3 word4")
The result set includes spurious hits.
Break does not work within a PL/SQL procedure if in-band break is being used. This applies to control C, OCIBreak, and kill of the client. Workaround: On platforms which support it, use out-of-band break
Query with LIKE predicate on concatenated index may return no rows.
This can occur if the "like" pattern contains enough characters to
match the column length but it has a trailing wild card.
Eg:
create table test (col1 varchar2(4) not null,col2 varchar2(4));
create index i_test on test (col1,col2);
insert into test values ('0001','');
select * from test where col1 like '0001%' and col2 is null;
This query returns no rows when it should.
After failover a statement with binds may error with ORA-1008.
If two 9i GIOP-enabled databases using dynamic endpoint registration are configured to register with one listener, it may happen (depending on timing) that only one of them will be able to receive GIOP connections. Issuing "lsnrctl reload" cmd may alleviate this condition, as after reload the databases have to re-register, and if this happens in the "right" order, then things may appear to start working fine. However note that "lsnrctl reload" *is not* a complete workaround.
Multiple processes executing ALTER INDEX .. REBUILD against the same index concurrently may see ORA-600 [KTSIRCINFO_NUM1] / ORA-600 [ktssdrp1] errors.
Star transformation may dump in <Function:EVAOPN2> if subquery_pruning is enabled. Workaround: Set _subquery_pruning_enable=false
JDBC Thin may hang sending lots of NULL data over multibyte. The hang appears as both ends of the NET connection waiting to "read" data.
Optimize FULL on certain indexes may fail with DRG-50608 errors. This can occur when at least one row in $I table has dbms_lob.getlength(token_info) > 4000.
Self Deadlock possible in SMON when shrinking a rollback segment in SMU mode. SMON signals an ORA-60.
ORA-600 [711] possible allocating an extent to a bitmap segment
Update of Oracle Schema Processor to W3C Recommendation (dated May 2, 2001).
Improvements to OTS when all transaction branches at same site
When a VPD policy is applied and the check option is enabled on a table with a self referencing constraint then it is not possible to insert rows into the table . A false "ORA-28117: integrity constraint violated - parent record not found" error" is signalled.
SDO_GEOM.RELATE with the DETERMINE mask may incorrectly return the COVEREDBY mask.
Incorrect document retrieval when alternate spelling or baseletter preferences used and query is a phrase containing accented characters.
NEXT_DAY function returns wrong day for NLS_TERRITORIES with first day of week between Tuesday - Saturday. (Eg: OMAN)
When a sqlnet client with its SDU size > the server's SDU, sends a packet with size greater than the server's SDU, the server may error out with "bad packet header".
Oracle Extensions for LDAP PL/SQL API are packaged in DBMS_LDAP_UTL package. It can be installed by executing rdbms/admin/catldap.sql in SYS user schema.
ORA-600 [KQLBLFC-1] during crash recovery / slow startup times possible.
This problem is introduced in Oracle 8.1.7.2 and it present in 9.0.1. ORA-7445 in KQRGCU/kqrpfr/kqrpre can occur under heavy load, especially when the shared pool is stressed. This can lead to an instance crash. Workaround: Set event:10235 to level 2
This fix is notable as it may cause a change in behaviour for
some applications as rewrite may no longer occur when expected.
The bug is that wrong results are possible from query rewrite
using materialized views and datefolding, if the date column
data has time values.
Eg: "SELECT sum(fact_col) FROM tab
WHERE date_col BETWEEN to_date('01-mar-2001','dd-mon-yyyy')
AND to_date('31-mar-2001','dd-mon-yyyy');
"
may be rewritten to get the SUM of FACT_COL for MARCH, but
this query should EXCLUDE dates with TIME information on
31-MAR-2001 so the rewrite could return wrong results.
With this fix TRUNC() is required for date folding with
conditions such as those above.
In 9.2 this fix can be backed out by setting
"_FORCE_DATEFOLD_TRUNC" to FALSE.
This problem is introduced in 9.0. OracleStatement.getStringValue() for a number may not return a full precision number as the text buffer is only 38 characters long instead of the required 44 characters
Network disconnect from standby can sometimes cause an instance crash of the primary and corruption of online redo at primary. The standy must be operating in "no-data-loss" mode. Workaround: Use disk_asynh_io = false if viable.
Function-based indexes are not updated with new rows when SQL*Loader direct
path is used. This leads to a table / index data mismatch.
Workaround:
1. Use conventional load.
or 2. Rebuild the index after load.
UTLIP.SQL does not exit on severe errors
ORA-7445 [zllcstda()] / core dump when you access table with labels created with Oracle Label Security Option. This happens when both of the following conditions are met: 1. The table has security labels (SA_LABEL_ADMIN.CREATE_LABEL) 2. Access the table through Proxy Authentication (JDBC OCI)
Missing period at the end of EXEC CICS or EXEC DCSQL statements generates a precompiler error or bad code.
Fetching DB2 Graphic data through HS results in an error (Character conversion between CCSID 933 and CCSID 834 not valid)
REG$ not altered and DBMS_AQIN invalid after downgrading from 817 to 816. This fix is in the downgrade scripts which are supplied with the higher version release.
PLSQL may dump when trying to fetch multiples rows from a FDS table containing a column that contains a Long data type. This only occurs when RexecOptimise capability is set up and a PL/SQL block to fetch all tries to fetch the rows in the FDS table one by one. The first row is successful, the remaining rows produced an error.
EXECUTE IMMEDIATE with CURSOR_SHARING=similar may signal a false ORA-1008
Buffer overflow possible KDRREB()
A query involving join of more than 5 tables can get ORA-600[15160] when the largest table has concatenated index on 3 or more columns and CBO attempts a STAR plan. Workaround: Avoid a star plan by setting optimizer_search_limit >= to the number of tables in the join. eg: alter session set "_optimizer_search_limit"=6;
ORA-03113 & ORA-7445 [KOCGPN2()] possible creating table of a SUBTYPE with no attributes.
XSLT may crash processing document containing elements created by LpxCreate* routines
Inserting a persistent subtype object into a supertype table may result in an OCI-21500 error and client side memory corruption.
A Java program may hang or experiences unexpected broken pipes when writing to the output stream of a Process returned by Runtime.exec.
On databases with large numbers of PL/SQL objects UTLIP may fail due to lack of rollback space.
Configuring cman.ora with a large number (eg: >109) rules in rule_list can cause TNS-4002 when trying to start CMAN.
SDO_UNION can generate an incorrect GTYPE for disjoint geometries.
ALTER SYSTEM SET SERVICE_NAMES=''; causes PMON to die
Dump in MSQOPNWS possible from SELECT DISTINCT in parallel
Using an ANALYTIC FUNCTION in a HEIRARCHICAL QUERY causes LEVEL pseudocolumn to always be returned as 1.
If a sql statement contains multibyte characters, and statspack.snap needs to store information about the sql statement, an ORA-1401 may occur.
Wrong selectivity estimate for some AND/OR combinations.
Eg: select * from t where a = 1 OR a = 2
AND (b =1 OR b = 2);
SDO_CENTROID using geometry with very close vertices may return wrong answer
Cannot build geodetic index if gedetic srid is set if the data has a geodetic srid set. (If the data is 3D and users specify sdo_indx_dims=2 the geodetic index should be built)
TEMPLOB generated by XMLTYPE.CREATEXML() not freed until session ends. ie: This is a temporary lob leak
ORA-600[KCVGCF_01] possible from PQ on READ ONLY database
This problem only affects Windows 95. Saving a Wallet to Registry does not work
Disk space can be lost if tablespace migration to locally managed type is aborted.
This problem is introduced in 9.0.1 clients. Forms clients attempting to logon after logging off may get error ora-1075. <<End_of_Article>> Load-Action: REPLACE Article-ID: BugTag:1938389 ID: 1938389 State: FIXED Updated: 19-oct-2001 03:01:31 NB: Comp: WMT Sev: 2 Vers-From: 9 Vers-To: 902 SupDesc: Saving a Wallet to the Registry (NT) does not work Fixed: 9012 9020 Tags: owm Saving a Wallet to the Registry (NT) does not work
ORA-01461 on INSERT (RETURNING VALUES) causes next INSERT to dump
Running Star queries with temp table transformation under Internode Parallel Query many times may see buffer cache internal errors such as ORA-600 [kcbgtcr_12]. This is caused by not flushing temp table buffers on other intances when QC drop a temp segment at the end of query execution.
SQL*Plus limits the value that a substitution variable may be set to 240 bytes, but no error is reported if this value is exceeded.
An FPE(Floating Point Exception) may be thrown when a query is executed in parallel.
This occurs on platforms which throw an exception for log(0)
Workaround:
Do not use parallel query.
Recreating the controlfile makes TEMPFILES unusable (ORA-25153) as the file size is not output.
Upgrade from 8i to 9i may fail with the errors: ORA-04045: errors during recompilation/revalidation of SYS.DBMS_OUTPUT ORA-01406: fetched column value was truncated ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 Or with ORA-600 [15456].
Parallel DML operations on an IOT with column re-ordering (example: if user columns are a,b,c and primary key is on columns c and b) may produce corrupt data. There is also a problem when global secondary indexes with non-key are present
This problem is introduced in Oracle8i. SQL Loader skips twice the number of records specified in the SKIP option when loading files with the VAR file processing format.
Using Oracle7 EXPORT against an Oracle9i database can fail with EXP-11.
Foregrounds may spin / hold cache buffers chain latch for a long time during instance recovery.
PL/SQL client side tool core dumps when running under UPI mode and using object types or schema level collection types.
In a heterogeneous environment (9i->8i or 8i->9i), if you issue a plsql block that accesses remote table and stays in that session, then the table which it is accessing cannot be dropped from remote site. DROP TABLE hangs until the session in which plsql is fired exits.
OCIDefineByPos core dumps when using a statement handle from a previously detached server after re-connecting to an 9i server. Eg: - Connect to a 8i/9i server - Create a statement handle and prepare a query statement - Execute the statement after doing OCIDefineByPos - End the previous session and Detach from the 8i/9i server - Connect now to an 8i/9i server - Using the statement handle created above in step 2, attempt to do step 3, i.e. call OCIDefineByPos followed by OCIStmtExecute. - OCIDefineByPos will core dump
This problem is introduced in 9.0. Dequeues using transaction grouping may signal ORA-604 / ORA-1007 .
SQLPLUS dies with an abnormal termination executing a SQL file with path longer than 80 characters on Windows platforms. Note: A 256 bytes limit still applies to the path length on win32
LMS may dump in kclpbi() due to corrupt downconvert list
Change to the way Oracle Instance monitor (oracle_up) detects instance failures as the method used without this fix can affect performance measures of enqueue waits.
Inserts can encounter ORA-600 [ktspfmtrng-nblks]
ORA-600 [kkqgUnpAgg.2] possible using GROUPING SETS
"lobdemo1.pc" may dump as the 'curdate' buffer is too short.
ORA-600 [15593] occurs using a TEMPORARY TEMP tablespace if a temp segment needs >64K extents.
Running sdo_tune.extent_of against a layer with SRID 32775 set on each geometry and on the layer via user_sdo_geom_metadata returns an mbr with no srid set.
OCCI: Dump occurs inserting a persistent object into an object table when some attributes are not specified.
Standby database recovery may fail (End-of-redo error possible) in delayed protection mode. This is similar to bug:1858166.
RMAN Tablespace point in time recovery (TSPITR) fails if the tablespace name is an RMAN keyword.
ORA-1450 can occur while doing ONLINE rebuild of an index that is created in a tablespace different from the tablespace of the table if the blocksize of the index tablespace is bigger than the base table tablespace.
Wallet is not picked up from default file system location
Create materialized view may create columns with the wrong data-width. If a materialized view created in 9i based on an object in a previous version ( <9i ) then the created MV does not reflect the changed character width if the databases are in different character sets.
CREATE BITMAP INDEX on TO_DATE function with partitioning and in parallel can signal ORA-00600: [qerbcRop ksize]
Wrong results are possible from queries against hash cluster tables if there are predicates and correlated subqueries that reference the cluster key column.
A lock with an expired timeout may never actually time out causing a hang scenario.
ArrayIndexOutOfBoundsException possible binding PLSQL table parameters
ALTER VIEW .. COMPILE which references ROWID fails with ORA-1446 when the view contains a UNION or DISTINCT. The view compile should succeed but any following SELECT should error.
Setting NLS_DATE_FORMAT from ALTER SESSION within a function does not change the date format.
This problem is introduced in 9.0.1. Insert APPEND of remote sequence into local table may fail with ORA-3106
If a protocol error (ORA-3106) or other error occurs early in two-phase commit, then when the database link is closed, the remote site can get ORA-00600[4400].
Updates of a partitioned table with a local index, where row movement is enabled, can result in ORA-600[kauupd:2] if there is also a unique constraint being enforced with a non-unique index.
Shared server connections may not establish
When a UTL_HTTP user makes HTTP POST request where the POST data is sent in chunked transfer-encoding (as specified in the "Transfer-Encoding" header), and the user receives the "ORA-3113: end-of-file on communication channel" when he either proceeds to get the response with utl_http.get_response, or ends the request with utl_http.end_request.
'Analyze table ... validate structure cascade online' sometimes yielded ORA-1499 even though table and index are okay.
OCIStmtExecute may hang binding >2000 byte character bind variable to an OUT CHAR parameter to PLSQL in a multibyte environment.
Slow performance of split partition operation on large partitioned tables (5000 partitions) when the key value of the partition being split is small. This problem does not happen for large key values.
Deadlock possible when a number of nested materialized views are refreshed complete concurrently.
Markup operations on certain documents on variable-width character set databases such as UTF-8 may fail with ORA-7445
"ORA-29545: badly formed class" possible loading Java code into the server.
Using SUBSTRB with UTF8 (or other multibyte char set)
can give blank-padding on those partial character position
related to SUBSTRB.
Note: This fix removes the blank padding ONLY if
<Event:10943> is set to level 524288 otherwise it
has not effect.
Server may spin in kksfbc (hang) while creating a child cursor if a dependent object remains invalid.
Long running SYNC may dump (in lxscop/drsxsqr)
A parallel query involving order-by, sub-query and union-all may hang because some slaves have their output table queue closed and they cannot send message to the QC and the QC is not expecting them to send messages.
ORA-7445 [kkdcacr] can occur during insert into a table which has a locally partitioned domain index. Workaround: Use a global index.
ORA-600 [KCRRGS2.2] possible on log switch with closed standby database
ORA-1502 possible for valid BITMAP JOIN INDEX during maintenence
ORA-1008 possible from 9i to 8i over a DB LINK when using bind variables
ORA-600 [KTEOPRPECT-1] is possible using system managed undo. When this occurs the DB will not start up.
PLSQL may produce incorrect results when running parallel queries with bind variables.
SQLPLUS may dump on some platforms if the server session dies (ORA-3113).
ENH: Millisecond precision for timestamps in Network trace files
If SAVEPOINTS are used for transactions involving a database link then using the same SAVEPOINT name twice can result in a ROLLBACK TO SAVEPOINT command rolling out the entire transaction at the remote site. The re-use of the SAVEPOINT name can be either explicit by quoting the same name more than once in different code locations, or implicit by executing the code containing the SAVEPOINT command twice within the same transaction. No error or warning of this problem is given to the user so the distributed transaction may be logically inconsistent. . There is no simple workaround to this problem other than to use unique savepoint names.
PQ (parallel query) invoked from a PL/SQL exception handler incorrectly resignals the original PL/SQL exception.
If you install XSQL Servlet as a global servlet on OC4J without this fix, you'll get an error locating its XSQLConfig.xml file.
Memory Leak for NTIER authentication sessions
Ultra Search performs bad query expansion when using asterisk wildcard
Update inserts NULL into a DATE column if the bind length is > 1333 from an OCI7 client using obndrv().
DCD (SQLNET.EXPIRE_TIME) does not work for dispatchers (ie: shared server connections)
RAW payload > 32K may dequeue incorrect data with AQ HTTP propogation
During query rewrite with Materialzed view, outer join can become an inner join ,and thereby caused incorrect results in some cases.
Logminer may fail with ORA-1332 if compatibility is set >= 8.2.0.0 and < 9.0.0.0
Session login through OCI migratable sessions does not trigger the logon event trigger. This can cause a dump accessing tables with labels created through Oracle Label Security through a Proxy Authenticated logon
High parse times can occur for queries with many repeated identical AND predicates when QUERY_REWRITE_ENABLED=TRUE. This fix eliminates duplicate AND predicates and may cause execution plan changes. The fix can be backed out with <Event:10142>
UTL_TCP.CLOSE_CONNECTION does not flush its output Workaround: Call utl_tcp.flush before closing the connection.
An obsolete version of "trcasst" is shipped with Oracle9i Release 1
When indexing documents, Chinese Lexer leaks memory per document.
In a RAC environment if a lot of CR block reads are serviced from the remote node then the local cache may fill with those CR blocks aging out locally read blocks and artificially reducing the cache size, leading to more IO.
Oracle8i client to a 9i server performing a DESCRIBE (describe_only mode in statement execute call) may return no information.
High CPU consumption by the LMS background process.
ORA-6502 possible from SWITCH_SNAPSHOT_MASTER
The 'immediate' parameter to dbms_debug.debug_on is ignored,
with the result that the engine does not enter debug
mode immediately even if 'immediate' is TRUE.
Workaround: Add some SQL (any SELECT statement will do) immediately
after the call to dbms_debug.debug_on; the engine should
enter debug mode after the SQL statement (as long as
'immediate' is TRUE).
ORA-22275 possible using EXTRACT()
This problem is introduced in 8.1. Update statement which contains subquery SET clause with many PL/SQL function calls may result in memory growth of the Oracle shadow process, and eventually lead to the error 'ORA-04030: out of process memory'.
ENHANCEMENT: Speed up instance & crash recovery for RAC
Enhancement: Batch together remote messages from LMS when possible.
"KCL FREELIST LATCH" latch contention under heavy load
getInt calls NUMBER.toLong instead of NUMBER.toInt.
Core dump possible when text index encounters a token which exceeds 64 bytes after alternate spelling expansion.
Query on ORACLE_LOADER EXTERNAL TABLE does not close the log file on error
ORA-600 [KZCKINI: NZDSI_INITIALIZE] possible starting RAC instance
ALTER INDEX REBUILD with PCTFREE on HASH [sub]partition should signal an ORA-14185 error but does not.
When querying using an XPATH expression where the predicate has an equality testing on attribute secion such as //Items_ROW[Part/@PartID = 'GG765'] this may not return data when it should. The semantically same expression //Items_ROW/Part[@PartID = 'GG765'] does return rows.
JDBC/NativeXA improvements to support JDBC NativeXA feature in JTA
Oracle Enterprise Manager is not able to monitor JDBC drivers
Oracle9i Release 1 is not shipped with support for the Distributed Computing Environment (DCE) on any platform.
ARCH Archival of threads with same SEQ# may use wrong first/next SCN. This can cause recovery to fail. This only affects Real Application Cluster installations.
Using SQLPLUS "start" command (eg: @scriptname) with a multibyte script filename containing a hex bytes 0x40, 0x3F or 0x25 garbles the filename.
This problem is introduced in Oracle9i 9.0.1.0. Multiple sessions timeout is not handled with CONNECTION POOLING.
Inserting into multibyte DB may hang if byte count equals column maximum. Eg: If inserting 6000 bytes into a varchar2(2000)
TNS listener may erroneously register MIBs for the oraPrespawnedSrvTable during Instance service registration/update
Insert performance degrades with long master freelists. This fix proactively moves blocks from the master to process freelists.
Refined version of fix for Bug:1410679. The original fix gives a choice between PERFORMANCE and COMPATIBILITY. This fix hopefully allows both.
Creating a DOMAIN INDEX on an OBJECT CONSTRUCTOR fails
with error:
ORA-30558: internal error [colfro1] in function based index
If the size of the SGA is greater than or equal to 4 GB, then instance startup with RMAN results in an RMAN-600 internal error on some platforms. Workaround: Run the STARTUP command outside of RMAN. eg: use the HOST command to run a script to to do it.
XSL engine does not implement all the functionality that decimal-format should be doing per XSLT 1.0 recommendation.
This problem is introduced in Oracle 9.0.1.
PLSQL may dump or signal ORA-22806 or ORA-600 [15212] when
a user BIND variable is used in a SQL statement in a PLSQL
block as part of an IN clause.
eg:
select * from emp where :BIND in (select empno from emp);
or where a statement of the form
select * from emp where :BIND.A in (select empno from emp);
is issued where :BIND is an object or REF.
TIMESTAMPTZ & TIMESTAMPLTZ constructors treat Callendar as DBTIMEZONE rather than session timezone.
NLS: Incorrect autodetected language for Chinese documents
User file names may be mistakenly considered as OMF files (Oracle Managed Files). This fix introduces a change in the format of OMF files. Please see <Note:159888.1> for full details of this change.
9i listener rejects all but the first connection to a dynamically registered 8i instance (ORA-12516). Workaround: Use an 817 listener for the 8i instances.
Speed up DMLs for objects using bitmap segments for RAC.
Upgrade from 8i to 9i can mess up multibyte data (eg: UTF8)
Markup operation on certain documents with a CHINESE_VGRAM_LEXER may produce incorrect results.
Export / Import of a wrapped package can result in a corrupt package being imported. The symptoms of this depend on exactly where in the package data the corruption occurs. This can produce a package which compiles but does not behave as expected, or can cause a dump on import, or a PLS error on compilation.
Additional tokens may occur for a document after crawling
PMON cannot cleanup a dead process holding the CI lock. This can lead to a hung system as the CI lock can never be freed.
Missing results possible for wild card section search queries such as "14% within SECTION1". Eg: "1% within SECTION1" may return less rows than "14% within SECTION1"
Query on a temp table using temporary index used to give ora-600 [qerixTIGet1], when the temptable has no records inserted into the table.
PMON may crash in nscon if ORACLE_TRACE_ENABLE=TRUE and EPC_DISABLED=TRUE
Shutdown normal may take a longer time than expected as a DML used internally has a FULL TABLE SCAN on obj$. In 8i the recursive SQL is: delete from sys.mon_mods$ where obj# not in (select obj# from sys.obj$) In 9i both the above statment and a similar one on COL_USAGE$ may be expensive.
ENH: Add support for SOAP messages to AQ XML SERVLET
'Shutdown immediate' does not check for the managed recover startup state only the active state. When managed recovery is starting up and shutdown immediate is issued, shutdown fails to stop the background managed recovery process.
This problem is introduced in 9.0.1.0. A race condition exists in the shared server where it could get an ORA-7445 or an internal error (ORA-600 [504]) in the routine kmcfsq().
Export may fail with ORA-1406 when exporting object type definitions.
Repeated object method invokation can use up all durations resulting in an ORA-600 [kohdtf048] error.
FULL JOIN of TABLE() functions may ORA-942 or dump.
MBRC value (use dbms_stats.get_system_stats(pname=>'mbrc') after gathering system stats is too high ( much more than db_file_multiblock_read_count parameter value ). This can lead to very low full table scan and fast full index scan cost estimates.
Enhancement: Allow descending partition scan for ORDER BY
When an MV has a GROUP BY but there is no GROUP BY in the query, then a SELECT COUNT(*) may return NULL instead of 0.
If a BITMAP CONVERSION occurs on an INDEX on a TEMPORARY table the session may dump or signal ORA-600 [25012] with qknCompHakan on the stack. Workaround: Set _b_tree_bitmap_plans = false
C0801070.SQL does not run CATHS.SQL - DBMS_HS_UTL invalid after upgrade from 8.1.7
This problem is introduced in 901 by the fix for bug:1449439. clearParameters() clears the whole batch, instead of clearing just the current row.
ORA-7445 errors were possible from queries which used partitioned tables or views during optimization
ORA-600 [QERTQTABLEALLOCA] possible when running parallel queries on a read-only database.
False indications of timeout on a network connection through the PL/SQL utl_http, utl_smtp, or utl_tcp packages is possible.
IMP-3/ / ORA-22854 occurs during import of a transportable tablespace a table residing in the transported tablespace contains a LOB column.
OracleSSLCredential.setWallet()fails with a NullPointerException if the wallet does not contain a private key.
stmt.setCHAR() does not convert from the CHAR objects charset to the DB charset
If a Create Table As Select of an Index-Organized Table has NOT NULL constraint(s) and any PARALLEL clause specified is ignored,
Out of shared pool might cause ORA-600[ksicget_3][KJUSERSTAT_NOSPACE].
Ultra Search login page text may appear as "?" characters for some NLS environments
Export may core dump if it encounters an error writing to the dump file whilst exporting LOB data.
Wrong results are possible from queries with subqueries, if the subquery selects an expression which has NVL over an aggregate function.
Query rewrite may produce the wrong plan on some platforms
Ultra Search Query API results may be returned in hexadecimal format for some NLS environments.
OR-expansion or negated predicates can cause huge shared pool memory consumption, use lots of CPU and may appear to hang if RBO is used. This is the same as bug:1344111 but for RBO. Workaround: Use a /*+ NO_EXPAND */ hint with the offending query.
MV Refresh may dump in kkzgeuti_pred
FAILOVER: Multithreaded OCI/JDBC-thick client with TAF may hang on failover
Unexpected ORA-01438 possible from PQ slave
When a composite unique PK constraint is added after a multi-column index
has been created against a table, DML against the table may return
a false ORA-1400.
eg:
create table ctest (a number(9), b number(9), c number(9));
create index ctest_idx on ctest (a,b,c);
alter table ctest add (constraint pk1 primary key (a,b) deferrable);
insert into ctest (a,b) values (1,2);
>> ORA-1400: cannot insert NULL into ("SYSTEM"."CTEST"."C")
When writing 0 bytes in JavaSSL, the program may spin in an infinite loop
Dump possible changing a TYPE from NOT FINAL to FINAL
Intermittent dump / client memory corruption
Demo executables do not link correctly on Solaris 64-bit (and possibly other platforms) with demo_plsql.mk.
A core dump may occur when repeatedly adding and removing a rule based subscriber with the same rule.
Query with BITMAP FUNCTIONAL INDEXES may dump
When create view is used with FORCE option and the view query has an invalid column name with a CAST operator and an alias, ORA-600 [qctVCO:csform] may occur.
Calls to OCISubscriptionPost() with the OCI_SUBSCR_NAMESPACE_AQ may cause the Oracle shadow process to dump (ORA-3113). With this fix an Ora-24903 is raised instead as this namespace is not supported with this OCI call.
This problem is introduced by the fix for bug 1320605 in 8163/8172/9010. An ORA-600[4512] can occur while inserting into a table which has an index. The scenario to hit this error is very rare.
Common subexpression elimination can cause wrong results for
negative predicates.
eg: for ( (sum_a!=1) and (sum_a!=2) and (sum_a!=3) ) OR
( (sum_a!=1) and (sum_a!=2) )
Workaround:
Set _ELIMINATE_COMMON_SUBEXPR = False
OCIAnyData may fail for character data during character conversion as it may look at uninitialized memory.
Crawler does not recognise FILE URLs on NT (due to backslash filenames)
PMON may die (in kjuef) if a user session is killed
It is possible for a DDL to not be logged in the redo file. This only affects LOGMINER as it may be missing some DDL commands.
When PMON determines that the listener needs to be updated due to session disconnects, it is possible that the listener will not be updated in a timely manner. This can lead to the listener refusing connections.
Errors possible from concurrent RESYNC operations against the same catalog.
ORA-600 [sigcomerr:!ctx] possible during database mount
SQL with ROLLUP, WINDOW an CASE expressions may dump
Dump in <Function:kkornvl> possible with an NVL/DECODE predicate of the form "to_number(to_char(nvl(:bind , expr)))"
AQxmlPublishRequest.getAutoCommit() may throw an exception
Disabled POLICIES are not caches properly on startup giving false ORA-12416
If <Parameter:RESOURCE_LIMIT> is TRUE and job queues / Parallel Query are being used then V$SYSSTAT may contain nonsense high values for some statistics.
INSO_FILTER sometimes garbles Turkish characters in PDF documents
Dropping a domain index while a long running query is in progress can raise internal errors on subsequent operations on the index.
Optimizer may not choose best plan if there is a join, BITMAP and DOMAIN index
UTLRP in PERSONAL Edition gives ORA-1403
This problem is introduced in 8.1.7B and 9.0.1.0. Text indexes on LONG columns may be build incorrectly. Some document contents may be double-indexed as part of later documents.
SQLPLUS cannot handle quoted passwords
This problem is introduced in Oracle9i. ORA-7445 [KKDLGOB] / Dump can occur on a CREATE SNAPSHOT / MATERIALIZED VIEW with ROWID against a remote table / view.
ORA-600 possible calling SQLJTYPE STATIC method from a PLSQL block
This problem is introduced in 9.0.1.0. SYNC_INDEX on shared server (MTS) databases can corrupt memory
Incorrect results possible from SDO_UNION two polygons
PFS_RECYCLE_INTERVAL cannot be adjusted
RECYCLE is not prevented within PFS_RECYCLE_INTERVAL if recycling
DBV may spin when SEGMENT_ID & USERID specified if there are multiple files in a tablespace, and the first file is not the one in which extents exist for the segment.
Contention for the "longop free list" latch possible.
Excessive memory use can occur when a user creates or syncs an index using URL datastore. This can also show as an ORA-600 [kghfrf1]. The rate of growth is larger for a larger URLSIZE attribute value.
Client memory corruption (statement handle) / dump possible at Fetch time when you set value_sz to a large value (eg:SB4MAXVAL) in OCIDefineByPos using OCI_DYNAMIC_FETCH
OracleConnection.setReadOnly(true) throws an SQLException
Master-detail datastores with BINARY=NO may produce corrupted document text at buffer boundaries -- this includes every 2000 bytes during highlighting/markup/filter, and every 16000 bytes during indexing.
OCIRefFromHex can leak client side memory if the OCIRef pointer is passed in on each invokation. The leak is about the size of the PREF for each invokation.
SUBSTR2(),SUBSTR4(),SUBSTRC() may dump for UTF8
This problem is introduced in 817. Select with GROUP BY on a composite partitioned table may dump (in kkpamHRGet) in a slave process while trying to map a partition key. Workaround: Set _partial_pwise_join_enabled=false in the init.ora file
Dump possible (QXOPQXEX) using CONTAINS on XMLTYPE column
Partition views are no longer recognised as such if base table columns are altered UNUSED or functional indexes are built on the base tables.
RMAN can report ORA-235 for any operation where it has to view V$ views in the CONTROLFILE of the TARGET database. Workaround: Often repeating the command will succeed.
CREATE TEXT INDEX may dump on UTF8 with PATH_SECTION_GROUP/AUTO_SECTION_GROUP
Using PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY=AUTO can cause SPIN Workaround: Set workarea_size_policy = MANUAL
When you select from x$logmnr_contents, sometimes a log dump record beginning with "tsn:" is written to a trace file.
Shutdown immediate sometimes takes more than 60 seconds even if there is no active transaction if PMON is busy when the shutdown is issued.
During instance reconfiguration the surviving instances may wait for 5 minutes before starting buffer cache recovery.
Filtering / indexing large PDF documents can be very slow, especially when compared to Oracle8i indexing of the same PDF document/s.
When a certificate has a Name (e.g. directoryName in Subject Alternative Name extension) with unknown Attribute type, the OWM/mkwallet may crash.
The procedure dbms_logmnr_d.build() may dump on some platforms
Query with user-defined aggregates and grouping sets may error with ORA-600 [kkqgRwrAggs.1]
Concatenation of grouping sets query with user-defined aggregate function can fail with ORA-600 [evaggsid-1]. This only happens if the cursor sharing mode is similar or force. Workaround: Set CURSOR_SHARING = EXACT
Query rewrite may not occur when using non-trivial analytics
The DB may crash on startup for large SHARED_POOL_SIZE with many CPUs. Workaround: Set _kghdsidx_count=4
If two polygons are compared using function sdo_geom.relate the comparison may fail with "UNKNOWN MASK" errors if they are allmost equal.
Complex join queries involving Hash-Join may result in Memory leak leading to ORA-4030 out of process memory.
A PAGU login may fail with error ORA-1017 or ORA-28273 or ORA-28275 after setting the nickname attribute in the root context
ORA-904 during dbms_redefinition.start_redef_table or during create materialized view possible if to_clob, to_blob or to_nclob are being used.
Complex_view_merging may cause a wrong result if :
1. outer query block has to be split in 2 blocks due to presense
of group by, order by.
2. one of the tables in outer query block has functional index,
which is not used in the query block
4. outer query block is a subquery itself
Invalid XPATH expressions can cause a dump / incorrect data.
eg: Evaluation of XPATH expression "/processing-instruction(xml-stylesheet)"
causes a crash in lpxlppaxnodetest.
Incorrect UNIQUE conflict handling for NCHAR/NVARCHAR etc.
DBA users cannot delete from FGA_LOG$. Workaround: grant delete on sys.fga_log$ to delete_catalog_role;
AQ of ADTs can leak TEMP lobs (the lobs can be seen via v$temporary_lobs)
Creating a sub-partitioned local index ONLINE can result in corrupt dictionary information for the index. This can result in ORA-600 [25012] / ORA-600 [KFTR2BZ_1] etc.. Workaround: create index without ONLINE option.
RESUME_MASTER_ACTIVITY after RELOCATE_MASTERDEF fails with ORA-23419
This problem is introduced in 8.1.6.0. Memory corruption can occur at optimization time. This mainly affects distributed queries and results in an almost random memory corruption which can show up are ORA-600 [17114] or similar, or as dumps in kgh* or kke* functions. Workaround: Set _enable_type_dep_selectivity=false This fix introduces a different memory corruption problem - Bug:2248904
ORA-7445 on accessing table X$KCFTIO on some platforms
ORA-600[6937] / LDR-961 / ORA-600 [kcblrr_1] possible while loading an object (or potentially a ref) in direct path mode.
ORA-600 [25012] / wrong results after EXCHANGE PARTITION between indexes with different FREELIST /FREELIST GROUPS
Any query with many single column equality predicates ORed together may signal an ORA-600 [12337] if the column is a valid prefix of a bitmap index .
Hang / protocol violation errors possible when PLSQL is called with associative parameter notation for OUT only bind variables. Workaround: Use positional notation, or make the parameters IN OUT
Ultra Search does not work in Standard Edition
When using Japanese Lexer, CTX_DOC.HIGHLIGHT may return the wrong offsets.
Dump (in qcitrans) possible using shared servers
If a table has an index parallelized and a query is issued which generates a plan for slave sql where index-fast full scan is chosen (for the specified index) as the right hand side access path of nested loops join . Now if the index is global partitioned then we might produce incorrect results . The above can also happen if the user supplies INDEX_FFS as hint .
When applying a policy on schema, disabling then immediately enabling the schema can signal a false "ORA-12443: policy not applied to some tables in schema"
PREV_SIZE and PREV_BUFFERS in the V$BUFFER_POOL view are updated even when a RESIZE operation fails
Wrong results are possible from queries with subqueries that are made into anti-joins, if the subquery is known to be single row.
Dump possible from dbms_logmnr.mine_value()
ORA-01283 from dbms_logmnr.mine_value()
After selecting from v$logmnr_contents a call to dbms_logmnr.add_logfile() may fail if the logfile being added is older then the previous logfiles added into Logminer (before the select from v$logmnr_contents)
A query like:
select mgr, deptno,
dense_rank(10, 20) within group (order by 10, sal)
from emp group by grouping sets (mgr, deptno);
gives:
ORA-604 / ORA-30497: Argument should be a constant or
a function of expressions in GROUP BY.
Shared servers may die with ORA-600 [4415] when using XA to an OPS or RAC instance where the transaction branches open DBLINKS to remote instances. PMON may die after the shared server dies thus crashing the instance.
SET_CONTEXT attribute over 4K long dump when referenced by SYS_CONTEXT
PGA memory corruption possible using adaptive direct reads (Oracle9i feature).
If a persistent object is created with a lob attribute and is flushed to the server and later if it is fetched from server then LOB operations may fail (eg:ORA-22275).
Add setNull() method to classes Ref<T> and RefImpl. This method should be called before terminateEnvironment on all static Refs and also Refs allocated on the stack in the main program. All operations to be performed on the Refs should be done within an inner scope of the Connection.
OCCI: Cache size may be exceeded appearing as a memory leak
INSO_FILTER fails to filter specific Microsoft Word documents (raising DRG-11207)
ORA-600 [kdiss_pin_hdr: too many] possible from index skip scan
Startup of multiple instances may hang. When this occurs the last entry in the LMON trace files of all cluster members is 'Name Service Frozen'.
In the xmltype extract function xpath expression which use the following and the preceding axes fail. "Preceding" causes a crash while "following" returns an empty set.
Use of a REF CURSOR RPC parameter in UPI mode causes PLS-801 [82605].
References to TABLE OF ANY (V2_TABLE_1) are disallowed in Forms packages FORMS4W, FORMS40 and/or FORMS_OLE.
AQJMSREADME.TXT instructions are incorrect for 9i
OracleSSLInputStream.available() may throw a NullPointerException if it is called after the SSLSocket was closed.
Creating ODM datafiles > 4Gb errors (ORA-959/ORA-19502)
Cannot start OPFS with PFSCTL with multiple volume groups
RMAN backup to disk is very slow if backup disk i/o slaves are started (DBWR_IO_SLAVES > 0)
Direct export can duplicate some columns and omit others
ORA-7445:[strncpy()] possible on SELECT from X$KSMSP
Memory corruption possible from DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT
The default value of the TIMEOUT attribute of the INSO_FILTER is 0 (seconds) instead of 120 (seconds).
HS qualifies DB2 tables with 'PUBLIC.' if the supplied schemaname is exactly 6 characters long. This can give unexpected ORA-942 errors.
alter package <package name> compile body from 8.0/ 8.1 client against 9.0.1 server may result in a hang if the compilation produced warnings. This is a client side fix.
BACKUP ARCHIVELOG DELETE [ALL] INPUT in RMAN may fail the whole job even if a single DELETE fails even if the entire BACKUP operation succeeded.
Reduce latch hold time for "row cache objects" latch.
Note: The 8173 form of this fix introduces a regression as described
in bug:2305689. The complete fix is in 8174.
ORA-600 [15599] possible from hash join. Workaround: A larger hash area size may help avoid this.
Processes that exceed PROFILE resource limits and have accessed objects (Eg CLOB etc) may fail with ORA-600 [17034] and/or [17281].
This problem is introduced in 8.1.7.1 by the fix in bug:1410679 if the application has NOT been re-precompiled/compiled and linked with the 8171 (or higher) precompiler and libraries. Applications using non-array EXEC SQL OPEN / FETCH may dump.
ALTER TYPE FINAL or NOT FINAL does not generate an intermediate version
This problem is introduced in 9.0.1.0. PLSQL Bulk INSERT NULL into TEMP table may insert bad data.
LMS might not be posted on log flush completion causing sessions waiting on log flush events to wait longer than needed
If table 't' is cached at middle tier as read only then
if a user does complete a refresh
eg: dbms_refresh.refresh('t','c')
then this will delete all rows from table 't1' at back end.
This occurs as the delete gets redirected to the back end.
Workaround:
In order to do a complete refresh at the middle tier
do the following:
connect <user>
execute dbms_ias_session.clear_redirection;
execute dbms_refresh<table list>
execute dbms_ias_session.set_redirection;
SP2I message files missing some Italian messages
This problem is introduced in 9i. UTL_HTTP's timeout mechanism does not always wait as long as desired before raising ORA-29276.
The max length parameter of registerOutParameter() is ignored
Unnecessary hold of library cache latch in RAC or OPS environments
A CREATE UNDO or CREATE TEMPORARY tablespace may get an ORA-901 reported by import if the tablespace already exists. The database alert log reports the correct error ORA-1543.
Query with inline views and pesistent views may return incorrect results when nls_sort is not binary.
On certain platforms (not Solaris) dbms_repair.check_object or ANALYZE ... TABLE ... VALIDATE STRUCTURE may erroneously report a corrupted block.
'CREATE JAVA SYSTEM' may dump in JOE_RUN_VM()
predicate1 OR predicate2 can give wrong results if predicate2 is a subset
of predicate1.
eg:
select /*+ALL_ROWS */ deptno,sal from emp
where (deptno=10 and sal=5000)
or (deptno=10);
will return rows where sal=5000 only.
Workaround:
Set _eliminate_common_subexpr = FALSE in the init.ora file
Describing an ADT column that has been defined as a NUMBER without the scale or precision explicitly specified returns 0 for the scale (instead of -127).
When a client manages multiple sessions in one connection, then exits, its dedicated server process may crash with ORA-00600 [ksfdchkfob1]
Internode Parallel Query may be slow
This problem is introduced in 8.1.5. If an instance crashes while someone is doing ALTER TABLESPACE xyz READ ONLY in that instance, then during crash recovery it is possible to get "ORA-1113, file <n> needs media recovery", and the instance fails to open the database. If the database is in NOARCHIVELOG mode, then it is possible that media recovery will also fail. It is also possible for crash recovery to appear to complete successfully, but to silently lose committed changes to the database. If running under RAC, it is possible for instance recovery to silently lose committed changes. Workaround: There is no reliable workaround. You are less likely to hit this bug if you keep COMPATIBLE < 8.1.0, as then it is not possible to perform ALTER TABLESPACE...READ ONLY unless there are no active transactions in the system. If the OPEN fails with ORA-1113, then doing manual media recovery will usually work,
OCI in the server is not initialized in OCI_EVENTS mode. As a result, any events related call in the server or in the client (when not using OCI_EVENTS) may dump when it should report an error "ORA-1010: Invalid OCI operation". Workaround: Pass the OCI_EVENTS flag to OCIEnvInit()
If the number of processor groups (quads) on a NUMA system exceeds the maximum number of database writers an "ORA-600 [KCBBNWA2]" is signalled
This problem is introduced in 8.1.7. Using AQ with transactional queues allows a second session to dequeue messages which are part of a transaction group which is already being dequeued.
An internal error is reported on some platforms when attempting to use the Oracle Advanced Security SHA-1 crypto-checksumming adapter.
This enhancement introduces a parallel version of utlrp.sql to recompile all packages but to do this in parallel. The new file is called utlrcmp.sql utlrcmp.sql contains a utility package that supports parallel recompilation of invalid database objects (typically, for objects invalidated after a database upgrade). This package is intended for DBAs on databases containing many views and/or PL/SQL objects (eg: Oracle Applications databases). For databases on single-CPU machines, Oracle recommends using utlrp.sql. For multi-CPU machines, utlrcmp.sql is recommended with the degree of parallelism set to number of CPUs + 2.
If a Grouping Set query has a correlated subquery in the HAVING clause and the correlating condition has aggregates to be computed by the outer query block (grouping set query block) or has grouping() function refering to outer query block, an ORA-600 [qks3tCTT:1] can occur.
If the endTime or startTime parameter to DBMS_LOGMNR.start_logmnr() are not specified and the NLS_DATE_LANGUAGE is not American then an ORA-01843 may be signalled.
Standby database may fail to open on same node as the primary (ORA-1102).
False PLS-452 possible
Create index or CTAS on large segments (extents greater than or equal to 1024 blocks) can hang and/or dump core. Also the low HWM does not get advanced correctly or sometimes dies (in kcbgtcr).
This problem affects Microsoft platforms only. A multithreaded OCI/XA client may leak memory.
Wrong results are possible from some queries with bind variables if
bind-by-position is used and placeholder names are repeated, or
differing bind variables have the same initial value.
Eg: SELECT /*+ ALL_ROWS */ DEPTNO FROM DEPT WHERE DEPTNO BETWEEN :b1 AND :b1;
where the 2 values of B1 are bound by position so have different values.
In Oracle9i the bind names may be different but the values the same
on the first parse and this can cause a similar problem - ie: the
statement may get optimized as if the binds are identical.
Any text index with lexer preferences for COMPOSITE and ALTERNATE_SPELLING may be missing some alternate spelling forms of the composite word subcomponents, resulting in incomplete results for queries on the composite word subwords. Also fixes a problem with German alternate spelling and non-mixed case, where sharp S shows up as lower case 'ss'.
Excessive memory use by oracle.sql.NUMBER.toString()
ALTER TABLE UPGRADE may dump after ALTER TYPE INVALIDATE
If a user tries to re-create a controlfile where the DB_BLOCK_SIZE initilization parameter is different from the DB_BLOCK_SIZE with which the database was created, then after the controlfile has been recreated, trying to open the database will hit ORA 600[711].
Timeout for GLOBAL CACHE operations in RAC too short for very busy systems
Incorrect results for PQ with multiple INV. DIS functions.
Eg:
select deptno,
percentile_disc(0.2) within group (order by ename) "0.2",
percentile_disc(0.6) within group (order by ename desc) "0.6_DSC",
percentile_disc(0.5) within group (order by ename) "0.5",
percentile_cont(0.5) within group (order by sal) "M_SAL(C)",
percentile_disc(0.5) within group (order by sal) "M_SAL(D)"
from myemp group by rollup(deptno) order by deptno;
ENHANCEMENT: Admin scripts should use CREATE OR REPLACE instead of DROP / CREATE .
ORA-1422 from DBMS_RULE_EXIMP possible on export
DROP Functional index does not clean up the dictionary COL$ entry. This can lead to a corrupt export file being produced as per the alert. Note: This fix is incomplete and can lead to the issue in Bug:1987122. See <Note:148740.1> on Metalink
ORA-600 [KCBGCUR_9] possible from ONLINE REBUILD INDEX with concurrent DML. Workaround: Use an offline rebuild of the index
Rollback of Direct load can corrupt BITMAP managed segments / ORA-8103
ORA-28030 using current user DBLINKS in LDAP root context
After duplicating a database with read only tablespaces it is not possible to use "backup database" because it will fail with the error "RMAN-6056". The duplicated database must be backup by explicly naming the datafiles. eg: backup datafile 1,2,3,4,5,6,7,8,9, ... Workaround: Make the read only tablespace read-write, then it can be returned to be read-only.
DROP USER CASCADE may drop a different users TRIGGERS. This requires that the object id of another users table is the same as the userid to be dropped, and that there is a trigger on that table.
DB2 error messages may not be propogated through the gateway to the user.
Clusters with freelists migrated from Oracle7 to Oracle 8.1.6/8.1.7
are treated as corrupt by the block checking code causing
ORA-600 [KCOAPL_BLK] errors. If the freelists are on a modified
C_TS# this can cause the migrated database not to open under Oracle8i.
Workaround:
Disable block checking by setting the following init.ora parameters:
DB_BLOCK_CHECKING = FALSE
_DB_ALWAYS_CHECK_SYSTEM_TS = FALSE
_CHECK_BLOCK_AFTER_CHECKSUM = FALSE
ORA-600 [KOHRSC153] / ORA-600 [KOHRSC154] possible using PLSQL with bind variables.
This problem is introduced in Oracle9i.
Exporting a table with all DML options on RLS will result in
export errors:
EXP-8: ORACLE error 1406 encountered
ORA-1406: fetched column value was truncated
EXP-0: Export terminated unsuccessfully
Client core dump if you describe packaged procedure with zero parameters from 9i,8i,8.0(client) to a 7.3 server.
Dump possible using a Range or List partitioned table if there is an IN clause and none of the elements of the INLIST exist in the table.
MERGE with DIRECT LOAD INSERT and UPDATE may allocate wrong extent size
DB may not start with large LARGE_POOL_SIZE and multiple CPUs. Workaround: Set the init.ora parameter _kghdsidx_count=1
Oracle9i SMON may report ORA-942 for the SMON_SCN_TIME table when opening an Oracle8i database during migration from Oracle 8.1.6 (or earlier). The errors do not cause any problem and stop after the relevant upgrade scripts have been run.
Java client applications using OracleTypeADT / OracleNamedType may hang. Using the Java runtime thread dump facility ( kill -3 on unix ) shows deadlocks in methods in these classes. It may also occur that seamingly random data corruption occurs.
False ORA-1 / dump from non-unique index on IOT
Java thin client with different character sets on the client and server can get "Bigger type length than maximum" errors when using database links.
Trusted callouts may leak memory when invoked from PLSQL. Eg: This can affect Oracle Text functions called from PLSQL code.
If an MTS primary database is in a Data Guard Broker configuration, the enabling of the Data Guard configuration may fail. You may see foreground trace file core dump in the log directory with ORA-600 [1237] error
Cannot import FGA (fine grain access) policies with QUOTES in predicate
Spin possible with shift sensitive charset using relative field positioning
ORA-600[KSIRES_1], [KJUSERSTAT_BUSY] possible on primary DB in "Instant Protection Mode" in RAC if RFS process dies.
An ORA-328 error may occur in a multi-instance (RAC) database while doing an ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH command.
Cannot create a text index on a table with RLS (DBMS_RLS.ADD_POLICY) (ORA-1031)
A stylesheet with two <xsl:key>'s defined produces unexpected (extra) results the first time the stylesheet is executed, and then if the same stylesheet instance is used (with a new XSLProcessor instance) to transform the same XML results, the expected results (using the keys) are MISSING and only the unexpected extra results are present.
When a database's enterprise domain is put into the Password_Accessible Domains List in an LDAP directory, password-authenticated enterprise users do not work until the database is shutdown and started up again.
"ORA-22998: CLOB or NCLOB in multibyte character set not supported" occurs when propagating from a multibyte character set database using HTTP propagation
ORA-600 [7001] possible on CREATE VIEW when OBJAUTH$.SEQUENCE# exceeds 65535
Import of a materialized view (snapshot) log, may signal ORA-600 [kkzugekdl:1] if the table on which it is based does not exist. With this fix an ORA-942 is signalled and IMPORT continues
This problem is introduced in 8172 and 9010 by the fix for bug:1476579. Processes can enter an undetected deadlock situation in rare cases when there is a need to populate a rowcache via recursive SQL and that recursive SQL also needs to load a different rowcache before it can complete. In 8i this can show up as waits on "null event". In 9i this can show up as waits on "row cache read". Workaround: Kill one of the parties involved in the deadlock.
When using multiple sessions on 1 connection with shared servers, some with idle time set and others without, ORA-600[17018] can result if some sessions get 'sniped'.
A GROUP BY may return the wrong number of rows when run in parallel with adaptive fetch turned on Workaround: Run serially or set _adaptive_fetch_enabled=false
Hang possible on database UNQUIESCE using shared servers
CONNECT BY queries on IOTs can cause heap corruption from 8.1.7 onwards. Typically the query errors with ORA-00600[kghasp1] and may cause subsequent sessions to error with ORA-600[17159]. This only happens in Oracle9i if "_old_connect_by_enabled" is set to TRUE.
Query on an IOT with functional index can return incorrect results.
ORA-7445 [PEVM_NCAL] possible after recompile of natively compiled PLSQL
ORA-600 [QSMEMCRG_MERGE_COMPLEX_RANGES-2] can occur.
ORA-600 [12455] [QKADELUPD] possible on EXPLAIN PLAN
When using INSO_FILTER on Tru64 UNIX or Red Hat Linux or Intel x86 platform, the filter output is sometimes incorrect for a few specific database character sets.
If an ADT (t1) embeds a substitutable ADT (t2), then it's not allowed to alter t1 to NOT FINAL since by doing so will mark column of t1 to be NSAL. However, if t1 embeds a substitutable collection of t2, then ALTER TYPE t1 NOT FINAL CASCADE succeeds which causes problem to dependent table that already contains collection data of subtype instances.
WITHIN queries that should be finding documents are returning matching rows. This affects XML documents containing numeric character entities such as   or 
 when the database character set is variable-width such as UTF-8
Using a function-based spatial RTREE index, if the parameter LAYER_GTYPE=POINT is set, then wrong results are sometimes returned on a select query. Workaround: Specify mask=anyinteract (even for filter queries) or Remove the layer_gtype constraint during index creation
ORA-600 [25012] [2147483647] possible selecting from certain V$ views. Note that the second argument is [2147483647] for this bug. Affected views include V$TRANSACTION, V$LOCKED_OBJECT, V$LOCK
Global context leaks 76 bytes everytime there is a new namespace ie: per SET_CONTEXT for globally accessed contexts
Dump in drexqrprs possible using CTXRULE CLOB api in multibyte /variable length character set (e.g. UTF8) database.
A non-blocking OCI application, issuing OCIBreak and OCIReset for an OCI call that is currently in progress can leak cursors. This can cause unexpected ORA-1000 errors.
Instance crashes if SERVICE_NAMES is set to an invalid string
CTX_DOC.MARKUP using PATH_SECTION_GROUP may dump for XML document with attribute sections.
SAVSETUP.SH does not work on some platforms
In JDBC/OCI as SELECT statement which includes an expression
over 255 characters long signals an unexpected ORA-1403 error
if the expression has no column alias.
eg: "Select a||b||C... from TAB" where the length of
the actual expression (not the data it returns) is
over 255 characters long.
Trying to paste a certificate into the Import Certificate Dialog does not work - a NullPointerException may be thrown.
Add LOGMINER support for NCHAR/NVARCHAR2/NCLOB
NLS: OWM show some messages without NLS translation
Attempting to use MATCHES queries with a CLOB parameter on a multibyte/variable length character set database (e.g. UTF8) fails.
This problem is introduced in 8.1.5. Tables which are stored in hash clusters report ORA-600 [25012] on queries accessing a LONG (or LONG RAW) column in the table.
ORA-7445 / dump from CREATE / ALTER table using TREAT directive
Using Resource Manager with MTS can lead to HANG scenarios.
Memory leak can occur in Oracle Text with a tag of "KOL VARRAY"
A memory leak can occur in Oracle Text with a memory type of "KOC KOCDS".
Invalid/incorrect XML results with varchar2 datatypes, inside a collection. The tags are messed up starting with the second row in the collection.
XMLType.createXML may cause heap corruption
getStringFunctions()/getSystemFunctions() etc.. should return a comma seperated list of functions, but the return String includes unwanted blank characters either side of each comma.
Client programs may dump or encounter errors while executing DMLs with RETURNING clauses, with cursor_sharing set to FORCE or SIMILAR.
This problem is introduced with the fix for bug:1390597. When using impicit cursors with release_cursor=yes, the cursors are not closed when there is an error (even for errors like no data found). For cursors accessing remote tables this can cause XA_END to return 100.
OERI:2888 / ORA-600 [KCFTRO_READ_WRITE] / ORA-600 [kcftro_in_trans] can occur when trying to make a tablespace READ ONLY after a crash / shutdown abort when the same TS was in transition to being READ ONLY. WORKAROUND: Re-run the command to make the tablespace read-only after the error occurs.
SIGFPE in PKRCD() possible after ALTER TYPE name COMPILE BODY
Explain plan of UPDATE VIEW may dump (in KKMMCTBF)
This problem is introduced in 9i. Dump in SQNPRS possible during semantic analysis
TIMESTAMPTZ.TIMESTAMPTZ(Connection, Timestamp) uses DB time zone instead of session
Introduce constructors to make TIMESTAMP types from String
PFSSETUP sets incorrect permissions on subdirectories in TNS_ADMIN
ORA-600 [7009] can occur for SQL using a WITH clause with a subquery which uses a DATE function if the subquery is materialized using a temp table.
When SQLPLUS attempts to connect to an invalid connection identifier as a privileged User, either an invalid error is reported, or the User is granted an idle instance connection to a local database.
A SQLPLUS connection to a remote database that fails with ORA-24327 may end up connecting to the local database.
Hang possible with CURSOR_SHARING=FORCE (or SIMILAR in 9i)
When using INSO_FILTER to filter a Japanese PDF document, the output of the filter is sometimes corrupted.
INSO_FILTER sometimes fails to filter a specific Japanese Microsoft Powerpoint document.
DBMS_BACKUP_RESTORE keeps a file handle open so OFFLINE files cannot be deleted at OS level on platforms which do not allow open files to be removed. On Unix platforms the file may be deleted but the space will not be released.
Buffer cache internal errors ORA-600 [kcbgtcr_12], ORA-600 [kcbgcur_6] and ORA-600 [kclchkinteg-1] may be raised during Selects or DML operations. This problem can occur if one session is accessing a table when that table gets dropped. There is no corruption involved from this bug.
Statement duration memory may not be freed at the end of the statement
Client memory may be corrupted when using the JDBC Thick driver A possible symptom of this is the error "ORA-24392: No connection pool to associate server handle"
If the log file name and dump file names are same then IMPORT can overwrite the dump file itself resulting in an IMP-50 or similar error. Note that there are some limitations of this fix. There could be cases where we may not know the dump file name (multiple dump files), when log file is opened. Then we cannot prevent that dump file being overwritten.
Dump in KKECDN possible for queries involving DB Links
ORA-2070 if CUBE is used in GROUPING SETS with TRUNC on DATE
Eg: This signals ORA-2070:
select ename as Employee,
trunc(to_date(hiredate), 'YYYY') as Hiredate, sum(sal) as sum_sal
from emp
group by grouping sets(cube(ename, trunc(to_date(hiredate), 'YYYY') ))
Certain large SQL statements (>= 2048 characters in length) may signal a PLS-801 [1002] error when compiled.
ORA-2291 can occur when creating a relation with ctx_thes package.
xxx_constraints.delete_rule shows the wrong value when the foreign key delete rule is 'Set Null'. It shows "NO ACTION" for ON DELETE SET NULL foreign key actions.
DML may spin with excessive cpu usage while the tablespace is put into hot backup mode.
Wallet Manager "Starting" message appears in English for non-english locales
Multi-threaded XA client which spawns threads which do xa_end(TMSUSPEND) leak memory. This leak occurs in the client and is most noticable if threads are repeatedly spawned , do work, do TMSUSPEND then exit.
ORA-1480 occurs when indexing UTF8 data by Japanese VGRAM lexer.
ORA-600 [KJBMPWR:4!RMD] possible in LMS process
Logminer may return information about rolled back transactions when start_logmnr() is called with the option COMMITTED_DATA_ONLY
A shared server or dispatcher process may appear to hang for 30-60 seconds then continue execution normally.
When a query uses a plan that performs rowid to bitmap conversions and
none of the indexes scanned are bitmap indexes and the following is
true for each of the tables accessed with rowid to bitmap conversions:
1) the table does not have any bitmap indexes
2) 'alter table <name> minimize records_per_block' has not been executed
for the table
Then an ora-28604 error may occur during query execution.
Workarounds
Any of the following are sufficient:
1) Create a bitmap index for each of the tables
2) Execute 'alter table <name> minimize records_per_block' for each of the
tables
3) Add: _b_tree_bitmap_plans=false to init.ora
4) Execute 'alter session set "_b_tree_bitmap_plans"=false in each sesssion
that encounters this error
When indexing documents, Japanese Lexer leaks memory per document.
ORA-600 [KJBRPICKC:HP1] / lots of KJX_B_UPDMASTER messages to update the master node repeatedly.
ORA-600 [KJBMPASSUME:!RES] possible from reconfiguration
Select with NOT EXISTS against IOT may fail
Exporting tables with AnyData columns with more than 14 rows results in EXP-56 / ORA-600 [kpotcprc: depth exceeded]
An attempt to use proxy authentication for a pass word authenticated global user with a mapped schema will fail. If the proxy client is not authenticated or authenticated using pass word, it will fail with error ORA-28150: proxy not authorized to connect as client. If the client is authenticated using a distinguished name, it will fail with error ORA-01017: invalid user name/pass word.
Wrong results are possible from queries if there is index access and an
IS NULL predicate both on the same index key. Changing the order of the
predicates on the indexed column may give correct results.
eg: select * from tst where (dt>sysdate-5) and (dt is null);
may return rows where none are expected if DT is an indexed column.
Star transformation applied to a query with a correlated subquery may signal ORA-600[kkojocol:2] WORKAROUND: Set STAR_TRANSFORMATION_ENABLED = FALSE
CBO does not use INDEX SKIP SCAN even if hinted (INDEX_SS) for
non-equality predicate with a BIND.
Eg: select /*+ INDEX_SS (o,oidx) */ o.acol from mytab o where o.icol <= :b1
does not skip scan the hinted index.
CBO may not choose INDEX SKIP SCAN plan even if it is cheaper
Dump in lxplset possible
ORA-22921 from LIKE / INSTR on CLOB column with Varying width Charset.
eg: In PLSQL "select c2 into i from test where c1 like 'a%'"
where c1 is a varying width NCLOB
ORA-600 [qkaUpsertRowVector4] can occur in a MERGE SQL statement when there is an "AND" in the ON clause. Possible Workaround: Use a NO_MERGE hint in the USING SQL statement
ORA-7445 errors in KKECCF are possible from queries or analyze statements using partitioned tables or views.
SQLPLUS memory leak during DESCRIBE
Creating a text index using URL_DATASTORE errors (11605) and does not index URLs over 256 characters long.
The SLEEP_COUNT column in V$LATCH_MISSES will always be zero for all latches except for the library cache and shared pool latches.
This problem is introduced in 9.0.1. Dictionary information for ARGUMENT$ includes PROCEDURE names when it should not. This can give unexpected results from some data dictionary views.
This problem is introduced in Oracle8i. Array fetch may return truncated data when OCIString types are used.
KUP-4039 accessing EXTERNAL TABLE files > 2GB
Misleading error message "Incompatible Version" if user does not exist
This problem is exposed in 8.1.7.1 onwards. Wrong results possible using Parallel Query if the all the below are true: - The query uses views (inline or outline) . - The views have one of its columns coming from the count(*) or count(not-null-column) - The columns selected in the query are the count columns of the views. - The query is executed in parallel and it gives same values in all selected columns.
CBO may not choose a domain index when it should.
Eg: An interMedia index may not be chosen to drive the access, and functional
invokation of the CONTAINS operator may occur instead.
JDBC Thin: ORA-1008 updating LONG RAW using updateBinaryStream()
If export is run with TRANSPORT_TABLESPACE=Y and the tablespace list exceeds about 10000 characters then EXP-8 / ORA-6502 is signalled. This makes it impossible to export very large transportable sets.
Pro/OCI DML RETURNING an ARRAY of LOB Locators dumps in TTCLD2I
SQLPLUS may dump executing SQL files with lines over 4096 characters long
DBMS_STATS can fail (ORA-904) for a table with a security policy on it
ORA-600 [7005] with KPRB / ORA-3115 with JDBC thin when querying an internal ROWID from a table.
Heap corruption / ORA-600 [17182] selecting DB2 DATA TYPE of CHAR.
Binding multibyte data of type SQLT_LNG (LONG) to 8i/9i database may raise an ORA-1461. Binding this to an 8.0 server may cause a HANG. Workaround: set OCI_ATTR_MAXDATA_SIZE/MAXCHAR_SIZE large enough.
ResultSetMetaData getScale() method can return incorrect SCALE for ADT NUMBER attributes.
Some queries using bitmap indexes can give incorrect results or coredump in qerixGetKey(), or during rowsource allocation time. Workaround: alter session set "_column_elimination_off"=true
During a parallel recovery in a SQLPLUS session, if you press ctrl-C, at the 'Specify log:' prompt of parallel recovery, the interrupt does not seem to reach shadow process at all and instead the control is back to SQLPLUS session immediately.
This bug number adds several enhancements to the subquery unnesting feature therby fixing many performance problems. It adds elimination of semi-join for single table correlated and uncorrelated subquery without which many queries execute with sub-optimal plans.
SELECT from Object view may spin (in kksfbc) after an "ALTER TABLE UPGRADE" on the table on which it depends. Workaround: Do an "ALTER VIEW COMPILE" explicitly before selecting from the view.
Import may fail when processing large (>64k) statements in the export dump file when the statement requires NLS translation. The import session errors showing an incomplete or garbled SQL statement. This mainly affects ASCII -> EBCDIC and vice versa.
Client memory corruption / dump possible (eg: in ttcfopr) using pre-fetch. Workaround: Turn off client pre-fetching of rows (OCI_PREFETCH_ROWS or prefetch precompiler option).
OERI:qksopOptASJLf1 / dump in kkeajsel with ALWAYS_SEMI_JOIN=MERGE or HASH with certain subqueries containing correlated variables appearing in a disjuntion(OR). Workaround: Set always_semi_join=NESTED_LOOPS (underscore parameter in 9i)
ENH: HS should write to the ALERT log when Data Dictionary changes are made
ORA-600 [qximcoc4] can occur if a memory error occurs when setting up a query using a DOMAIN index. This ORA-600 should not be signalled, just the original memory error.
A memory leak of private shadow memory , or ultimately an ORA-4030, can occur if a long running PLSQL block repeatedly binds in a loop.
ORA-600 [2103] possible during reconfiguration.
Wrong results with a parallel query containing
correlated subqueries with set(eg: minus) operations.
eg:
select DNAME from DEPT A where DEPTNO in
(select DEPTNO from DEPT where A.DNAME=DNAME
minus
select DEPTNO from EMP);
Workaround:
Set "_column_elimination_off"=false
Indexing a table with many NULL values, with a low index memory, may taking a long time because the index flushes one document at a time.
Using the grouping_id() function with grouping sets or concatenation of rollups (more than one rollup in group-by), is slower than without using the grouping_id() function. This enhancement adds the parameter "_precompute_gid_values" which is enabled by default.
If a super type t is created with subtypes and a table is created with substitutable column type t, if you do alter type t with INVALIDATE option, then alter table upgrade, you will get ORA-04020 / dump Workaround: Use alter type with CASCADE option instead.
A hierarchical query utilizing the pre-9i row source (i.e. without connect-by filter and pump) and which involves an index access by ROWID range scan corrupts the cursor work heap.
Wrong results are possible from queries which use the inlist iterator
if the inlist has functions on correlated columns.
Eg: select /*+ ALL_ROWS */ col1
from tab1
where not exists
(select /*+ INDEX(tab2) */ '1' from tab2
where tab2.col2 in (tab1.col1*10+1, tab1.col1*20+1);
Workaround:
Set event 10157 to disable the inlist iterator
ENHANCEMENT: An SP2-750 error is now reported if SQLPLUS fails to open the SP1 message file.
Multi Threaded Server (MTS) crashes when an SSL Callout spans multiple sessions. The stack trace contains calls to nzjsWrite() or nzjsRead().
Small memory leak in UGA from lock memory used for TEMP segments not being freed or reused.
ORA-1424 or wrong results possible when a query against a union view contains a LIKE predicate with an ESCAPE clause and the LIKE can be replaced with =(EQUAL) predicate.
A program using any of the datetime identifiers (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TIMEZONE_ABBR) or TRIM identifiers (LEADING, TRAILING, BOTH) as the first token in a subroutine call's parameter list where the subroutine is specified by a complex identifier incorrectly error with PLS-103. This is related to Bug:1484770 which fixes this problem for some constructs.
Identical SQL/PLSQL using different Array sizes are not shared.
NullPointerException in oracle.sql.ZONEIDMAP.getID from TIMESTAMPTZ constructor.
Eg: Timestamp tss = Timestamp.valueOf("1999-06-07 10:05:23.99");
TIMESTAMP ts = new TIMESTAMP(tss);
TIMESTAMPTZ tstz = new TIMESTAMPTZ(con, tss);
PDML to bitmap key of a partition table with row movement hangs. The fix causes the statement to execute serially. Workaround: Run the statement serially.
LMON may die during reconfiguration with ORA-600 [kjbrrcfwst:xxx] errors.
Generate ' for single quotes instead of &APOS; as some clients do not recognise ' correctly.
NETMGR may give error on menu options for locale=KO
HTML tags may be incorrectly parsed for entity references
Improved error information for AQ transformation errors
When a shadow reports ORA-600 [kcblibr_1], no new buffers are read into the cache and the instance eventually hangs. With the fix buffer gets are not suspended.
This is an enhancement mainly intended to reduce invalidations and recompilations when installing a new patchset or patch.
Index DDL (create/alter/sync) operation following another index DDL operation in the same session can fail with ORA-600 [kgfrf1].
Sporadic "NAMESPACE PREFIX USED BUT NOT DECLARED" error
When doing a parallel NL Semi/Anti Join the wrong distribution method may be chosen by the optimizer leading to wrong results for the query.
Update statements with a range scan may core dump in kdudcp / signal ORA-600 [13013] when checking the compare column values(CR copy) with the current values. This can happen if the execution plan shows the range scan conversion to bitmaps. Workaround: None. Try to avoid range scan (use full table scan)
A memory leak can occur in the JDBC OCI driver when reusing statements that reference object types.
ORA-932 if DBMS_XMLGEN is passed a CURSOR() expression.
Eg: declare
ctx number;
xmldoc CLOB;
begin
ctx := DBMS_XMLGEN.newContext(
'select cursor(select * from dual) dual_rec from dual');
xmldoc := DBMS_XMLGEN.getXML(ctx);
end;
/
ENHANCEMENT: OracleConnection.pingDatabase() added
SQLPLUS may dump using the BREAK command
getString() does not return number strings in scientific notation.
Note: this fix is not complete so may still return incorrect
strings for certain numbers.
Select from join of two subqueries may fail with ORA-600[XTYCSR2],[2] on a slave, if there is a local partitioned index on one of the tables being joined in subqueries. Workaround: Force Hash join or SMJ instead of NLJ using optimizer hints.
PARSE=partial generates a precomp error, for trigraphs used as directives.
ORA-2002/ORA-1461 from AUDIT CREATE TRIGGER when creating a LOGON TRIGGER
When a 'drop column' operation is interrupted, an ORA-600[729] space leak error may be reported on exit from the session.
AVLCSPPK.SH / AVLCSTPK.SH do not test for success correctly
ORA-600[QKAGBY0.4] from PQ SELECT with DEGREE > 1 and GROUP BY
if it contains any duplicate columns or duplicate aggregate
functions on duplicate columns and if it also has a group by clause.
eg: SELECT c1, c2, SUM(c3), SUM(c4)
FROM ( SELECT 1 c1, col c2, min(1) c3, min(1) c4 FROM t1
GROUP BY 1, col
)
GROUP BY c1, c2;
ORA-1000 / ORA-600 [QXIMCOC4] can occur from ORed CONTAINS clauses using SCOREs. This can cause other errors depending on where in the code the ORA-1000 error is encountered. This problem occurs if the execution plan shows CONCATENATION being used. Note that the cursors are leaked within the session so the ORA-1000 error may not occur on the statement with the CONTAINS clause but on some other statement. Workaround: Force execution not to use CONCATENATION.
SQLJ allows the same bind variable name to be used in
different places but each bind is treated as a seperate
bind value (even though the bind names are the same).
This case result in SQL runtime errors when not expected.
Eg: select :bind, count(*) from tab group :bind;
will signal ORA-959 as the 2 binds are actually
different items.
The fix for this bug introduces a "-bind-by-identifier"
SQLJ option which when set to true maps repeat bind
variable names to the same actual bind variable
When setting the failover mode to be preconnect, number of preconnected processes increase after each detach, attach.
"FULL_THEMES" parameter affects output Weights in CTX_DOC.THEMES
ALTER INDEX REBUILD ONLINE of a REPLICATED object HANGS on "null event". Workaround: Rebuild the index offline rather than ONLINE.
This problem affects Windows platforms only. Indexing with URL_DATASTORE on Windows platforms leaks sockets. (netstat will show many sockets in CLOSE_WAIT state). This can show as an apparent hang if a few thousand URLs are attempted to be indexed.
Unnecessary partition access is possible in parallel queries if there is a single-row subquery against the partition key.
This problem is introduced in Oracle9i ORA-980 may be raised if a PLSQL block references a SYNONYM which points to a REMOTE PUBLIC SYNONYM.
CTAS between different character set databases might not add the padding character for CHAR columns if the database character sets differ and at least one character set is multibyte.
Incorrect results possible when a period (.) is specified as a printjoin
character if a period is also (by default or explicit setting) a
numjoin or numgroup separator.
Eg: "ABC.123.DEF" gets lexed as "ABC" and "123.DEF" instead of as a single
token.
If a non-default CPU_PER_CALL is in effect, the CPU time logged by Oracle
may be up to twice the actual CPU time used by the program.
(ie: The value in V$SESSTAT for 'CPU used by this session' may be up to
twice the correct value).
Spurious ORA-12571 possible using BEQUEATH connection if write is interrupted
When the initialization parameter 'PARTITION_VIEW_ENABLED' is set to 'TRUE' and tables have been analyzed, 'ORA-979' can occur for queries involving literals.
Pre-spawned servers crash (with an ORA-07445 core dump) on the second connection when OPS is configured.
Direct export may fail with ORA-600[6191] with trailing null column data.
Dump (kohfrem/kohfrm) possible at logoff when using cartidges (mainly affects Shared Servers on Windows).
Control characters in access parameter strings may be ignored. eg: "RECORDS DELIMITED BY "*EOF*\t" ignores the TAB character
Interrupt of a parallel execution of a query involving temporary table could cause ORA-600 [KCBLIBR_USER_FOU], and potentially an instance hang. Workaround: Set STAR_TRANSFORMATION_ENABLED= temp_disable | false
This problem is introduced in 815.
Wrong results can occur for index range scan when composite indexes
are used. The stopkey is formed wrongly in this case when we
have a composite index with keys such as (c1,c2) and
some predicate such as c1 > v1 and an equality predicate
c2 = v2 present together. The query may return too many rows.
Eg: SELECT B.col_from ,A.col ,B.col_to
FROM B ,A
WHERE A.col > B.col_from
AND B.col_to > A.col
AND A.id='ZIP';
when there is a composite index on A(col,id)
A query with an INDEX_JOIN hint can cause a memory corruption if _INDEX_JOIN_ENABLED=false, _B_TREE_BITMAP_PLANS=false and the table does not have bitmap indexes. This can show as ORA-600[17114]/[17147] errors.
Leak of "ktatt" memory chunks possible (ORA-600 [729]) on failed creation of a TEMP segment
V$SGASTAT value for "shared pool free memory" may be incorrect
OCIDateTimeGetTimeZoneOffset()/OCIDateTimeGetTimeZoneName() return incorrect results for TIMESTAMP WITH LOCAL TIME ZONE. The offset returned is that from the DB timezone, and the name returned is that of the DB timezone.
This problem is introduced in 8.1.5. Loading data with sql*loader in direct mode into a table with a primary key constraint enabled may dump in SOREND() during index maintenance if duplicate rows are detected. The fix causes an error to be signalled instead. eg: ORA-1452: cannot CREATE UNIQUE INDEX; duplicate keys found
When accessing a lob inserted via a conversion function such as to_lob(), and when 'storage in row' is enabled, and the lob after conversion was exactly 3964 bytes, then a select on the lob can result in ORA-1555 'snapshot too old' errors
@ Originally listed as fixed in 8173/9012 but the fix was incomplete. "Protocol Violation" from JDBC THIN if account password has expired
When using LOB columns with the "CACHE READS" option incorrect copies of
the LOB blocks may be read due to stale block images being left in the
buffer cache after a LOB block has been updated. This can result in
many different errors.
Eg: ORA-1555 / ORA-22924 when selecting a LOB from the table,
ORA-1410 / ORA-600 [12406] from interMedia etc..
Workaround:
Change the LOB definition to not use the CACHE READS option
Query rewrite does not occur if base table has a FUNCTIONAL index on it.
ALTER TYPE or running CATALOG invalidates Queues based on the recompiled type. This causes AQ operations on the queue to error with ORA-24085. See the alert for details of making the queues usable again.. See <Note:151613.1> on Metalink
"drop (non-unique) index" invalidates views dependent upon the index base table view dependents.
When a java.lang.Float object is passed to the oracle.sql.NUMBER constructor it rounds off the float value.
When running dbverify against files in temporary tablespaces, corrupt blocks may be reported.
ORA-3217 occurs during TSPITR clone export if the primary database contains TEMPFILEs.
SMON may die with OERI:16224 crashing the instance when deleting non-existent objects. Workaround: It is possible to set <Event:10052> as a short term workaround to this issue. It prevents SMON from cleaning up non-existent objects thus preventing a crash.
Theme output for empty documents or documents with no tokens may be incorrect and may change depending on the order of processing.
Enhancement to reduce contention on ROW CACHE OBJECTS latch. This enhancement is most effective for sites with large numbers of objects in the dictionary cache.
OCIStmtExecute() may fail while doing DML array operations with iteration > 32767.
Using one QueueReceiver per dequeue operation leaks memory which can result in "java.lang.OutOfMemoryError".
PDML "Update SET=(subquery)" may set data to NULL causing logical data corruption.
INSO_FILTER can fail to filter certain Microsoft Word documents.
Stopping an archiver process generates a trace file even if the init.ora <parameter:log_archive_trace> is not set.
An ALTER TYPE with INVALIDATE option followed by an ALTER TABLE UPGRADE may results in a spin(hang) or an ORA-3113/ORA-600 [12869] or similar. Workaround: Use alter type with CASCADE option instead.
With OCI applications which manage multiple sessions over one connection; if one session changes its language, then other sessions may start to report errors in the new language
Wrong results are possible from queries that undergo star transformation if they have semijoins. This occurs if a subquery is converted to a semijoin and there is joinback elimination. During the star transformation the semijoin table is lost so the condition is not applied. Workaround: Set event 10162 to disable joinback elimination
ORA-00600: [ksuwaitsysevent1] or tracefile messages "Wait on system events broadcast channel timed out" possible from clients opening more than one session over the same connection (eg: Oracle Forms)
When exporting an indexed clustered table containing rows with trailing nulls, import error IMP-00009: Abnormal end of export file can result on import.
Attempting to execute certain routines in serially reusable (SR) packages can result in an ORA-600 [PFRI.C:KGI_SRCTX] error if the package contains or references package variables.
ORA-7445 possible when a query with binds re-executes
on a synonym on a remote object, which has been dropped and
recreated on a local object.
The stack is likely to include:
memmove <- ttcclr <- opiobv <- opipbr
Inserting into an empty Updateable Resultset causes an SQLException: java.sql.SQLException: Invalid argument(s) in call: setRowBufferAt
Heap corruption (OERI:17182/dump in kghfrf) using very large collections
An unsuccessful JDBC OCI connect attempt leaks memory
ORA-600 [15212] from EXECUTE IMMEDIATE with binds but no USING clause.
Workaround: Fix the PLSQL code as with the fix it will just raise a bind
mismatch error instead.
Importing a view with an OBJECT IDENTIFIER attribute specification containing a newline character causes import to fail with IMP-9.
The memory consumption of oracle shadow process grows if DBMS_LDAP is used repeatedly.
ORA-600 [kopuopkl1] / ORA-31012 possible from XPATH operator in
XPATH expression.
eg:
select
sys.xmltype.createxml('<a><b>2</b><b>3</b></a>').
extract('/a/b[position()=2).getclobval()
from dual;
Bytes may be lost inserting multibyte data > 4k in length.
RMAN database restore does not recognise that a whole database backup taken after resetlogs includes a backup of a read-only tablespace.
Describing (using OCIDescribeAny) a public synonym with
an invalid username successfully describes the public synonym
with the same name (if it exists).
Eg: In sqlplus "describe no_such_user.public_synonym_name"
will describe the "public_synonym_name" even if the
user "no_such_user" does not exist.
Fetching objects to a JDBC client gets progressively slower as more rows are returned from a cursor.
If the length of ORACLE_SID name is 16 characters, sqlplus, svrmgrl and Navigator utilities were crashing in Windows platform.
ORA-12592: TNS BAD PACKET possible with MTS and checksum (ASO)
INSO_FILTER sometimes hangs or fails when filtering a certain Microsoft Word documents.
It is possible for ADT data to exceed the declared column length. This can result is ORA-600 errors.
TRUNCATE on the primary may lead to ORA-8103 on the standby if it is opened read only
An ORA-904 is signalled when attempting to create a Remote object-relational
Materialized View if the WHERE clause has a dotted column name.
eg: create materialized view mv1 refresh fast as
select x.c1 , x.c2.c1 , x.c2.c2 from tab2@dbs1 x
WHERE x.c2.c1 > 20 ;
When a database has tablespaces with non-default block sizes
then objects created in those tablespaces get created with
extent sizes which do not match the requested size.
Eg: If the default block size is 2K and the tablespace
blocksize is 8K then a request for a 400K extent
will actually allocate a 400K*4 = 1.6Mb extent
Assigning a value to :NEW.COLUMN in a trigger fired
as part of an array insert can cause subsequent
firings of the trigger to see the assigned value
rather than the a statement constant.
eg: insert into tab values ( 0, :bind_array );
With a trigger setting :NEW.COL1 to a value (say 99)
will cause subsequent firings of the trigger for
this array insert to see :NEW.COL1 as 99 rather
than 0.
Workaround:
Do not use mixed constants and array binds in array
inserts.
Statements using duplicate bind variables over a DB LINK may return incorrect results, or error with ORA-1008 / ORA-2063
SQLPLUS SP-0642 / Dump where schema.package_name over 30 characters
Direct export of a table containing columns of type ROWID may fail with ORA-600 [6193]
When using DBV to verify datafiles without any file extension, DBV reports error "DBV-00100 : Specified FILE (<filename>) not accessible" Workaround: Create a hard or symbollic link to the file you want to check using a filename with an extension and use DBV against that file.
Parallel transaction recovery may be abandoned and continue serially. Workaround: Keep issuing the commands: ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK=LOW; ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK=HIGH; until the transaction has been recovered.
DRG-10599 possible using CONTAINS with an OUTER JOIN
CHARSET Filter does not index all documents if there is a NULL in the indexed column. Workaround: Remove any nulls from the indexed data set.
INSO_FILTER sometimes garbles double quote characters in specific Word documents.
ORA-600 [kjbrrcon:!send] can occur.
Ora-600 [16608] or Ora-600 [16609] may sometimes be raised for certain operations that involve constraints, especially if the shared pool is heavily loaded.
Functions/procedures taking %TYPE as a formal parameter, with the base type being varchar2/long/CHAR/NCHAR may dump if a value longer than the %TYPE length is passed to the function. Procedures / functions should ignore length constraints on formal parameters. Workaround: Declare the formals as the basetype instead thru %TYPE.
A long running batch job (which runs over many days) can cause the savepoint number to wrap signalling either ORA-600[4411] or ORA-600[4454]. Workaround: Break the job into smaller chunks and reconnect for each part of the job to reset the savepoint number.
A semantic error may occur during precompilation of PLSQL in Pro* when a lower-version of Pro* connects to a higher-versioned database and the program references an indexed table method. Eg: mytable.DELETE
SQLPLUS may dump executing a SQL file with lines longer than 4096 characters.
"% Non-Parse CPU" in the output from statspack spreport.sql (8i) / sprepins.sql (9i) is calculated incorrectly.
This problem is introduced in 815. An ORA-600 [6731] can occur if an update / delete operation tries to modify a chained row if block level recovery has recovered the row head-piece but not the chained row pieces.
Failed EXTERNAL USER identification tries global user identification
Export in 8.0/8i/9i is slower than Oracle 7 export of the same data
Unnecessary partition access can occur during parallel queries if there is partition pruning based on a nested loops join.
Blank trimming is not done properly on array fetches. Workaround: Constrain the column values explicitly using appropriate TRIM function in the query.
Constraints on PLSQL variables are not being checked on dynamic
SQL RETURNING INTO clause variables.
Eg: a number(2);
..
EXECUTE IMMEDIATE 'update a set a=9999 returning a into :M' using out M;
should raise an exception.
ORA-600 [4506] possible against transported tablespace
Using the PreparedStatement's setNull() method to set
DATE fields to NULL with batch execution can result
in data corruption.
eg: Using pstmt.setNull(6, java.sql.Types.DATE) with
pstmt.setExecuteBatch(100) can lead to data corruption.
Workaround:
Use pstmt.setString(6,null) instead.
ENHANCEMENT: JDBC OCI driver add support for TIMESTAMP datatype. Without this fix "oracle.jdbc.driver.ResultSetMetaData.getColumnType" on a TIMESTAMP returns 1111 (other) instead of 93 (TIMESTAMP)
PLSQL BULK collect of REFs can dump (in kpcocrpc).
'PLS-00553' can occur if a BIND variable is used in the same SQLPLUS session as used to startup the database. Workaround: After startup reconnect (connect / as sysdba) before using any bind variables in the SQLPLUS session.
Use of objects may result in a large number of buffer header state objects being acquired needlessly. This may impact the process that acquires them by degrading performance, and impact others by increasing the contention on the shared pool or by causing Ora-4031 errors. This problem is resolved by this fix.
ORA-600 [84] on TO_DATE using ARABIC HIJRAH calendar
SET LINESIZE may dump SQLPLUS
V$SESSION.OSUSER is always 'ORACLE' using JDBC Thin
Dynamically changing <event:10270> can result in an ORA-600 [252]. Workaround: Do not dynamically change the setting of this event (eg: via ALTER SESSION). Always specify it at instance level if it needs to be set.
If rollback encounters a media corrupt block (ORA-1578) then the block is skipped and UNDO is discarded. Subsequent restore and roll forward of the corrupt file can leave the block transactionally inconsistent as the changes to roll out the transaction are never issued against the block.
DESCRIBE <table> shows NUMBER when FLOAT was used
Referencing of synonyms within DDL other than those supported(AUDIT, COMMENT, GRANT, NOAUDIT and REVOKE plus others within suqbuery clauses such as in CREATE TABLE, VIEW etc.) is not validated and can lead to server crashes , dictionary corruption and strange errors .
Stemming queries on words containing accented letters fails on text indexes with base_letter preference enabled.
The value of v$session.sql_address iss not correctly cleared when a cursor is unmapped.
Pro/OCI clients single row select may use more server CPU than pre 8.1 clients.
This is an enhancement related to the fix for bug:947460. The ALTER USER syntax is extended to allow the current users old password to be specified when changing their own password. This new clause is only required when password complexity checking is enabled. The old password is required to avoid an ORA-28003 error when a PASSWORD_VERIFY_FUNCTION is in use. eg: Non DBA users can change their password using the syntax: ALTER USER user IDENTIFIED BY newpassword REPLACE oldpassword
Concurrent ALTER TABLESPACE READ ONLY can fail with an ORA-60
Wrong results possible in PLSQL using uninitialized BINDS in SQL
ORA-600 [KXTOTOLC_LOBOPT] accessing a LOB column (:NEW.LOB_COLUMN) from within a trigger
ORA-942 can occur when attempting to access a LOB attribute of an ADT obtained from INSERT .. RETURNING statement.
MAXVALUE keyword HIGH_VALUE column of DBA_TAB_PARTTIONS is not capitalized.
Select from V$LATCH may hang / dump after RESOURCE_MANAGER_PLAN change.
eg: ALTER SYSTEM SET RESOURCE_MANAGER_PLAN=<new plan>;
SELECT * FROM V$LATCH;
may hang or dump
If SESSIONS_PER_USER is limited PQ slaves over the "sesions_per_user" limit dump ORA-2391 trace files
After a session inserting into a global temporary table is killed, another session may not be able to drop the global temporary table.
BACKUP CONTROLFILE TO TRACE output is wrong if using BACKUP/STANDBY Controlfile. In particular read only files may be listed when they should not.
ORA-29900 is possible from PQ using extensible ANCILLARY-PRIMARY operators. Eg: This can affect Oracle Text CONTAINS / SCORE operators
getUpdateCount() does not behave correctly (as per the JDBC spec)
SQLCODE may not get the correct error number if SQLCODE is declared outside the DECLARE SECTION, even if the application is precompiled with command line options "mode=ansi declare=yes assume_sqlcode=yes".
Invalid TABLE() subqueries in SQL statements can error with PLS-801 [22016] or [22052] when compiled if using the pre-9i PLSQL engine.
If external name or internal name attributes (OCI_ATTR_EXTERNAL_NAME/ OCI_ATTR_INTERNAL_NAME) are set, then an implicitly started transaction (not started by OCITranStart) will get ORA-02041 if it attempts to access a remote site. This restriction also applies to a remote PL/SQL procedures which has done a commit and then attempts to access a remote site. The most troublesome part of this restriction occurs for ODBC running under Microsoft Transaction Server, since the external name has to be set to allow MTS to control transactions. The attributes have to be set prior to session begin, which is before there is any chance to know whether or not the connection will actually be controlled by MTS. The restriction also means that XA local transactions, for example, can't use database links, and that certain restrictions apply to what remote PL/SQL procedures can do. Workaround: In some cases the problem can be coded around, or a real global transaction can be started.
OCI application may dump core when updating more than one LONG column using dynamic binds with callbcaks.
"PLS-00553: character set name is not recognized" possible from some RMAN operations if the target database is not open.
Names cache is never checkpointed
ProCobol: Use of EXEC SQL INCLUDE before WORKING-STORAGE SECTION may generate incorrect code.
Parallel TO_LOB(LONG) may dump
Drop table from dynamic sql in a PLSQL does not free the space until the PLSQL call finishes.
"Rows loaded" information may be incorrect when the object being loaded runs out of space during a conventional path load.