Dissecting 201020 BP, PSU, RU and RUR

This post is also available in: Português

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.201020 DB PSU
    • 11.2.0.4.201020 Exadata Bundle Patch
    • 11.2.0.4.201020 OJVM PSU
  • 12.1.0.2
    • 12.1.0.2.201020 DB PSU
    • 12.1.0.2.201020 Exadata Bundle Patch
    • 12.1.0.2.201020 OJVM PSU
  • 12.2.0.1
    • 12.2.0.1.201020 RU
    • 12.2.0.1.JUL2020 OCT2020RUR
    • 12.2.0.1.APR2020 OCT2020RUR
    • 12.2.0.1.201020 OJVM PSU
  • 18
    • 18.12.0 RU
    • 18.11.1 RUR
    • 18.10.2 RUR
    • 18.0.0.0.201020 OJVM
  • 19
    • 19.9.0 RU
    • 19.8.1 RUR
    • 19.7.2 RUR
    • 19.0.0.0.201020 OJVM

To check previous changes, follow the links below:

So what oracle internal objects were changed in October 2020 - 201020?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
11.2.0.4   BP         SYS                            PACKAGE BODY             1
12.1.0.2   BP         DVSYS                          PACKAGE BODY             5
12.1.0.2   BP         SYS                            PACKAGE                  1
12.1.0.2   BP         SYS                            PACKAGE BODY             3
12.1.0.2   PSU        DVSYS                          PACKAGE BODY             5
12.1.0.2   PSU        SYS                            PACKAGE                  1
12.1.0.2   PSU        SYS                            PACKAGE BODY             1
12.2.0.1   APR2020RUR DVSYS                          FUNCTION                 1
12.2.0.1   APR2020RUR DVSYS                          PACKAGE BODY             7
12.2.0.1   APR2020RUR DVSYS                          VIEW                     2
12.2.0.1   JUL2020RUR DVSYS                          FUNCTION                 1
12.2.0.1   JUL2020RUR DVSYS                          PACKAGE BODY             7
12.2.0.1   JUL2020RUR DVSYS                          VIEW                     2
12.2.0.1   RU         CTXSYS                         PACKAGE                  1
12.2.0.1   RU         CTXSYS                         PACKAGE BODY             1
12.2.0.1   RU         DVSYS                          FUNCTION                 1
12.2.0.1   RU         DVSYS                          PACKAGE BODY             7
12.2.0.1   RU         DVSYS                          VIEW                     2
12.2.0.1   RU         SYS                            PACKAGE BODY             3
12.2.0.1   RU         SYS                            PROCEDURE                1
18.0.0.0   18.10RUR   SYS                            PACKAGE                  2
18.0.0.0   18.10RUR   SYS                            PACKAGE BODY             1
18.0.0.0   18.11RUR   SYS                            PACKAGE                  2
18.0.0.0   18.11RUR   SYS                            PACKAGE BODY             1
18.0.0.0   RU         SYS                            PACKAGE                  2
18.0.0.0   RU         SYS                            PACKAGE BODY             3
19.0.0.0   19.7RUR    SYS                            PACKAGE                  2
19.0.0.0   19.7RUR    SYS                            PACKAGE BODY             1
19.0.0.0   19.8RUR    SYS                            PACKAGE                  3
19.0.0.0   19.8RUR    SYS                            PACKAGE BODY             4
19.0.0.0   RU         DBSFWUSER                      PACKAGE BODY             1
19.0.0.0   RU         MDSYS                          PACKAGE BODY             1
19.0.0.0   RU         SYS                            PACKAGE                 11
19.0.0.0   RU         SYS                            PACKAGE BODY            19
19.0.0.0   RU         SYS                            PROCEDURE                1
19.0.0.0   RU         SYS                            TYPE                     2
19.0.0.0   RU         SYS                            TYPE BODY                3
19.0.0.0   RU         SYS                            VIEW                     2
19.0.0.0   RU         XDB                            PACKAGE                  5
19.0.0.0   RU         XDB                            PACKAGE BODY             5

And created?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
12.1.0.2   PSU        SYS                            PACKAGE BODY             1
19.0.0.0   19.8RUR    SYS                            TYPE                     8
19.0.0.0   RU         SYS                            PACKAGE                  1
19.0.0.0   RU         SYS                            PACKAGE BODY             1
19.0.0.0   RU         SYS                            PROCEDURE                4
19.0.0.0   RU         SYS                            VIEW                     2

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

So which are exactly the objects modified by 201020?

VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION
---------- --------------- ------------------------------ --------------- ------------------------------ ------
11.2.0.4   BP              SYS                            PACKAGE BODY    DBMS_PDB                       MOD
12.1.0.2   PSU             SYS                            PACKAGE BODY    DBMS_SQLPATCH                  NEW
12.1.0.2   BP              DVSYS                          PACKAGE BODY    DBMS_MACSEC_ROLES              MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_STATS                     MOD
12.1.0.2   PSU             DVSYS                          PACKAGE BODY    FACTOR_TYPE$_PRIV              MOD
12.1.0.2   PSU & BP        DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
12.1.0.2   PSU & BP        DVSYS                          PACKAGE BODY    DBMS_MACOLS                    MOD
12.1.0.2   PSU & BP        DVSYS                          PACKAGE BODY    DBMS_MACSEC                    MOD
12.1.0.2   PSU & BP        DVSYS                          PACKAGE BODY    DBMS_MACUTL                    MOD
12.1.0.2   PSU & BP        SYS                            PACKAGE         DBMS_RCVMAN                    MOD
12.1.0.2   PSU & BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
12.2.0.1   RU              CTXSYS                         PACKAGE         DRVDML                         MOD
12.2.0.1   RU              CTXSYS                         PACKAGE BODY    DRVDML                         MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_SNAPSHOT_KKXRCA           MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD
12.2.0.1   RU              SYS                            PROCEDURE       DBMS_FEATURE_ACTIVE_DATA_GUARD MOD
12.2.0.1   RU & JUL2020RUR DVSYS                          FUNCTION        DVLANG                         MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACOLS                    MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACOLS_SESSION            MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACSEC                    MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACSEC_RULES              MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    DBMS_MACUTL                    MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          PACKAGE BODY    EVENT                          MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          VIEW            DBA_DV_STATUS                  MOD
            & APR2020RUR
12.2.0.1   RU & JUL2020RUR DVSYS                          VIEW            DBA_DV_USER_PRIVS_ALL          MOD
            & APR2020RUR
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SNAPSHOT_KKXRCA           MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD
18.0.0.0   RU & 18.11RUR & SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
            18.10RUR
18.0.0.0   RU & 18.11RUR & SYS                            PACKAGE         DBMS_REGISTRY                  MOD
            18.10RUR
18.0.0.0   RU & 18.11RUR & SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
            18.10RUR
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016008$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016012$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016023$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016024$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016207$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016378$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000016899$            NEW
19.0.0.0   19.8RUR         SYS                            TYPE            SYS_YOID0000017005$            NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_XMLSCHEMA_UTIL            NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_XMLSCHEMA_UTIL            NEW
19.0.0.0   RU              SYS                            PROCEDURE       SCHEDULER$NTFY_SVC_METRICS     NEW
19.0.0.0   RU              SYS                            PROCEDURE       SCHEDULER$RM_ALL_MISSMATCH_MSG NEW
19.0.0.0   RU              SYS                            PROCEDURE       SCHEDULER$RM_MISSMATCH_MSGS    NEW
19.0.0.0   RU              SYS                            PROCEDURE       SCHEDULER$RM_ONE_MISSMTACH_MSG NEW
19.0.0.0   RU              SYS                            VIEW            CDB_SUBSCR_DUR_REGISTRATIONS   NEW
19.0.0.0   RU              SYS                            VIEW            DBA_SUBSCR_DUR_REGISTRATIONS   NEW
19.0.0.0   RU              DBSFWUSER                      PACKAGE BODY    DBMS_SFW_ACL_ADMIN             MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_RDF_INTERNAL               MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_CRYPTO                    MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_CRYPTO_FFI                MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_JSON0                     MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_PARALLEL_EXECUTE_INTERNAL MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_RULE_IMP_OBJ              MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SODA                      MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SODA_UTIL                 MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVTEMX_PERF                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CRYPTO                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CRYPTO_FFI                MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_ISCHED                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_JSON0                     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PARALLEL_EXECUTE          MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PARALLEL_EXECUTE_INTERNAL MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_RULE_IMP_OBJ              MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SNAPSHOT_KKXRCA           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SODA                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SODA_UTIL                 MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_XPLAN                     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_ADMIN                  MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_PERF                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    STANDARD                       MOD
19.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_UNIFIED_AUDIT     MOD
19.0.0.0   RU              SYS                            TYPE            SODA_COLLECTION_T              MOD
19.0.0.0   RU              SYS                            TYPE            SODA_OPERATION_T               MOD
19.0.0.0   RU              SYS                            TYPE BODY       SODA_COLLECTION_T              MOD
19.0.0.0   RU              SYS                            TYPE BODY       SODA_OPERATION_T               MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_SESSION              MOD
19.0.0.0   RU              SYS                            VIEW            DBA_PARALLEL_EXECUTE_CHUNKS    MOD
19.0.0.0   RU              SYS                            VIEW            DBA_PARALLEL_EXECUTE_TASKS     MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_JSON                      MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_JSON_INT                  MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_SODA_ADMIN                MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_SODA_DML                  MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_SODA_DOM                  MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_JSON                      MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_JSON_INT                  MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_SODA_ADMIN                MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_SODA_DML                  MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_SODA_DOM                  MOD
19.0.0.0   RU & 19.8RUR    SYS                            PACKAGE         DBMS_SPM_INTERNAL              MOD
19.0.0.0   RU & 19.8RUR    SYS                            PACKAGE BODY    DBMS_AUTO_INDEX_INTERNAL       MOD
19.0.0.0   RU & 19.8RUR    SYS                            PACKAGE BODY    DBMS_SPM                       MOD
19.0.0.0   RU & 19.8RUR    SYS                            PACKAGE BODY    DBMS_SPM_INTERNAL              MOD
19.0.0.0   RU & 19.8RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           19.7RUR
19.0.0.0   RU & 19.8RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           19.7RUR
19.0.0.0   RU & 19.8RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           19.7RUR

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.