{"id":4100,"date":"2019-05-24T11:31:35","date_gmt":"2019-05-24T14:31:35","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=4100"},"modified":"2019-05-24T11:37:44","modified_gmt":"2019-05-24T14:37:44","slug":"dissecting-190416-bp-psu-ru-and-rur","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/","title":{"rendered":"Dissecting 190416 BP, PSU, RU and RUR"},"content":{"rendered":"<p>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.<\/p>\n<p>To check previous changes, follow the links below:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2019\/02\/dissecting-190115-bp-psu-ru-and-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 190115 BP, PSU, RU and RUR<\/a><\/li>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2018\/11\/dissecting-181016-bp-psu-ru-and-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 181016 BP, PSU, RU and RUR<\/a><\/li>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2018\/08\/dissecting-180717-bp-psu-ru-and-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 180717 BP, PSU, RU and RUR<\/a><\/li>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2018\/05\/dissecting-180417-bp-psu-ru-and-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 180417 BP, PSU, RU and RUR<\/a><\/li>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2018\/01\/dissecting-180116-bp-psu-ru-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 180116 BP, PSU, RU and RUR<\/a><\/li>\n<li><a href=\"https:\/\/www.dbarj.com.br\/en\/2017\/10\/dissecting-171017-bp-psu-ru-rur-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 171017 BP, PSU, RU and RUR<\/a><\/li>\n<\/ul>\n<p>So what oracle internal objects were changed in <strong>April 2019 &#8211; <\/strong><span style=\"text-decoration: underline;\"><strong>190416<\/strong><\/span>?<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">VERSION    PATCH      OWNER                          TYPE                 TOTAL\r\n---------- ---------- ------------------------------ --------------- ----------\r\n11.2.0.4   BP         SYS                            PACKAGE BODY             1\r\n11.2.0.4   PSU        SYS                            PACKAGE BODY             1\r\n12.1.0.2   BP         SYS                            PACKAGE                  1\r\n12.1.0.2   BP         SYS                            PACKAGE BODY             3\r\n12.2.0.1   JAN2019RUR SYS                            PACKAGE                  2\r\n12.2.0.1   JAN2019RUR SYS                            PACKAGE BODY             3\r\n12.2.0.1   OCT2018RUR SYS                            PACKAGE                  2\r\n12.2.0.1   OCT2018RUR SYS                            PACKAGE BODY             3\r\n12.2.0.1   RU         SYS                            PACKAGE                  5\r\n12.2.0.1   RU         SYS                            PACKAGE BODY            12\r\n18.0.0.0   18.4RUR    SYS                            PACKAGE                  3\r\n18.0.0.0   18.4RUR    SYS                            PACKAGE BODY             3\r\n18.0.0.0   18.5RUR    SYS                            PACKAGE                  3\r\n18.0.0.0   18.5RUR    SYS                            PACKAGE BODY             3\r\n18.0.0.0   RU         CTXSYS                         PACKAGE                  1\r\n18.0.0.0   RU         CTXSYS                         PACKAGE BODY             2\r\n18.0.0.0   RU         SYS                            PACKAGE                  4\r\n18.0.0.0   RU         SYS                            PACKAGE BODY             6\r\n18.0.0.0   RU         SYS                            PROCEDURE                2\r\n18.0.0.0   RU         SYS                            VIEW                    24<\/pre>\n<p>And created?<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">VERSION    PATCH      OWNER                          TYPE                 TOTAL\r\n---------- ---------- ------------------------------ --------------- ----------\r\n12.2.0.1   JAN2019RUR SYS                            FUNCTION                 1\r\n12.2.0.1   OCT2018RUR SYS                            FUNCTION                 1\r\n12.2.0.1   RU         SYS                            FUNCTION                 1\r\n12.2.0.1   RU         SYS                            VIEW                     2\r\n18.0.0.0   RU         SYS                            VIEW                     2<\/pre>\n<p><span style=\"font-size: 12pt; color: #800000;\"><strong>P.S: Nothing was added for 11.2 \/ 12.1 in Oracle objects.<\/strong><\/span><\/p>\n<p>So which are exactly the objects modified by 190416?<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION\r\n---------- --------------- ------------------------------ --------------- ------------------------------ ------\r\n11.2.0.4   PSU &amp; BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.1.0.2   BP              SYS                            PACKAGE         DBMS_RCVMAN                    MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_STATS                     MOD\r\n12.2.0.1   RU              SYS                            VIEW            CDB_REGISTRY_BACKPORTS         NEW\r\n12.2.0.1   RU              SYS                            VIEW            DBA_REGISTRY_BACKPORTS         NEW\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            FUNCTION        DBMS_PDB_IS_VALID_PATH         NEW\r\n            &amp; JAN2019RUR\r\n12.2.0.1   RU              SYS                            PACKAGE         DBMS_RCVMAN                    MOD\r\n12.2.0.1   RU              SYS                            PACKAGE         DBMS_XSTREAM_ADM_INTERNAL      MOD\r\n12.2.0.1   RU              SYS                            PACKAGE         UTL_RECOMP                     MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    CDBVIEW_INTERNAL               MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_AQ                        MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_PARALLEL_EXECUTE_INTERNAL MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_XSTREAM_ADM_INTERNAL      MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_XSTREAM_AUTH_IVK          MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    UTL_RECOMP                     MOD\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            PACKAGE         DBMS_DBFS_SFS_ADMIN            MOD\r\n            &amp; JAN2019RUR\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            PACKAGE         DBMS_PDB                       MOD\r\n            &amp; JAN2019RUR\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            PACKAGE BODY    DBMS_DBFS_SFS                  MOD\r\n            &amp; JAN2019RUR\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            PACKAGE BODY    DBMS_DBFS_SFS_ADMIN            MOD\r\n            &amp; JAN2019RUR\r\n12.2.0.1   RU &amp; OCT2018RUR SYS                            PACKAGE BODY    DBMS_PDB                       MOD\r\n            &amp; JAN2019RUR\r\n18.0.0.0   RU              SYS                            VIEW            CDB_REGISTRY_BACKPORTS         NEW\r\n18.0.0.0   RU              SYS                            VIEW            DBA_REGISTRY_BACKPORTS         NEW\r\n18.0.0.0   RU              CTXSYS                         PACKAGE         DRIXMD                         MOD\r\n18.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRIXMD                         MOD\r\n18.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRVDDL                         MOD\r\n18.0.0.0   RU              SYS                            PACKAGE         UTL_RECOMP                     MOD\r\n18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AQ                        MOD\r\n18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PARALLEL_EXECUTE_INTERNAL MOD\r\n18.0.0.0   RU              SYS                            PACKAGE BODY    UTL_RECOMP                     MOD\r\n18.0.0.0   RU              SYS                            PROCEDURE       APS_VALIDATE                   MOD\r\n18.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_REGISTER_ALLFEAT  MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_RU_UNSUPPORT_TAB_12_1 MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_RU_UNSUPPORT_TAB_12_2 MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_RU_UN_TAB_12_2_0_2    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_10_1      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_10_2      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_11_1      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_11_2      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_11_2B     MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_12_1      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_12_2      MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_SUPPORT_TAB_12_2_0_2  MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_10_1    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_10_2    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_11_1    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_11_2    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_11_2B   MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_12_1    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPPORT_TAB_12_2    MOD\r\n18.0.0.0   RU              SYS                            VIEW            LOGSTDBY_UNSUPP_TAB_12_2_0_2   MOD\r\n18.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_11_2           MOD\r\n18.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_11_2B          MOD\r\n18.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_12_1           MOD\r\n18.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_12_2           MOD\r\n18.0.0.0   RU              SYS                            VIEW            OGG_SUPPORT_TAB_12_2_0_2       MOD\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD\r\n           18.4RUR\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE         DBMS_DBFS_SFS_ADMIN            MOD\r\n           18.4RUR\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE         DBMS_REGISTRY                  MOD\r\n           18.4RUR\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE BODY    DBMS_DBFS_SFS                  MOD\r\n           18.4RUR\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE BODY    DBMS_DBFS_SFS_ADMIN            MOD\r\n           18.4RUR\r\n18.0.0.0   RU &amp; 18.5RUR &amp;  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n           18.4RUR<\/pre>\n<h2><strong>What changed for each? (click to see the changes)<\/strong><\/h2>\n<ul>\n<li>11.2.0.4\n<ul>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.11.2.0.4_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 11g (PSU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.11.2.0.4_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 11g (BP)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>12.1.0.2\n<ul>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE.12.1.0.2_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_SQLPATCH.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_SQLPATCH &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_STATS.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_STATS &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>12.2.0.1\n<ul>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE 12cR2 (OCT2018RUR &amp; JAN2019RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_PDB.PACKAGE.12.2.0.1_JAN2019RUR\">SYS.DBMS_PDB &#8211; PACKAGE 12cR2 (RU &amp; OCT2018RUR &amp; JAN2019RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE.12.2.0.1_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_XSTREAM_ADM_INTERNAL.PACKAGE.12.2.0.1_RU\">SYS.DBMS_XSTREAM_ADM_INTERNAL &#8211; PACKAGE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.UTL_RECOMP.PACKAGE.12.2.0.1_RU\">SYS.UTL_RECOMP &#8211; PACKAGE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.CDBVIEW_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.CDBVIEW_INTERNAL &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_AQ.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_AQ &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 12cR2 (JAN2019RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_OCT2018RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 12cR2 (OCT2018RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY 12cR2 (OCT2018RUR &amp; JAN2019RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_PARALLEL_EXECUTE_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_PARALLEL_EXECUTE_INTERNAL &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_PDB.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_PDB &#8211; PACKAGE BODY 12cR2 (RU &amp; OCT2018RUR &amp; JAN2019RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_SQLPATCH.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_SQLPATCH &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_STATS.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_STATS &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_XSTREAM_ADM_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_XSTREAM_ADM_INTERNAL &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_XSTREAM_AUTH_IVK.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_XSTREAM_AUTH_IVK &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.UTL_RECOMP.PACKAGE BODY.12.2.0.1_RU\">SYS.UTL_RECOMP &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>18.0.0.0\n<ul>\n<li><a href=\"#CTXSYS.DRIXMD.PACKAGE.18.0.0.0_RU\">CTXSYS.DRIXMD &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#CTXSYS.DRIXMD.PACKAGE BODY.18.0.0.0_RU\">CTXSYS.DRIXMD &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#CTXSYS.DRVDDL.PACKAGE BODY.18.0.0.0_RU\">CTXSYS.DRVDDL &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.5RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 18c (18.5RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 18c (18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE 18c (18.5RUR &amp; 18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_RU\">SYS.DBMS_REGISTRY &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE 18c (18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_18.5RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE 18c (18.5RUR)<\/a><\/li>\n<li><a href=\"#SYS.UTL_RECOMP.PACKAGE.18.0.0.0_RU\">SYS.UTL_RECOMP &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_AQ.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_AQ &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_18.5RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 18c (18.5RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 18c (18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY 18c (18.5RUR &amp; 18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_PARALLEL_EXECUTE_INTERNAL.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_PARALLEL_EXECUTE_INTERNAL &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_18.5RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 18c (18.5RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 18c (18.4RUR)<\/a><\/li>\n<li><a href=\"#SYS.UTL_RECOMP.PACKAGE BODY.18.0.0.0_RU\">SYS.UTL_RECOMP &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.APS_VALIDATE.PROCEDURE.18.0.0.0_RU\">SYS.APS_VALIDATE &#8211; PROCEDURE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_FEATURE_REGISTER_ALLFEAT.PROCEDURE.18.0.0.0_RU\">SYS.DBMS_FEATURE_REGISTER_ALLFEAT &#8211; PROCEDURE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_RU_UN_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UN_TAB_12_2_0_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_10_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_10_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_10_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_10_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_11_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_2B &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_SUPPORT_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_2_0_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_10_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_10_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_10_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_10_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_11_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_2B &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_12_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_12_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.LOGSTDBY_UNSUPP_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPP_TAB_12_2_0_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.OGG_SUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_11_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.OGG_SUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_11_2B &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.OGG_SUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_1 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.OGG_SUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.OGG_SUPPORT_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_2_0_2 &#8211; VIEW 18c (RU)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Changed Objects<\/h2>\n<p><span style=\"font-size: 12pt;\"><strong>P.S:<br \/>\n<\/strong><\/span><span style=\"font-size: 12pt;\"><strong>&gt; = Added Lines<br \/>\n&lt; = Removed Lines<\/strong><\/span><\/p>\n<h3><strong>11.2.0.4<\/strong><\/h3>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.11.2.0.4_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">21896a21897\r\n&gt;       END IF;\r\n21898,21921c21899,21919\r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n&lt;              (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n&lt;               USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n&lt;               LOCAL.TOSCN_ACT &lt; AVAILABLE_FROMSCN_ACT)) THEN\r\n&lt;             IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n&lt;                DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n&lt;                               AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n&lt;                               LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&lt;                               LOCAL.DFCREATIONSCN_OBJ);\r\n&lt;             ELSE\r\n&lt;                DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n&lt;                               AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n&lt;                               LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&lt;                               LOCAL.DFCREATIONSCN_OBJ);\r\n&lt;             END IF;\r\n&lt;             USABLE_INCR := LOCAL;\r\n&lt;             AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n&gt;           (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n&gt;            USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n&gt;            LOCAL.TOSCN_ACT &lt; AVAILABLE_FROMSCN_ACT)) THEN\r\n&gt;          IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n&gt;             DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n&gt;                            AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n&gt;                            LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&gt;                            LOCAL.DFCREATIONSCN_OBJ);\r\n&gt;          ELSE\r\n&gt;             DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n&gt;                            AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n&gt;                            LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&gt;                            LOCAL.DFCREATIONSCN_OBJ);\r\n21922a21921,21922\r\n&gt;          USABLE_INCR := LOCAL;\r\n&gt;          AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.11.2.0.4_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">21898a21899\r\n&gt;       END IF;\r\n21900,21923c21901,21921\r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          \r\n&lt;          IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n&lt;              (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n&lt;               USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n&lt;               LOCAL.TOSCN_ACT &lt; AVAILABLE_FROMSCN_ACT)) THEN\r\n&lt;             IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n&lt;                DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n&lt;                               AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n&lt;                               LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&lt;                               LOCAL.DFCREATIONSCN_OBJ);\r\n&lt;             ELSE\r\n&lt;                DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n&lt;                               AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n&lt;                               LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&lt;                               LOCAL.DFCREATIONSCN_OBJ);\r\n&lt;             END IF;\r\n&lt;             USABLE_INCR := LOCAL;\r\n&lt;             AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n---\r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       \r\n&gt;       IF (AVAILABLE_FROMSCN_ACT IS NULL OR\r\n&gt;           (USABLE_INCR.DFNUMBER_OBJ = LOCAL.DFNUMBER_OBJ AND\r\n&gt;            USABLE_INCR.DFCREATIONSCN_OBJ = LOCAL.DFCREATIONSCN_OBJ AND\r\n&gt;            LOCAL.TOSCN_ACT &lt; AVAILABLE_FROMSCN_ACT)) THEN\r\n&gt;          IF (AVAILABLE_FROMSCN_ACT IS NULL) THEN\r\n&gt;             DEB(DEB_PRINT, 'available_fromSCN_act set to ' ||\r\n&gt;                            AVAILABLE_FROMSCN_ACT || ' for file# ' ||\r\n&gt;                            LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&gt;                            LOCAL.DFCREATIONSCN_OBJ);\r\n&gt;          ELSE\r\n&gt;             DEB(DEB_PRINT, 'broken chain, available_fromSCN_act set to ' ||\r\n&gt;                            AVAILABLE_FROMSCN_ACT || ' for file ' ||\r\n&gt;                            LOCAL.DFNUMBER_OBJ || ', creation_scn '||\r\n&gt;                            LOCAL.DFCREATIONSCN_OBJ);\r\n21924a21923,21924\r\n&gt;          USABLE_INCR := LOCAL;\r\n&gt;          AVAILABLE_FROMSCN_ACT := LOCAL.FROMSCN_ACT;\r\n<\/pre>\n<h3><strong>12.1.0.2<\/strong><\/h3>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE.12.1.0.2_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3109c3109,3110\r\n&lt;   ,toDest4         IN   varchar2 DEFAULT NULL);\r\n---\r\n&gt;   ,toDest4         IN   varchar2 DEFAULT NULL\r\n&gt;   ,atAnyScn        IN   boolean  DEFAULT FALSE);\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">7281,7287c7281,7288\r\n&lt;    DEVICE_TYPE  IN VARCHAR2\r\n&lt;   ,CMD          IN VARCHAR2\r\n&lt;   ,KTAG         IN VARCHAR2\r\n&lt;   ,PATTERN1     IN VARCHAR2\r\n&lt;   ,PATTERN2     IN VARCHAR2\r\n&lt;   ,PATTERN3     IN VARCHAR2\r\n&lt;   ,PATTERN4     IN VARCHAR2)\r\n---\r\n&gt;    DEVICE_TYPE    IN VARCHAR2\r\n&gt;   ,CMD            IN VARCHAR2\r\n&gt;   ,KTAG           IN VARCHAR2\r\n&gt;   ,PATTERN1       IN VARCHAR2\r\n&gt;   ,PATTERN2       IN VARCHAR2\r\n&gt;   ,PATTERN3       IN VARCHAR2\r\n&gt;   ,PATTERN4       IN VARCHAR2\r\n&gt;   ,BACKEDUPANYSCN IN NUMBER)\r\n7288a7290,7303\r\n&gt; WITH\r\n&gt; MY_DBINC AS\r\n&gt;    (SELECT RESETLOGS_TIME, \r\n&gt;            RESETLOGS_CHANGE#,\r\n&gt;            PRIOR RESETLOGS_CHANGE# NEXT_RESETLOGS_CHANGE#\r\n&gt;     FROM V$DATABASE_INCARNATION             \r\n&gt;     START WITH RESETLOGS_CHANGE# = THIS_RESET_SCN\r\n&gt;           AND  RESETLOGS_TIME    = THIS_RESET_TIME  \r\n&gt;     CONNECT BY PRIOR PRIOR_INCARNATION# = INCARNATION#\r\n&gt;     UNION ALL\r\n&gt;     SELECT THIS_RESET_TIME  RESETLOGS_TIME,\r\n&gt;            THIS_RESET_SCN   RESETLOGS_CHANGE#,\r\n&gt;            NULL             NEXT_RESETLOGS_CHANGE#\r\n&gt;     FROM DUAL)\r\n7324,7328c7339,7350\r\n&lt;                 FILE#, CREATION_CHANGE#, PLUGIN_CHANGE#,\r\n&lt;                 PLUGGED_READONLY, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,\r\n&lt;                 RESETLOGS_CHANGE#, RESETLOGS_TIME\r\n&lt;            FROM V$DATAFILE_COPY\r\n&lt;           WHERE STATUS = 'A') CDF,\r\n---\r\n&gt;                 CDF.FILE#, CDF.CREATION_CHANGE#, CDF.PLUGIN_CHANGE#,\r\n&gt;                 CDF.PLUGGED_READONLY, CDF.CHECKPOINT_CHANGE#, \r\n&gt;                 CDF.CHECKPOINT_TIME, CDF.RESETLOGS_CHANGE#, \r\n&gt;                 CDF.RESETLOGS_TIME, CDF.ABSOLUTE_FUZZY_CHANGE#\r\n&gt;            FROM V$DATAFILE_COPY CDF, MY_DBINC\r\n&gt;           WHERE CDF.STATUS = 'A'\r\n&gt;             AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = FALSE# OR\r\n&gt;                  (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# AND\r\n&gt;                   CDF.FILE# &gt; 0 AND\r\n&gt;                   (MY_DBINC.NEXT_RESETLOGS_CHANGE# IS NULL OR\r\n&gt;                    CDF.ABSOLUTE_FUZZY_CHANGE# &lt;= \r\n&gt;                    MY_DBINC.NEXT_RESETLOGS_CHANGE#)))) CDF,\r\n7361,7362c7383,7385\r\n&lt;      AND BDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE#\r\n&lt;      AND BDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME\r\n---\r\n&gt;      AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# OR\r\n&gt;           (BDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE# AND\r\n&gt;            BDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME))\r\n7462,7466c7485,7496\r\n&lt;                 FILE#, CREATION_CHANGE#, PLUGIN_CHANGE#,\r\n&lt;                 PLUGGED_READONLY, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,\r\n&lt;                 RESETLOGS_CHANGE#, RESETLOGS_TIME\r\n&lt;            FROM V$DATAFILE_COPY\r\n&lt;           WHERE STATUS = 'A') CDF\r\n---\r\n&gt;                 CDF.FILE#, CDF.CREATION_CHANGE#, CDF.PLUGIN_CHANGE#,\r\n&gt;                 CDF.PLUGGED_READONLY, CDF.CHECKPOINT_CHANGE#, \r\n&gt;                 CDF.CHECKPOINT_TIME, CDF.RESETLOGS_CHANGE#, CDF.RESETLOGS_TIME,\r\n&gt;                 CDF.ABSOLUTE_FUZZY_CHANGE#\r\n&gt;             FROM V$DATAFILE_COPY CDF, MY_DBINC\r\n&gt;           WHERE CDF.STATUS = 'A'\r\n&gt;             AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = FALSE# OR\r\n&gt;                  (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# AND\r\n&gt;                   CDF.FILE# &gt; 0 AND\r\n&gt;                   (MY_DBINC.NEXT_RESETLOGS_CHANGE# IS NULL OR\r\n&gt;                    CDF.ABSOLUTE_FUZZY_CHANGE# &lt;= \r\n&gt;                    MY_DBINC.NEXT_RESETLOGS_CHANGE#)))) CDF\r\n7471,7473c7501,7504\r\n&lt;      AND XDF.CREATION_CHANGE#  = CDF.CREATION_CHANGE#\r\n&lt;      AND XDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE#\r\n&lt;      AND XDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME\r\n---\r\n&gt;      AND XDF.CREATION_CHANGE#   = CDF.CREATION_CHANGE#\r\n&gt;      AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# OR\r\n&gt;           (XDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE# AND\r\n&gt;            XDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME))\r\n26998c27029,27030\r\n&lt;   ,TODEST4         IN   VARCHAR2 DEFAULT NULL)\r\n---\r\n&gt;   ,TODEST4         IN   VARCHAR2 DEFAULT NULL\r\n&gt;   ,ATANYSCN        IN   BOOLEAN  DEFAULT FALSE) \r\n27000,27010c27032,27043\r\n&lt;    EOF         BOOLEAN := FALSE;\r\n&lt;    LOCAL       BHISTORYREC_T;\r\n&lt;    ICOUNT      NUMBER  := 0;\r\n&lt;    LOCCRESCN   NUMBER;\r\n&lt;    LASTCRESCN  NUMBER;\r\n&lt;    LOCRLGSCN   NUMBER;\r\n&lt;    LASTRLGSCN  NUMBER;\r\n&lt;    LOCRLGTIME  DATE;\r\n&lt;    LASTRLGTIME DATE;\r\n&lt;    LOCCKPSCN   NUMBER;\r\n&lt;    LASTCKPSCN  NUMBER;\r\n---\r\n&gt;    EOF                BOOLEAN := FALSE;\r\n&gt;    LOCAL              BHISTORYREC_T;\r\n&gt;    ICOUNT             NUMBER  := 0;\r\n&gt;    LOCCRESCN          NUMBER;\r\n&gt;    LASTCRESCN         NUMBER;\r\n&gt;    LOCRLGSCN          NUMBER;\r\n&gt;    LASTRLGSCN         NUMBER;\r\n&gt;    LOCRLGTIME         DATE;\r\n&gt;    LASTRLGTIME        DATE;\r\n&gt;    LOCCKPSCN          NUMBER;\r\n&gt;    LASTCKPSCN         NUMBER;\r\n&gt;    BACKEDUPANYSCN     NUMBER;\r\n27013a27047,27056\r\n&gt; \r\n&gt; \r\n&gt; \r\n&gt; \r\n&gt;    IF (ATANYSCN) THEN\r\n&gt;       BACKEDUPANYSCN := TRUE#;\r\n&gt;    ELSE\r\n&gt;       BACKEDUPANYSCN := FALSE#;\r\n&gt;    END IF;\r\n&gt; \r\n27018a27062\r\n&gt;    \r\n27020,27026c27064,27071\r\n&lt;       OPEN DCBACKUPHISTORY_C(DEVICE_TYPE =&gt; BACKEDUPDEV,\r\n&lt;                              CMD         =&gt; DOINGCMD,\r\n&lt;                              KTAG        =&gt; KEEPTAG,\r\n&lt;                              PATTERN1    =&gt; STARTWITHPATTERN(TODEST1),\r\n&lt;                              PATTERN2    =&gt; STARTWITHPATTERN(TODEST2),\r\n&lt;                              PATTERN3    =&gt; STARTWITHPATTERN(TODEST3),\r\n&lt;                              PATTERN4    =&gt; STARTWITHPATTERN(TODEST4));\r\n---\r\n&gt;       OPEN DCBACKUPHISTORY_C(DEVICE_TYPE    =&gt; BACKEDUPDEV,\r\n&gt;                              CMD            =&gt; DOINGCMD,\r\n&gt;                              KTAG           =&gt; KEEPTAG,\r\n&gt;                              PATTERN1       =&gt; STARTWITHPATTERN(TODEST1),\r\n&gt;                              PATTERN2       =&gt; STARTWITHPATTERN(TODEST2),\r\n&gt;                              PATTERN3       =&gt; STARTWITHPATTERN(TODEST3),\r\n&gt;                              PATTERN4       =&gt; STARTWITHPATTERN(TODEST4),\r\n&gt;                              BACKEDUPANYSCN =&gt; BACKEDUPANYSCN);\r\n<\/pre>\n<h3><strong>12.2.0.1<\/strong><\/h3>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE (JAN2019RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">454a455,459\r\n&gt;     function    get_param(\r\n&gt;         name                in         varchar2)\r\n&gt;             return boolean;\r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">454a455,457\r\n&gt;     function get_param(\r\n&gt;         name                in          varchar2)\r\n&gt;              return boolean;\r\n<\/pre>\n<div id=\"SYS.DBMS_PDB.PACKAGE.12.2.0.1_JAN2019RUR\">SYS.DBMS_PDB &#8211; PACKAGE (JAN2019RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">410a411,420\r\n&gt; \r\n&gt;   function is_valid_path(path_name IN varchar2)\r\n&gt;            return boolean;\r\n&gt;   -- NAME:\r\n&gt;   -- is_valid_path\r\n&gt;   --\r\n&gt;   -- DESCRIPTION:\r\n&gt;   --   check whether given path_name is corresponding to the path_prefix\r\n&gt;   --   property\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE.12.2.0.1_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3154c3154,3155\r\n&lt;   ,toDest4         IN   varchar2 DEFAULT NULL);\r\n---\r\n&gt;   ,toDest4         IN   varchar2 DEFAULT NULL\r\n&gt;   ,atAnyScn        IN   boolean  DEFAULT FALSE);\r\n<\/pre>\n<div id=\"SYS.DBMS_XSTREAM_ADM_INTERNAL.PACKAGE.12.2.0.1_RU\">SYS.DBMS_XSTREAM_ADM_INTERNAL &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">27a28\r\n&gt;              PROCREP                   OUT BOOLEAN, \r\n<\/pre>\n<div id=\"SYS.UTL_RECOMP.PACKAGE.12.2.0.1_RU\">SYS.UTL_RECOMP &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">28a29,32\r\n&gt;     *   ORACLE_MAINTAINED -  Only recompile PUBLIC synonyms and objects\r\n&gt;     *                   belonging to Oracle_maintained schemas.  This mode is\r\n&gt;     *                   used by datapatch to automatically revalidate any OM\r\n&gt;     *                   objects invalidated by patch apply\/rollback processing.\r\n36a41\r\n&gt;    ORACLE_MAINTAINED CONSTANT PLS_INTEGER := 256;\r\n<\/pre>\n<div id=\"SYS.CDBVIEW_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.CDBVIEW_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">184c184\r\n&lt;       when no_data_found then return FALSE;\r\n---\r\n&gt;       when no_data_found then return false;\r\n195c195\r\n&lt;       when no_data_found then return FALSE;\r\n---\r\n&gt;       when no_data_found then return false;\r\n<\/pre>\n<div id=\"SYS.DBMS_AQ.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_AQ &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1378,1380c1378,1380\r\n&lt;       AND Q.NAME = QUEUE_NAME\r\n&lt;       AND T.NAME = TABLE_NAME\r\n&lt;       AND T.SCHEMA = SCHEMA;\r\n---\r\n&gt;       AND Q.NAME = AQ$_BACKGROUND_OPER.QUEUE_NAME\r\n&gt;       AND T.NAME = AQ$_BACKGROUND_OPER.TABLE_NAME\r\n&gt;       AND T.SCHEMA = AQ$_BACKGROUND_OPER.SCHEMA;\r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (JAN2019RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11483\r\n&gt;         \r\n&gt;         \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt; \r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_OCT2018RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (OCT2018RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                   '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                    '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11483\r\n&gt;         \r\n&gt;         \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt; \r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM\r\n&gt;                                  ('_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;   \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                  '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;            GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;            IF NOT GOODLINK THEN \r\n&gt;               RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;            END IF;\r\n&gt;         END IF;\r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11479\r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                  '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;            GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;            IF NOT GOODLINK THEN \r\n&gt;               RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;            END IF;\r\n&gt;         END IF;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY (JAN2019RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">645a646,675\r\n&gt;     FUNCTION    GET_PARAM(NAME IN VARCHAR2)\r\n&gt;         RETURN  BOOLEAN\r\n&gt;     IS\r\n&gt;         VAL     VARCHAR2(4000)  := NULL;\r\n&gt;     BEGIN\r\n&gt;         BEGIN\r\n&gt;             VAL := NULL;\r\n&gt;             SELECT  Y.KSPPSTVL\r\n&gt;             INTO    VAL\r\n&gt;             FROM    SYS.X$KSPPI     X\r\n&gt;                 ,   SYS.X$KSPPCV    Y\r\n&gt;             WHERE   X.INDX          = Y.INDX\r\n&gt;                 AND X.KSPPINM       = NAME\r\n&gt;             ;\r\n&gt;         EXCEPTION\r\n&gt;             WHEN OTHERS THEN\r\n&gt;             BEGIN\r\n&gt;                 TRACE(1, 'parameter=' || NAME ||\r\n&gt;                     ' err:' || SQLERRM);\r\n&gt;                 VAL := NULL;\r\n&gt;             END;\r\n&gt;         END;\r\n&gt;    \r\n&gt; \r\n&gt;         IF LOWER(VAL) = 'true' THEN\r\n&gt;             RETURN TRUE;\r\n&gt;         END IF;\r\n&gt; \r\n&gt;         RETURN FALSE;\r\n&gt;     END;\r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">645a646,677\r\n&gt;     FUNCTION    GET_PARAM(NAME IN VARCHAR2)\r\n&gt;         RETURN  BOOLEAN\r\n&gt;     IS\r\n&gt;         VAL     VARCHAR2(4000)  := NULL;\r\n&gt;     BEGIN\r\n&gt;         BEGIN\r\n&gt;             VAL := NULL;\r\n&gt;             SELECT  Y.KSPPSTVL\r\n&gt;             INTO    VAL\r\n&gt;             FROM    SYS.X$KSPPI     X\r\n&gt;                 ,   SYS.X$KSPPCV    Y\r\n&gt;             WHERE   X.INDX          = Y.INDX\r\n&gt;                 AND X.KSPPINM       = NAME\r\n&gt;             ;\r\n&gt;         EXCEPTION\r\n&gt;             WHEN OTHERS THEN\r\n&gt;             BEGIN\r\n&gt;                 TRACE(1, 'parameter=' || NAME ||\r\n&gt;                     ' err:' || SQLERRM);\r\n&gt;                 VAL := NULL;\r\n&gt;             END;\r\n&gt;         END;\r\n&gt;    \r\n&gt; \r\n&gt;         IF LOWER(VAL) = 'true' THEN\r\n&gt;             RETURN TRUE;\r\n&gt;         END IF;\r\n&gt; \r\n&gt;         RETURN FALSE;\r\n&gt;     END;\r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_PARALLEL_EXECUTE_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_PARALLEL_EXECUTE_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">701a702,706\r\n&gt;       \r\n&gt;       IF C.CUR_SIZE = 0 THEN\r\n&gt;         GOTO DONE;\r\n&gt;       END IF;\r\n&gt; \r\n705a711,713\r\n&gt; &lt;&lt;DONE&gt;&gt;\r\n&gt;       \r\n&gt;       \r\n707c715\r\n&lt;       IF (BUFFERED_CHUNK# = 0) THEN\r\n---\r\n&gt;       IF (BUFFERED_CHUNKS.COUNT = 0) THEN\r\n<\/pre>\n<div id=\"SYS.DBMS_PDB.PACKAGE BODY.12.2.0.1_JAN2019RUR\">SYS.DBMS_PDB &#8211; PACKAGE BODY (JAN2019RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">471a472,494\r\n&gt; \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   FUNCTION KPDBISVALIDPATH(PATH_NAME VARCHAR2) RETURN BOOLEAN;\r\n&gt;   PRAGMA INTERFACE(C, KPDBISVALIDPATH);\r\n&gt; \r\n&gt;   FUNCTION IS_VALID_PATH (PATH_NAME VARCHAR2) RETURN BOOLEAN IS\r\n&gt;   BEGIN\r\n&gt;     RETURN KPDBISVALIDPATH(PATH_NAME);\r\n&gt;   END;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">7668c7668,7669\r\n&lt;   ,PATTERN4     IN VARCHAR2)\r\n---\r\n&gt;   ,PATTERN4       IN VARCHAR2\r\n&gt;   ,BACKEDUPANYSCN IN NUMBER)\r\n7669a7671,7684\r\n&gt; WITH\r\n&gt; MY_DBINC AS\r\n&gt;    (SELECT RESETLOGS_TIME, \r\n&gt;            RESETLOGS_CHANGE#,\r\n&gt;            PRIOR RESETLOGS_CHANGE# NEXT_RESETLOGS_CHANGE#\r\n&gt;     FROM V$DATABASE_INCARNATION             \r\n&gt;     START WITH RESETLOGS_CHANGE# = THIS_RESET_SCN\r\n&gt;           AND  RESETLOGS_TIME    = THIS_RESET_TIME  \r\n&gt;     CONNECT BY PRIOR PRIOR_INCARNATION# = INCARNATION#\r\n&gt;     UNION ALL\r\n&gt;     SELECT THIS_RESET_TIME  RESETLOGS_TIME,\r\n&gt;            THIS_RESET_SCN   RESETLOGS_CHANGE#,\r\n&gt;            NULL             NEXT_RESETLOGS_CHANGE#\r\n&gt;     FROM DUAL)\r\n7705,7709c7720,7731\r\n&lt;                 FILE#, CREATION_CHANGE#, PLUGIN_CHANGE#,\r\n&lt;                 PLUGGED_READONLY, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,\r\n&lt;                 RESETLOGS_CHANGE#, RESETLOGS_TIME\r\n&lt;            FROM V$DATAFILE_COPY\r\n&lt;           WHERE STATUS = 'A') CDF,\r\n---\r\n&gt;                 CDF.FILE#, CDF.CREATION_CHANGE#, CDF.PLUGIN_CHANGE#,\r\n&gt;                 CDF.PLUGGED_READONLY, CDF.CHECKPOINT_CHANGE#, \r\n&gt;                 CDF.CHECKPOINT_TIME, CDF.RESETLOGS_CHANGE#, \r\n&gt;                 CDF.RESETLOGS_TIME, CDF.ABSOLUTE_FUZZY_CHANGE#\r\n&gt;            FROM V$DATAFILE_COPY CDF, MY_DBINC\r\n&gt;           WHERE CDF.STATUS = 'A'\r\n&gt;             AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = FALSE# OR\r\n&gt;                  (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# AND\r\n&gt;                   CDF.FILE# &gt; 0 AND\r\n&gt;                   (MY_DBINC.NEXT_RESETLOGS_CHANGE# IS NULL OR\r\n&gt;                    CDF.ABSOLUTE_FUZZY_CHANGE# &lt;= \r\n&gt;                    MY_DBINC.NEXT_RESETLOGS_CHANGE#)))) CDF,\r\n7742,7743c7764,7766\r\n&lt;      AND BDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE#\r\n&lt;      AND BDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME\r\n---\r\n&gt;      AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# OR\r\n&gt;           (BDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE# AND\r\n&gt;            BDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME))\r\n7843,7847c7866,7877\r\n&lt;                 FILE#, CREATION_CHANGE#, PLUGIN_CHANGE#,\r\n&lt;                 PLUGGED_READONLY, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,\r\n&lt;                 RESETLOGS_CHANGE#, RESETLOGS_TIME\r\n&lt;            FROM V$DATAFILE_COPY\r\n&lt;           WHERE STATUS = 'A') CDF\r\n---\r\n&gt;                 CDF.FILE#, CDF.CREATION_CHANGE#, CDF.PLUGIN_CHANGE#,\r\n&gt;                 CDF.PLUGGED_READONLY, CDF.CHECKPOINT_CHANGE#, \r\n&gt;                 CDF.CHECKPOINT_TIME, CDF.RESETLOGS_CHANGE#, CDF.RESETLOGS_TIME,\r\n&gt;                 CDF.ABSOLUTE_FUZZY_CHANGE#\r\n&gt;             FROM V$DATAFILE_COPY CDF, MY_DBINC\r\n&gt;           WHERE CDF.STATUS = 'A'\r\n&gt;             AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = FALSE# OR\r\n&gt;                  (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# AND\r\n&gt;                   CDF.FILE# &gt; 0 AND\r\n&gt;                   (MY_DBINC.NEXT_RESETLOGS_CHANGE# IS NULL OR\r\n&gt;                    CDF.ABSOLUTE_FUZZY_CHANGE# &lt;= \r\n&gt;                    MY_DBINC.NEXT_RESETLOGS_CHANGE#)))) CDF\r\n7853,7854c7883,7885\r\n&lt;      AND XDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE#\r\n&lt;      AND XDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME\r\n---\r\n&gt;      AND (DCBACKUPHISTORY_C.BACKEDUPANYSCN = TRUE# OR\r\n&gt;           (XDF.CHECKPOINT_CHANGE# = CDF.CHECKPOINT_CHANGE# AND\r\n&gt;            XDF.CHECKPOINT_TIME    = CDF.CHECKPOINT_TIME))\r\n27694c27725,27726\r\n&lt;   ,TODEST4         IN   VARCHAR2 DEFAULT NULL)\r\n---\r\n&gt;   ,TODEST4         IN   VARCHAR2 DEFAULT NULL\r\n&gt;   ,ATANYSCN        IN   BOOLEAN  DEFAULT FALSE) \r\n27706a27739\r\n&gt;    BACKEDUPANYSCN     NUMBER;\r\n27709a27743,27752\r\n&gt; \r\n&gt; \r\n&gt; \r\n&gt; \r\n&gt;    IF (ATANYSCN) THEN\r\n&gt;       BACKEDUPANYSCN := TRUE#;\r\n&gt;    ELSE\r\n&gt;       BACKEDUPANYSCN := FALSE#;\r\n&gt;    END IF;\r\n&gt; \r\n27714a27758\r\n&gt;    \r\n27722c27766,27767\r\n&lt;                              PATTERN4    =&gt; STARTWITHPATTERN(TODEST4));\r\n---\r\n&gt;                              PATTERN4       =&gt; STARTWITHPATTERN(TODEST4),\r\n&gt;                              BACKEDUPANYSCN =&gt; BACKEDUPANYSCN);\r\n<\/pre>\n<div id=\"SYS.DBMS_SQLPATCH.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_SQLPATCH &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">322c322\r\n&lt;     RETURN '$Header: rdbms\/src\/server\/dict\/plsicds\/prvtsqlpatch.sql \/st_rdbms_12.2.0.1.0dbbp\/4 2018\/10\/09 03:33:10 sanagara Exp $';\r\n---\r\n&gt;     RETURN '$Header: rdbms\/src\/server\/dict\/plsicds\/prvtsqlpatch.sql \/st_rdbms_12.2.0.1.0dbbp\/5 2018\/12\/18 08:17:21 sanagara Exp $';\r\n430a431,434\r\n&gt; \r\n&gt;       \r\n&gt;       \r\n&gt;       EXECUTE IMMEDIATE 'ALTER SESSION SET \"_kolfuseslf\" = TRUE';\r\n<\/pre>\n<div id=\"SYS.DBMS_STATS.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_STATS &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">9804a9805,9809\r\n&gt; \r\n&gt;             \r\n&gt;             CSTATS(SAMECOLITR).RPCNT  := \r\n&gt;                        CSTATS(SAMECOLITR).RPCNT\/SCALING_FACTOR;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_XSTREAM_ADM_INTERNAL.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_XSTREAM_ADM_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">152c152,153\r\n&lt;     SELECT_PRIVILEGES   IN BOOLEAN) IS\r\n---\r\n&gt;     SELECT_PRIVILEGES   IN BOOLEAN,\r\n&gt;     PROCREP             IN BOOLEAN) IS\r\n2688a2690\r\n&gt;     PROCREP                   OUT BOOLEAN,\r\n2702a2705\r\n&gt;     PROCREP := FALSE;\r\n2726c2729\r\n&lt;                       PROCREP_PACKAGES, PROCREP_ALLOWED, TRUE);\r\n---\r\n&gt;                       PROCREP_PACKAGES, PROCREP, PROCREP_ALLOWED, TRUE);\r\n3092a3096,3097\r\n&gt;     PROCREP               BOOLEAN := FALSE;\r\n&gt; \r\n3099,3100d3103\r\n&lt;     POPULATE_QUEUE_SCRIPT(IS_GRANT, SCRIPT, CANON_GRANTEE, \r\n&lt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES);\r\n3104d3106\r\n&lt;     \r\n3111c3113,3116\r\n&lt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES, OPTIONAL_PRIVILEGES);\r\n---\r\n&gt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES, PROCREP, OPTIONAL_PRIVILEGES);\r\n&gt; \r\n&gt;     POPULATE_QUEUE_SCRIPT(IS_GRANT, SCRIPT, CANON_GRANTEE, \r\n&gt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES, PROCREP);\r\n3300a3306\r\n&gt;              PROCREP                   OUT BOOLEAN, \r\n3332a3339\r\n&gt;     PROCREP             := FALSE;\r\n3343a3351\r\n&gt;       PROCREP := INC_INTERNAL_PKGS;\r\n3375a3384\r\n&gt;           PROCREP := INC_INTERNAL_PKGS;\r\n3407a3417,3423\r\n&gt;       \r\n&gt;       \r\n&gt;       NUM_OPTIONAL := NUM_OPTIONAL + 1;\r\n&gt;       PRIVILEGE_TABLE(NUM_OPTIONAL) := 'ALL ON SYS.AQ$_EVENT_MESSAGE';\r\n&gt;       NUM_OPTIONAL := NUM_OPTIONAL + 1;\r\n&gt;       PRIVILEGE_TABLE(NUM_OPTIONAL) := 'ALL ON SYS.AQ$_SRVNTFN_MESSAGE';\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_XSTREAM_AUTH_IVK.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_XSTREAM_AUTH_IVK &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">353c353,354\r\n&lt;     SELECT_PRIVILEGES   IN BOOLEAN) IS\r\n---\r\n&gt;     SELECT_PRIVILEGES   IN BOOLEAN,\r\n&gt;     PROCREP             IN BOOLEAN) IS\r\n398c399\r\n&lt;     IF (SELECT_PRIVILEGES = TRUE) THEN\r\n---\r\n&gt;     IF ((SELECT_PRIVILEGES = TRUE) OR (PROCREP = TRUE)) THEN\r\n3044a3046\r\n&gt;     PROCREP             OUT BOOLEAN,\r\n3056a3059\r\n&gt;     PROCREP := FALSE;\r\n3074c3077,3078\r\n&lt;                       OPTIONAL_PRIVILEGES, PRIVILEGE_TABLE, UNUSED_TABLE);\r\n---\r\n&gt;                       OPTIONAL_PRIVILEGES, PRIVILEGE_TABLE, UNUSED_TABLE,\r\n&gt;                       PROCREP);\r\n3209a3214\r\n&gt; \r\n3222a3228\r\n&gt;     PROCREP               BOOLEAN := FALSE;\r\n3228,3229d3233\r\n&lt;     POPULATE_QUEUE_SCRIPT(IS_GRANT, SCRIPT, CANON_GRANTEE,\r\n&lt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES);\r\n3238c3242\r\n&lt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES,\r\n---\r\n&gt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES, PROCREP,\r\n3240a3245,3247\r\n&gt;     POPULATE_QUEUE_SCRIPT(IS_GRANT, SCRIPT, CANON_GRANTEE,\r\n&gt;       CANON_PRIVILEGE_TYPE, SELECT_PRIVILEGES, PROCREP);\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.UTL_RECOMP.PACKAGE BODY.12.2.0.1_RU\">SYS.UTL_RECOMP &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">323a324,335\r\n&gt;       \r\n&gt;       \r\n&gt;       IF (BITAND(FLAGS, ORACLE_MAINTAINED) != 0) THEN\r\n&gt;          WHERE_CLAUSE := WHERE_CLAUSE || 'AND ' ||\r\n&gt;              '(owner in (select name \r\n&gt;                    from user$ where type# = 1 and bitand(spare1,256)=256)\r\n&gt;                OR (owner = ''PUBLIC'' and obj# IN \r\n&gt;                   (select obj# from obj$ where name=objname\r\n&gt;                           and type#=5 \r\n&gt;                           and bitand(flags, 4194304)=4194304)))';\r\n&gt;       END IF;\r\n&gt; \r\n511a524,535\r\n&gt;       \r\n&gt;       \r\n&gt;       IF (BITAND(FLAGS, ORACLE_MAINTAINED) != 0) THEN\r\n&gt;          WHERE_CLAUSE := WHERE_CLAUSE || 'AND ' ||\r\n&gt;              '(owner in (select name \r\n&gt;                    from user$ where type# = 1 and bitand(spare1,256)=256)\r\n&gt;                OR (owner = ''PUBLIC'' and obj# IN \r\n&gt;                   (select obj# from obj$ where name=objname\r\n&gt;                           and type#=5 \r\n&gt;                           and bitand(flags, 4194304)=4194304)))';\r\n&gt;       END IF;\r\n&gt; \r\n<\/pre>\n<h3><strong>18.0.0.0<\/strong><\/h3>\n<div id=\"CTXSYS.DRIXMD.PACKAGE.18.0.0.0_RU\">CTXSYS.DRIXMD &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">790a791,799\r\n&gt; \/*---------------------------- RemoveJob ----------------------------------*\/\r\n&gt; \/*remove job name from dr$index or dr$index_partition                      *\/\r\n&gt; \r\n&gt; procedure RemoveJob (\r\n&gt;   idxid     in  number,\r\n&gt;   ixpid     in  number default null,\r\n&gt;   jobname   in  varchar2\r\n&gt; );\r\n&gt; \r\n<\/pre>\n<div id=\"CTXSYS.DRIXMD.PACKAGE BODY.18.0.0.0_RU\">CTXSYS.DRIXMD &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">4210a4211,4236\r\n&gt; PROCEDURE REMOVEJOB (\r\n&gt;   IDXID     IN NUMBER,\r\n&gt;   IXPID     IN  NUMBER DEFAULT NULL,\r\n&gt;   JOBNAME   IN VARCHAR2\r\n&gt; )\r\n&gt; IS\r\n&gt; BEGIN\r\n&gt;   IF (IXPID IS NULL) THEN\r\n&gt;     UPDATE DR$INDEX SET IDX_SYNC_JOBNAME = NULL\r\n&gt;       WHERE IDX_ID = IDXID;\r\n&gt;   ELSE\r\n&gt;     UPDATE DR$INDEX_PARTITION SET IXP_SYNC_JOBNAME = NULL\r\n&gt;       WHERE IXP_IDX_ID = IDXID AND IXP_ID = IXPID;\r\n&gt;   END IF;\r\n&gt; \r\n&gt; EXCEPTION\r\n&gt;   WHEN DR_DEF.TEXTILE_ERROR THEN\r\n&gt;     DRIUTL.DRUEBRK;  \r\n&gt;     RAISE DR_DEF.TEXTILE_ERROR;\r\n&gt;   WHEN OTHERS THEN\r\n&gt;     DRUE.TEXT_ON_STACK(SQLERRM, 'drixmd.RemoveJob');\r\n&gt;     RAISE DR_DEF.TEXTILE_ERROR;\r\n&gt; END REMOVEJOB;\r\n&gt; \r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"CTXSYS.DRVDDL.PACKAGE BODY.18.0.0.0_RU\">CTXSYS.DRVDDL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">340,344c340,345\r\n&lt;   L_PART_NAME  DRVUTL.DR_QLID2 := LTRIM(RTRIM(PART_NAME,'\"'),'\"');\r\n&lt;   WHAT    DRVUTL.DR_STRING;\r\n&lt;   SESS_STATE DR$SESSION_STATE_T;\r\n&lt;   PFX     DRVUTL.DR_QLID2;\r\n&lt;   JOBNAME DRVUTL.DR_QLID2;\r\n---\r\n&gt;   L_PART_NAME    DRVUTL.DR_QLID2 := LTRIM(RTRIM(PART_NAME,'\"'),'\"');\r\n&gt;   WHAT           DRVUTL.DR_STRING;\r\n&gt;   SESS_STATE     DR$SESSION_STATE_T;\r\n&gt;   PFX            DRVUTL.DR_QLID2;\r\n&gt;   L_JOBNAME      DRVUTL.DR_QLID2;\r\n&gt;   L_JOBNAME_ENQ  DRVUTL.DR_QLID2;\r\n347d347\r\n&lt; \r\n382,385c382,383\r\n&lt;   JOBNAME := PFX||'J';\r\n&lt;   DRIXMD.RECORDJOB(IDXID, IXPID, JOBNAME);\r\n&lt; \r\n&lt;   JOBNAME := DBMS_ASSERT.ENQUOTE_NAME(JOBNAME, FALSE);\r\n---\r\n&gt;   L_JOBNAME := PFX||'J';\r\n&gt;   L_JOBNAME_ENQ := DBMS_ASSERT.ENQUOTE_NAME(L_JOBNAME, FALSE);\r\n387,399c385,405\r\n&lt;   DBMS_SCHEDULER.CREATE_JOB(\r\n&lt;     JOB_NAME            =&gt; JOBNAME,\r\n&lt;     JOB_TYPE            =&gt; 'PLSQL_BLOCK',\r\n&lt;     JOB_ACTION          =&gt; WHAT, \r\n&lt;     REPEAT_INTERVAL     =&gt; SYNC_INTERVAL,\r\n&lt;     COMMENTS            =&gt; 'automatic sync job' \r\n&lt;   );\r\n&lt; \r\n&lt;   DBMS_SCHEDULER.SET_ATTRIBUTE(\r\n&lt;      NAME               =&gt; JOBNAME,\r\n&lt;      ATTRIBUTE          =&gt; 'FOLLOW_DEFAULT_TIMEZONE',\r\n&lt;      VALUE              =&gt; TRUE\r\n&lt;   );\r\n---\r\n&gt;   \r\n&gt;   BEGIN\r\n&gt;     DBMS_SCHEDULER.CREATE_JOB(\r\n&gt;       JOB_NAME            =&gt; L_JOBNAME_ENQ,\r\n&gt;       JOB_TYPE            =&gt; 'PLSQL_BLOCK',\r\n&gt;       JOB_ACTION          =&gt; WHAT, \r\n&gt;       REPEAT_INTERVAL     =&gt; SYNC_INTERVAL,\r\n&gt;       COMMENTS            =&gt; 'automatic sync job' \r\n&gt;     );\r\n&gt; \r\n&gt;     DBMS_SCHEDULER.SET_ATTRIBUTE(\r\n&gt;        NAME               =&gt; L_JOBNAME_ENQ,\r\n&gt;        ATTRIBUTE          =&gt; 'FOLLOW_DEFAULT_TIMEZONE',\r\n&gt;        VALUE              =&gt; TRUE\r\n&gt;     );\r\n&gt; \r\n&gt;     DBMS_SCHEDULER.SET_ATTRIBUTE(\r\n&gt;        NAME               =&gt; L_JOBNAME_ENQ,\r\n&gt;        ATTRIBUTE          =&gt; 'DATABASE_ROLE',\r\n&gt;        VALUE              =&gt; 'ALL'\r\n&gt;     );\r\n401,405c407,409\r\n&lt;   DBMS_SCHEDULER.SET_ATTRIBUTE(\r\n&lt;      NAME               =&gt; JOBNAME,\r\n&lt;      ATTRIBUTE          =&gt; 'DATABASE_ROLE',\r\n&lt;      VALUE              =&gt; 'ALL'\r\n&lt;   );\r\n---\r\n&gt;     DBMS_SCHEDULER.ENABLE(L_JOBNAME_ENQ);\r\n&gt;     DRIXMD.RECORDJOB(IDXID, IXPID, L_JOBNAME);\r\n&gt;     COMMIT;\r\n407,409c411,421\r\n&lt;   DBMS_SCHEDULER.ENABLE(JOBNAME);\r\n&lt;   \r\n&lt;   COMMIT;\r\n---\r\n&gt;   EXCEPTION\r\n&gt;   WHEN DR_DEF.TEXTILE_ERROR THEN\r\n&gt;     DRIUTL.DRUEBRK;  \r\n&gt;     GOTO CLEANUP;\r\n&gt;   WHEN OTHERS THEN\r\n&gt;     DRUE.TEXT_ON_STACK(SQLERRM, 'drvddl.submit_job');\r\n&gt;     GOTO CLEANUP;\r\n&gt; &lt;&lt;CLEANUP&gt;&gt;\r\n&gt;     DRIXMD.REMOVEJOB(IDXID, IXPID, L_JOBNAME);\r\n&gt;     RAISE DR_DEF.TEXTILE_ERROR;\r\n&gt;   END;\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12c12\r\n&lt;   bannerVersion CONSTANT VARCHAR2(15) := '18.05.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.06.00.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.05.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.05.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.05.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.06.00.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.06.00.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.06.00.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.05.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.06.00.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.05.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.06.00.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.05.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.06.00.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.05.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.06.00.00',  psn + 1));\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.5RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (18.5RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12c12\r\n&lt;   bannerVersion CONSTANT VARCHAR2(15) := '18.05.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.05.01.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.05.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.05.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.05.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.05.01.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.05.01.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.05.01.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.05.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.05.01.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.05.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.05.01.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.05.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.05.01.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.05.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.05.01.00',  psn + 1));\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12c12\r\n&lt;   bannerVersion CONSTANT VARCHAR2(15) := '18.05.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.04.02.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.05.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.05.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.05.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.04.02.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.04.02.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.04.02.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.05.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.04.02.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.05.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.04.02.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.05.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.04.02.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.05.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.04.02.00',  psn + 1));\r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">454a455,459\r\n&gt;     function    get_param(\r\n&gt;         name                in         varchar2)\r\n&gt;             return boolean;\r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">456a457,459\r\n&gt;     function get_param(\r\n&gt;         name                in          varchar2)\r\n&gt;              return boolean;\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_RU\">SYS.DBMS_REGISTRY &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">13c13\r\n&lt;                                '18.5.0.0.0';\r\n---\r\n&gt;                                '18.6.0.0.0';\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_18.4RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">13c13\r\n&lt;                                '18.5.0.0.0';\r\n---\r\n&gt;                                '18.4.2.0.0';\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_18.5RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE (18.5RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">13c13\r\n&lt;                                '18.5.0.0.0';\r\n---\r\n&gt;                                '18.5.1.0.0';\r\n<\/pre>\n<div id=\"SYS.UTL_RECOMP.PACKAGE.18.0.0.0_RU\">SYS.UTL_RECOMP &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">28a29,32\r\n&gt;     *   ORACLE_MAINTAINED -  Only recompile PUBLIC synonyms and objects\r\n&gt;     *                   belonging to Oracle_maintained schemas.  This mode is\r\n&gt;     *                   used by datapatch to automatically revalidate any OM\r\n&gt;     *                   objects invalidated by patch apply\/rollback processing.\r\n36a41\r\n&gt;    ORACLE_MAINTAINED CONSTANT PLS_INTEGER := 256;\r\n<\/pre>\n<div id=\"SYS.DBMS_AQ.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_AQ &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1378,1380c1378,1380\r\n&lt;       AND Q.NAME = QUEUE_NAME\r\n&lt;       AND T.NAME = TABLE_NAME\r\n&lt;       AND T.SCHEMA = SCHEMA;\r\n---\r\n&gt;       AND Q.NAME = AQ$_BACKGROUND_OPER.QUEUE_NAME\r\n&gt;       AND T.NAME = AQ$_BACKGROUND_OPER.TABLE_NAME\r\n&gt;       AND T.SCHEMA = AQ$_BACKGROUND_OPER.SCHEMA;\r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_18.5RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (18.5RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11483\r\n&gt;         \r\n&gt;         \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                   '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt; \r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                   '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;   \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                  '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;            GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;            IF NOT GOODLINK THEN \r\n&gt;               RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;            END IF;\r\n&gt;         END IF;\r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11479\r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                  '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;            GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;            IF NOT GOODLINK THEN \r\n&gt;               RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;            END IF;\r\n&gt;         END IF;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11145a11146\r\n&gt;         GOODLINK        BOOLEAN;\r\n11164a11166,11174\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                 '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);\r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             LINK := '';  \r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION;\r\n&gt;           END IF;\r\n&gt;         END IF;  \r\n&gt; \r\n11399a11410\r\n&gt;         GOODLINK        BOOLEAN;\r\n11400a11412,11422\r\n&gt;         \r\n&gt;         \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n11446a11469\r\n&gt;         GOODLINK        BOOLEAN;\r\n11447a11471,11483\r\n&gt;         \r\n&gt;         \r\n&gt; \r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM(\r\n&gt;                                   '_bug28742555_dbfs_symlink_path_prefix') THEN\r\n&gt; \r\n&gt;           GOODLINK := DBMS_PDB_IS_VALID_PATH(LINK);      \r\n&gt;           IF NOT GOODLINK THEN\r\n&gt;             RAISE DBMS_DBFS_CONTENT.UNSUPPORTED_OPERATION; \r\n&gt;           END IF;\r\n&gt;         END IF;\r\n&gt;         \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">645a646,676\r\n&gt;     FUNCTION    GET_PARAM(NAME IN VARCHAR2)\r\n&gt;         RETURN  BOOLEAN\r\n&gt;     IS\r\n&gt;         VAL     VARCHAR2(4000)  := NULL;\r\n&gt;     BEGIN\r\n&gt;         BEGIN\r\n&gt;             VAL := NULL;\r\n&gt;             SELECT  Y.KSPPSTVL\r\n&gt;             INTO    VAL\r\n&gt;             FROM    SYS.X$KSPPI     X\r\n&gt;                 ,   SYS.X$KSPPCV    Y\r\n&gt;             WHERE   X.INDX          = Y.INDX\r\n&gt;                 AND X.KSPPINM       = NAME\r\n&gt;             ;\r\n&gt;         EXCEPTION\r\n&gt;             WHEN OTHERS THEN\r\n&gt;             BEGIN\r\n&gt;                 TRACE(1, 'parameter=' || NAME ||\r\n&gt;                     ' err:' || SQLERRM);\r\n&gt;                 VAL := NULL;\r\n&gt;             END;\r\n&gt;         END;\r\n&gt;    \r\n&gt; \r\n&gt;         IF LOWER(VAL) = 'true' THEN\r\n&gt;             RETURN TRUE;\r\n&gt;         END IF;\r\n&gt; \r\n&gt;         RETURN FALSE;\r\n&gt;     END;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS_ADMIN.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_DBFS_SFS_ADMIN &#8211; PACKAGE BODY (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">645a646,675\r\n&gt;     FUNCTION    GET_PARAM(NAME IN VARCHAR2)\r\n&gt;         RETURN  BOOLEAN\r\n&gt;     IS\r\n&gt;         VAL     VARCHAR2(4000)  := NULL;\r\n&gt;     BEGIN\r\n&gt;         BEGIN\r\n&gt;             VAL := NULL;\r\n&gt;             SELECT  Y.KSPPSTVL\r\n&gt;             INTO    VAL\r\n&gt;             FROM    SYS.X$KSPPI     X\r\n&gt;                 ,   SYS.X$KSPPCV    Y\r\n&gt;             WHERE   X.INDX          = Y.INDX\r\n&gt;                 AND X.KSPPINM       = NAME\r\n&gt;             ;\r\n&gt;         EXCEPTION\r\n&gt;             WHEN OTHERS THEN\r\n&gt;             BEGIN\r\n&gt;                 TRACE(1, 'parameter=' || NAME ||\r\n&gt;                     ' err:' || SQLERRM);\r\n&gt;                 VAL := NULL;\r\n&gt;             END;\r\n&gt;         END;\r\n&gt;    \r\n&gt; \r\n&gt;         IF LOWER(VAL) = 'true' THEN\r\n&gt;             RETURN TRUE;\r\n&gt;         END IF;\r\n&gt; \r\n&gt;         RETURN FALSE;\r\n&gt;     END;\r\n<\/pre>\n<div id=\"SYS.DBMS_PARALLEL_EXECUTE_INTERNAL.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_PARALLEL_EXECUTE_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">701a702,706\r\n&gt;       \r\n&gt;       IF C.CUR_SIZE = 0 THEN\r\n&gt;         GOTO DONE;\r\n&gt;       END IF;\r\n&gt; \r\n705a711,713\r\n&gt; &lt;&lt;DONE&gt;&gt;\r\n&gt;       \r\n&gt;       \r\n707c715\r\n&lt;       IF (BUFFERED_CHUNK# = 0) THEN\r\n---\r\n&gt;       IF (BUFFERED_CHUNKS.COUNT = 0) THEN\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_18.5RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (18.5RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122c122\r\n&lt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.05.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.05.01.00'; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122c122\r\n&lt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.05.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.06.00.00'; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_18.4RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (18.4RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122c122\r\n&lt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.05.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.04.02.00'; \r\n25510,25512c25510,25512\r\n&lt;          IF ((UNTILTIME IS NULL AND UNTILSCN IS NULL) OR\r\n&lt;              LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME       OR\r\n&lt;              LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN) THEN\r\n---\r\n&gt;          IF (LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME OR\r\n&gt;              (UNTILTIME IS NULL AND\r\n&gt;               LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)) THEN\r\n<\/pre>\n<div id=\"SYS.UTL_RECOMP.PACKAGE BODY.18.0.0.0_RU\">SYS.UTL_RECOMP &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">323a324,335\r\n&gt;       \r\n&gt;       \r\n&gt;       IF (BITAND(FLAGS, ORACLE_MAINTAINED) != 0) THEN\r\n&gt;          WHERE_CLAUSE := WHERE_CLAUSE || 'AND ' ||\r\n&gt;              '(owner in (select name \r\n&gt;                    from user$ where type# = 1 and bitand(spare1,256)=256)\r\n&gt;                OR (owner = ''PUBLIC'' and obj# IN \r\n&gt;                   (select obj# from obj$ where name=objname\r\n&gt;                           and type#=5 \r\n&gt;                           and bitand(flags, 4194304)=4194304)))';\r\n&gt;       END IF;\r\n&gt; \r\n511a524,535\r\n&gt;       \r\n&gt;       \r\n&gt;       IF (BITAND(FLAGS, ORACLE_MAINTAINED) != 0) THEN\r\n&gt;          WHERE_CLAUSE := WHERE_CLAUSE || 'AND ' ||\r\n&gt;              '(owner in (select name \r\n&gt;                    from user$ where type# = 1 and bitand(spare1,256)=256)\r\n&gt;                OR (owner = ''PUBLIC'' and obj# IN \r\n&gt;                   (select obj# from obj$ where name=objname\r\n&gt;                           and type#=5 \r\n&gt;                           and bitand(flags, 4194304)=4194304)))';\r\n&gt;       END IF;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.APS_VALIDATE.PROCEDURE.18.0.0.0_RU\">SYS.APS_VALIDATE &#8211; PROCEDURE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">16c16\r\n&lt;     EXECUTE IMMEDIATE 'alter session set events=''37396 trace name context forever,  level '||to_char(new_e_level)||'''';\r\n---\r\n&gt;     EXECUTE IMMEDIATE 'alter session set events=''37396 trace name context forever,  level '||to_char(new_e_level,'9999999999')||'''';\r\n31d30\r\n&lt; \r\n47d45\r\n&lt; \r\n65c63\r\n&lt;      execute immediate 'ALTER SESSION SET EVENTS ''37396 trace name context level to_char(e_level)''';\r\n---\r\n&gt;      execute immediate 'ALTER SESSION SET EVENTS ''37396 trace name context level ' ||  to_char(e_level,'9999999999') || '''';\r\n<\/pre>\n<div id=\"SYS.DBMS_FEATURE_REGISTER_ALLFEAT.PROCEDURE.18.0.0.0_RU\">SYS.DBMS_FEATURE_REGISTER_ALLFEAT &#8211; PROCEDURE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">4118a4119,4135\r\n&gt;   \/**********************************************\r\n&gt;    * Scrollable Cursors\r\n&gt;    **********************************************\/\r\n&gt; \r\n&gt;   declare\r\n&gt;     DBFUS_SCC_STR CONSTANT VARCHAR2(1000) :=\r\n&gt;       'select max(ksuzsal2), NULL, NULL from x$ksuzsa where ksuzsal2 != 0';\r\n&gt; \r\n&gt;   begin\r\n&gt;     dbms_feature_usage.register_db_feature\r\n&gt;      ('Scrollable Cursor',\r\n&gt;       dbms_feature_usage.DBU_INST_ALWAYS_INSTALLED,\r\n&gt;       NULL,\r\n&gt;       dbms_feature_usage.DBU_DETECT_BY_SQL,\r\n&gt;       DBFUS_SCC_STR,\r\n&gt;       'Scrollable Cursor has been used');\r\n&gt;   end;\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">105a106,109\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UNSUPPORT_TAB_12_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">93a94,97\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_RU_UN_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_RU_UN_TAB_12_2_0_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">95a96,99\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_10_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_10_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">63a64,67\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_10_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_10_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">60a61,64\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_11_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">59a60,63\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">54a55,58\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_11_2B &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">59a60,63\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">100a101,104\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">103a104,107\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_SUPPORT_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_SUPPORT_TAB_12_2_0_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">106a107,110\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_10_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_10_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">74a75,78\r\n&gt;     or (bitand(t.property, 1024) = 1024       \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_10_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_10_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">62a63,66\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_11_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">79a80,83\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">72a73,76\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_11_2B &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">77a78,81\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_12_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">107a108,111\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPPORT_TAB_12_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">111a112,115\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.LOGSTDBY_UNSUPP_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.LOGSTDBY_UNSUPP_TAB_12_2_0_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">113a114,117\r\n&gt;   or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.OGG_SUPPORT_TAB_11_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_11_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">81a82,85\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.OGG_SUPPORT_TAB_11_2B.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_11_2B &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">82a83,86\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.OGG_SUPPORT_TAB_12_1.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_1 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">119a120,123\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.OGG_SUPPORT_TAB_12_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">120a121,124\r\n&gt;      or (bitand(t.property, 1024) = 1024        \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<div id=\"SYS.OGG_SUPPORT_TAB_12_2_0_2.VIEW.18.0.0.0_RU\">SYS.OGG_SUPPORT_TAB_12_2_0_2 &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122a123,126\r\n&gt;     or (bitand(t.property, 1024) = 1024         \/* Sorted hash cluster table *\/\r\n&gt;         and exists (select 1 from clu$ cl\r\n&gt;                      where cl.obj#=t.bobj#\r\n&gt;                        and bitand(cl.spare1, 8388608) != 0))\r\n<\/pre>\n<hr \/>\n<p>Useful Links:<\/p>\n<ul>\n<li>Download Assistant: <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=2118136.2\" target=\"_blank\" rel=\"noopener noreferrer\">MOS Note: 2118136.2<\/a><\/li>\n<li>2019 April CPU: <a href=\"https:\/\/www.oracle.com\/technetwork\/security-advisory\/cpuapr2019-5072813.html\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.oracle.com\/technetwork\/security-advisory\/cpuapr2019-5072813.html<\/a><\/li>\n<\/ul>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-4100 jlk' href='javascript:void(0)' data-task='like' data-post_id='4100' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-4100 lc'>+2<\/span><\/a><\/div><\/div> <div class='status-4100 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>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. To check previous changes, follow the links below: Dissecting 190115 BP, PSU, RU and RUR Dissecting 181016 BP, PSU, RU and RUR Dissecting 180717 BP, PSU, RU and RUR &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,15],"tags":[],"class_list":["post-4100","post","type-post","status-publish","format-standard","hentry","category-security-en","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dissecting 190416 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"All the changes performed by Oracle April 2019 Database CPU (190416) dissected.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"40 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Dissecting 190416 BP, PSU, RU and RUR\",\"datePublished\":\"2019-05-24T14:31:35+00:00\",\"dateModified\":\"2019-05-24T14:37:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/\"},\"wordCount\":1345,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Database Security\",\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/\",\"name\":\"Dissecting 190416 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2019-05-24T14:31:35+00:00\",\"dateModified\":\"2019-05-24T14:37:44+00:00\",\"description\":\"All the changes performed by Oracle April 2019 Database CPU (190416) dissected.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/05\\\/dissecting-190416-bp-psu-ru-and-rur\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dissecting 190416 BP, PSU, RU and RUR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dissecting 190416 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"All the changes performed by Oracle April 2019 Database CPU (190416) dissected.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"40 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Dissecting 190416 BP, PSU, RU and RUR","datePublished":"2019-05-24T14:31:35+00:00","dateModified":"2019-05-24T14:37:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/"},"wordCount":1345,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Database Security","Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/","url":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/","name":"Dissecting 190416 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2019-05-24T14:31:35+00:00","dateModified":"2019-05-24T14:37:44+00:00","description":"All the changes performed by Oracle April 2019 Database CPU (190416) dissected.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/05\/dissecting-190416-bp-psu-ru-and-rur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Dissecting 190416 BP, PSU, RU and RUR"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=4100"}],"version-history":[{"count":4,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4100\/revisions"}],"predecessor-version":[{"id":4105,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4100\/revisions\/4105"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=4100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=4100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=4100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}