Dissecting 210119 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases.

The following patches were analysed:

  • 11.2.0.4
    • 11.2.0.4.210119 DB PSU
  • 12.1.0.2
    • 12.1.0.2.210119 DB PSU
    • 12.1.0.2.210119 Exadata Bundle Patch
    • 12.1.0.2.210119 OJVM PSU
  • 12.2.0.1
    • 12.2.0.1.210119 RU
    • 12.2.0.1.210119 OJVM PSU
  • 18
    • 18.13.0 RU
    • 18.12.1 RUR
    • 18.11.2 RUR
    • 18.0.0.0.210119 OJVM
  • 19
    • 19.10.0 RU
    • 19.9.1 RUR
    • 19.8.2 RUR
    • 19.0.0.0.210119 OJVM

To check previous changes, follow the links below:

So what oracle internal objects were changed in January 2021 - 210119?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
12.1.0.2   BP         SYS                            PACKAGE BODY             3
12.1.0.2   BP         SYS                            VIEW                     2
12.1.0.2   PSU        SYS                            PACKAGE BODY             1
18.0.0.0   18.11RUR   GSMADMIN_INTERNAL              PACKAGE BODY             3
18.0.0.0   18.11RUR   SYS                            PACKAGE                  2
18.0.0.0   18.11RUR   SYS                            PACKAGE BODY             1
18.0.0.0   18.12RUR   GSMADMIN_INTERNAL              PACKAGE BODY             3
18.0.0.0   18.12RUR   SYS                            PACKAGE                  2
18.0.0.0   18.12RUR   SYS                            PACKAGE BODY             1
18.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE BODY             3
18.0.0.0   RU         SYS                            PACKAGE                  2
18.0.0.0   RU         SYS                            PACKAGE BODY             3
18.0.0.0   RU         SYS                            VIEW                     2
19.0.0.0   19.8RUR    GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   19.8RUR    SYS                            PACKAGE                  2
19.0.0.0   19.8RUR    SYS                            PACKAGE BODY             1
19.0.0.0   19.9RUR    GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   19.9RUR    SYS                            PACKAGE                  2
19.0.0.0   19.9RUR    SYS                            PACKAGE BODY             2
19.0.0.0   RU         CTXSYS                         PACKAGE BODY             4
19.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   RU         MDSYS                          TRIGGER                  2
19.0.0.0   RU         SYS                            PACKAGE                 11
19.0.0.0   RU         SYS                            PACKAGE BODY            37
19.0.0.0   RU         SYS                            PROCEDURE                3
19.0.0.0   RU         SYS                            TYPE BODY                3
19.0.0.0   RU         SYS                            VIEW                    16

P.S: No internal PL/SQL was modified on 11.2 / 12.2.

And created?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
19.0.0.0   19.9RUR    SYS                            TYPE                     8
19.0.0.0   RU         MDSYS                          TRIGGER                  1
19.0.0.0   RU         SYS                            FUNCTION                 1
19.0.0.0   RU         SYS                            LIBRARY                  3
19.0.0.0   RU         SYS                            PACKAGE                  3
19.0.0.0   RU         SYS                            PACKAGE BODY             3
19.0.0.0   RU         SYS                            TYPE                     2
19.0.0.0   RU         SYS                            VIEW                     9

P.S: No internal PL/SQL was added on 11.2 / 12.1 / 12.2 / 18.

So which are exactly the objects modified by 210119?

VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION
---------- --------------- ------------------------------ --------------- ------------------------------ ------
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_AWR_REPORT_LAYOUT         MOD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_STATS                     MOD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
12.1.0.2   BP              SYS                            VIEW            DBA_TABLESPACE_USAGE_METRICS   MOD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
12.1.0.2   BP              SYS                            VIEW            USER_ROLE_PRIVS                MOD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
12.1.0.2   PSU & BP        SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AWR_REPORT_LAYOUT         MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE                   MOD
18.0.0.0   RU              SYS                            VIEW            DBA_TABLESPACE_USAGE_METRICS   MOD
18.0.0.0   RU              SYS                            VIEW            USER_ROLE_PRIVS                MOD
18.0.0.0   RU & 18.12RUR & GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_CLOUDADMIN            MOD
            18.11RUR
18.0.0.0   RU & 18.12RUR & GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_NOPRIV                MOD
            18.11RUR
18.0.0.0   RU & 18.12RUR & GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_POOLADMIN             MOD
            18.11RUR
18.0.0.0   RU & 18.12RUR & SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
            18.11RUR
18.0.0.0   RU & 18.12RUR & SYS                            PACKAGE         DBMS_REGISTRY                  MOD
            18.11RUR
18.0.0.0   RU & 18.12RUR & SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
            18.11RUR
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016008$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016012$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016023$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016024$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016207$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016378$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000016899$            NEW
19.0.0.0   19.9RUR         SYS                            TYPE            SYS_YOID0000017005$            NEW
19.0.0.0   RU              MDSYS                          TRIGGER         SDO_NETWORK_DROP_USER          NEW
19.0.0.0   RU              SYS                            FUNCTION        SPATIALACTIVE                  NEW
19.0.0.0   RU              SYS                            LIBRARY         DBMS_BLOCKCHAIN_TABLE_LIB      NEW
19.0.0.0   RU              SYS                            LIBRARY         DBMS_TABLE_DATA_LIB            NEW
19.0.0.0   RU              SYS                            LIBRARY         DBMS_USER_CERTS_LIB            NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_BLOCKCHAIN_TABLE          NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_TABLE_DATA                NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_USER_CERTS                NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_BLOCKCHAIN_TABLE          NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_TABLE_DATA                NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_USER_CERTS                NEW
19.0.0.0   RU              SYS                            TYPE            ORABCTAB_ROW_ARRAY_T           NEW
19.0.0.0   RU              SYS                            TYPE            ORABCTAB_ROW_T                 NEW
19.0.0.0   RU              SYS                            VIEW            ALL_BLOCKCHAIN_TABLES          NEW
19.0.0.0   RU              SYS                            VIEW            ALL_CERTIFICATES               NEW
19.0.0.0   RU              SYS                            VIEW            CDB_BLOCKCHAIN_TABLES          NEW
19.0.0.0   RU              SYS                            VIEW            CDB_CERTIFICATES               NEW
19.0.0.0   RU              SYS                            VIEW            DBA_BLOCKCHAIN_TABLES          NEW
19.0.0.0   RU              SYS                            VIEW            DBA_CERTIFICATES               NEW
19.0.0.0   RU              SYS                            VIEW            DBA_LOGMNR_DICTIONARY_BUILDLOG NEW
19.0.0.0   RU              SYS                            VIEW            USER_BLOCKCHAIN_TABLES         NEW
19.0.0.0   RU              SYS                            VIEW            USER_CERTIFICATES              NEW
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRIREPZ                        MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRISGP                         MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRIXMD                         MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRVDDL                         MOD
19.0.0.0   RU              MDSYS                          TRIGGER         SDO_DROP_USER                  MOD
19.0.0.0   RU              MDSYS                          TRIGGER         SDO_TOPO_DROP_FTBL             MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_ASH                       MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_CAPTURE_ADM_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_PERF                      MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_REPORT                    MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SWRF_INTERNAL             MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_UMF_PROTECTED             MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_XS_SIDP                   MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVT_AWR_VIEWER                MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVT_EMX                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_ASH                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTO_INDEX_INTERNAL       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AWR_REPORT_LAYOUT         MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CAPTURE_ADM               MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CAPTURE_ADM_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CAPTURE_ADM_IVK           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CAPTURE_PROCESS           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_DBFS_CONTENT              MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_DBFS_CONTENT_ADMIN        MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_DBFS_SFS                  MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_DST                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_EXTENDED_TTS_CHECKS       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_IJOB                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_LOGMNR_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_LOGREP_UTIL               MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PERF                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PICKLER                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_REPORT                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SNAP_INTERNAL             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SPM_INTERNAL              MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SWRF_INTERNAL             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_TTS                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_UMF_PROTECTED             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_XS_SIDP                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_ADMIN                  MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_CELL                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_DBHOME                 MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_ASH_OMX                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_AWR_VIEWER                MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_COMPRESSION               MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_EMX                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_HDM                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_SQLPA                     MOD
19.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_PARTITION_SYSTEM  MOD
19.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_PARTITION_USER    MOD
19.0.0.0   RU              SYS                            PROCEDURE       LOGMNR_GTLO3                   MOD
19.0.0.0   RU              SYS                            TYPE BODY       PRVT_AWRV_METADATA             MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_AWRV                 MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_SQLPI                MOD
19.0.0.0   RU              SYS                            VIEW            ALL_IND_STATISTICS             MOD
19.0.0.0   RU              SYS                            VIEW            CDB_WORKLOAD_CAPTURES          MOD
19.0.0.0   RU              SYS                            VIEW            DBA_IND_STATISTICS             MOD
19.0.0.0   RU              SYS                            VIEW            DBA_JOBS                       MOD
19.0.0.0   RU              SYS                            VIEW            DBA_JOBS_RUNNING               MOD
19.0.0.0   RU              SYS                            VIEW            DBA_TABLESPACE_USAGE_METRICS   MOD
19.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_CAPTURES          MOD
19.0.0.0   RU              SYS                            VIEW            LOGSTDBY_RU_SUPP_TAB_19        MOD
19.0.0.0   RU              SYS                            VIEW            LOGSTDBY_RU_UN_TAB_19          MOD
19.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_19        MOD
19.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPP_TAB_19         MOD
19.0.0.0   RU              SYS                            VIEW            MON_MODS_V                     MOD
19.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_19             MOD
19.0.0.0   RU              SYS                            VIEW            STRADDLING_TS_OBJECTS          MOD
19.0.0.0   RU              SYS                            VIEW            USER_IND_STATISTICS            MOD
19.0.0.0   RU              SYS                            VIEW            USER_ROLE_PRIVS                MOD
19.0.0.0   RU & 19.9RUR    SYS                            PACKAGE BODY    STANDARD                       MOD
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_CLOUDADMIN            MOD
           19.8RUR
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_NOPRIV                MOD
           19.8RUR
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_POOLADMIN             MOD
           19.8RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           19.8RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           19.8RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           19.8RUR

What exactly changed for each?

(click to see detailed line changes)

Useful Links:

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.