Sunday, July 3, 2022

B-Tree index deduplication enabled by default since PostgreSQL 13

 PostgreSQL B-Tree indexes are multi-level tree structures, where each level of the tree can be used as a doubly-linked list of pages. Each leaf page contains tuples that point to table rows.

A new feature introduced in PostgreSQL 13 called "deduplication". A duplicate is a leaf page tuple (a tuple that points to a table row) where all indexed key columns have values that match corresponding column values from at least one other leaf page tuple in the same index. More information refers to official documentation: https://www.postgresql.org/docs/13/btree-implementation.html#BTREE-DEDUPLICATION

Use "deduplicate_items" to explicitly disable deduplicate for write-heavy workload with no duplication to avoid performance overheads associated with de-duplication logic, which is default to enabled.

Demo Setup

create table salesorder (
    id          integer, 
    salerep     varchar(10), 
    order_date  date,
    amount numeric(10,2)
);
insert into salesorder 
select generate_series, 
       'salesrep'||mod(generate_series,100),
        concat(generate_series, ' day')::interval+current_date,
        round((random()*100)::numeric,2)
from generate_series(1, 1000000);
vacuum analyze salesorder;

Create indexes

create index id_dedup_on on salesorder(id);
create index id_dedup_off on salesorder(id)  WITH (deduplicate_items = off);
create index salerep_dedup_on on salesorder(salerep);
create index salerep_dedup_off on salesorder(salerep)  WITH (deduplicate_items = off);

Compare table and index sizes

mytest=> \d+
                                     List of relations
 Schema |    Name    | Type  |  Owner   | Persistence | Access method | Size  | Description
--------+------------+-------+----------+-------------+---------------+-------+-------------
 public | salesorder | table | postgres | permanent   | heap          | 57 MB |
(1 row)

mytest=> \di+
                                                List of relations
 Schema |       Name        | Type  |  Owner   |   Table    | Persistence | Access method |  Size   | Description
--------+-------------------+-------+----------+------------+-------------+---------------+---------+-------------
 public | id_dedup_off      | index | postgres | salesorder | permanent   | btree         | 21 MB   |
 public | id_dedup_on       | index | postgres | salesorder | permanent   | btree         | 21 MB   |
 public | salerep_dedup_off | index | postgres | salesorder | permanent   | btree         | 30 MB   |
 public | salerep_dedup_on  | index | postgres | salesorder | permanent   | btree         | 6912 kB |
(4 rows)

Tuesday, June 21, 2022

Automatic start observer during instance startup/reboot

Observer plays critical role during automatic failover, but sometimes routine maintenance would restart the Linux instance running observer and causes observer in stopped after instance reboot. Here are scripts to start observer automatically during Linux OS startup.

Running observer in background requires Oracle wallet setup, refer to below 2 links for more details:

/home/oracle/start_observer.sh

#!/bin/bash

export PATH

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/client
export LD_LIBRARY_PATH=/u01/lib
export PATH=/u01/sqlcl/bin:$ORACLE_HOME/bin:$PATH

ObserverRunning=`ps -ef|grep dgmgrl|grep -v grep|wc -l`
# echo $ObserverRunning
if [[ $ObserverRunning -eq 1 ]]
then
         echo "Observer is already running"
else
dgmgrl  <<EOD
start observer in background logfile is '/tmp/observer.log' connect identifier is rds_custom_orcl_a;
EOD
fi

/etc/rc.local

#!/bin/bash
# THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES
#
# It is highly advisable to create own systemd services or udev rules
# to run scripts during boot instead of using this file.
#
# In contrast to previous versions due to parallel execution during boot
# this script will NOT be run after all other services.
#
# Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure
# that this script will be executed during boot.

touch /var/lock/subsys/local

su - oracle -c "nohup /home/oracle/start_observer.sh &" 

Make sure change these scripts to be *executable".

chmod +x /home/oracle/start_observer.sh
chmod +x /etc/rc.local 

pyexpat.cpython-36m-x86_64-linux-gnu.so: undefined symbol: XML_SetHashSalt

Symptom:


Command line "aws cli" failed with error /usr/lib64/python3.6/lib-dynload/pyexpat.cpython-36m-x86_64-linux-gnu.so: undefined symbol: XML_SetHashSalt.

-bash-4.2$ aws s3 ls
Traceback (most recent call last):
  File "/usr/local/bin/aws", line 27, in <module>
    sys.exit(main())
  File "/usr/local/bin/aws", line 23, in main
    return awscli.clidriver.main()
  File "/usr/local/lib/python3.6/site-packages/awscli/clidriver.py", line 69, in main
    driver = create_clidriver()
  File "/usr/local/lib/python3.6/site-packages/awscli/clidriver.py", line 79, in create_clidriver
    event_hooks=session.get_component('event_emitter'))
  File "/usr/local/lib/python3.6/site-packages/awscli/plugin.py", line 44, in load_plugins
    modules = _import_plugins(plugin_mapping)
  File "/usr/local/lib/python3.6/site-packages/awscli/plugin.py", line 61, in _import_plugins
    module = __import__(path, fromlist=[module])
  File "/usr/local/lib/python3.6/site-packages/awscli/handlers.py", line 43, in <module>
    from awscli.customizations.history import register_history_mode
  File "/usr/local/lib/python3.6/site-packages/awscli/customizations/history/__init__.py", line 28, in <module>
    from awscli.customizations.history.show import ShowCommand
  File "/usr/local/lib/python3.6/site-packages/awscli/customizations/history/show.py", line 16, in <module>
    import xml.parsers.expat
  File "/usr/lib64/python3.6/xml/parsers/expat.py", line 4, in <module>
    from pyexpat import *
ImportError: /usr/lib64/python3.6/lib-dynload/pyexpat.cpython-36m-x86_64-linux-gnu.so: undefined symbol: XML_SetHashSalt

Troubleshooting:


Check the dependencies for pyexpat.cpython-36m-x86_64-linux-gnu.so:

-bash-4.2$ ldd /usr/lib64/python3.6/lib-dynload/pyexpat.cpython-36m-x86_64-linux-gnu.so
        linux-vdso.so.1 =>  (0x00007fffa67fc000)
        libexpat.so.1 => /lib64/libexpat.so.1 (0x00007f16058bb000)
        libpython3.6m.so.1.0 => /lib64/libpython3.6m.so.1.0 (0x00007f1605394000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f1605178000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f1604daa000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f1604ba6000)
        libutil.so.1 => /lib64/libutil.so.1 (0x00007f16049a3000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f16046a1000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f1605cf4000)

Check the suspicious file, found multiple of it in the LD_LIBRARY_PATH:

$ find / -name libexpat.so.1 2>/dev/null
/usr/lib64/libexpat.so.1
/rdsdbbin/oracle.12.1.custom.r1.EE.1/lib/libexpat.so.1

Solution:


Add /usr/lib64/ to the beginning of LD_LIBRARY_PATH:

export LD_LIBRARY_PATH=/usr/lib64/:$LD_LIBRARY_PATH

Saturday, May 28, 2022

DBCA failed with error "ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed"

 

Symptom during DBCA on OACLE_HOME with RU/PSU installed

46% complete
100% complete
[FATAL] Error while restoring PDB backup piece
-- from $ORACLE_BASE/cfgtoollogs/dbca/ORCLCDB/trace.log_xxxxx
[Thread-244] [ 2022-05-28 08:31:49.022 UTC ] [RMANUtil$RMANUtilErrorListener.handleError:1386]  ERROR=RMAN-03002: failure of restore command at 05/28/2022 08:31:48
[Thread-244] [ 2022-05-28 08:31:49.022 UTC ] [RMANUtil$RMANUtilErrorListener.handleError:1386]  ERROR=ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed
[Thread-244] [ 2022-05-28 08:31:49.022 UTC ] [RMANUtil$RMANUtilErrorListener.handleError:1386]  ERROR=RMAN>
[Thread-244] [ 2022-05-28 08:31:49.022 UTC ] [RMANUtil$RMANUtilErrorListener.handleError:1386]  ERROR=echo set on

Root Cause

ORA-04062 on "SYS.DBMS_BACKUP_RESTORE" because datapatch failed, which supposes to recreate RMAN packages based on installed RU/PSU patches.

[progressPage.flowWorker] [ 2022-05-28 08:57:16.357 UTC ] [CloneDBCreationStep.executeImpl:836]  executing datapatch /u01/db/OPatch/datapatch
[progressPage.flowWorker] [ 2022-05-28 08:57:16.357 UTC ] [CloneDBCreationStep.executeImpl:836]  executing datapatch /u01/db/OPatch/datapatch
[progressPage.flowWorker] [ 2022-05-28 08:57:25.369 UTC ] [CloneDBCreationStep.executeImpl:839]  datapatch returned with exit status 1

The cause for data patch failure is NOT able to query OPATCH

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /u01/db193/QOpatch/qopiprep.bat encountered
error "locale: Cannot set LC_CTYPE to default locale: No such file or directory"

Solution for my case

export LANG=en_US.utf-8
export LC_ALL=en_US.utf-8

Add these 2 lines into /etc/environment for permanently change:

LANG=en_US.utf-8
LC_ALL=en_US.utf-8

Wednesday, April 27, 2022

Oracle 21c bug fixes in Apr-2022 quarterly patches

Total 327 bugs fixed in Apr-2022 Oracle 21c updates (21.6RU)


BUG_ID
DESCRIPTION
19884953LNX64-12.2-UTL-SCC ER TO ADD ASMCMD CP FOR FILE COPY TO ASMCC LOCAL NODE
19958239INVALID CONTAINER DBID IN DBA_AUDIT_MGMT_LAST_ARCH_TS AFTER UPGRADE TO 12.1.0.2
24597536UNIFIED AUDIT RECORDS ARE NOT PURGED WITH LAST ARCHIVE TS TRUE
24916492PLSCOPE_SETTINGS DOESNT PARSE IDENTIFIER INFORMATION AFTER NULL STATEMENT.
27751518FRA SPACE NOT RECLAIMABLE FOR ARCHIVELOG ON STANDBY
27979632OLS ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [8153]
28337860WRONG RESULTS WHEN QUERYING AV CALC MEASURE USING COUNT DISTINT
29524043CDB CLEANUP FILES AFTER ANY FAILURE IN PDB CLONE BEFORE PLUGGING IN SYSTEM TABLESPACE
29900186OPTIMIZE THE CODE IN KJB_SET_L2B/KJBFP_SET_L2B ROUTINES
30343750PERF_DIAG AH LOG FILE SWITCH (CHECKPOINT INCOMPLETE) HANG ANALYSIS CALLBACK SHOULDNT ALWAYS BLAME LGWR
30747820KERBEROS AUTHENTICATION FAILS WHEN SQLNET.KERBEROS5_CONF IS SET TO AUTO_DISCOVER WITH KERBEROS5PRE
30840150PARALLEL DML DATA IS NOT REFLECTED IN DBA_TAB_MODIFICATIONS
30846263ET20.1PART ORA-7445 [KKPAPSETBOUNDS] ON A QUERY
30933117PRO*COBOL APPLICATION CRASH ON SQLADRCR WHEN RUN AS 64BIT EXE, 32BIT WORKS FINE.
31073424V$RMAN_BACKUP_JOB_DETAILS VIEW SHOWS DISK EVEN IF BACKUP TAKEN TO TAPE
31079198UNPROTECTED WRITES TO REDO BLOCKS RESULTS IN ORA-700 (CORRUPT BLOCKS)
31110887WRONG RESULTS WHEN CASTING BETWEEN DATETIME TYPES AND ROWSETS
31138371WRONG RESULTS WITH INSERT AS SELECT
31243859SQL EXECUTION USING APPROX_COUNT() CRASHES, HITS ORA-7445 [KKQWOPO_POSTPROC]
31356954ZDLRA KDIMSTART KDIGNBK-LOOP DURING COALESCE INDEX
31385668MMON IS NOT RESPAWN ON ALTER SYSTEM ENABLE RESTRICTED SESSION
31535516DICTIONARY INCONSTANCY REPORTED BY CUSTOMER APPLY WORKAROUND OF BUG 31336934
31588631EXCESSIVE TRACING OSSDISK_IPCDAT.C
31628975SQL*PLUS COMMAND LINE ERROR WHEN AN @ CHARACTER IS PRESENT IN PASSWORD.
31652763LOG_FILE_SIZE_LISTENER PARAMETER IS LIMITED TO LESS THAN 4096 MB
31720377TT21.1UBSAN UBSANERR (UNDEFINED BEHAVIOUR ) IN KEWA_SAMPLE_SESSION
31725154XF21.1SEC_UNIAUD_FGA - TRC - KKOGFP - ORA-600 [KKOGFP NO NEXT TABLE]
31781944RUNNING PGA WORKLOAD HIT ORA 7445 [KGHFRF]
31827584ADB-S LIMIT KJCI MESSAGES IN RAC/DLM TO LOCAL NODE IN CASE OF CIC FOR PDB RELATED OPERATIONS SUCH AS PATCHING
31918462VERSIONS QUERY HITTING ORA-00600 [KTRVTGR_2] WHEN DOING A VERSIONS QUERY WITH QUICK MULTI DELETE ROLLBACKS
31939767EBS APPS PDB UPGRADE FAILED WITH ORA 600 [KPDBLOADCBK-BAD-OBJ#]
31954223EXADATA MRP PROCESS SHUTDOWN UNEXPECTEDLY WITH ORA-00600 [KCBO_LINK_Q_BH]
31969646ORA-600 [17147] [0X7FD086F3B2E0] INSTALLING 19.8 DURING ASM INSTANCE INITIATION
31986827TRACKING BUG FOR RIT 22172887
31987278Fix for Bug 31987278
31992242SUPPORT FOR CUSTOM KERBEROS LOGIN MODULES
31992953RMAN - RAC INSTANCE CRASHED AFTER CTWR PROCESS TERMINATION
32013253SR21.1CHAOS_V2 - TRC - QESAAGGNONDISTSS - ORA-600 [QEAEDECOMPRESS KGCDDO]
32015642BI SERVER CRASHING EVERY 30 MINUTES IN KPUEONSCALLBACK
3201763519C STARTER BUILDS ARE FAILING WITH ORA-00600 INTERNAL ERROR CODE
32041003BIGDATASQL AUTHENTICATION FEATURE DOES NOT WORK ON READ-ONLY ORACLE_HOME CONFIG
32055692XF21.3ADBS_LV32K - TRC - KESWXCURNBROWS - ORA-7445 [KESWXCURNBROWS()]
32102722DB PRODUCES TRACE FILES WITH MESSAGE /ETC/ORACLE/OLR.LOC CANNOT BE OPENED. ERRNO 2 IN AIX
32115403DB STARTUP FAILS WITH ORA-600 [IPC ASSERT], [IPCOR_MEM.C 381 SZ > 0] AFTER APPLYING A MERGE PATCH 31940707
32118543ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KRSB_BEGIN.NO_BHB]
32133898ENQUEUE OF MESSAGE LARGER THAN 100 MB FAILED WITH JMS-122 INTERNAL ERROR BYTES_LOB IS NULL
32159343APPS RT REPLAY WRC CLIENT FAILS WITH ERROR - OCI 24550 [11]
32184844SQL PARALLEL EXECUTION HITS ORA-12805, SLAVES RUN INTO ORA-7445 [KXFQHSH]
32198368BLOCK CHANGE TRACKING GETS DISABLED WHEN BACKUP IS PERFORMED ON FILE RESTORED AFTER PDB PITR
32205514DB STARTUP FAILS WITH ORA-07445 CORE DUMP [SIPC_SLTR_QTIME_GETTIME_INT()+10] [SIGILL] / ORA 499 ERROR
32284608ZRH CANARY CONNECTION USING LOCAL NODE VIP STATUS CHECK ALARM FOR E1POD
32287989CHANGE TRACKING FILE SYNCHRONOUS READ WAIT DOESNT END
32302470FULL SCAN OF TABLES WITHIN SCALAR SUBQUERIES
32343092DATABASE MOUNT IS FAILING WITH RMAN-03002 AND ORA-600 [KCCSGA_UPDATE_AMX_2] [1055]
32345050PERF_DIAG ADD HANG ANALYZE CALLBACK FOR REVOKE GET OBJECT
32362072CREATE PARTITION INDEX DOES NOT GATHER PENDING STATISTICS
32374616ALLOW UNDERSCORE AND HYPHEN FOR ORACLE_SID
32377901ESSAV WRONG QDR EXPRESSION RESULT WHEN NESTED QDR WITH HIER_PARENT IS USED
32379001REDO TRANPORT FROM DBMS 21.3.0.0.0 TO ZDLRA 19.2.1.1.2 THROWING ORA-16063
32393137ORAPKI REPLACE , EXPORT AND REMOVE COMMAND DOES NOT VALIDATE THE SERIAL_NUM OPTION
32423678AFTER UPGRADE TO 19 DBVERIFY FAILS WITH DBV-00600 FATAL ERROR - [21] [4]
32424465LNX64-21C-CDB HIT ERROR ORA-600 [KSQCMI REQ_MODE_BUT_REQ_SET] & INST CRASH
32425778EXCESSIVE TRACING FROM LMS TRACES (KJM HIST LMS MOST RECENT FIRST)
32425862JSON_TEXTCONTAINS (INPATH) QUERIES DEGRADE WITH DATA SIZE
32427583SR21.3MFSR_CONC_PDB_OPS - TRC - KJBCLOSE - ORA-600 [KJBCLOSE L]
32431049NULL VALUES RETURNED FROM AV QUERY USING NESTED CALC WITH SHARE_OF( QUALIFY (...) )
32459632SQL_TRACE EVENT DOESNT WORK IN PDB SESSION VIA LISTENER
32472485EXADATA AUTO MGMT INEFFICIENT RECOVERY FROM DATA LOSS
32486955RF ENQUEUE DEADLOCK ON RAC WITH DG BROKER
32506809WRH$_SYSMETRIC_HISTORY_INDEX INDEX DOESNT GET PARTITIONED AFTER DATABASE UPGRADE FROM 12.2 TO 19C
32524841ERROR ORA-7445 [LMEBCO] CREATING INDEX ON HYBRID PARTITIONED TABLE
32529396UNIFIED_AUDIT_POLICIES COLUMN EMPTY FOR ACTIONS ALL OPTION
32540772HYBRID COLUMNAR COMPRESSION IS STILL YET TO WORK WITH ACFS ON EDV
32546937ORA-29363 WHEN UPGRADING DB FROM 12.1.0.2 TO 19.9
32549277AH ADD RETRY FOR _BCT_PUBLIC_DBA_BUFFER_SIZE SETTING IN CTWR PHX E12POD NOT ABLE TO CONNECT TO POD
32555592AFTER SUSPENSION OF DATABASE SYSDBA USERS SHOULD NOT HAVE TO ACCESS THE DICTIONARY AGAIN
32573197XF23.1SEC_UNIAUD_FGA - DIF - TKDP - > ORA-28112 FAILED TO EXECUTE POLICY FUNCTI
32584505DIAGNOSTIC IMPROVEMENT FOR BUG 32303293
32587305SHOULD NOT BE INCLUDING THE SINGLE ALL SELECTION IN THE AGGREGATION FOR ANY QUERY
32610185HEAVY DIAGNOSTICS DUMPED DURING CTWR CRASH CAUSING LMHB TO KILL THE THE ALREADY GOING OUT CTWR
32625356ORA-8181 ERROR FROM FBDA QUERY
32630060IAD E25POD ORA_DIAG PROCESS IS FILLING UP DIAG AREA
32649749AH HANDLE CTWR HANGS WITH FILES KIX E2POD OBSERVED HUNG ON E2POD
32665836SQL QUERY FAILS WITH ORA-00979 NOT A GROUP BY EXPRESSION
32669149FUNCTION DECLARED WITH RESULT_CACHE RETURNS WRONG RESULT
32685989PX SLAVE SESSION HANG WHILE WAITING FOR GC CR REQUEST, GC CR BLOCK LOST CONTINUOUSLY
32697157GATEWAY CERTIFICATION FOR IBM DB2 V11.5 LUW
32697859EXCESSIVE WAITS ON BLOCK CHANGE TRACKING BUFFER SPACE
32703155USED_CHANGE_TRACKING COLUMN IN V$BACKUP_DATAFILE MAY NOT REFLECT IF BCT IS INDEED USED DURING BACKUP OF A DATAFILE
3270917066618 SWITCHOVER TO DGPDB FAILS IN RAC+OMF+TDE ENABLED ENVIRONMENT
32719288DUMP X$KRCSTAT INFO DURING CTWR CRASH FOR BETTER DIAGNOSTICS
32724505DEFAULT MEMORY TRACE BUCKETS DOES NOT SUPPORT RESET
32747680DIAG PROCESS FLOODED WITH DUMP TRACE BUCKET CALLBACK DUMP REQUESTS
32750940ORA-00600 [526], [0X6FE5EF2580], [1], [GES RESOURCE HASH LIST] ON 19.9
32754044QUERY NOT USING INDEX WHEN USER CREATED WITH MAX_STRING_SIZE = EXTENDED
32754574DATA CONVERSION ISSUES FOR DB2 ZOS TIMESTAMP & NUMERIC DATA WHEN THE QUERY IS PROCESSED BY IDAA
32760868FAL ANNOUNCE ENHANCEMENT
32763283SCRIPT TO ADD SPATIAL REFERENCE EPSG 6622 NAD83(CSRS)/QUEBEC LAMBERT
32763544ALTER SYSTEM SET INMEMORY_SIZE = <VALUE> SCOPE = <ANY> ON PDB LEVEL RESULTS IN ORA-02096
32766916WRONG RESULTS WHEN USING CONCATENATION ON 19C
32782851UNNECESSARY ROW CACHE POPULATION WITH SUB-PARTITION INFORMATION FOR CHILD TABLES
32786308SQL HAS BEEN WORKED ON 11G BUT OCCUR ORA-01719 ON 19C
32794261AIM ORA-600 [QESRCDO_REMRO-2] - QESRCDO_REMRO
32806069DNFS NOT RELEASING THE OPEN FILE OWNERS WITH NFSV4
32822436HM DO NOT APPLY BLOCKED SESSION PERCENTAGE THRESHOLD2 TO FAST-TRACKED SESSIONS
32823545PER-PDB CAPTURE PARALLEL LOGMNR READER STALLING WHEN READING INSTANCE PARTITIONED PDB WORKLOAD
32834426FADBRWT STRESS FA STACK DATAPATCH CANNOT COMPLETE RECOMPILING LARGE NUMBER OF INVALID OBJECTS IN 19.11.0.0.210420DBRU + FA MLR210420
32842415OGG CDB RAC ORA 353 [277210] [241176768] IN LOGMINER PARALLEL READER & EXTRACT ABEND
32850174ORA 7445 [KKOUTLGETPUSHSUBQLIST]
32851615SLOW EXECUTION WITH NEW ORE FUNCTIONALITY
32856375INCORRECT CARDINALITY WHEN USING CASE STATEMENT
32864736STANDBY TO PRIMARY ROLE TRANSITION FAILED WITH ORA-700[OPIIOR SHUTDOWN HANG]
32869560HIGH CPU ON KXSGETRUNTIMELOCK AND SSKGSLCAS
32883853INCORRECT COLUMN STATS IN A SQL WITH VIRTUAL COLUMNS DUE TO MISMATCHING KCCCID
32887649AIM ORA-603 - KNSQ_KWQBBFS_SQL_EXE
32898678IAD BLOCK CHANGE TRACKING HANG CAUSED THE APP-CTRL OUTAGE
32901237ADD HANG ANALYZE CALLBACK TO NO FREE LOCKS
32904867TRACKING BUG FOR LRG 24176972, 24177857
32918041ORA-00932 INTERMITTENTLY WHEN USING EBR 19C
32924796FILTER ON AUTO_CAPTURE_PARSING_SCHEMA_NAME NOT WORKING AS EXPECTED
32925703FIRST FAILURE DIAGNOSTICS FOR CORRUPT BLOCK BEFORE-IMAGES
32936424SESSION POOL NOT CONNECTING TO A SHARD THAT COMES BACKUP AFTER A SHUTDOWN
32937167ALERT LOG EXCESSIVE NUMBER OF WARNING TEMP BLOCK IS BEING CHANGED UNTIL INVALID LOCK
32937338AWR REPORT UNOPTIMIZED READS %OPT COLUMN FOR PMEMCACHE IS INCORRECT.
32941096ORA-00600 [QKSWCPRWDO3T NO RECURSIVE FRO] WITH /*+ PARALLEL */ HINT
32941792HIERARCHY DATATYPE QUERY IS NOT EFFICIENT
32945404TCH19C ORA-39139 DATA PUMP DOES NOT SUPPORT XMLTYPE OBJECTS WHEN DOING XTTS
32946347GL POSTING UPDATE TO GL_BALANCE IS ~30% SLOW WITH DEFAULT _INMEMORY_64K_PERCENT
32956896FIX FOR BUG 32529483 IS INCOMPLETE
32967871ORA-600 [KJBMPCLO CVT] [116023] [302] [0XA483E5F38]
32968634E23POD CUSTOMER EXPERIENCING INTERMITTENT ORA-28860 ERRORS LEADING TO FATAL SSL ERRORS
32982562GDS FAILS WHEN TRY TO ADD STANDBY DATABASE
32984625RANDOM AFD DISK MISSING AFTER A NODE REBOOT IN SIHA.
32991289IAD APPCTRL LOAD AVERAGE HIGH DUE TO CURSOR BUILD LOCK CONTENTION
32994080RESTORE FAILOVER NOT WORKING WHEN DATA FILE CREATED WITH INCORRECT BLOCK SIZE
32996974AH MITIGATE CLUSTER WIDE HANGS DUE TO SORT SEG. SPACE REBALANCE CIC
33004888STABLE_E2POD CKPT WAITS FOR CF ENQUEUE, LMHB TERMINATED INSTANCE, RELATED TO RMAN PROCESS
33011078NEED OCI TO IMPLEMENT SERVICEMEMBER UP EVENT HANDLING AND PICK UP THE CHANGES FROM NETWORK TXN.
33016007FBI VC NOT USED ON MOVED PREDS, PREVENTING INDEX-ONLY ACCESS IN 19C (WORKED IN 11G)
33022043ORA-7445 [KKMNAMERESCOLUMN] ON DROP TYPE ATTRIBUTE
33032299ADD BEARER TOKEN TO DB-IAM (M2)
33034642SYS_CONTEXT RETURNS INVALID VALUES
33035710SYS_FBA_HIST TABLES HIGH_PART PARTITION DOESNT GET SPLIT
33038537IMPROVE MESSAGES FOR ORA-201 CAUSED BY INCORRECT SETTING OF COMPATIBLE PARAMETER
33039277MULTIPLE QUERIES FAIL WITH ORA-04023 AFTER UPGRADE TO 19C
33043881PROVIDE ABILITY TO CONFIGURE CUSTOM DNS SERVICE PROVIDER ON A PER CONNECTION BASIS
33050587ORA-4031 RUNNING AWR_EXTRACT
3305062219.11 DB INSTANCE STARTUP FAILS WHEN HAIP/MULTIPLE CLUSTER_INTERCONNECT IN USE ON SOLARIS
33051299DURING PLUG PDB [WARNING] ORA-60510 ENCOUNTERED AN ERROR DURING REPLAY UPGRADE SHOWN
33064324ORA-7445 [QKSBGGETCURSORVAL] WITH 32362698 INSTALLED
33075452AIM ORA-600 [KCBKXOBJ_8A] - KCBKXOBJ_KJCI
33076129JPMC PRODUCTION POD EINO DB PERFORMANCE ISSUE REPORTED
33098505GOLDENGATE PROCESS WAITING FOR 15MINS TO LOGOUT EVEN WHEN OCI RECEIVE TIMEOUT SET TO 10SEC
3310027021.1PE ORA-03137 MALFORMED TTC PACKET FROM CLIENT REJECTED [64219] [96]
33102477CHECK FOR STILL-ENCRYPTED BUFFER IN CACHE DURING READ ABSTRACT SEND RECEIVE AC
33106897CREATE OFFLOAD CONTEXT ONLY ONCE DURING RELOCATION
33110642SESSIONS HANG, BLOCKED BY ROW CACHE LOCK
33115438DISPLAY THE TDE WALLET PATH IN THE ALERT LOG
33123402ENABLE QUERY REWRITE GIVING WRONG RESULT
33123404DATABASE HANG ON LOG FILE SWITCH (CHECKPOINT INCOMPLETE), ALL DBWR STOPPED WRITI
33127312AIM ORA-2097 - KSBMAIN_HANDLE_ERROR
33137328STATS FOR SO PRIVATE SGA PER SO TYPE (EXTERNAL)
33139230DATABASE UPGRADE FROM 12.1.0.2 TO 19.11 SEEING ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KQLDTAU AQ IOT CANT HAVE DEFERRED SEGMENT], [DEL], [3105710]
33140218Integrated Replicat is not updating target columns with KEYINCLUDING in CDR condition.
331414200RA-00600 ERROR [KKOUPDATEFROANN INCORRECT PWJ] WITH 19.11
33161535TRACKING BUG FOR RDF GRAPH PATCH KIT Q3 2021
33161726TABLE CREATION HANGS ON DV ENABLED, WORKS FINE ON DV DISABLED.
33163159ORA 600 [KCLRMPI_2] EVEN WITH DIAGNOSTIC PATCH 31936072 APPLIED
33165391HIERARCHY QUERY CONTAINS TOO MANY ATTRIBUTES
33176672Fix for Bug 33176672
33177660BUFFER BUSY WAITS ON IOT JOURNAL TABLE DURING ONLINE INDEX REBUILD
33184467LRGVMCC - ORA-7445 [_INTEL_SSE2_STRCAT()+161] [ACCESS_VIOLATION]
33191584SAGEFC-E HIT ORA 600 [12240]
33193293UPGRADE FROM 11.2.0.4 TO 19C FAILS ON OWM
33199431PERFORMANCE ISSUES WITH CTXAGG MERGE OPERATION
33199858Hung on oracle.ucp.common.Service.create after RAC node failure event
33208644DCN NOTIFICATION DO NOT WORK WITH KERBEROS AUTHENTICATION FOR JDBC THIN DRIVER
33225584AIM ORA-32701 POSSIBLE HANGS UP TO HANG ID=114 DETECTED (ROOT NOT IN WAIT / IMMEDIATE LATCH SHARED POOL / TYPE HANG) - KGHFRUNP
33227044AIM ORA-7445 [K2QBEQCALLBACK] - K2QBEQCALLBACK
33239083SSL_SERVER_DN_MATCH NOT SUPPORTED IN LONG FORMAT TNS URL
33244297ORA-00600 [QMCXDGETQNAMEINFO2] WHEN QUERYING CSX AFTER TTS
33247372BROKER HANG DMON EXCLUSIVE ACQUISITION OF METADATA LOCK RETRYING AFTER 120 SECONDS
33251111AIM ORA-600 [KCLADDUNDO_2] - KCLADDUNDO
33253466AVOID THREAD SUSPEND IF OS LOCKS HELD BY THREAD
33266449ALTER USER SYS ACCOUNT UNLOCK IS NOT WORKING ON ACTIVE DATA GUARD
33268162APPLICATIONS TPCBSGI1.PCO AND T5214846.PCO ARE CRASHING WITH VISUAL COBOL 6 RUNTIME
33271941X$KRFSTHRD NOT REQUIRED FOR ZDLRA
33273638ORA-01452 CANNOT CREATE UNIQUE INDEX; DUPLICATE KEYS FOUND DURING OWM UPGRADE
33279489DBUA RESETS OPTIMIZER_ADAPTIVE_PLANS AND OTHER PARAMETERS POST UPGRADE ON RAC DATABASE
33281287KTFTREUSE/KTFTFILEREUSE SHOULD STEAL SORT EXTENTS FROM CLOSED PDBS ON INSTANCES WHICH ARE STILL ALIVE
33282605GOLDENGATE DOWNSTREAM RFS CLIENT PROCESSING OF KRSRFLAS OPCODE HAS PROBLEMS
33288427TRUNCATE TABLE TAKES LONG ON TABLE HAVING MORE HASH PARTITIONS
33292175SAGEASM-E RESYNC STUCK DURING DISK OFFLINE/ONLINE TEST RUN
33297275PREDICATE NOT PUSHING TO VIEW IN 19C
33298903QUORUM DISK AUTO-ONLINE FAILING WITH MISCONFIGURED QUORUM DISKS INTERRUPTING REBALANCE REPEATEDLY
33305254DESTRUCTIVE CONCURRENT DML WORKLOAD ON MAINLY TEMP TABLES HITS ORA-600 [KTSFBFMT KCBNEW_12]
33306852REPLICAT ABENDS WITH ORA-1847 FOR INSERT WHEN TARGET TABLE HAS EXPR_DT DATE DEFAULT ON NULL 01-01-0001
33312823LNX64-1912-CMT LOTS OF KJOER_OS_GETNEXT FAILED MESSAGES FLOODING IN GEN0 TRACE AND UNPUBLISH FENCED ORPHAN MSG IN ASM ALERT LOG
33314122NEW OLINT WARNINGS INTRODUCED BY TRANSACTION CRGOGONZ_BUG-33200536
33314523LNX64-1912-CMT ERRORS ORA-15261/ORA-15260 FOUND IN ASM ALERT LOGS IN PATCHED ENVS
33316711ADDING QUORUM DISK FAILED WITH ORA-15333
33318949AIM ORA-7445 [KFDDSDUMP] - KFDDSDUMP
33323634FAST SPLIT NOT TAKEN ON RANGE-RANGE PARTITIONED TABLE
33323903QUERY USES MORE PGA IN 19C
33324226USE KGL FUNCTIONS TO DETERMINE IF A TABLE EXISTS OR AN IOT
33327118HCS HIGH PARSE TIME WITH HIER_ORDER COLUMN WITH MANY LEVELS
33332612ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [EVAOPN2.H KAF_QEECOL] ON 19.11
33334340SAGEASM-E HIT ORA 7445 [KSS_FIRST_CHILD]
33335201GLOBAL KSBCIRSS CIC HANG DUE TO RACE CONDITION DURING PROCESSING OF AUTO TEMP TBS SHRINK CIC
33344767DBMS_FEATURE_USAGE_INTERNAL.EXEC_DB_USAGE_SAMPLING RUNS SLOW
33347947RFS CLIENTS SHOULD NOT GET DISABLED WHEN SIGNALING A FATAL ERROR
33351136ASM OS_NAME IN V$ASM_USER IS MISSING THE FIRST CHARACTER IN RDBMS INSTANCE
33351978SCHED SCHEDSTRESS HIT ORA 600 [KJSMESM DARCFG!]
33354011CELL SINGLE BLOCK PHYSICAL READ FIXUP WITH IOTARGET
33360246SDO_GEOR_ADMIN PKG FUNCTIONS CANNOT BE EXECUTED BY ANY ADMINISTRATIVE USER
33364012INTERSECT IN HCSHIERCOLSGETATRSFORLVLPRI CAUSED PARSE SLOW DOWN
33367184ORA-600 [QESMAGETPAMR-NULLCTX] ON PARTITION TABLE DURING GATHER TABLE STATS
33372080TRACKING BUG FOR RTI 24643366
33373693INSTANCE CRASH DUE TO ORA-00600 KTCSETACTIVESESSION_1
33375194ORA 600 [KGLCSS HEAP COUNT] FOLLOWED BY ORA-02019.
33380871HIGH CPU ON KSLWT_UPDATE_STATS_ELEM
33382108RESULT CACHE IS CORRUPT WITH ORA 600 [QESRCRO_XOR]
33382224ORA-600 [KFNSETGROUPASMBIDX BADASMB2]
33382529RAC DB HUNG WITH LGWR AS THE BLOCKER WHILE SPINNING ON A BUFFER
33401519OBJECTS BECOMING INVALID AFTER MATERIALIZED VIEW REFRESH WITH OUT_OF_PLACE
33402406AWR EXADATA INCLUDE ALL CELL SINGLE BLOCK PHYSICAL READ WAITS IN SUMMARY
33409163INSTANCE CRASHED AFTER RS0 HITS ORA-00600 [KJBRRCFW CQ]
33409759ASM UFG KFNSBACKGROUND SHOULD LOG COMPLETED TIME IN MILLI SECS
33409841ORA-29003 ACCESSING MULTIPLE ADDRESS USING SQLPLUS HAVING SCAN ( TCPS )
33417145DBMS_STATS JOB BLOCKING MULTIPLE APPLICATIONS
33420490DATASAFE USER UNABLE TO COLLECT RECORDS FROM .BIN FILES
33422596TTS EXPORT WITH XMLTYPE IS NOT REGISTERING PROPERLY A PARTITIONED TABLE OBJ#
33426135ORA-7445 KGGR_RECOVER()+235
33427823RFS PROCESSES THAT ARE DONE RECEIVING GAP REDO DO NOT EXIT WHEN GAP IS RESOLVED
33428795TRACKING BUG FOR RTI 24668907 RDBMS-SIDE CHANGES ON RDBMS_MAIN
33440442PRINT MORE INFO FOR ORA-600 [KTFBNBGPM-BLKTYPE] BLOCK TYPE, OBJN, OBJD, TSN, RDBA IN ARGS
33441073DG4ODBC 21C - GETTING ORA-28500 DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED {IM002} SPECIFYING HS_LANGUAGE=.AL32UTF8
33444647BACKUP PERFORMANCE SLOW ON ED19 ZFS FRAME (NEW PRIMARY)
33446226AH RAC ADD SKGXP DUMP DURING DEFER MESG TIMOUT
33451134EXTPROC COREDUMP ON SESSION END IF EXTERNAL C LIBRARY WAS DEFINED WITH CREDENTIAL CLAUSE
33454288TRACKING BUG FOR RTI 24629546
33454299EEHO DEQUEUE STALLED ON EDN QUEUE (AQ$EDN_EVENT_QUEUE_TABLE) DUE TO SECONDARY INDEX ON AQ IOT
33455225MATERIALIZED VIEW REFRESH IS GETTING FAILED WITH ORA-01740
33456703ALTER TABLE TO CELL_FLASH_CACHE KEEP SHOULD NOT INVALIDATE CURSORS
33456848UFG EXCESSIVE CPU USAGE FOR ASM REBALANCE MESSAGE HANDLING
33457235SAGEASM-E HIT ORA 7445 [KCBS_FREE_GRANULE_SIM_BUFFERS] AND DB CRASH
33460521DIA0 HITS ORA0-00600 [17147] FOLLOWED BY [KGHFRH DS]
33462620REGRESSION OF 33300781
33466822PORT KCFIS CHANGES TO RDBMS_MAIN FOR TOP MEM SQL STAT TESTING
33470092CLEAN_AUDIT_TRAIL FAILS TO PURGE RECORDS ON INSTANCES WITH MULTI DATABASE_IDS
33473795ORA-7445 [KKOPPJT()+250] EVEN WITH PATCH 32602990 INSTALLED
33474916FRA FE10POD SINGLE INSTANCE DOWN DUE TO ORA ERROR 204 - DIAGNOSTIC IMPROVEMENT
33479703DYNAMIC SERVER REGISTRATION DOES NOT WORK WHEN PER-PDB WALLET IS CONFIGUED
33498037LNX64-23C ORA-7445 COREDUMP AT KJCIPDBIMAP()+152
33499125RESERVE ERROR #S 20100 - 20599 FOR ODP.NET & ASSOCIATED COMPONENTS
33499867NOT GETTING MV REWRITE WHEN CACHE IS IN NEEDS COMPILE STATE
33504432BUG TO TRACK ISSUES IN KMATKAR_BUG-32895713 (RTI 24667678)
33504902TRACKING BUG FOR RTI 24680649
33510171AH RAC ADD LE DUMP DURING EARLY WARNING OF HM ANALYSIS WHEN FB IS GC CLAIM
33517445AIM ORA-7445 [KTBAIR2] - KTBAIR2
33522799REGRESSION TRACKING BUG FILED FROM MERGEREQ
33531067ORA-01405 ERRORS IN THE DOWNGRADE SCRIPT FROM 19.11 TO 11.2.0.4 WITH REDACTION
33531364LNX64-1913-CMT ASMCMD SHOULD SHOW ERROR MESSAGE ON FAILURES
33532755GG DOWNSTREAM EXTRACT NOT CAPTURING CHANGES AFTER APPLYING FIX FOR BUG 33059891
33534589INSTANCE CRASH WITH ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KJBLGOLOCAL DS]
33536809JDBCSTRESS HEAP MEMORY ISSUE DUE TO LRUSTATEMENTCACHE
33537229UPDATE AUTOUPGRADE.JAR IN 21.6 TO INCLUDE CUSTOMER CRITICAL BUG FIXES
33538063AH FWD MERGE OF BUG 33418859 TO MAIN TO TRACE KJBDELIVER AND IPC TRACING FOR SND FAILURE
33545698EGVH GSI-3-27435904407-HIGH NUMBER OF DEQUEUE SQL EXECUTIONS/EVENTS
33548709TRACKING BUG TO MERGE RTI 24811031
33548869LNX64-1913-CMT 21.4 DBVM CREATION FAILED PRCZ-4001 PRCZ-2103 [FATAL] RECOVERY MANAGER FAILED TO RESTORE DATAFILES.
33550827FAILOVER FROM CLOUD CONSOLE FAIL ORA-1093 AND INSTANCE TERMINATED
33553902OGG-00662 OCI Error ORA-00600 internal error code, arguments [602]
33561671CAST AS TIMESTAMP(X) IS NOT ROUNDED IN PL/SQL
33561845ORA-00600 [KCBZ_PARSE_KEYCHAIN_5] EVENT WITH 32578113 INSTALLED
33562255EGVV HUGE WAIT EVENTS OBSERVED.
33566611LGWR PLUS 4 WORKERS HAVE OPEN QPS , SHOULD BE ONLY 2 WORKERS
33571225ARCHIVE LOGS CANNOT BE DELETED ON SOURCE AFTER APPLYING FIX 33282605 ON THE DOWNSTREAM DATABASE
33584404ORA-29770 RAC GLOBAL ENQUEUE HANG
33586107ORACLERESULTSET.PUBLISHERORACLE() HANGS, DOES NOT EMIT ONNEXT
33589615EXASCALE ADVM PROXY INSTANCE IS GETTING TERMINATED DURING VOLUME CREATION ON ASM DG
33601195GRIDSETUP -SWITCHGRIDHOME OOP - ROOT.SH GENERATED INCORRECTLY
33601849GRANT ON ANALYTIC VIEW LOOPS WHILE PARSING AND CONSUME EXCESSIVE MEMORY.
33617685LNX64-23C ORA-600 ARGS [KCLCLS_2] AND ORA-1688
33618962APPLICATION SYNC IN PDB FAILED AFTER MULTIPLE UPGRADES.
33621794ORION SHOULD VERIFY THAT PENDING I/O REQUESTS ARE RETURNED VIA OSS_WAIT()
33622325AH FWD MERGE OF BUG 33558317 TO MAIN - DIAGNOSTIC PATCH FOR BUG 33520776
33624356ORA-65092 WHILE MOVING FROM 19.12 TO 19.13 RU
33631068BACKPORT 33200622 TO OSS_21.0.0.0.0DB
33631562LIMIT THE NUMBER OF CELLS BEING UPGRADED WHEN ANOTHER CELL HAS DISK FAILURE
33632754PMEMLOG CLIENT IO SHOULD MARK ITSELF ELIGIBLE FOR IO LATENCY CAPPING
33633875AVOID THREAD SUSPEND IF SRWLOCK HELD BY ANY THREAD
33637219SR21.1BIGSCN_HIPU3 - TRC - CTSDRV1 - ORA-600 [CTSDRV-4]
33641592UNICODE STRING STORED INCORRECTLY IN CLOB IN 64 BIT 19.13 CLIENT
33647820CN DB ENCOUNTERED ORA-04031 KGLSESHTTABLE AFTER UPGRADING TO 19.12DBRU FROM 19.10
33655399SDO_UTIL.TO_WKTGEOMETRY DOES NOT PRESERVE LRS MEASURE VALUES
33656679CORRECT THE FIX CONTROLS ADDED AS PART OF BUG 30564898
33657553ORA-00700 SOFT INTERNAL ERROR, ARGUMENTS [KJBRMNOT WN] EVEN WITH THESE TWO FIXES APPLIED 33035201 31965391
33660093IPCDAT ASSERTION ON DISQUALIFYING DEVICES
33660782MEDIA RECOVERY PERFORMS PERIODICAL CHECKPOINT DUE TO _TIME_BASED_RCV_HDR_UPDATE_INTERVAL
33661960Fix for Bug 33661960
33674035Fix for Bug 33674035
33681814EDSLIB VERSION SUPPORT NEEDED
33681832RDBMS CLIENT SHOULD PASS EDSLIB VERSION
33684377TRACKING BUG FOR RTI 24951959 SET JZN_ALLOW_CONTROLS_WHITESPACE ON THE PARSER
33695048Fix for Bug 33695048
33718848REMOVE UTLRP CALL FROM SDOCMPRG.SQL
33727406REDUCE LEVEL OF IPCDAT DESTROY QP TRACING
33736618ORA-07445 [KTUCANCLNUPTEMPSO()+381] AFTER FAILOVER ON STANDBY
33738702TRACKING BUG TO ADD ADDITIONAL _FIX_CONTROL PARAMETER FOR _FIX_CONTROL LIMIT EXTENTION
33743745OPC DB PATCH FAILED AT DATA PATCH APPLY FOR ODS DB - US6BODST
33750344MS PRECISION INACCURATE IN KSTMGETHIGHRESMSTICK_FN
33753873LOCAL ONLY APPLICATIONS SHOULD NOT HAVE REMOTE EXECUTION DEPENDENCIES
33768421Fix for Bug 33768421
33794088Fix for Bug 33794088
33805155Fix for Bug 33805155
33810177JDK BUNDLE PATCH 21.0.0.0.220419
33817717TRACKING BUG TO UPDATE BUNDLEFCP.XML IN APR 2022 RELEASE
33822187FADBRWT DATAPATCH FAILING WITH ERRORS ON 19.15DBRU -ORA-04098- PLS-00302
33850437ORPHAN MESSAGE CLEANUP TASK DOES NOT PURGE REMOVED SUBSCRIBER IF THERE ARE EXPIRED MESSAGES
33853330ALTER DISKGROUP CHECK ALL DOES NOT REPORT MISMATCH EXTENT NUM
33861312INCOMPLETE DEPENDENCIES FOR BACKPORT BUG 33318247
3386326119.14 DB UPGRADE TO 21.6 FAILS DUE TO ORA-60510 ENCOUNTERED AN ERROR DURING REPLAY UPGRADE
3387905419.14 OGG CDB RAC EXTRACT ABEND W/ ORA-600[KRVUATLA20] IN LOGMINER BUILDER & UNABLE TO RESTART
33893127ORA-600 [QKSDMLMRGVIEWDESTFRO_5] ON 19.14 DUE TO 32464021
33954999ORA-600 [KJBRWRDONE SC4]
33967599AIM ORA-7445 [QKSWCSIMPLELOBFUNCTION] - QKSWCSIMPLELOBFUNCTION

Below script can help to capture such patch information without direct opatch command

-- 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
;
SQL> set serveroutput on;
SQL> execute dbms_optim_bundle.ListBundlesWithFCFixes;
bundleId: 211019,  bundleName: 21.4.0.0.211019DBRU
bundleId: 220118,  bundleName: 21.5.0.0.220118DBRU
bundleId: 220419,  bundleName: 21.6.0.0.220419DBRU

PL/SQL procedure successfully completed.
SQL> set serveroutput on;
SQL> execute dbms_optim_bundle.getBugsforBundle;

21.6.0.0.220419DBRU:
    Bug: 32856375,  fix_controls: 32856375
    Bug: 33297275,  fix_controls: 33297275
    Bug: 33323903,  fix_controls: 33323903
    Bug: 32302470,  fix_controls: 32302470
    Bug: 32851615,  fix_controls: 32851615
    Bug: 32754044,  fix_controls: 32754044

PL/SQL procedure successfully completed.
SQL> execute dbms_optim_bundle.getBugsforBundle(220118);

21.4.0.0.211019DBRU:
    Bug: 31988833,  fix_controls: 31988833
    Bug: 32800137,  fix_controls: 32800137
    Bug: 32408640,  fix_controls: 32408640
    Bug: 32312412,  fix_controls: 29738374
    Bug: 33325981,  fix_controls: 33325981

21.5.0.0.220118DBRU:
    Bug: 32913527,  fix_controls: 32913527
    Bug: 32766397,  fix_controls: 32766397
    Bug: 31912834,  fix_controls: 31912834
    Bug: 33145153,  fix_controls: 33145153
    Bug: 31843716,  fix_controls: 31843716
    Bug: 32212062,  fix_controls: 32212062
    Bug: 33613512,  fix_controls: 31880080

PL/SQL procedure successfully completed.

SQL> execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');
DBMS_OPTIM command:  dbms_optim_bundle.enable_optim_fixes('ON', 'BOTH', 'YES')

Bundles _fix_control setting as per action:ON
31988833:1  32800137:0  32408640:1  29738374:1  33325981:1  32913527:0  32766397:0  31912834:1  33145153:1  31843716:0
32212062:0  31880080:0  32856375:1  33297275:1  33323903:1  32302470:1  32851615:1  32754044:1

Taking current instance orcl21c as base, details on _fix_control setting for CON_ID 1 :

1) Current _fix_control setting for spfile:
None

2) Final _fix_control setting for spfile considering current_setting_precedence is YES
31988833:1  32800137:0  32408640:1  29738374:1  33325981:1  32913527:0  32766397:0  31912834:1  33145153:1  31843716:0
32212062:0  31880080:0  32856375:1  33297275:1  33323903:1  32302470:1  32851615:1  32754044:1

3) Current _fix_control setting in memory:
31988833:0  32800137:0  32408640:0  29738374:0  33325981:0  32913527:0  32766397:0  31912834:0  33145153:0  31843716:0
32212062:0  31880080:0  32856375:0  33297275:0  33323903:0  32302470:0  32851615:0  32754044:0

4) Final _fix_control setting for memory considering current_setting_precedence is YES
31988833:0  32800137:0  32408640:0  29738374:0  33325981:0  32913527:0  32766397:0  31912834:0  33145153:0  31843716:0
32212062:0  31880080:0  32856375:0  33297275:0  33323903:0  32302470:0  32851615:0  32754044:0

WARNING: final _fix_control setting for memory is not same as final _fix_control setting for spfile. Please look at point 2 and
4 above to see the differences.


PL/SQL procedure successfully completed.
SQL> select value from v$spparameter where name='_fix_control';

        VALUE
_____________
31988833:1
32800137:0
32408640:1
29738374:1
33325981:1
32913527:0
32766397:0
31912834:1
33145153:1
31843716:0
32212062:0
31880080:0
32856375:1
33297275:1
33323903:1
32302470:1
32851615:1
32754044:1

18 rows selected.
SQL> select bugno, value ,sql_feature, description from v$system_fix_control where bugno in (31988833);

      BUGNO    VALUE           SQL_FEATURE                                           DESCRIPTION
___________ ________ _____________________ _____________________________________________________
   31988833        0 QKSFM_CBO_31988833    Enable global caching of IMC stats per original qb