Total 276 bugs fixed in Jul-2022 Oracle 21c updates (21.7RU)
BUG_ID | DESCRIPTION |
|---|---|
| 25655012 | UNABLE TO MONITOR PARALLEL QUERY (MARKED INACTIVE AFTER 30MINS) IN SQL MONITOR |
| 28044739 | FTS PLAN FOR REMOTE WHEN SQL CONTAINS NESTED TABLES AND REMOTE TABLES |
| 28089112 | ALTERNATIVE QUOTING Q[LITERALS] GENERATES WRONG RESULT THROUGH JDBC |
| 28513129 | VERY LARGE SQL GENERATED FROM GRAPH QUERY NEVER GETS A QUERY PLAN |
| 29413205 | SELECT QUERY FAILS WITH ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [EVAPLS] |
| 29811720 | DATAPATCH PRECHECK ENHANCEMENT |
| 29927360 | UPDATING PROXY USER PASSWORD VIA GETCONNECTION() UPDATES WRONG PASSWORD |
| 29948154 | ORA-01403 USING TEXT INDEX IN ADG |
| 30706073 | ORDER_SUBQ HINT IS USUSED |
| 30771009 | PSR PERF SUPPORTING ACS FOR AUTO-SPM |
| 31192261 | CORRECT ERROR HANDLING IN PRESENCE OF MULTIPLE ODCI*CLOSE CALLS |
| 31487775 | ADB-CC BB UI PDB RMAN-06813 COULD NOT TRANSLATE PLUGGABLE DATABASE |
| 31504723 | SELECT QUERY FAILED WITH ORA-00979 AFTER UPGRADE TO 19C |
| 31531079 | AQ RESPONSYS ON-PREM EFFICIENT SPACE MANAGEMENT NEEDED FOR TEQ INTERNAL SEGMENTS |
| 31676324 | GOLDENGATE CAPTURE STARTED BY REGISTER EXTRACT SHOULD STOP AFTER FINISH DICTIONARY LOADING |
| 31768866 | CDB_RAC_AUDIT ORA-7445 [__INTEL_AVX_REP_MEMCPY] WAS ENCOUNTER WHILE RUNNING THE WORKLOAD CONCURRENTLY |
| 31834611 | SR21.1CHAOS_V2 - TRC - QERTBRANGEMAP - ORA-600 [12701] |
| 31960603 | PRO*COBOL COMPILATION IS GENERATING SEGMENTATION FAULT AFTER APPLYING PATCH 28704412 ON 18C ORACLE CLIENT |
| 31974187 | ORA-07445 [MDCGPP()+83] |
| 32012400 | ACCESS ADVISOR IS FAILING WITH ERROR ORA-13602 FROM OEM PARAMETER RETAIN_UNIQUE_INDEX |
| 32017570 | INTERMITTENT ORA-03106 ERROR FROM OCI APPLICATION |
| 32104578 | IMPROVE DIAGNOSTICS FOR HSM CONNECTIONS |
| 32122804 | PET ORA-7445 [ATBFMEXDOMETADATA] WHILE EXCHANGE PARTITION |
| 32166950 | CORRECT VALUE OF REQUIRED_MIRROR_FREE_MB AND USABLE_FILE_MB FOR EXADATA SYSTEMS |
| 32196943 | XF21.3ADBD_FLASHBACK_TABLE - TRC - KSLILCR - ORA-7445 [KGHCLN_INT()] |
| 32224140 | CONVERT ASSERT TO PDB SPECIFIC IN KPDBAOPENCLOSERECOVERCBK |
| 32233406 | INCORPORATE DIAGNOSTICS FROM SRDC FOR ORA-4023 INTO THE PRODUCT |
| 32234148 | BETTER DIAGS ON AN ORA-60 (DEADLOCK) |
| 32240272 | CALL KZSRCRL CONDITIONALLY ONLY FOR OGG AND XSTREAMS |
| 32255529 | ASMCMD CREDVERIFY DOES NOT DETECT CREDENTIAL PROBLEM WHEN ASM IS RUNNING |
| 32255762 | PERF_ENH ENHANCEMENTS TO HINT USAGE REPORT IN 19C |
| 32258388 | LOGMINER SESSION ACTION MISSING DATA FOR CDB SUPPORT |
| 32294031 | JSON_VALUE FAILS WITH ORA-29903, ORA-20000, DRG-00100 [50600],[DRED.C],[1927],[] |
| 32338919 | PERFORMANCE ISSUES WITH NFV4. |
| 32371828 | DUP REARCH FOR DUPLICATED, DEFAULT VALUES OF A COLUMN DOESNT GET PROPAGATED TO SHARDS |
| 32449909 | TPCDS BLOCKCHAIN COMMIT TIME PERFORMANCE NEED TO BE IMPROVED AFTER THE LOAD |
| 32506166 | PIPE FILE DESCRIPTOR LEAK EACH TIME USING EXTERNAL JOB |
| 32514516 | STRESS FA MEM FMW12C MEMORY LEAK IN AQJMSDESTINATION CLASSES |
| 32535156 | INSERTS INTO BLOCKCHAIN TABLE HAVE UNCESSARY OVERHEAD |
| 32550894 | HEAVY WAITS ON LIBRARY CACHE MUTEX X WHEN INSERTING INTO A BLOCKCHAIN TABLE |
| 32556311 | ADD WARNING IF GCS_SERVER_PROCESSES PARAMETER SET VALUE IS LOWER FROM DEFAULT |
| 32593877 | BLOOM FILTER IS NOT CHOSEN DUE TO MISSING PARTITION LEVEL STATISTICS |
| 32606093 | 19.9 ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [KKQTUTLGETFIRSTCOL()+20] |
| 32609512 | CRASH ON KOXSS2GPAGE ON CROSS-CONTAINER VIEW WITH XMLTYPE |
| 32625160 | WRONG RESULTS WITH WHERE WITH AN IN WITH MULTIPLE VALUES AND JSON_VALUE INDEX |
| 32649737 | SELECT * FROM DBA_DIRECTORIES IN PDB RETURNS ORA-12801,ORA-48189 |
| 32682586 | DBA_TABLESPACE_USAGE_METRICS DOES NOT SHOW UNDO TABLESPACE WHEN UNDO_TABLESPACE VALUE IS LOWER CASE |
| 32705734 | XF23.1MFSR_VERSIONS_QRY - TRC - KJBDOM_ENABLE_PDBISOLATION_CHKS - ORA-700 [KJBDOM_ENABLE_PDBISOLATION_CHKS ENQS] |
| 32712791 | ADD TRACING IN KKQCTTCALO() |
| 32726772 | LMS PROCESS HUNG IN KJCSSBA_PREALLOC() WAITING FOR GES MESSAGE BUFFER ALLOCATION |
| 32732179 | TXTCDB ORA-14552 CANNOT PERFORM A DDL, COMMIT OR ROLLBACK INSIDE A QUERY OR DML |
| 32737827 | IMPROVE THE DIAGNOSIS IN METHOD KZEKMRTK FOR THE ERROR ZTERR_KEY_NOT_FOUND |
| 32802926 | QUERY ON V$DATAGUARD_STAT TAKES A VERY LONG TIME AFTER UPGRADING TO 19C FROM 11.2.0.4 |
| 32804609 | ATP DG REINSTATE OPERATION TERMINATES W/ CDG-50301 - FAILED TO REINSTATE ONE OR MORE INSTANCES |
| 32848060 | LNX-21.3-RDBMS ORA-29770 GLOBAL ENQUEUE PROCESS IS HUNG AND INSTANCE TERMINATED. |
| 32852484 | EMIT INFO MESSAGES IN THE ASM ALERT.LOG WHEN DISKGROUP SPACE USAGE EXCEEDS EXADATAS RESERVED SPACE REQUIREMENTS |
| 32856640 | COLUMN_AUTH_INDICATOR WITH LEFT JOIN RETURNING NULL INSTEAD OF 1/0 |
| 32868344 | AIM ORA-600 [QKAINITGRPFNS.3] - QKAINITGRPFNS |
| 32874225 | EXASCALE WHEN IN CLOUD MODE, SKIP VAULT OPERATIONS |
| 32913610 | 19C OLS SESSION LABEL FOR USER THROUGH A TRUSTED PACKAGE WITH FULL PRIVILEGES SHOWS NO ROWS |
| 32920489 | ORA 7445 [KJDR_PRM_SCAN] WHILE RUNNING CUSTOMER WORKLOAD WITH ASO |
| 32926653 | ORA-47306 ERROR WHEN TRYING TO ALTER USERS PASSWORD SINCE UPGRADE FROM 12.2 TO |
| 32936537 | SIGNIFICANT CONTENTION ON LIBRARY CACHE MUTEX X WHEN FIRST INSERTING INTO A TABLE |
| 32940440 | ORA-12154 SHOULD GIVE MORE DETAIL |
| 32943694 | TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KJXBSTATREQ+3773 |
| 32947268 | ERROR ORA-16625 GENERATED AFTER SWITCHOVER |
| 32958616 | OPTIMIZE CONTROL FILE I/O UNDER KCCREC_RBL<-KCCREC_READ_WRITE<-KCCUGG?KCCGTS?KRTCKTT?KPDBASWITCHOPENCLOSE |
| 32961142 | POSSIBLE SEGVS IN KDZK* ON SSE4/AVX/AVX2/AVX512 PLATFORMS |
| 33001615 | CN DEADLOCK LIBRARY CACHE LOCK=LIBRARY CACHE LOCK? (CYCLE) AFTER UPGRADED TO 19.10. |
| 33005241 | 19CCUSTOMERUPGRADE ORA-00600 [KDSGRP1] |
| 33022926 | AIM ORA-600 [16607] - QMXTKISNONPUSHABLELOBCOL |
| 33025005 | LATCH CACHE BUFFERS CHAINS AFTER UPGRADE FROM 12.1.0.2 TO 19C |
| 33034846 | VSS BACKUP THROWS ORA-959 IN CDB MODE - BACKUP CODE WAS NOT HANDLING PDB NAMES CORRECTLY |
| 33038120 | LARGE NUMBER OF PDB DOMAIN REQUEST QUEUES LATCH GETS DURING PDB FAILOVER |
| 33047645 | ORA-600 [KCSGSSN8_2] |
| 33048074 | GDSCTL PRCR-1207 THERE ARE NO RUNNING RESOURCES TO STOP, SAME AS BUG 31532308 |
| 33061595 | SQL TUNING ADVISOR FAILED WITH ORA-56900 FOR SQL WITH HIGH NUMBER OF BINDS |
| 33065343 | SOME ORA ERRORS IN 0 TO 65535 RANGE ARE MISSING CAUSE OR ACTION |
| 33065526 | ORA-00600 [KTCRAB CALLER PASSED INVALID XCB] DBMS_SQLCONTROL_INTERNAL |
| 33069889 | GETTING ORA-28113 POLICY PREDICATE HAS ERROR IN RESYNC WHEN DATA VAULT IS ENABLED. |
| 33075093 | HEAP MEMORY ISSUE WHEN USING THE JDBC 21C DRIVER DUE TO LRUSTATEMENTCACHE |
| 33080651 | OCI PROD - LAUNCH ISSUE - WHEN AQ IS FAILOVER TO SECONDARY NODE |
| 33088863 | AIM ORA-600 [KSFDFIDS2] - KSFD_ODMFIDS |
| 33089096 | AFTER UPGRADE TO 19C , SEVERE PERFORMANCE DEGRADATION FOR QUERIES. |
| 33090127 | Fix for Bug 33090127 |
| 33116481 | FSFO RESULTED TWO PRIMARY DATABASES, DATA LOSS AFTER RECREATING THE OLD PRIMARY FROM NEW PRIMARY. |
| 33120920 | AIM ORA-600 [KOKLGETLOCANDFLAG BNDPOS] - KOKLGETLOCANDFLAG |
| 33121934 | IAD E23POD LIBRARY CACHE LOCK / LOAD LOCK / MUTEX X DURING CONNECTION STORM |
| 33132050 | DATABASE IO ERROR WHEN ENABLING DNFS WITH NFSV4.1 |
| 33135374 | RS-700 [OFFLOAD SERVER TERMINATED DUE TO HIGH MEMORY CONSUMPTION] |
| 33136601 | ENABLE RESET OF FORCED INDIRECT SENDS AFTER TIMEOUT OF DLM MESSAGE SEND. |
| 33142479 | OPTIMIZE RS PRIORITY BUMP DURING RECONFIG BUMP AFTER ACKING FREEZE, INITIATE BUMP VERY EARLY |
| 33146001 | TRANSIENT ORA-00604 IN DRC LOG DURING STANDBY STARTUP |
| 33147065 | XSTREAM LOSES PRECISON FOR INTERVAL AND TIMESTAMP DATA TYPES |
| 33161424 | ENHANCE ORACLE HIVE METADATA TO DETECT HIVE TRANSACTIONAL TABLES FOR DD VIEWS |
| 33179718 | A WAY TO ADD OPCODE IN HANG ANALYZE DUMP WHEN CROSS INSTANCE CALL RELATED WAIT EVENTS ARE INVOLVED |
| 33181349 | SESSION POOL FOR LOCAL SERVICE FAILS WHEN MULTIPLE TABLE FAMILIES ARE PRESENT |
| 33186650 | REGRESSION TRACKING BUG FILED FROM MERGEREQ |
| 33189199 | ERROR 16198 FOR LAD2 AFTER STANDBY DATABASE RESTART [HUNG I/O] |
| 33190761 | AH IMPROVE SPIN CHECK DIAGNOSTICS AND HANDLE SAGEASM-E HIT ORA 600 [KCBBPIBR_WAITALL_2] |
| 33195897 | ADD RETURN CHARACTER WHEN PRINTING BEFORE IMAGE SCN |
| 33201415 | AQ Notification not Working when DMLs Replicated with Goldengate |
| 33203951 | AIM ORA-7445 [RI_RESMNGR_ADD] - RI_RESMNGR_ADD |
| 33205229 | PHX E7POD QSUEFF3YZUQPQE7_CELL1OCNSDB GOLDENGATE EXTRACT IS WAITING FOR ARCHIVE LOG FROM AUG 1ST |
| 33216590 | SELECT GROUP BY FAILS WITH ORA-7445 [EXPCHECKEXPREQUIV()+342] [SIGSEGV] |
| 33241118 | JED E1POD RMAN IS NOT RESTORING THE RIGHT FILES WHEN PITR BELONGS TO ORPHAN INCARNATION |
| 33241692 | LOTS OF CHECKING SER BIT VECTOR MESSAGES IN ALERT LOG |
| 33245879 | JSON_VALUE INDEX NOT PICKEDUP BY JSON_EXISTS WHEN THERES AN ARRAY ELEMENT IN THE PATH |
| 33254019 | PREREQ CHECK FAILS IF A PDB HAS AN EXTRA PATCH TO BE INSTALLED (IN COMPARISON TO ROOT IN RU) |
| 33261707 | ORA-600 [KGHSTACK_FREE1] KFKBESTEFFOFFLN RTI 24514376 |
| 33278440 | IMPROVE DIAGNOSTICS IN DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP PROCEDURE |
| 33282502 | ADD TESTS TO LRG OF SANITY_CHECKS |
| 33282504 | ADD TESTS TO LRG OF SANITY_CHECKS (SECOND BUG) |
| 33289734 | UNIFIED_AUDIT_POLICIES COLUMN IS EMPTY FOR CERTAIN AUDIT RECORDS FOR PRIVILEGE AUDITING(CREATE VIEW PRIVILEGE) |
| 33292429 | WRONG STATS (NUMBER OF DISTINCT KEYS) ON COMPRESSED SECONDARY INDEXES |
| 33294123 | KZTDE IS THE DIAGNOSTIC TAG WHICH SHALL BE PREFIXED TO IMPROVEMENTS DONE AS PART OF 33115438 AND 33023671 |
| 33305175 | ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KGHSSC_GETBUF] |
| 33308736 | DATAPATCH HANGS AS CATCON TRIES TO START MANY PROCESSES IN EXA ENVIRONMENTS |
| 33309324 | NEED ASMCMD CREDFIX TO HANDLE FAILURES WHEN IMPORTING CREDENTIALS INTO OLR |
| 33312932 | DISABLE RDMA REGISTRATION ON STORAGE DEVICES IF RDMA REGISTRAION WERE TO FAIL |
| 33315230 | INMEMORY 1MB POOL SPACE LEAKS |
| 33316815 | AIM ORA-7445 [KKOIOP] - KKOIOP |
| 33317740 | AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBZPBUF_3] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT |
| 33317752 | AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBZIB_6] SEEN IN SMON TO PDB-SPECIFIC ASSERT OR SOFT ASSERT |
| 33319065 | EJAM GSI- PERFORMANCE ENTIRE POD-ORA-04036 PGA_AGGREGATE_LIMIT ISSUE |
| 33320455 | 19.10 ENQ DX - CONTENTION WHEN AUTONOMOUS PROCEDURE OVER DBLINK HANGS |
| 33329192 | DDL REPLICATION ERROR AFTER CHANGING AN EXPIRED PASSWORD IF PASSWORD VERIFY FUNCTION EXISTS |
| 33334957 | SUBQUERY IN CURSOR REFERENCES MATERIALIZED SUBQUERY IN WITH GIVING WRONG RESULTS |
| 33339444 | NO PERMISSION TO ACCESS PMEM FILESTORE USING FUSE WHEN ORACLE SERVER BINARY IS SETGID TO A DIFFERENT GROUP |
| 33339868 | AQ 10852 TRACES DUMPS NULL MSG ID ALWAYS FOR DEQUEUED MESSAGES |
| 33345269 | DUPLICATE ALERT.LOG IF ORACLE_PATH IS SET |
| 33352740 | VERY HIGH WAITS WAITING FOR RMAN BACKUP & RECOVERY IO AFTER UPGRADE TO 19.11 |
| 33367076 | MAKE KGI ASSERTS USEFUL FOR MITIGATION. |
| 33370332 | SKIP PDBS THAT DO NOT HAVE FDA ENABLED TABLES |
| 33376694 | IN 19C ANALYTICAL FUNCTION LAG RETURNS A VALUE FOR THE FIRST ROW WHEN NORMALLY A NULL IS EXPECTED |
| 33380058 | LOGMINER BUILDER PROCESSES SHOW HIGH CPU EVEN THE EXTRACT IS IDLE |
| 33381839 | ADB-D - EXPDP FAILED WITH ORA-62612 OPERATION DISALLOWED; COLUMN WITH ROWID TYPE CANNOT BE CREATED IN ORACLEAUTONOMOUS DATABASE CLOUD |
| 33389651 | AV QUERIES CREATE NEW CHILD CURSOR DUE TO BIND_EQUIV_FAILURE (BIND MISMATCH) |
| 33390717 | AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KTFTDROPEXT-1] SEEN IN SMON TO PDB-SPECIFIC ASSERT OR SOFT ASSERT |
| 33390917 | AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBTSE_POPULATE_TBSKEY_1] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT |
| 33390925 | AH DB23 PROJECT 84763 CONSIDER CONVERTING ORA-600 [KCBBXSV_NWP] SEEN IN DBWN TO PDB-SPECIFIC ASSERT OR SOFT ASSERT |
| 33392926 | INSERTING JSON DATA INTO A TABLE WITH MV FAILS WITH ORA-29913, ORA-04091 |
| 33397605 | AIM ORA-600 [QSMOPREPLOCKNAME 1] - QSMOPREPLOCKNAME |
| 33402361 | LNX64-21C ORA-7445 COREDUMP AT KSS_GET_TYPE()+6 |
| 33402456 | STANDBY EXPERIENCING HIGH STANDBY QUERY SCN ADVANCE WAITS. |
| 33410321 | CN?ORA-06553 FROM NAMED ARG TYPE CALL FROM SQL |
| 33418112 | TRACKING BUG FOR LRG 24619245 - CELL HANDLE LEAK |
| 33418443 | ORA-06553 PLS-801 ORA-06544 ORA-00600 [15419] [78405] |
| 33420096 | NO WAY TO DISABLE IO MONITORING IN DRF |
| 33421440 | AWR IO STATS AND V$IOFUNCMETRIC AND SHOWING WRONG VALUE AFTER 19.10 |
| 33422877 | GSM SEND MALFORMED ONS FAN MESSAGE FOR SERVICEMEMBER EVENTS WHEN IT HAS ORPHANED BUDDY REGIONS |
| 33424192 | XMLFOREST IN 19C CAUSING ORA-07445 [QCTCPQBL()+68] |
| 33427991 | ORA-600 [KJRBKTHK MASK], [.JWH], [0] CRASH ASM INSTANCE AFTER LINUX LIVE MIGRATION ENDED |
| 33440899 | PRINT MORE INFO FOR ORA-600 [KTSPFMTHWM] TSN, RDBA AND DUMP THE SEGMENT HEADER BLOCK |
| 33441073 | Fix for Bug 33441073 |
| 33447015 | ORA-372 SHOULD PROVIDE THE ABSOLUTE FILE NUMBER INSTEAD OF RELATIVE FILE NUMBER |
| 33447957 | HIGH LIBRARY CACHE LOCK AND LIBRARY CACHE MUTEX X WAITS AFTER APPLYING 19.11 DB RU WHICH HAS BUG 30220932 FIXED |
| 33460870 | RHP DELETEHOME STOPS LISTENER RUNNING FROM DIFFERENT DBHOME |
| 33464061 | TT23.1ASAN HEAP-BUFFER-OVERFLOW IN PGA AT KKZPMARKFC+405 |
| 33467715 | REGRESSION TRACKING BUG FILED FROM MERGEREQ |
| 33470254 | UPDATE FAILS WITH ORA-00600 [13030], [20] |
| 33480765 | DISABLING CURSORTRACE DOESNT SEEM TO WORK FULLY UNDER SHARED SERVER USE |
| 33485134 | AFTER SHUTDOWN AND STARTUP GSM, THE GSM IS REJECTING REGISTRATION FROM ALL OF THE DATABASES |
| 33486067 | KSFD_ODMCRT() IMPLEMENTATION DOES NOT RESULT IN CONTENTS OF EXISTING FILE TO BE DISCARDED WHEN KSFD_REUSE/KSFD_RESIZE FLAGS ARE SPECIFIED |
| 33491676 | IMPROVE TRACE MESSAGE WHEN WALLET FAILS TO OPEN DURING MIGRATION IS IN PROGRESS |
| 33492066 | DBMS_AQADM.PURGE_QUEUE_TABLE SKIPS DELETING ENTRIES FROM TIME MANAGER IOT |
| 33492136 | IMPORT OF SOME TABLES WTIHOUT ACCESS_METHOD=EXTERNAL_TABLE PARAMETER ARE FAILIG |
| 33503732 | ADD GCS DRM FREEZE IN ENTER SERVER MODE AS A TRUSTED WAIT EVENT IN HANG MANAGER |
| 33504158 | LOW CONTROL FILE RDMA% DURING PDB OPEN DUE TO MGA BUFFER ALLOCATION SLOWNESS |
| 33504626 | DBMS_SPACE_ADMIN.TABLESPACE_DUMP_BITMAPS DUMPS FFB AS CORRUPT |
| 33505158 | TEST HANG. CKP INCOMPLETE DUE TO CAN NOT ENTER DLM |
| 33513906 | EVEN WITH 32730701 QUERY REGRESSION ON V$DIAG_ALERT_EXT AFTER UPGRADE FROM 12.1 TO 19C |
| 33514440 | SYS_REMAP_XMLTYPE OPERATOR IS CAUSING PERFORMANCE ISSUES WHEN IT COMES TO LARGE DATASETS |
| 33516571 | GI PATCHING FRA EFRA2A007-FXHMR5 CRS POST PATCH FAILED WITH CLSRSC-205 FAILED TO UNINSTALL ADVM/ACFS |
| 33517703 | DB WIDE HANG, SMON WAITING ON DBW |
| 33520658 | SELECT TO_NUMBER CAUSING ORA-03113 END-OF-FILE ON COMMUNICATION CHANNEL |
| 33523982 | BLOCK CHECKING MEDIUM DOES NOT CHECK SELF REFERENCING CHAINED CU PIECES |
| 33525448 | LNX64-19.13-RAC,DB HANG AT CPU OR WAIT CPU<=LOG FILE SWITCH (CHECKPOINT INCOMPLETE)... |
| 33527630 | SCRUB STOP COMMAND ISNT STOPPING SCRUB OPERATION |
| 33527663 | AMDU FAILS TO DUMP METADATA FROM STRIDES > 4 |
| 33532517 | PRINT TSN, RDBA IN THE ORA-600 [KTUGCT CORRUPTION DETECTED] ARGUMENTS |
| 33533269 | PRINT OBJN OBJD TSN BLOCK IN ARGS OF ORA-600 [6006] |
| 33545633 | HOSTNAME BASED DN MATCHING DOES NOT WORK WITH HTTPS_PROXY |
| 33553452 | LNX64-1913-CMT ODAVM REMOVE FILE GROUP CASCADE AS ORACLE USER FAILS WITH ORA-15260 |
| 33555482 | AIM ORA-600 [KJBRMNOT WN] - KJBRWREQ |
| 33558087 | CBTREE CREATE FUNCTION BASED INDEX FAILS - WHEN FUNCTION RETURNS NULL |
| 33568355 | TXTCDB ORA-7445 [DREDFO()+792] DURING RSI BASED TEXT QUERY EXECUTION. |
| 33580595 | DD AND VAL BLOCKS SHOULD BE DUMPED TO AMDU EVEN IF BLOCKS ARE ZEROED OUT |
| 33581395 | SATURN BRANCH GENERATED A DIF ON DELETE FILE OP |
| 33584585 | NLSN QUERY HANG AND ASM HIT ORA-600 [KFK_IODONE_INVALID_BUFFER] |
| 33584637 | 19C UNIFIED AUDITING GIVING WRONG RESULT IF POLICY CONDITION IS LONG |
| 33596056 | ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KSFDODM_LIBGETATTR] |
| 33596361 | ORADEBUG SUBHEAP_GC SHOULD FORCE GARBAGE COLLECTION EVEN IF THE THRESHOLD IS NOT MET |
| 33598703 | HIGH WAITS ON ENQ TX - INDEX CONTENTION MORE SEVERLY THAN 19.4 |
| 33601673 | ADD A SUMMARY JSON REPORT TO SANITY_CHECKS |
| 33607613 | INCORRECT TRACING IN KRSG_TEST_GAP() ROUTINE |
| 33617587 | SAGEASM-E QUERY INDIRECT EXTENT RETURNS NO ROW AFTER MIRROR SPLIT COPY IS DROPPED |
| 33624052 | XF23.1IMC_FORCE_QH_SR - TRC - KJBCLOSEIMC - ORA-7445 [KJBCLOSEIMC()] |
| 33647716 | ASM HIT ORA-600 [KFFBADDBLK04] |
| 33651993 | ORA-15064 AND ORA-15078 WITH THE FAILGROUP TESTING FOR THE DB USING NORMAL REDUNDANCY |
| 33663444 | ALTER DATABASE SWITCHOVER VERIFY GETS ORA-16467 ERROR |
| 33664959 | AIM ORA-7445 [KDDLRC] - KDDLRC |
| 33664976 | DIAGNOSTIC TRACING IMPROVEMENT IN SHARED CURSORS AREA UID 581 |
| 33666803 | ENCOUNTERS CHECKPOINT HANG WHEN DIFFERENT NUMBER OF LMS IS SET |
| 33676296 | UNCONDITIONALLY SETTING SA_CACHETHIS IN NFS4.1 SEQUENCE OP CAUSES IO ERRORS WITH ONTAP |
| 33677163 | Adding columns to ACDR Column Resolution enable table receives error ORA-01400 on insert |
| 33679665 | DBMS_HADOOP NEEDS TO SUPPORT HIVE 3.0 |
| 33704431 | SHARDING DEPLOYMENT FAILS DUE TO REGRESSION IN VNCR REGISTRATION OF LONG FQDN HOSTNAME |
| 33708958 | IN RAC DEQUEUES AT NON-OWNER INSTANCE SEARCH DEQUEUE LOG FOR EVERY DEQUEUE PERMANENTLY POST BOUNCE DEGRADING PERFORMANCE |
| 33710568 | 19.14 DBVM PROVISION DCS-10001 FAILED TO CREATE THE DATABASE PRCZ-4001 PRCZ-2103 [FATAL] ERROR IN PROCESS ?/BIN/ORAPWD |
| 33714000 | FADBRWT STRESS FA ORA-07445 [KSKENFORCERUNAWAYGENCB] DURING FA BATS WORKLOAD |
| 33727390 | BRING DOWN RDMA PATHS ON TCP DOWN |
| 33727922 | Logminer Builder ORA-600 [krvuatla20] and Capture ORA-600 [600] |
| 33729569 | PROTOCOL VIOLATION CAUSED BY ISVALID(SOCKET) RIGHT AFTER PROXY AUTHENTICATION |
| 33729692 | ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FAILED IN OCI DBSYSTEM |
| 33746114 | INCORRECT GAP ANALYSIS WHEN THERE ARE DISABLED REDO THREADS |
| 33749984 | ADD DATABASE RESULTS IN ORA-45540 CALL TO SRVCTL FAILED WITH STATUS 1, ERRORS PRCR-1001 |
| 33751080 | DBMS_OUTPUT IS LEAKING PGA MEMORY 19C |
| 33755161 | 19.15 DBRU DROP GETTING DATAPATCH ERROR ON PDB DUE TO BUG 30910255, 32914978 (LABEL RDBMS_19.0.0.0.0_LINUX.X64_220106) |
| 33757064 | OKV JOBS INTERMITTELY FAILING WITH ORA-01031 BEING RAISED BY DV CODE |
| 33761538 | ORA-13200 INTERNAL ERROR [MDMRTBUILDGEODRAY 1] IN SPATIAL INDEXING |
| 33763570 | AIM ORA-600 [QJSNPLSSETINT NEWNODE,!OK] - QJSNPLSSETINT |
| 33764761 | SYS_CONTEXT WITH NAMESPACE RETURNS EMPTY AFER EXECUTION OF DBMS_SCHEDULER |
| 33767425 | OUTPUT ADDITIONAL INFORMATION RIGHT AFTER THE MESSAGE POSSIBLE NETWORK DISCONNECT WITH PRIMARY DATABASE |
| 33770883 | USERS WITH SCHEDULER AUTHORIZATION CANNOT ENABLE/DISABLE JOBS WHEN JOBS ARE PROTECTED BY A REALM |
| 33774856 | IAD ORA 600 [ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KKDOILSN1], [0], [16961889] |
| 33777176 | DUPLICATE DATABASE USING DNFS RESULTS ORA-16032 ORA-01264 ORA-19800 |
| 33780001 | BDSQL4.1.2 21C AND OSS20 BASED CELLS OBSERVE QUERY HANG WITH DOP16 |
| 33786208 | ORA-7445 [KKBORTC()+111] ON CREATING VIEW KU$_ATTR_DIM_JOIN_PATH_VIEW WITH TYPE |
| 33796040 | ORA-600 [KJBLCWSCN !WR] |
| 33798328 | SCHED HUGE NO. OF SCHEDULER JOB SLAVE TRACE FILE GENERATED IN SCHEDULER/OTHER STRESS TESTS - KGHUPR_FLG |
| 33809062 | TRACKING BUG FOR REGRESSION RTI 24544369 CAUSED BY PKNAGGS_BUG-32472737 APPROVED/INCLUDED IN 21.0.0.0 ADBSBP |
| 33810360 | Fix for Bug 33810360 |
| 33813849 | ORA-00600 WHILE TRUNCATING TABLE |
| 33845824 | ENABLE EVENT BASED STACK DUMP IN KSVKILLSLAVES |
| 33848294 | ORA-00600 [KQRPRE1-KQRDSTRU] |
| 33863183 | EXASCALE CLIENT SIDE AGGREGATE FIXES POST 21.3 |
| 33865116 | REPLACE OBJ FILES IN LIBKNLOPT.A WITH FILES IN RDBMS/LIB WHILE LINKING ORACLE |
| 33865495 | AH FOR DIA0, START RECONFIGURATION OR RESTART MASTER PROCESS IF DIA0 LEVEL COMMUNICATION FAILS |
| 33867208 | AGGREGATE BUG FIXES FOR EXASCALE IN DB |
| 33870373 | SHUTDOWN IMMEDIATE TAKES TOO LONG |
| 33871591 | ORA-00600 [QCSRWAE1], JSON WITH OBJECT TYPES |
| 33871761 | ENABLE DIRECT RETURN OF DLM MESSAGE BUFFERS TO LGWR PROCESS |
| 33875167 | ORA-13199 WK BUFFER MERGE FAILURE |
| 33897055 | TRACKING BUG FOR RTI 25101314 |
| 33902235 | ADD MORE DIAGNOSTICS WITH SRSNEXT ASSERTS |
| 33909838 | SSS_XCPT_SAFESUSPEND TO SUSPEND THREAD IF NO LOCKS HELD |
| 33916081 | Fix for Bug 33916081 |
| 33921410 | ORA-00600 [KCL_SND_CUR_2]/CORRUPT BLOCK DURING PREPARING FOR TRANSFER |
| 33932721 | APPLYING DATAPATCH TO 19C RAC CDB DATABASE WITH DBSHAPES AS ODB1 ALWAYS FAIL |
| 33933784 | Fix for Bug 33933784 |
| 33937333 | JDBCSTRESS UCP FCF NON-AC HA MODE JDBC CLIENT HANG WITH CORE DRIVER AND FCF ENABLED |
| 33947516 | DBID NOT SET IN FLASHCACHE IOCTLS TO CELLS (REGRESSION FROM 19C) |
| 33957025 | ORA-7445 IN KDST_COMPILE() OR QEESRINITOPNMUTRSET() IN 19.13 AND ABOVE WITH MULTI-BYTE CHARSET |
| 33960647 | TRACKING BUG FOR RTI 25201958 |
| 33970659 | DBWX HANG WAITING FOR WRITE PERMISSION |
| 33973695 | SPARQL QUERIES WITH GROUP BY + ORDER BY ADD REDUNDANT VALUE$ JOINS |
| 33987170 | CHECKPOINT INCOMPLETE HANG PLUS ORA-00700 [KCBBXSV_NOWRITESBUF] |
| 33987636 | EXPOSE HELP TEXT FOR DGPDB COMMANDS |
| 33988974 | HIT ORA-00600 [KCLCHKBLKDMA_3] FOLLOWED BY [KCLALC_1] |
| 33990985 | 21.6 DBRU PATCH MISMATCH IN VERSION IN BUILD LABEL INFO IN TRACE LOG |
| 34001406 | MVIEW CREATION WITH ON PREBUILT TABLE WITH REDUCED PRECISION CLAUSE FAILS WITH ORA-03113 |
| 34003643 | ORADEBUG LKDEBUG -M RECONFIG SHOULD REMASTER ALL PDBS |
| 34023644 | SA_CACHETHIS IN NFS4.1 SEQUENCE OP IS SET INCORRECTLY IN BUG 33676296 |
| 34053514 | ADB-CC RESTORE CLONE PDB FROM BACKUP FAILED -- BACKUP PIECE ALREADY INCLUDED |
| 34066251 | TRACKING BUG TO BACKPORT TXN RAMISRA_RTI-25249075 ON 21 |
| 34094291 | Fix for Bug 34094291 |
| 34110342 | TRACKING BUG FOR MERGING AZURE OAUTH SUPPORT (93576) |
| 34113643 | JDK BUNDLE PATCH 21.0.0.0.220719 |
| 34139217 | TRACKING BUG TO UPDATE BUNDLEFCP.XML IN JUL 2022 RELEASE |
| 34149263 | Fix for Bug 34149263 |
| 34164828 | ADD SQLPATCH_SANITY_CHECKS.PM TO COPY_SQLPATCH_FILES.PL |
| 34183461 | LINUX.X64 - 19.16RU - UPGRADE PDB UNPLUG-PLUG UPGRADE FROM 12.2.0.1 AND 18.1 TO 19.16 COMPLETES WITH ERRORS DUE TO ISSUE IN BUG_32583355_APPLY.SQL |
| 34220943 | REMOVE EXTRA WAIT IN KGHFRUNP ADDED IN BUG 33225584 |
| 34240339 | FOLLOW ON FROM 33182407 |
| 34261947 | LMS HIT ORA-00600[KJBLPCM !CLOCKP] |
Fix Control | SQL Feature | Description |
|---|---|---|
| 31988833:1 | QKSFM_CBO_31988833 | Enable global caching of IMC stats per original qb |
| 32856375:1 | QKSFM_CBO_32856375 | convert simple CASE to IS NOT NULL where apropriate |
| 32913527:0 | QKSFM_CBO_32913527 | do not populate log costs if not already populated on inspection |
| 33323903:1 | QKSFM_CBO_33323903 | no redundant visits of query blocks for virtual column processin |
| 32800137:0 | QKSFM_DDL_32800137 | allow sharded table reference duplicated table |
| 32408640:1 | QKSFM_FIRST_ROWS_32408640 | correct settings when switching between Kmode and Amode |
| 31912834:1 | QKSFM_JPPD_31912834 | skip filter push predicate into outer join subquery view for MER |
| 32754044:1 | QKSFM_JPPD_32754044 | allow JPPD with LOB column when max_string_size = EXTENDED |
| 33297275:1 | QKSFM_JPPD_33297275 | avoid double costing e.g. of pushed views under OJPPD |
| 29738374:1 | QKSFM_MVIEWS_29738374 | delete orphan rows in sys.snap_logdep$ during mview refresh |
| 32212062:0 | QKSFM_MVIEWS_32212062 | Rebuild index online with redef online |
| 28044739:1 | QKSFM_OBJ_EXT_28044739 | allow collection iterator predicates to be pushed |
| 32302470:1 | QKSFM_OR_EXPAND_32302470 | Try LORE after ORE rejected for subquery correlated to non-paren |
| 32851615:1 | QKSFM_OR_EXPAND_32851615 | allow Legacy ORE correction to more cost-based ORE cases |
| 31545400:1 | QKSFM_PQ_31545400 | Delay in setting QERTBTEMPCSH when kxttIsIMCDTEnabled is safe to |
| 31843716:0 | QKSFM_QUERY_REWRITE_31843716 | remove expression col from frocol if NOT referenced in the query |
| 30771009:1 | QKSFM_SQL_PLAN_MANAGEMENT_30771009 | enable adaptive cursor sharing for SPM |
| 29413205:1 | QKSFM_TRANSFORMATION_29413205 | fix the traversal of view columns in an operator tree |
| 33145153:1 | QKSFM_TRANSFORMATION_33145153 | allow CBQT in presense of pseudo-column |
| 33325981:1 | QKSFM_UNNEST_33325981 | allow unnesting in some cases previously restricted |
| 31880080:0 | QKSFM_XML_REWRITE_31880080 | disable rewrite for XMLTABLE and OUTER JOINS |
| 32766397:0 | QKSFM_XML_REWRITE_32766397 | handle invalid characters by replacing or removing them |
-- create view my_patch_view
-- as
with a as (select dbms_qopatch.get_opatch_bugs patch_output from dual)
select x.*
from a,
xmltable('bugInfo/bugs/*'
passing a.patch_output
columns
bug_id number path '@id',
description varchar2(160) path 'description'
) x
;
execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');
select p.value, f.sql_feature, f.description
from v$spparameter p join v$system_fix_control f
on substr(p.value,1,length(p.value)-2)=f.bugno
where p.name='_fix_control'
order by f.sql_feature;
No comments:
Post a Comment