Dissecting 200414 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 analyzed:

  • 11.2.0.4
    • 11.2.0.4.200414 DB PSU
    • 11.2.0.4.200414 Exadata Bundle Patch
    • 11.2.0.4.200414 OJVM PSU
  • 12.1.0.2
    • 12.1.0.2.200414 DB PSU
    • 12.1.0.2.200414 Exadata Bundle Patch
    • 12.1.0.2.200414 OJVM PSU
  • 12.2.0.1
    • 12.2.0.1.200414 RU
    • 12.2.0.1.JAN2020RUR
    • 12.2.0.1.OCT2019RUR
    • 12.2.0.1.200414 OJVM PSU
  • 18
    • 18.10.0 RU
    • 18.9.1 RUR
    • 18.8.2 RUR
    • 18.0.0.0.200414 OJVM
  • 19
    • 19.7.0 RU
    • 19.6.1 RUR
    • 19.5.2 RUR
    • 19.0.0.0.200414 OJVM

To check previous changes, follow the links below:

So what oracle internal objects were changed in April 2020 - 200414?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
12.1.0.2   BP         DVSYS                          PACKAGE                  1
12.1.0.2   BP         DVSYS                          PACKAGE BODY             1
12.1.0.2   BP         SYS                            PACKAGE                  2
12.1.0.2   BP         SYS                            PACKAGE BODY             5
12.1.0.2   BP         SYS                            VIEW                     2
12.2.0.1   RU         SYS                            PACKAGE BODY             3
12.2.0.1   RU         SYS                            PROCEDURE                1
18.0.0.0   18.8RUR    SYS                            PACKAGE                  2
18.0.0.0   18.8RUR    SYS                            PACKAGE BODY             1
18.0.0.0   18.9RUR    SYS                            PACKAGE                  2
18.0.0.0   18.9RUR    SYS                            PACKAGE BODY             1
18.0.0.0   RU         SYS                            PACKAGE                  2
18.0.0.0   RU         SYS                            PACKAGE BODY             1
18.0.0.0   RU         SYS                            PROCEDURE                1
18.0.0.0   RU         SYS                            VIEW                     4
19.0.0.0   19.5RUR    SYS                            PACKAGE                  2
19.0.0.0   19.5RUR    SYS                            PACKAGE BODY             1
19.0.0.0   19.6RUR    SYS                            PACKAGE                  2
19.0.0.0   19.6RUR    SYS                            PACKAGE BODY             1
19.0.0.0   RU         AUDSYS                         PACKAGE BODY             1
19.0.0.0   RU         CTXSYS                         PACKAGE                  1
19.0.0.0   RU         CTXSYS                         PACKAGE BODY             4
19.0.0.0   RU         DVSYS                          PACKAGE BODY             1
19.0.0.0   RU         LBACSYS                        PACKAGE                  2
19.0.0.0   RU         LBACSYS                        PACKAGE BODY             3
19.0.0.0   RU         MDSYS                          PACKAGE                  1
19.0.0.0   RU         MDSYS                          PACKAGE BODY             6
19.0.0.0   RU         MDSYS                          TYPE BODY                1
19.0.0.0   RU         SYS                            PACKAGE                 17
19.0.0.0   RU         SYS                            PACKAGE BODY            29
19.0.0.0   RU         SYS                            PROCEDURE                1
19.0.0.0   RU         SYS                            TYPE BODY                3
19.0.0.0   RU         SYS                            VIEW                     4
19.0.0.0   RU         XDB                            PACKAGE                  1
19.0.0.0   RU         XDB                            PACKAGE BODY             1

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

And created?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
12.1.0.2   BP         DVSYS                          VIEW                     1
12.1.0.2   BP         SYS                            TYPE                     3
19.0.0.0   RU         LBACSYS                        PACKAGE                  2
19.0.0.0   RU         LBACSYS                        PACKAGE BODY             2

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

So which are exactly the objects modified by 200414?

VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION
---------- --------------- ------------------------------ --------------- ------------------------------ ------
12.1.0.2   BP              DVSYS                          VIEW            DBA_DV_PREPROCESSOR_AUTH       NEW
12.1.0.2   BP              SYS                            TYPE            SYS_PLSQL_1EE1A140_153_1       NEW
12.1.0.2   BP              SYS                            TYPE            SYS_PLSQL_1EE1A140_184_1       NEW
12.1.0.2   BP              SYS                            TYPE            SYS_PLSQL_1EE1A140_DUMMY_1     NEW
12.1.0.2   BP              DVSYS                          PACKAGE         DBMS_MACADM                    MOD
12.1.0.2   BP              DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
12.1.0.2   BP              SYS                            PACKAGE         DBMS_SQLDIAG_INTERNAL          MOD
12.1.0.2   BP              SYS                            PACKAGE         PRVT_ILM                       MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_QOPATCH                   MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_REDEFINITION              MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_SQLDIAG_INTERNAL          MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    LOGMNR_DICT_CACHE              MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    PRVT_ILM                       MOD
12.1.0.2   BP              SYS                            VIEW            DBA_ILMOBJECTS                 MOD
12.1.0.2   BP              SYS                            VIEW            USER_ILMOBJECTS                MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_AQJMS_INTERNAL            MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_HEAT_MAP_INTERNAL         MOD
12.2.0.1   RU              SYS                            PACKAGE BODY    LOGMNR_DICT_CACHE              MOD
12.2.0.1   RU              SYS                            PROCEDURE       DBMS_FEATURE_JSON              MOD
18.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_JSON              MOD
18.0.0.0   RU              SYS                            VIEW            CDB_WORKLOAD_CAPTURES          MOD
18.0.0.0   RU              SYS                            VIEW            CDB_WORKLOAD_REPLAY_FILTER_SET MOD
18.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_CAPTURES          MOD
18.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_REPLAY_FILTER_SET MOD
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           18.8RUR
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           18.8RUR
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           18.8RUR
19.0.0.0   RU              LBACSYS                        PACKAGE         LBAC_POLICY_ADMIN_INT          NEW
19.0.0.0   RU              LBACSYS                        PACKAGE         SA_USER_ADMIN_INT              NEW
19.0.0.0   RU              LBACSYS                        PACKAGE BODY    LBAC_POLICY_ADMIN_INT          NEW
19.0.0.0   RU              LBACSYS                        PACKAGE BODY    SA_USER_ADMIN_INT              NEW
19.0.0.0   RU              AUDSYS                         PACKAGE BODY    DBMS_AUDIT_MGMT                MOD
19.0.0.0   RU              CTXSYS                         PACKAGE         DRIXMD                         MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRIPARSE                       MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRIREPM                        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              DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
19.0.0.0   RU              LBACSYS                        PACKAGE         LBAC_POLICY_ADMIN              MOD
19.0.0.0   RU              LBACSYS                        PACKAGE         SA_USER_ADMIN                  MOD
19.0.0.0   RU              LBACSYS                        PACKAGE BODY    LBAC_POLICY_ADMIN              MOD
19.0.0.0   RU              LBACSYS                        PACKAGE BODY    SA_SYSDBA                      MOD
19.0.0.0   RU              LBACSYS                        PACKAGE BODY    SA_USER_ADMIN                  MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_3GL                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    RDF_APIS                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    RDF_APIS_INTERNAL              MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOM                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_RDF                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_RDF_INTERNAL               MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_UTIL                       MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SDO_RDF_TRIPLE_S               MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_APP_CONT_ADMIN            MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_AUTOTASK_PRVT             MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_HADOOP_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_JSON0                     MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_REDACT_INT                MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_REPORT                    MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_RLS_INT                   MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SQLTUNE_UTIL2             MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SWRF_REPORT_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE         KUPU$UTILITIES_INT             MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVTEMX_PERF                   MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVT_ASH_OMX                   MOD
19.0.0.0   RU              SYS                            PACKAGE         PRVT_AWR_VIEWER                MOD
19.0.0.0   RU              SYS                            PACKAGE         XS_DATA_SECURITY_INT           MOD
19.0.0.0   RU              SYS                            PACKAGE         XS_DIAG_INT                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_APP_CONT_ADMIN            MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTOTASK_PRVT             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTO_INDEX_INTERNAL       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTO_REPORT               MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_HADOOP                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_HADOOP_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_JSON0                     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PART                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PERF                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_REPORT                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_RLS                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_RLS_INT                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SPM                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTCB_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE_UTIL2             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SWRF_REPORT_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    KUPF$FILE                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    KUPU$UTILITIES_INT             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    KUPW$WORKER                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_PERF                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_RSRCMGR                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_EMX                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    XS_DATA_SECURITY               MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    XS_DATA_SECURITY_INT           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    XS_DIAG                        MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    XS_DIAG_INT                    MOD
19.0.0.0   RU              SYS                            PROCEDURE       XOQ_VALIDATE                   MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_ASH_OMX              MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_AWRV                 MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_SESSION              MOD
19.0.0.0   RU              SYS                            VIEW            CDB_WORKLOAD_CAPTURES          MOD
19.0.0.0   RU              SYS                            VIEW            DBA_APP_VERSIONS               MOD
19.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_CAPTURES          MOD
19.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_REPLAYS           MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_JSON                      MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_JSON                      MOD
19.0.0.0   RU & 19.6RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           19.5RUR
19.0.0.0   RU & 19.6RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           19.5RUR
19.0.0.0   RU & 19.6RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           19.5RUR

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.