Dissecting 200714 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.200714 DB PSU
    • 11.2.0.4.200714 Exadata Bundle Patch
    • 11.2.0.4.200714 OJVM PSU
  • 12.1.0.2
    • 12.1.0.2.200714 DB PSU
    • 12.1.0.2.200714 Exadata Bundle Patch
    • 12.1.0.2.200714 OJVM PSU
  • 12.2.0.1
    • 12.2.0.1.200717 RU
    • 12.2.0.1.APR2020 JUL2020RUR
    • 12.2.0.1.JAN2020 JUL2020RUR
    • 12.2.0.1.200714 OJVM PSU
  • 18
    • 18.11.0 RU
    • 18.10.1 RUR
    • 18.9.2 RUR
    • 18.0.0.0.200714 OJVM
  • 19
    • 19.8.0 RU
    • 19.7.1 RUR
    • 19.6.2 RUR
    • 19.0.0.0.200714 OJVM

To check previous changes, follow the links below:

So what oracle internal objects were changed in July 2020 - 200714?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
11.2.0.4   BP         SYS                            PACKAGE BODY             1
11.2.0.4   PSU        SYS                            PACKAGE BODY             1
12.1.0.2   BP         SYS                            PACKAGE                  1
12.1.0.2   BP         SYS                            PACKAGE BODY             3
12.1.0.2   BP         SYS                            PROCEDURE                1
12.1.0.2   PSU        SYS                            PACKAGE                  2
12.1.0.2   PSU        SYS                            PACKAGE BODY             2
12.1.0.2   PSU        SYS                            VIEW                    12
12.2.0.1   APR2020RUR SYS                            PACKAGE BODY             1
12.2.0.1   JAN2020RUR SYS                            PACKAGE BODY             1
12.2.0.1   RU         DVSYS                          PACKAGE BODY             1
12.2.0.1   RU         SYS                            PACKAGE BODY             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.9RUR    SYS                            PACKAGE                  2
18.0.0.0   18.9RUR    SYS                            PACKAGE BODY             1
18.0.0.0   RU         DVSYS                          PACKAGE BODY             1
18.0.0.0   RU         MDSYS                          FUNCTION                 1
18.0.0.0   RU         SYS                            PACKAGE                  5
18.0.0.0   RU         SYS                            PACKAGE BODY             7
18.0.0.0   RU         SYS                            TYPE BODY                2
19.0.0.0   19.6RUR    SYS                            PACKAGE                  2
19.0.0.0   19.6RUR    SYS                            PACKAGE BODY             2
19.0.0.0   19.7RUR    SYS                            PACKAGE                  2
19.0.0.0   19.7RUR    SYS                            PACKAGE BODY             2
19.0.0.0   RU         CTXSYS                         PACKAGE BODY             1
19.0.0.0   RU         DVSYS                          PACKAGE BODY             1
19.0.0.0   RU         MDSYS                          FUNCTION                 1
19.0.0.0   RU         MDSYS                          PACKAGE                  4
19.0.0.0   RU         MDSYS                          PACKAGE BODY            21
19.0.0.0   RU         MDSYS                          TRIGGER                  2
19.0.0.0   RU         MDSYS                          TYPE BODY                3
19.0.0.0   RU         MDSYS                          VIEW                     4
19.0.0.0   RU         SYS                            FUNCTION                 2
19.0.0.0   RU         SYS                            PACKAGE                  8
19.0.0.0   RU         SYS                            PACKAGE BODY            16
19.0.0.0   RU         SYS                            PROCEDURE                1
19.0.0.0   RU         SYS                            TYPE BODY                5
19.0.0.0   RU         SYS                            VIEW                     3

And created?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
11.2.0.4   BP         SYS                            PACKAGE                  1
11.2.0.4   BP         SYS                            PACKAGE BODY             1
19.0.0.0   19.7RUR    SYS                            TYPE                     8
19.0.0.0   RU         MDSYS                          PACKAGE BODY             1
19.0.0.0   RU         MDSYS                          PROCEDURE                1
19.0.0.0   RU         SYS                            PROCEDURE                1

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

So which are exactly the objects modified by 200714?

VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION
---------- --------------- ------------------------------ --------------- ------------------------------ ------
11.2.0.4   BP              SYS                            PACKAGE         DBMS_PDB                       NEW
11.2.0.4   BP              SYS                            PACKAGE BODY    DBMS_PDB                       NEW
11.2.0.4   PSU & BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
12.1.0.2   BP              SYS                            PACKAGE BODY    CDBVIEW                        MOD
12.1.0.2   BP              SYS                            PROCEDURE       SCHEDULER$_JOB_EVENT_HANDLER   MOD
12.1.0.2   PSU             SYS                            PACKAGE         DBMS_RCVMAN                    MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$BACKUP_DATAFILE            MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$BACKUP_PIECE               MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$BACKUP_SET                 MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$BACKUP_SPFILE              MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$DATAFILE_COPY              MOD
12.1.0.2   PSU             SYS                            VIEW            GV_$PROXY_DATAFILE             MOD
12.1.0.2   PSU             SYS                            VIEW            V_$BACKUP_DATAFILE             MOD
12.1.0.2   PSU             SYS                            VIEW            V_$BACKUP_PIECE                MOD
12.1.0.2   PSU             SYS                            VIEW            V_$BACKUP_SET                  MOD
12.1.0.2   PSU             SYS                            VIEW            V_$BACKUP_SPFILE               MOD
12.1.0.2   PSU             SYS                            VIEW            V_$DATAFILE_COPY               MOD
12.1.0.2   PSU             SYS                            VIEW            V_$PROXY_DATAFILE              MOD
12.1.0.2   PSU & BP        SYS                            PACKAGE         DBMS_STATS                     MOD
12.1.0.2   PSU & BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
12.1.0.2   PSU & BP        SYS                            PACKAGE BODY    DBMS_STATS                     MOD
12.2.0.1   RU              DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
12.2.0.1   RU & JAN2020RUR SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
            & APR2020RUR
18.0.0.0   RU              DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD
18.0.0.0   RU              MDSYS                          FUNCTION        SDO_JOIN                       MOD
18.0.0.0   RU              SYS                            PACKAGE         DBMS_REPORT                    MOD
18.0.0.0   RU              SYS                            PACKAGE         DBMS_SQLTUNE_UTIL2             MOD
18.0.0.0   RU              SYS                            PACKAGE         PRVT_AWR_VIEWER                MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_REPORT                    MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE                   MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE_UTIL2             MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_PERF                   MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_RSRCMGR                MOD
18.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_AWR_VIEWER                MOD
18.0.0.0   RU              SYS                            TYPE BODY       PRVT_AWRV_METADATA             MOD
18.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_AWRV                 MOD
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           18.10RUR
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           18.10RUR
18.0.0.0   RU & 18.9RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           18.10RUR
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016008$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016012$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016023$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016024$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016207$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016378$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000016899$            NEW
19.0.0.0   19.7RUR         SYS                            TYPE            SYS_YOID0000017005$            NEW
19.0.0.0   RU              MDSYS                          PACKAGE BODY    PRVT_TIN                       NEW
19.0.0.0   RU              MDSYS                          PROCEDURE       CREATE_SDO_TTS_METADATA        NEW
19.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_IM_BASE_LEVEL     NEW
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              MDSYS                          FUNCTION        SDO_JOIN                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE         MDPRVT_IDX                     MOD
19.0.0.0   RU              MDSYS                          PACKAGE         PRVT_IDX                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_IDX                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_UTIL                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    MDPRVT_GMD                     MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    MDPRVT_IDX                     MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    PRVT_PC                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    PRVT_SAM                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDOTNPC                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_3GL                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_CS                         MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOM                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR_AGGR                  MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_IDX                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_META                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_MIGRATE                    MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_PC_PKG                     MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_RDF_INTERNAL               MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_SAM                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_TIN_PKG                    MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_TPIDX                      MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_TRKR                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_TUNE                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_UTIL                       MOD
19.0.0.0   RU              MDSYS                          TRIGGER         SDO_GEOM_TRIG_INS1             MOD
19.0.0.0   RU              MDSYS                          TRIGGER         SDO_GEOM_TRIG_UPD1             MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SAMCLUST_IMP_T                 MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SDO_INDEX_METHOD_10I           MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SPARQL_SERVICE_IMPL_T          MOD
19.0.0.0   RU              MDSYS                          VIEW            ALL_SDO_GEOM_METADATA          MOD
19.0.0.0   RU              MDSYS                          VIEW            ALL_SDO_INDEX_METADATA         MOD
19.0.0.0   RU              MDSYS                          VIEW            MY_SDO_INDEX_METADATA          MOD
19.0.0.0   RU              MDSYS                          VIEW            USER_SDO_INDEX_METADATA        MOD
19.0.0.0   RU              SYS                            FUNCTION        DG$GETFLATDG                   MOD
19.0.0.0   RU              SYS                            FUNCTION        DG$HASDGINDEX                  MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_ASH                       MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_HADOOP_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SQLTUNE_UTIL2             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         PRVT_DBMS_INMEMORY_ADMIN       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_DBFS_CONTENT              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_ISCHED                    MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_ISYNCREF                  MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_LDAP                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PERF                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE_UTIL2             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVTEMX_PERF                   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                            PROCEDURE       DBMS_FEATURE_IMC               MOD
19.0.0.0   RU              SYS                            TYPE BODY       PRVT_AWRV_METADATA             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_PERF                 MOD
19.0.0.0   RU              SYS                            TYPE BODY       WRI$_REPT_SESSION              MOD
19.0.0.0   RU              SYS                            VIEW            DBA_WORKLOAD_CAPTURES          MOD
19.0.0.0   RU              SYS                            VIEW            INT$DBA_JSON_DATAGUIDES        MOD
19.0.0.0   RU              SYS                            VIEW            INT$DBA_JSON_DG_COLS           MOD
19.0.0.0   RU & 19.7RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           19.6RUR
19.0.0.0   RU & 19.7RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           19.6RUR
19.0.0.0   RU & 19.7RUR &  SYS                            PACKAGE BODY    DBMS_AUTO_INDEX                MOD
           19.6RUR
19.0.0.0   RU & 19.7RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           19.6RUR

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.