{"id":4250,"date":"2019-08-18T21:05:46","date_gmt":"2019-08-19T00:05:46","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=4250"},"modified":"2019-09-24T12:19:47","modified_gmt":"2019-09-24T15:19:47","slug":"dissecting-190716-bp-psu-ru-and-rur","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/","title":{"rendered":"Dissecting 190716 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\/05\/dissecting-190416-bp-psu-ru-and-rur\/\" target=\"_blank\" rel=\"noopener noreferrer\">Dissecting 190416 BP, PSU, RU and RUR<\/a><\/li>\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>July 2019 &#8211; <\/strong><span style=\"text-decoration: underline;\"><strong>190716<\/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                  1\r\n11.2.0.4   BP         SYS                            PACKAGE BODY             1\r\n11.2.0.4   PSU        SYS                            PACKAGE                  1\r\n11.2.0.4   PSU        SYS                            PACKAGE BODY             1\r\n12.1.0.2   BP         DVSYS                          PACKAGE                  1\r\n12.1.0.2   BP         DVSYS                          PACKAGE BODY             2\r\n12.1.0.2   BP         LBACSYS                        PACKAGE BODY             1\r\n12.1.0.2   BP         SYS                            PACKAGE                  2\r\n12.1.0.2   BP         SYS                            PACKAGE BODY             5\r\n12.1.0.2   BP         SYS                            TYPE                     2\r\n12.1.0.2   PSU        SYS                            PACKAGE                  2\r\n12.1.0.2   PSU        SYS                            PACKAGE BODY             2\r\n12.2.0.1   RU         DVSYS                          TYPE                     9\r\n12.2.0.1   RU         DVSYS                          VIEW                     1\r\n12.2.0.1   RU         SYS                            PACKAGE                  2\r\n12.2.0.1   RU         SYS                            PACKAGE BODY             4\r\n12.2.0.1   RU         SYS                            TYPE                     2\r\n18.0.0.0   18.5RUR    SYS                            PACKAGE                  2\r\n18.0.0.0   18.5RUR    SYS                            PACKAGE BODY             1\r\n18.0.0.0   18.6RUR    SYS                            PACKAGE                  2\r\n18.0.0.0   18.6RUR    SYS                            PACKAGE BODY             1\r\n18.0.0.0   RU         SYS                            PACKAGE                  3\r\n18.0.0.0   RU         SYS                            PACKAGE BODY             3\r\n18.0.0.0   RU         SYS                            TYPE                     2\r\n18.0.0.0   RU         SYS                            VIEW                     1\r\n19.0.0.0   19.3RUR    SYS                            PACKAGE                  2\r\n19.0.0.0   19.3RUR    SYS                            PACKAGE BODY             1\r\n19.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE                  5\r\n19.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE BODY             3\r\n19.0.0.0   RU         MDSYS                          PACKAGE                  1\r\n19.0.0.0   RU         MDSYS                          PACKAGE BODY             3\r\n19.0.0.0   RU         MDSYS                          TYPE                     1\r\n19.0.0.0   RU         SYS                            PACKAGE                  7\r\n19.0.0.0   RU         SYS                            PACKAGE BODY            13\r\n19.0.0.0   RU         SYS                            TYPE                     2\r\n19.0.0.0   RU         SYS                            VIEW                     1<\/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   RU         SYS                            PACKAGE                  1\r\n12.2.0.1   RU         SYS                            PACKAGE BODY             1<\/pre>\n<p><span style=\"font-size: 12pt; color: #800000;\"><strong>P.S: Nothing was added for 11.2 \/ 12.1 \/ 18 \/ 19 in Oracle objects.<\/strong><\/span><\/p>\n<p>So which are exactly the objects modified by 190716?<\/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         DBMS_RCVMAN                    MOD\r\n11.2.0.4   PSU &amp; BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.1.0.2   BP              DVSYS                          PACKAGE         DBMS_MACUTL                    MOD\r\n12.1.0.2   BP              DVSYS                          PACKAGE BODY    DBMS_MACADM                    MOD\r\n12.1.0.2   BP              DVSYS                          PACKAGE BODY    DBMS_MACUTL                    MOD\r\n12.1.0.2   BP              LBACSYS                        PACKAGE BODY    OLS_ENFORCEMENT                MOD\r\n12.1.0.2   BP              SYS                            PACKAGE         DBMS_OPTIM_BUNDLE              MOD\r\n12.1.0.2   BP              SYS                            PACKAGE         DBMS_REDEFINITION_INTERNAL     MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_OPTIM_BUNDLE              MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_REDEFINITION              MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_REDEFINITION_INTERNAL     MOD\r\n12.1.0.2   BP              SYS                            PACKAGE BODY    DBMS_STATS                     MOD\r\n12.1.0.2   BP              SYS                            TYPE            DBMS_OPTIM_BUGVALOBTYPE        MOD\r\n12.1.0.2   BP              SYS                            TYPE            DBMS_OPTIM_FCTABTYPE           MOD\r\n12.1.0.2   PSU             SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD\r\n12.1.0.2   PSU             SYS                            PACKAGE         DBMS_RCVMAN                    MOD\r\n12.1.0.2   PSU             SYS                            PACKAGE BODY    DBMS_BACKUP_RESTORE            MOD\r\n12.1.0.2   PSU &amp; BP        SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.2.0.1   RU              SYS                            PACKAGE         DBMS_BDSQL                     NEW\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_BDSQL                     NEW\r\n12.2.0.1   RU              DVSYS                          TYPE            KU$_DV_COMMAND_RULE_T          MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072649$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072661$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072664$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072667$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072694$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072697$            MOD\r\n12.2.0.1   RU              DVSYS                          TYPE            SYS_YOID0000072870$            MOD\r\n12.2.0.1   RU              DVSYS                          VIEW            KU$_DV_COMMAND_RULE_VIEW       MOD\r\n12.2.0.1   RU              SYS                            PACKAGE         DBMS_HADOOP                    MOD\r\n12.2.0.1   RU              SYS                            PACKAGE         DBMS_OPTIM_BUNDLE              MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    CDBVIEW_INTERNAL               MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_HADOOP                    MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_OPTIM_BUNDLE              MOD\r\n12.2.0.1   RU              SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n12.2.0.1   RU              SYS                            TYPE            DBMS_OPTIM_BUGVALOBTYPE        MOD\r\n12.2.0.1   RU              SYS                            TYPE            DBMS_OPTIM_FCTABTYPE           MOD\r\n18.0.0.0   RU              SYS                            PACKAGE         DBMS_OPTIM_BUNDLE              MOD\r\n18.0.0.0   RU              SYS                            PACKAGE BODY    CDBVIEW_INTERNAL               MOD\r\n18.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_OPTIM_BUNDLE              MOD\r\n18.0.0.0   RU              SYS                            TYPE            DBMS_OPTIM_BUGVALOBTYPE        MOD\r\n18.0.0.0   RU              SYS                            TYPE            DBMS_OPTIM_FCTABTYPE           MOD\r\n18.0.0.0   RU              SYS                            VIEW            DBA_APPLY_ERROR                MOD\r\n18.0.0.0   RU &amp; 18.6RUR &amp;  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD\r\n           18.5RUR\r\n18.0.0.0   RU &amp; 18.6RUR &amp;  SYS                            PACKAGE         DBMS_REGISTRY                  MOD\r\n           18.5RUR\r\n18.0.0.0   RU &amp; 18.6RUR &amp;  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD\r\n           18.5RUR\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE         DBMS_GSM_COMMON                MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE         DBMS_GSM_DBADMIN               MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE         DBMS_GSM_POOLADMIN             MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE         DBMS_GSM_UTILITY               MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE         EXCHANGE                       MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_DBADMIN               MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_POOLADMIN             MOD\r\n19.0.0.0   RU              GSMADMIN_INTERNAL              PACKAGE BODY    EXCHANGE                       MOD\r\n19.0.0.0   RU              MDSYS                          PACKAGE         SDO_GEORX                      MOD\r\n19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_CSWADM                     MOD\r\n19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR                       MOD\r\n19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEORX                      MOD\r\n19.0.0.0   RU              MDSYS                          TYPE            SDO_RDF_TRIPLE_S               MOD\r\n19.0.0.0   RU              SYS                            PACKAGE         DBMS_ASH                       MOD\r\n19.0.0.0   RU              SYS                            PACKAGE         DBMS_AWR_REPORT_LAYOUT         MOD\r\n19.0.0.0   RU              SYS                            PACKAGE         DBMS_OPTIM_BUNDLE              MOD\r\n19.0.0.0   RU              SYS                            PACKAGE         DBMS_RCVMAN                    MOD\r\n19.0.0.0   RU              SYS                            PACKAGE         DBMS_RMIN_SYS                  MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_ASH                       MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTO_INDEX_INTERNAL       MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AWR_REPORT_LAYOUT         MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_BACKUP_RESTORE            MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_DBFS_SFS                  MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_OPTIM_BUNDLE              MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_RESOURCE_MANAGER          MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SPM                       MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SPM_INTERNAL              MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STATS                     MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SWRF_REPORT_INTERNAL      MOD\r\n19.0.0.0   RU              SYS                            PACKAGE BODY    KUPM$MCP                       MOD\r\n19.0.0.0   RU              SYS                            TYPE            DBMS_OPTIM_BUGVALOBTYPE        MOD\r\n19.0.0.0   RU              SYS                            TYPE            DBMS_OPTIM_FCTABTYPE           MOD\r\n19.0.0.0   RU              SYS                            VIEW            CDB_TAB_COLS_V$                MOD\r\n19.0.0.0   RU &amp; 19.3RUR    SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD\r\n19.0.0.0   RU &amp; 19.3RUR    SYS                            PACKAGE         DBMS_REGISTRY                  MOD\r\n19.0.0.0   RU &amp; 19.3RUR    SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD<\/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.11.2.0.4_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE 11g (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE.11.2.0.4_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE 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<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.11.2.0.4_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 11g (PSU)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>12.1.0.2\n<ul>\n<li><a href=\"#DVSYS.DBMS_MACUTL.PACKAGE.12.1.0.2_BP\">DVSYS.DBMS_MACUTL &#8211; PACKAGE 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#DVSYS.DBMS_MACADM.PACKAGE BODY.12.1.0.2_BP\">DVSYS.DBMS_MACADM &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#DVSYS.DBMS_MACUTL.PACKAGE BODY.12.1.0.2_BP\">DVSYS.DBMS_MACUTL &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#LBACSYS.OLS_ENFORCEMENT.PACKAGE BODY.12.1.0.2_BP\">LBACSYS.OLS_ENFORCEMENT &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.12.1.0.2_PSU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 12cR1 (PSU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE.12.1.0.2_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE 12cR1 (PSU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REDEFINITION_INTERNAL.PACKAGE.12.1.0.2_BP\">SYS.DBMS_REDEFINITION_INTERNAL &#8211; PACKAGE 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE BODY.12.1.0.2_PSU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE BODY 12cR1 (PSU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY 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_RCVMAN.PACKAGE BODY.12.1.0.2_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 12cR1 (PSU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REDEFINITION.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_REDEFINITION &#8211; PACKAGE BODY 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REDEFINITION_INTERNAL.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_REDEFINITION_INTERNAL &#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<li><a href=\"#SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE 12cR1 (BP)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_FCTABTYPE.TYPE.12.1.0.2_BP\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE 12cR1 (BP)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>12.2.0.1\n<ul>\n<li><a href=\"#DVSYS.KU$_DV_COMMAND_RULE_T.TYPE.12.2.0.1_RU\">DVSYS.KU$_DV_COMMAND_RULE_T &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072649$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072649$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072661$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072661$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072664$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072664$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072667$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072667$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072694$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072694$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072697$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072697$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.SYS_YOID0000072870$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072870$ &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#DVSYS.KU$_DV_COMMAND_RULE_VIEW.VIEW.12.2.0.1_RU\">DVSYS.KU$_DV_COMMAND_RULE_VIEW &#8211; VIEW 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_HADOOP.PACKAGE.12.2.0.1_RU\">SYS.DBMS_HADOOP &#8211; PACKAGE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUNDLE &#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_HADOOP.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_HADOOP &#8211; PACKAGE BODY 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY 12cR2 (RU)<\/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_OPTIM_BUGVALOBTYPE.TYPE.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_FCTABTYPE.TYPE.12.2.0.1_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE 12cR2 (RU)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>18.0.0.0\n<ul>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.6RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 18c (18.6RUR)<\/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_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE 18c (RU)<\/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.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.6RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE 18c (18.6RUR)<\/a><\/li>\n<li><a href=\"#SYS.CDBVIEW_INTERNAL.PACKAGE BODY.18.0.0.0_RU\">SYS.CDBVIEW_INTERNAL &#8211; PACKAGE BODY 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#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.6RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 18c (18.6RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_FCTABTYPE.TYPE.18.0.0.0_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE 18c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBA_APPLY_ERROR.VIEW.18.0.0.0_RU\">SYS.DBA_APPLY_ERROR &#8211; VIEW 18c (RU)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>19.0.0.0\n<ul>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_COMMON.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_COMMON &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_UTILITY.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_UTILITY &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.EXCHANGE.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.EXCHANGE &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#GSMADMIN_INTERNAL.EXCHANGE.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.EXCHANGE &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#MDSYS.SDO_GEORX.PACKAGE.19.0.0.0_RU\">MDSYS.SDO_GEORX &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#MDSYS.SDO_CSWADM.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_CSWADM &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#MDSYS.SDO_GEOR.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_GEOR &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#MDSYS.SDO_GEORX.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_GEORX &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#MDSYS.SDO_RDF_TRIPLE_S.TYPE.19.0.0.0_RU\">MDSYS.SDO_RDF_TRIPLE_S &#8211; TYPE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_ASH.PACKAGE.19.0.0.0_RU\">SYS.DBMS_ASH &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_AWR_REPORT_LAYOUT.PACKAGE.19.0.0.0_RU\">SYS.DBMS_AWR_REPORT_LAYOUT &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.19.0.0.0_19.3RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 19c (19.3RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE.19.0.0.0_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE.19.0.0.0_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REGISTRY.PACKAGE.19.0.0.0_RU\">SYS.DBMS_REGISTRY &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_REGISTRY.PACKAGE.19.0.0.0_19.3RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE 19c (19.3RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RMIN_SYS.PACKAGE.19.0.0.0_RU\">SYS.DBMS_RMIN_SYS &#8211; PACKAGE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_ASH.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_ASH &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_AUTO_INDEX_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_AUTO_INDEX_INTERNAL &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_AWR_REPORT_LAYOUT.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_AWR_REPORT_LAYOUT &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_BACKUP_RESTORE.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_DBFS_SFS.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_DBFS_SFS &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RCVMAN.PACKAGE BODY.19.0.0.0_19.3RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY 19c (19.3RUR)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_RESOURCE_MANAGER.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_RESOURCE_MANAGER &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_SPM.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SPM &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_SPM_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SPM_INTERNAL &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_STATS.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_STATS &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_SWRF_REPORT_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SWRF_REPORT_INTERNAL &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.KUPM$MCP.PACKAGE BODY.19.0.0.0_RU\">SYS.KUPM$MCP &#8211; PACKAGE BODY 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.DBMS_OPTIM_FCTABTYPE.TYPE.19.0.0.0_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE 19c (RU)<\/a><\/li>\n<li><a href=\"#SYS.CDB_TAB_COLS_V$.VIEW.19.0.0.0_RU\">SYS.CDB_TAB_COLS_V$ &#8211; VIEW 19c (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.11.2.0.4_BP\">SYS.DBMS_RCVMAN &#8211; PACKAGE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2974c2974,2975\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.11.2.0.4_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2974c2974,2975\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\n3275c3276\r\n&lt;    name       IN  varchar2);\r\n---\r\n&gt;   name          IN  varchar2);\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\">6262c6262,6263\r\n&lt;   ,PATTERN4     IN VARCHAR2)\r\n---\r\n&gt;   ,PATTERN4       IN VARCHAR2\r\n&gt;   ,BACKEDUPANYSCN IN NUMBER)\r\n6263a6265,6278\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\n6299,6303c6314,6325\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\n6336,6337c6358,6360\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\n6437,6441c6460,6471\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\n6447,6448c6477,6479\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\n15317c15348,15349\r\n&lt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I\r\n---\r\n&gt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I,\r\n&gt;                V$DATABASE DB\r\n15333a15366\r\n&gt;             AND L.NEXT_CHANGE# &gt;= DB.STANDBY_BECAME_PRIMARY_SCN\r\n23672a23706,23711\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' ||\r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n23679,23681c23718,23724\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n24283c24326,24327\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\n24295a24340\r\n&gt;    BACKEDUPANYSCN     NUMBER;\r\n24298a24344,24353\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\n24303a24359\r\n&gt;    \r\n24311c24367,24368\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_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\">6256,6262c6256,6263\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\n6263a6265,6278\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\n6299,6303c6314,6325\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\n6336,6337c6358,6360\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\n6437,6441c6460,6471\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\n6446,6448c6476,6479\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\n10049,10050c10080,10081\r\n&lt;         DEB(DEB_PRINT, 'CheckRecAction:matches inc='||INC_IDX||\r\n&lt;                        ',fromscn='||FROMSCN ||\r\n---\r\n&gt;            DEB(DEB_PRINT, 'CheckRecAction:matches inc='||INC_IDX||\r\n&gt;                           ',fromscn='|| FROMSCN ||\r\n10052c10083\r\n&lt;            RETURN SUCCESS;\r\n---\r\n&gt;               RETURN SUCCESS;\r\n15315c15346,15347\r\n&lt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I\r\n---\r\n&gt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I,\r\n&gt;                V$DATABASE DB\r\n15331a15364\r\n&gt;             AND L.NEXT_CHANGE# &gt;= DB.STANDBY_BECAME_PRIMARY_SCN\r\n17413,17414c17446,17447\r\n&lt;       RAISE_APPLICATION_ERROR(-20514,\r\n&lt;          'feature requires Availability Machine recovery catalog');\r\n---\r\n&gt;          RAISE_APPLICATION_ERROR(-20514,\r\n&gt;             'feature requires Availability Machine recovery catalog');\r\n17721,17722c17754,17755\r\n&lt;    DEB(DEB_OPEN, 'translateDatabase_c');\r\n&lt;    OPEN TRANSLATEDATABASE_C(FROMSCN, TOSCN);\r\n---\r\n&gt;       DEB(DEB_OPEN, 'translateDatabase_c');\r\n&gt;       OPEN TRANSLATEDATABASE_C(FROMSCN, TOSCN);\r\n17724,17725c17757,17758\r\n&lt;    GETDATAFILECURSOR       := 'translateDatabase';\r\n&lt;    GETDATAFILENOROWS.ERROR := NULL;             \r\n---\r\n&gt;       GETDATAFILECURSOR := 'translateDatabase';\r\n&gt;       GETDATAFILENOROWS.ERROR := NULL;             \r\n18487c18520\r\n&lt;    MASK NUMBER := NVL(STATUSMASK,\r\n---\r\n&gt;    MASK    NUMBER := NVL(STATUSMASK,\r\n18577c18610\r\n&lt;    MASK NUMBER := NVL(STATUSMASK,\r\n---\r\n&gt;    MASK    NUMBER := NVL(STATUSMASK,\r\n19783,19784c19816,19817\r\n&lt;                CLOSE FINDBACKUPPIECE_C;\r\n&lt;                DEB(DEB_EXIT, 'with error 20261');\r\n---\r\n&gt;                   CLOSE FINDBACKUPPIECE_C;\r\n&gt;                   DEB(DEB_EXIT, 'with error 20261');\r\n19785a19819\r\n&gt;                END IF;\r\n19788d19821\r\n&lt;       END IF;\r\n21799,21806c21832,21839\r\n&lt;                                 FNO        =&gt; FILE#,\r\n&lt;                                 CRESCN     =&gt; CREATE_SCN,\r\n&lt;                                 RESET_SCN  =&gt; NVL(RESET_SCN, THIS_RESET_SCN),\r\n&lt;                                 RESET_TIME =&gt; NVL(RESET_TIME, THIS_RESET_TIME),\r\n&lt;                                 LEVEL      =&gt; ILEVEL,\r\n&lt;                                 STATUSMASK =&gt; BSAVAILABLE,\r\n&lt;                                 TAG        =&gt; TAG,\r\n&lt;                                 ONLYTC     =&gt; TRUE#,\r\n---\r\n&gt;         FNO             =&gt; FILE#,\r\n&gt;         CRESCN          =&gt; CREATE_SCN,\r\n&gt;         RESET_SCN       =&gt; NVL(RESET_SCN, THIS_RESET_SCN),\r\n&gt;         RESET_TIME      =&gt; NVL(RESET_TIME, THIS_RESET_TIME),\r\n&gt;         LEVEL           =&gt; ILEVEL,\r\n&gt;         STATUSMASK      =&gt; BSAVAILABLE,\r\n&gt;         TAG             =&gt; TAG,\r\n&gt;         ONLYTC          =&gt; TRUE#,\r\n22446,22447c22479,22481\r\n&lt;          DEB(DEB_PRINT, 'getConfig: using primary configurations');\r\n&lt;          OPEN FINDCONFIG_C(NAME, VALUE, PRIMARY_DB_UNIQUE_NAME);\r\n---\r\n&gt;             DEB(DEB_PRINT, 'getConfig: using primary configurations');\r\n&gt;             OPEN FINDCONFIG_C(NAME, VALUE, PRIMARY_DB_UNIQUE_NAME);\r\n&gt;          END IF;\r\n22449d22482\r\n&lt;    END IF;\r\n22637,22638c22670,22671\r\n&lt;          RETURN FALSE;\r\n&lt;       END IF;\r\n---\r\n&gt;             RETURN FALSE;\r\n&gt;          END IF;\r\n23155,23161c23188,23194\r\n&lt;       \r\n&lt;       \r\n&lt;       \r\n&lt;       \r\n&lt;       \r\n&lt;       \r\n&lt;       \r\n---\r\n&gt;          \r\n&gt;          \r\n&gt;          \r\n&gt;          \r\n&gt;          \r\n&gt;          \r\n&gt;          \r\n23186c23219\r\n&lt;         RCVRECPOP(RCVREC);\r\n---\r\n&gt;              RCVRECPOP(RCVREC);\r\n23670a23704,23709\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' ||\r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n23677,23679c23716,23722\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n24281c24324,24325\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\n24293a24338\r\n&gt;    BACKEDUPANYSCN     NUMBER;\r\n24296a24342,24351\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\n24301a24357\r\n&gt;    \r\n24309c24365,24366\r\n&lt;                              PATTERN4    =&gt; STARTWITHPATTERN(TODEST4));\r\n---\r\n&gt;                              PATTERN4       =&gt; STARTWITHPATTERN(TODEST4),\r\n&gt;                              BACKEDUPANYSCN =&gt; BACKEDUPANYSCN);\r\n24915a24973\r\n&gt;             END IF;\r\n24917d24974\r\n&lt;       END IF;\r\n25753,25754c25810,25811\r\n&lt;    OPEN TRANSLATETEMPFILE_C;\r\n&lt;    GETTEMPFILECURSOR := 'translateTempfile_c';\r\n---\r\n&gt;       OPEN TRANSLATETEMPFILE_C;\r\n&gt;       GETTEMPFILECURSOR := 'translateTempfile_c';\r\n25924c25981\r\n&lt;    NAME         IN VARCHAR2\r\n---\r\n&gt;    NAME         IN  VARCHAR2\r\n25930c25987\r\n&lt;    RSP RESTORE_POINT_C%ROWTYPE;\r\n---\r\n&gt;    RSP  RESTORE_POINT_C%ROWTYPE;\r\n25941,25943c25998,26000\r\n&lt;       RLGSCN := NULL;\r\n&lt;       RLGTIME := NULL;\r\n&lt;       SCN := NULL;\r\n---\r\n&gt;       RLGSCN     := NULL;\r\n&gt;       RLGTIME    := NULL;\r\n&gt;       SCN        := NULL;\r\n25946,25948c26003,26005\r\n&lt;       RLGSCN := RSP.RESET_SCN;\r\n&lt;       RLGTIME := RSP.RESET_TIME;\r\n&lt;       SCN := RSP.SCN;\r\n---\r\n&gt;       RLGSCN     := RSP.RESET_SCN;\r\n&gt;       RLGTIME    := RSP.RESET_TIME;\r\n&gt;       SCN        := RSP.SCN;\r\n<\/pre>\n<h3><strong>12.1.0.2<\/strong><\/h3>\n<div id=\"DVSYS.DBMS_MACUTL.PACKAGE.12.1.0.2_BP\">DVSYS.DBMS_MACUTL &#8211; PACKAGE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">463a464,472\r\n&gt;   \/**\r\n&gt;   * Checks whether the given role is enabled in the current session.\r\n&gt;   *\r\n&gt;   * @param p_role Role to check\r\n&gt;   * @return TRUE if the role is enabled in the current session\r\n&gt;   *\/\r\n&gt;   FUNCTION session_enabled_role(p_role    IN VARCHAR2)\r\n&gt;     RETURN BOOLEAN;\r\n&gt; \r\n499a509,517\r\n&gt;   * Checks whether the given role is enabled in the current session.\r\n&gt;   *\r\n&gt;   * @param p_role Role to check\r\n&gt;   * @return Y if the role is enabled in the current session, N otherwise\r\n&gt;   *\/\r\n&gt;   FUNCTION session_enabled_role_varchar(p_role    IN VARCHAR2)\r\n&gt;     RETURN VARCHAR2;\r\n&gt; \r\n&gt;   \/**\r\n<\/pre>\n<div id=\"DVSYS.DBMS_MACADM.PACKAGE BODY.12.1.0.2_BP\">DVSYS.DBMS_MACADM &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3400c3400,3401\r\n&lt;     IF DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_ACCTMGR', LOGIN_USER) = 'N' THEN\r\n---\r\n&gt;     IF DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_ACCTMGR', LOGIN_USER) = 'N' AND\r\n&gt;        DVSYS.DBMS_MACUTL.SESSION_ENABLED_ROLE_VARCHAR('DV_ACCTMGR') = 'N' THEN\r\n<\/pre>\n<div id=\"DVSYS.DBMS_MACUTL.PACKAGE BODY.12.1.0.2_BP\">DVSYS.DBMS_MACUTL &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">603a604,620\r\n&gt;    FUNCTION SESSION_ENABLED_ROLE(P_ROLE     IN VARCHAR2)\r\n&gt;    RETURN BOOLEAN\r\n&gt;    IS EXTERNAL\r\n&gt;    LANGUAGE C\r\n&gt;    NAME \"kzvIsRoleEnabled\"\r\n&gt;          LIBRARY DVSYS.KZV$UTL_LIBT\r\n&gt;          WITH CONTEXT\r\n&gt;    PARAMETERS\r\n&gt;    (CONTEXT,\r\n&gt;     P_ROLE             STRING,\r\n&gt;     P_ROLE INDICATOR   SB4,\r\n&gt;     P_ROLE LENGTH      SB4,\r\n&gt; \r\n&gt;     RETURN INDICATOR SB4,\r\n&gt;     RETURN           SB2\r\n&gt;    );\r\n&gt; \r\n776a794,805\r\n&gt;   FUNCTION SESSION_ENABLED_ROLE_VARCHAR(P_ROLE    IN VARCHAR2)\r\n&gt;   RETURN VARCHAR2 IS\r\n&gt;     IS_ENABLED BOOLEAN ;\r\n&gt;   BEGIN\r\n&gt;     IS_ENABLED := DBMS_MACUTL.SESSION_ENABLED_ROLE(P_ROLE);\r\n&gt; \r\n&gt;     IF ( IS_ENABLED ) THEN\r\n&gt;         RETURN G_YES;\r\n&gt;     ELSE\r\n&gt;         RETURN G_NO;\r\n&gt;     END IF;\r\n&gt;   END;\r\n<\/pre>\n<div id=\"LBACSYS.OLS_ENFORCEMENT.PACKAGE BODY.12.1.0.2_BP\">LBACSYS.OLS_ENFORCEMENT &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">7a8,24\r\n&gt; FUNCTION SESSION_ENABLED_ROLE(P_ROLE     IN VARCHAR2)\r\n&gt;    RETURN BOOLEAN\r\n&gt;    IS EXTERNAL\r\n&gt;    LANGUAGE C\r\n&gt;    NAME \"kzvIsRoleEnabled\"\r\n&gt;    LIBRARY LBACSYS.LBAC$EVENT_LIBT\r\n&gt;          WITH CONTEXT\r\n&gt;    PARAMETERS\r\n&gt;    (CONTEXT,\r\n&gt;     P_ROLE             STRING,\r\n&gt;     P_ROLE INDICATOR   SB4,\r\n&gt;     P_ROLE LENGTH      SB4,\r\n&gt; \r\n&gt;     RETURN INDICATOR SB4,\r\n&gt;     RETURN           SB2\r\n&gt;    );\r\n&gt; \r\n15a33,40\r\n&gt;   \r\n&gt;   \r\n&gt;   IF (LBACDBA_ROLE_COUNT + DVOWNER_ROLE_COUNT) &lt; 1 THEN\r\n&gt;     IF (SESSION_ENABLED_ROLE('DV_OWNER')) THEN\r\n&gt;       DVOWNER_ROLE_COUNT := 1;\r\n&gt;     END IF;\r\n&gt;   END IF;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.12.1.0.2_PSU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">8189a8190,8195\r\n&gt; \r\n&gt;   FUNCTION createTempXmlFile\r\n&gt;      RETURN varchar2;\r\n&gt;   -- This procedure returns a temporary filename.\r\n&gt;   -- The temporary filename is derived from ?\/dbs location.\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1\r\n&lt; PACKAGE dbms_optim_bundle AS\r\n---\r\n&gt; PACKAGE dbms_optim_bundle AUTHID CURRENT_USER AS\r\n15a16,20\r\n&gt; \r\n&gt; \r\n&gt; ----------------------------\r\n&gt; --  PROCEDURES AND FUNCTIONS\r\n&gt; ----------------------------\r\n99a105,122\r\n&gt; -- USAGE:\r\n&gt; -- User can invoke below procedure to display bundle-ids and bundle-names\r\n&gt; -- which have fixes with _fix_controls i.e. fixes which may cause plan change.\r\n&gt; --\r\n&gt; -- listBundlesWithFCFixes\r\n&gt; --\r\n&gt; --  Input arguments: None\r\n&gt; --\r\n&gt; -- USAGE EXAMPLE:\r\n&gt; -- 1. exec dbms_optim_bundle.listBundlesWithFCFixes;\r\n&gt; --    This will display all bundle-ids and names which have\r\n&gt; --    fixes with _fix_controls.\r\n&gt; --\r\n&gt; -- ERRORS:\r\n&gt; -- Application errors used are:\r\n&gt; --   -20001  user-supplied value error\r\n&gt; --   -20002  internal\/other errors\r\n&gt; PROCEDURE listBundlesWithFCFixes;\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE.12.1.0.2_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3089c3089,3090\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_REDEFINITION_INTERNAL.PACKAGE.12.1.0.2_BP\">SYS.DBMS_REDEFINITION_INTERNAL &#8211; PACKAGE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">306a307,333\r\n&gt;   \r\n&gt; \r\n&gt;   FUNCTION GET_IDX_NAME(CONS_NAME IN VARCHAR2,\r\n&gt;                         CONS_OWNER IN VARCHAR2)\r\n&gt;   RETURN VARCHAR2;\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 GET_INT_OBJ_NAME(RID           IN     PLS_INTEGER,\r\n&gt;                             OTYP          IN     PLS_INTEGER,\r\n&gt;                             O_OBJ_OWNER   IN     VARCHAR2,\r\n&gt;                             O_OBJ_NAME    IN     VARCHAR2)\r\n&gt;   RETURN VARCHAR2;\r\n&gt; \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE BODY.12.1.0.2_PSU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE BODY (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">8987a8988,9006\r\n&gt; \r\n&gt; \r\n&gt; FUNCTION KRBI_CREATE_XML RETURN VARCHAR2;\r\n&gt; PRAGMA INTERFACE (C, KRBI_CREATE_XML);\r\n&gt; \r\n&gt; FUNCTION CREATETEMPXMLFILE  RETURN VARCHAR2 IS \r\n&gt;    FNAME VARCHAR2(1024);\r\n&gt; BEGIN\r\n&gt;    ICDSTART(214);\r\n&gt;    FNAME := KRBI_CREATE_XML;\r\n&gt;    ICDFINISH;\r\n&gt;    RETURN FNAME;\r\n&gt; EXCEPTION\r\n&gt;    WHEN OTHERS THEN\r\n&gt;       ICDFINISH;\r\n&gt;       RAISE;\r\n&gt; END;\r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12,43d11\r\n&lt; PROCEDURE CREATE_DIRS  IS\r\n&lt;     L_HOME VARCHAR2(255);\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt; BEGIN\r\n&lt;     \r\n&lt;     SYS.DBMS_SYSTEM.GET_ENV('ORACLE_HOME', L_HOME);\r\n&lt; \r\n&lt;     \r\n&lt;     DIR := ADMINDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || ADMINDIR ||  ' as '''||L_HOME||'\/rdbms\/admin''';\r\n&lt; \r\n&lt;     DIR := LOGDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || LOGDIR || ' as '''||L_HOME||'\/cfgtoollogs''';\r\n&lt; \r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      \r\n&lt;      IF DIR = LOGDIR THEN\r\n&lt;        EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR; \r\n&lt;      END IF;\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', directory creation failed for ' || DIR);\r\n&lt; END CREATE_DIRS;\r\n&lt; \r\n&lt; \r\n&lt; PROCEDURE CLEANUP  IS\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt;     OBJID NUMBER;\r\n&lt;     CURSOR C1(NAME VARCHAR2) IS SELECT OBJECT_ID FROM ALL_OBJECTS \r\n&lt;      WHERE OBJECT_TYPE ='DIRECTORY' AND OBJECT_NAME=NAME;\r\n&lt; BEGIN\r\n&lt;   \r\n&lt;   DIR := ADMINDIR;\r\n45,62d12\r\n&lt;   OPEN C1(ADMINDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR;\r\n&lt;   END IF;\r\n&lt;   CLOSE C1;\r\n&lt;   \r\n&lt;   DIR := LOGDIR;\r\n&lt;   OPEN C1(LOGDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || LOGDIR;\r\n&lt;   END IF;\r\n&lt; \r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', cleanup failed for ' || DIR);\r\n&lt; END CLEANUP;\r\n67,71c17\r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; FUNCTION GET_LOGFILE_NAME RETURN SYS.V$SYSTEM_PARAMETER.VALUE%TYPE\r\n---\r\n&gt; FUNCTION GET_LOGFILE_NAME RETURN \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE\r\n74,75c20\r\n&lt;   LOGFILE  SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&lt; \r\n---\r\n&gt;   LOGFILE  \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n103a49\r\n&gt;      RETURN NULL;\r\n160,161d105\r\n&lt;       \r\n&lt;       CLEANUP;\r\n180,181d123\r\n&lt;     \r\n&lt;     CLEANUP;\r\n201c143\r\n&lt; FUNCTION PARSE_INPUT_FILE RETURN NUMBER_ARRAY IS\r\n---\r\n&gt; FUNCTION PARSE_INPUT_FILE RETURN FIX_CONTROL_DATA IS\r\n207a150\r\n&gt;   FCDATA  FIX_CONTROL_DATA;\r\n217c160,161\r\n&lt;   OPTIMBUGS := NUMBER_ARRAY();\r\n---\r\n&gt;   FCDATA.FIXES := NUMBER_ARRAY();\r\n&gt;   FCDATA.VALS := NUMBER_ARRAY();\r\n229,232c173,181\r\n&lt;         OPTIMBUGS.EXTEND();\r\n&lt;         OPTIMBUGS(OPTIMBUGS.COUNT) := XML.EXTRACT('\/bundlefcp\/bundle[' ||\r\n&lt;                                       P_COUNT || ']\/fcbuglist\/bug[' ||\r\n&lt;                                       C_COUNT || ']\/fix_control[' || GC_COUNT || ']\/text()').GETSTRINGVAL();\r\n---\r\n&gt;         FCDATA.FIXES.EXTEND();\r\n&gt;         FCDATA.FIXES(FCDATA.FIXES.COUNT) := XML.EXTRACT('\/bundlefcp\/bundle[' ||\r\n&gt;                                         P_COUNT || ']\/fcbuglist\/bug[' ||\r\n&gt;                                         C_COUNT || ']\/fix_control[' || GC_COUNT || ']\/text()').GETSTRINGVAL();\r\n&gt;         FCDATA.VALS.EXTEND();\r\n&gt;         FCDATA.VALS(FCDATA.VALS.COUNT)     := XML.EXTRACT('\/bundlefcp\/bundle[' ||\r\n&gt;                                         P_COUNT || ']\/fcbuglist\/bug[' ||\r\n&gt;                                         C_COUNT || ']\/fix_control[' || GC_COUNT || ']\/@default_value').GETSTRINGVAL();\r\n&gt; \r\n242c191\r\n&lt;   RETURN OPTIMBUGS;\r\n---\r\n&gt;   RETURN FCDATA;\r\n246,247d194\r\n&lt;      \r\n&lt;      CLEANUP;\r\n249c196\r\n&lt;      RETURN OPTIMBUGS;\r\n---\r\n&gt;      RETURN FCDATA;\r\n268c215\r\n&lt;   VALUE  VARCHAR2(10);\r\n---\r\n&gt;   STRVALUE  VARCHAR2(10);\r\n322c269\r\n&lt;       VALUE := SUBSTR(FIXSTRING, POS+1, LENGTH(FIXSTRING));\r\n---\r\n&gt;       STRVALUE := SUBSTR(FIXSTRING, POS+1, LENGTH(FIXSTRING));\r\n325,327c272,274\r\n&lt;       IF IS_NUMBER(VALUE) = 'Y' THEN\r\n&lt;         SPVALS(SPVALS.COUNT) := TO_NUMBER(VALUE);\r\n&lt;       ELSIF UPPER(VALUE)='OFF' THEN\r\n---\r\n&gt;       IF IS_NUMBER(STRVALUE) = 'Y' THEN\r\n&gt;         SPVALS(SPVALS.COUNT) := TO_NUMBER(STRVALUE);\r\n&gt;       ELSIF UPPER(STRVALUE)='OFF' THEN\r\n329c276\r\n&lt;       ELSIF UPPER(VALUE)='ON' THEN\r\n---\r\n&gt;       ELSIF UPPER(STRVALUE)='ON' THEN\r\n351,352d297\r\n&lt;      \r\n&lt;      CLEANUP;\r\n426,427d370\r\n&lt;      \r\n&lt;      CLEANUP;\r\n445c388\r\n&lt;     SELECT VALUE FROM SYS.V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n---\r\n&gt;     SELECT VALUE FROM \"PUBLIC\".V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n464c407\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in PUBLIC.v$system_fix_control'); \r\n469c412\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in PUBLIC.v$system_fix_control'); \r\n485,486d427\r\n&lt;      \r\n&lt;      CLEANUP;\r\n497,499c438,439\r\n&lt; PROCEDURE DISPLAY_ALTER_CMD(BUGSARRAY IN NUMBER_ARRAY, \r\n&lt;                         ACTION IN VARCHAR2, \r\n&lt;                         SCOPE IN VARCHAR2) \r\n---\r\n&gt; PROCEDURE DISPLAY_ALTER_CMD(BUNDDATA IN FIX_CONTROL_DATA, \r\n&gt;                             SCOPE IN VARCHAR2) \r\n503c443,445\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&gt;   BUGSARRAY NUMBER_ARRAY  := BUNDDATA.FIXES;\r\n&gt;   VALSARRAY NUMBER_ARRAY  := BUNDDATA.VALS;\r\n518c460\r\n&lt;       SQLCMD := SQLCMD || '''' || BUGSARRAY(I) ||':'|| ACTION || ''',';\r\n---\r\n&gt;       SQLCMD := SQLCMD || '''' || BUGSARRAY(I) ||':'|| VALSARRAY(I) || ''',';\r\n520c462\r\n&lt;       SQLCMD := SQLCMD || '''' || BUGSARRAY(I) ||':'|| ACTION || '''';\r\n---\r\n&gt;       SQLCMD := SQLCMD || '''' || BUGSARRAY(I) ||':'|| VALSARRAY(I) || '''';\r\n538,539d479\r\n&lt;      \r\n&lt;      CLEANUP;\r\n555c495\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n607,608d546\r\n&lt;      \r\n&lt;      CLEANUP;\r\n615c553\r\n&lt;   CURSOR C1 IS  SELECT COUNT(*) FROM GV$INSTANCE WHERE STATUS='OPEN';\r\n---\r\n&gt;   CURSOR C1 IS  SELECT COUNT(*) FROM SYS.GV$INSTANCE WHERE STATUS='OPEN';\r\n618c556\r\n&lt;   CURSOR C2 IS SELECT VALUE FROM V$PARAMETER WHERE NAME='cluster_database_instances';\r\n---\r\n&gt;   CURSOR C2 IS SELECT VALUE FROM \"PUBLIC\".V$PARAMETER WHERE NAME='cluster_database_instances';\r\n620c558\r\n&lt;   TOTAL_VAL  SYS.V$PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   TOTAL_VAL  \"PUBLIC\".V$PARAMETER.VALUE%TYPE;\r\n652,653d589\r\n&lt;     \r\n&lt;     CLEANUP;\r\n661c597\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n748c684\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n867c803\r\n&lt;    SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;    SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n981,983d916\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n994d926\r\n&lt;     CLEANUP;\r\n1004c936\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1040c972\r\n&lt;                'gv$system_fix_control where inst_id= ' || INSTID;\r\n---\r\n&gt;                'sys.gv$system_fix_control where inst_id= ' || INSTID;\r\n1102,1104d1033\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n1115d1043\r\n&lt;     CLEANUP;\r\n1142c1070\r\n&lt;     SELECT OPEN_MODE INTO OPENMODE FROM V$PDBS;\r\n---\r\n&gt;     SELECT OPEN_MODE INTO OPENMODE FROM \"PUBLIC\".V$PDBS;\r\n1165d1092\r\n&lt;     CLEANUP;\r\n1178d1104\r\n&lt;   BUNDARRAY NUMBER_ARRAY;\r\n1203c1129\r\n&lt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE \r\n---\r\n&gt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE \r\n1216d1141\r\n&lt;   INSTNAMEBIND VARCHAR2(20);\r\n1218c1143,1146\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&gt; \r\n&gt;   SPFILE_ERROR EXCEPTION;\r\n&gt;   PRAGMA EXCEPTION_INIT( SPFILE_ERROR, -32010 );\r\n1229a1158\r\n&gt; \r\n1233,1234c1162,1164\r\n&lt;  \r\n&lt;   CREATE_DIRS;\r\n---\r\n&gt;   \r\n&gt;   \r\n&gt;   BUNDDATA := PARSE_INPUT_FILE;\r\n1237c1167,1172\r\n&lt;   BUNDARRAY := PARSE_INPUT_FILE();\r\n---\r\n&gt;   \r\n&gt;   IF UPPER(ACTION)='OFF' THEN\r\n&gt;     FOR I IN 1..BUNDDATA.FIXES.COUNT LOOP\r\n&gt;       BUNDDATA.VALS(I) := 0;\r\n&gt;     END LOOP;\r\n&gt;   END IF;\r\n1239,1242c1174,1175\r\n&lt;   IF (BUNDARRAY.COUNT = 0) THEN\r\n&lt;     DBMS_OUTPUT.PUT_LINE(' No fixes with fix_controls applied as part of this bundle.');\r\n&lt;     \r\n&lt;     CLEANUP;\r\n---\r\n&gt;   IF (BUNDDATA.FIXES.COUNT = 0) THEN\r\n&gt;     DBMS_OUTPUT.PUT_LINE(' No fixes with fix_controls applied as part of bundles.');\r\n1249,1251c1182\r\n&lt;     DISPLAY_ALTER_CMD(BUNDARRAY, ACTION, SCOPE);\r\n&lt;     \r\n&lt;     CLEANUP;\r\n---\r\n&gt;     DISPLAY_ALTER_CMD(BUNDDATA, SCOPE);\r\n1256,1273d1186\r\n&lt;   BUNDDATA.FIXES := BUNDARRAY;\r\n&lt; \r\n&lt;   \r\n&lt;   BUNDDATA.VALS :=  NUMBER_ARRAY();\r\n&lt; \r\n&lt;   FOR I IN 1..BUNDARRAY.COUNT LOOP\r\n&lt; \r\n&lt;     BUNDDATA.VALS.EXTEND();\r\n&lt; \r\n&lt;     IF UPPER(ACTION)='OFF' THEN\r\n&lt;       BUNDDATA.VALS(I) := 0;\r\n&lt;     ELSIF UPPER(ACTION)='ON' THEN\r\n&lt;       BUNDDATA.VALS(I) := 1;\r\n&lt;     END IF;\r\n&lt; \r\n&lt;   END LOOP;\r\n&lt; \r\n&lt;   \r\n1293c1206\r\n&lt;   SELECT INSTANCE_NAME INTO INSTNAME FROM V$INSTANCE; \r\n---\r\n&gt;   SELECT INSTANCE_NAME INTO INSTNAME FROM \"PUBLIC\".V$INSTANCE; \r\n1365c1278\r\n&lt;        MEMVALARRAY  := GET_BUNDLE_FIXES_INMEMORY_VAL(BUNDARRAY,CON_ID);\r\n---\r\n&gt;        MEMVALARRAY  := GET_BUNDLE_FIXES_INMEMORY_VAL(BUNDDATA.FIXES, CON_ID);\r\n1369c1282\r\n&lt;         FINALMEMDATA.FIXES := BUNDARRAY;\r\n---\r\n&gt;         FINALMEMDATA.FIXES := BUNDDATA.FIXES;\r\n1374c1287\r\n&lt;         FINALMEMDATA.FIXES := BUNDARRAY;\r\n---\r\n&gt;         FINALMEMDATA.FIXES := BUNDDATA.FIXES;\r\n1380,1381c1293,1294\r\n&lt;       FOR I IN 1..BUNDARRAY.COUNT LOOP\r\n&lt;         FIXCONTROL := FIXCONTROL || BUNDARRAY(I) || ':' || MEMVALARRAY(I) || '  ';\r\n---\r\n&gt;       FOR I IN 1..BUNDDATA.FIXES.COUNT LOOP\r\n&gt;         FIXCONTROL := FIXCONTROL || BUNDDATA.FIXES(I) || ':' || MEMVALARRAY(I) || '  ';\r\n1393,1394c1306,1307\r\n&lt;       FOR I IN 1..BUNDARRAY.COUNT LOOP\r\n&lt;         FIXCONTROL := FIXCONTROL || BUNDARRAY(I) || ':' || FINALMEMDATA.VALS(I) || '  ';\r\n---\r\n&gt;       FOR I IN 1..BUNDDATA.FIXES.COUNT LOOP\r\n&gt;         FIXCONTROL := FIXCONTROL || BUNDDATA.FIXES(I) || ':' || FINALMEMDATA.VALS(I) || '  ';\r\n1479,1480c1392,1394\r\n&lt;             INSTNAMEBIND := '''' || INSTNAME || '''';\r\n&lt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' || INSTNAMEBIND || 'scope=spfile';\r\n---\r\n&gt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' ||  \r\n&gt;                          SYS.DBMS_ASSERT.ENQUOTE_LITERAL(INSTNAME) || \r\n&gt;                          ' scope=spfile';\r\n1484,1492c1398,1406\r\n&lt;             WHEN OTHERS THEN\r\n&lt;               \r\n&lt;               IF (SQLCODE NOT IN (-32010)) THEN\r\n&lt;                 UTL_FILE.FCLOSE(LOGF);\r\n&lt;                 CLEANUP;\r\n&lt;                 CLOSE C1;\r\n&lt;                 RAISE;\r\n&lt;               END IF;\r\n&lt;           END;\r\n---\r\n&gt;             \r\n&gt;             \r\n&gt;             WHEN SPFILE_ERROR THEN\r\n&gt;               NULL;  \r\n&gt;             WHEN OTHERS THEN   \r\n&gt;               UTL_FILE.FCLOSE(LOGF);\r\n&gt;               CLOSE C1;\r\n&gt;               RAISE;\r\n&gt;             END; \r\n1509,1511d1422\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1517,1518d1427\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1542,1544d1450\r\n&lt;   CREATE_DIRS;\r\n&lt; \r\n&lt;   \r\n1558a1465,1469\r\n&gt;   IF P_COUNT = 1 THEN\r\n&gt;     DBMS_OUTPUT.PUT_LINE( CHR(10) || 'Bundles with fixes which can cause plan changes not applied yet');\r\n&gt;     RETURN;\r\n&gt;   END IF;\r\n&gt; \r\n1570,1572c1481,1483\r\n&lt;    DBMS_OUTPUT.PUT_LINE(CHR(10) || 'Either invalid bundle-id or no fixes '\r\n&lt;                     || 'with fix_controls added in corresponding bundle');\r\n&lt;    CLEANUP;\r\n---\r\n&gt;    DBMS_OUTPUT.PUT_LINE(CHR(10) || 'Invalid input value, please execute '\r\n&gt;                                 || 'dbms_optim_bundle.listBundlesWithFCFixes '\r\n&gt;                                 || 'to get list of valid bundleId values');\r\n1652,1654d1562\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1657,1658d1564\r\n&lt;      \r\n&lt;      CLEANUP;\r\n1661a1568,1601\r\n&gt; \r\n&gt; \r\n&gt; PROCEDURE LISTBUNDLESWITHFCFIXES\r\n&gt; IS\r\n&gt;   XCLOB CLOB;\r\n&gt;   XML XMLTYPE;\r\n&gt;   BUNDLEID NUMBER;\r\n&gt;   P_COUNT NUMBER := 1;   \r\n&gt;   BUNDLENAME VARCHAR2(100);\r\n&gt; BEGIN\r\n&gt; \r\n&gt;   \r\n&gt;   XCLOB := GETDOCUMENT(INPUTFILE);\r\n&gt; \r\n&gt;   \r\n&gt;   XML := XMLTYPE.CREATEXML(XCLOB);\r\n&gt; \r\n&gt;   \r\n&gt;   WHILE XML.EXISTSNODE('\/bundlefcp\/bundle[' || P_COUNT || ']') = 1 LOOP\r\n&gt;     BUNDLEID := TO_NUMBER(XML.EXTRACT('\/bundlefcp\/bundle[' || P_COUNT || ']\/@id').GETSTRINGVAL());\r\n&gt;     BUNDLENAME := XML.EXTRACT('\/bundlefcp\/bundle[' || P_COUNT || ']\/@description').GETSTRINGVAL();\r\n&gt;     DBMS_OUTPUT.PUT_LINE('bundleId: ' || BUNDLEID || ',  bundleName: ' || BUNDLENAME);\r\n&gt;     P_COUNT := P_COUNT + 1;\r\n&gt;   END LOOP;\r\n&gt; \r\n&gt;   IF P_COUNT = 1 THEN\r\n&gt;     DBMS_OUTPUT.PUT_LINE(CHR(10) || 'Bundles with fixes which can cause plan changes not applied yet');\r\n&gt;   END IF;\r\n&gt; \r\n&gt; EXCEPTION\r\n&gt;    WHEN OTHERS THEN\r\n&gt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', listBundles Error ');\r\n&gt; END LISTBUNDLESWITHFCFIXES;\r\n&gt; \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\">16711c16711,16712\r\n&lt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I\r\n---\r\n&gt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I,\r\n&gt;                V$DATABASE DB\r\n16727a16729\r\n&gt;             AND L.NEXT_CHANGE# &gt;= DB.STANDBY_BECAME_PRIMARY_SCN\r\n25871a25874,25881\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' ||\r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_plugin_change#=' ||\r\n&gt;                              LBREC.DF_PLUGIN_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n25878,25880c25888,25896\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((LBREC.DF_PLUGIN_CHANGE# &gt; LBREC.DF_CREATION_CHANGE#) AND\r\n&gt;                    (LBREC.DF_PLUGIN_CHANGE# &lt;= UNTILSCN))  OR\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.12.1.0.2_PSU\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (PSU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">7209c7209,7210\r\n&lt;   ,PATTERN4     IN VARCHAR2)\r\n---\r\n&gt;   ,PATTERN4       IN VARCHAR2\r\n&gt;   ,BACKEDUPANYSCN IN NUMBER)\r\n7210a7212,7225\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\n7246,7250c7261,7272\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\n7283,7284c7305,7307\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\n7384,7388c7407,7418\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\n7394,7395c7424,7426\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\n16593c16624,16625\r\n&lt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I\r\n---\r\n&gt;           FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATABASE_INCARNATION I,\r\n&gt;                V$DATABASE DB\r\n16609a16642\r\n&gt;             AND L.NEXT_CHANGE# &gt;= DB.STANDBY_BECAME_PRIMARY_SCN\r\n25542a25576,25581\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' ||\r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n25549,25551c25588,25594\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n26694c26737,26738\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\n26706a26751\r\n&gt;    BACKEDUPANYSCN     NUMBER;\r\n26709a26755,26764\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\n26714a26770\r\n&gt;    \r\n26722c26778,26779\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_REDEFINITION.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_REDEFINITION &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">123a124,144\r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   PROCEDURE IS_USER_CREATED(TABOWNER      IN     VARCHAR2,\r\n&gt;                             TABNM         IN     VARCHAR2,\r\n&gt;                             INDEX_NAME    IN     VARCHAR2,\r\n&gt;                             IS_USER_CRTD  OUT    PLS_INTEGER) IS\r\n&gt;   EXTERNAL\r\n&gt;     NAME \"kkziIsUserCreatedIdx\"\r\n&gt;     LIBRARY DBMS_SNAPSHOT_LIB\r\n&gt;     WITH CONTEXT\r\n&gt;     PARAMETERS(CONTEXT,\r\n&gt;                TABOWNER         STRING,  TABOWNER LENGTH SB2,\r\n&gt;                TABNM            STRING,  TABNM LENGTH SB2,\r\n&gt;                INDEX_NAME       STRING,  INDEX_NAME  LENGTH SB2,\r\n&gt;                IS_USER_CRTD     UB1)\r\n&gt;   LANGUAGE C;\r\n1012a1034,1037\r\n&gt;   IDX_NAME            VARCHAR(128);\r\n&gt;   IDX_INT_NAME        VARCHAR(2000);\r\n&gt;   IS_INDEX_USER_CRTD  PLS_INTEGER := 0;\r\n&gt;   USING_INDEX         BOOLEAN :=FALSE;\r\n1129a1155,1177\r\n&gt;     \r\n&gt;     \r\n&gt; \r\n&gt;     IF (OBJ_TYPE = DBMS_REDEFINITION.CONS_CONSTRAINT) THEN\r\n&gt;       IDX_NAME := DBMS_REDEFINITION_INTERNAL.GET_IDX_NAME(O_OBJ_NAME, O_OBJ_OWNER);\r\n&gt;       IF (IDX_NAME IS NOT NULL) THEN\r\n&gt;         \r\n&gt;         IS_USER_CREATED( O_OBJ_OWNER, O_BT_NAME, IDX_NAME, IS_INDEX_USER_CRTD);\r\n&gt;         IF (IS_INDEX_USER_CRTD = 1) THEN\r\n&gt;            IDX_INT_NAME := DBMS_REDEFINITION_INTERNAL.GET_INT_OBJ_NAME(RID,\r\n&gt;                            DBMS_REDEFINITION.CONS_INDEX,O_OBJ_OWNER,IDX_NAME);\r\n&gt;            \r\n&gt;            IF ( IDX_INT_NAME IS NOT NULL) THEN\r\n&gt;              T_HANDLE:= DBMS_METADATA.ADD_TRANSFORM(HANDLE, 'MODIFY');\r\n&gt;              DBMS_METADATA.SET_REMAP_PARAM(T_HANDLE,'REMAP_NAME',IDX_NAME,\r\n&gt;                                            IDX_INT_NAME);\r\n&gt;              USING_INDEX := TRUE;\r\n&gt;            END IF;\r\n&gt;         END IF;\r\n&gt;        END IF;\r\n&gt;     END IF;\r\n&gt; \r\n&gt;     \r\n1137c1185,1189\r\n&lt;       DBMS_METADATA.SET_TRANSFORM_PARAM(DHANDLE,'INDEX_BY_NAME',FALSE);\r\n---\r\n&gt;       IF ( USING_INDEX ) THEN\r\n&gt;         DBMS_METADATA.SET_TRANSFORM_PARAM(DHANDLE,'INDEX_BY_NAME',TRUE);\r\n&gt;       ELSE\r\n&gt;         DBMS_METADATA.SET_TRANSFORM_PARAM(DHANDLE,'INDEX_BY_NAME',FALSE);\r\n&gt;       END IF;\r\n1144c1196,1202\r\n&lt;         DBMS_METADATA.SET_TRANSFORM_PARAM(DHANDLE,'ONLINE_REDEF',TRUE);\r\n---\r\n&gt;         IF (NOT USING_INDEX) THEN\r\n&gt;           DBMS_METADATA.SET_TRANSFORM_PARAM(DHANDLE,'ONLINE_REDEF',TRUE);\r\n&gt;         END IF;\r\n&gt;         \r\n&gt;         \r\n&gt;         \r\n&gt;         \r\n<\/pre>\n<div id=\"SYS.DBMS_REDEFINITION_INTERNAL.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_REDEFINITION_INTERNAL &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">46a47,69\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 GET_IDX_NAME(CONS_NAME IN VARCHAR2,\r\n&gt;                         CONS_OWNER IN VARCHAR2) RETURN VARCHAR2 IS\r\n&gt;     IDX_NAME VARCHAR2(128);\r\n&gt;   BEGIN\r\n&gt;     SELECT INDEX_NAME INTO IDX_NAME\r\n&gt;     FROM  DBA_CONSTRAINTS\r\n&gt;     WHERE CONSTRAINT_NAME=CONS_NAME AND OWNER=CONS_OWNER;\r\n&gt;     RETURN IDX_NAME;\r\n&gt;   EXCEPTION\r\n&gt;     WHEN NO_DATA_FOUND THEN\r\n&gt;       RETURN NULL;\r\n&gt;     WHEN OTHERS THEN\r\n&gt;       RETURN NULL;\r\n&gt;   END;\r\n&gt; \r\n53a77,105\r\n&gt;   \r\n&gt;   \r\n&gt;   FUNCTION GET_INT_OBJ_NAME(RID           IN     PLS_INTEGER,\r\n&gt;                             OTYP          IN     PLS_INTEGER,\r\n&gt;                             O_OBJ_OWNER   IN     VARCHAR2,\r\n&gt;                             O_OBJ_NAME    IN     VARCHAR2)\r\n&gt;   RETURN VARCHAR2 IS\r\n&gt;     INT_OBJ_NAME VARCHAR2(2000);\r\n&gt;   BEGIN\r\n&gt;     SELECT INT_OBJ_NAME INTO INT_OBJ_NAME\r\n&gt;     FROM SYS.REDEF_OBJECT$\r\n&gt;     WHERE REDEF_ID = RID\r\n&gt;     AND OBJ_TYPE = OTYP\r\n&gt;     AND OBJ_OWNER = O_OBJ_OWNER\r\n&gt;     AND OBJ_NAME = O_OBJ_NAME;\r\n&gt;     RETURN INT_OBJ_NAME;\r\n&gt;   EXCEPTION\r\n&gt;     WHEN NO_DATA_FOUND THEN\r\n&gt;       RETURN NULL;\r\n&gt;     WHEN OTHERS THEN\r\n&gt;       RETURN NULL;\r\n&gt;   END;\r\n&gt;  \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n&gt;   \r\n<\/pre>\n<div id=\"SYS.DBMS_STATS.PACKAGE BODY.12.1.0.2_BP\">SYS.DBMS_STATS &#8211; PACKAGE BODY (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">32494c32494,32498\r\n&lt;         MULTI_COMPART := TRUE;\r\n---\r\n&gt;         \r\n&gt;         \r\n&gt;         IF (PNAME IS NULL) THEN\r\n&gt;           MULTI_COMPART := TRUE;\r\n&gt;         END IF;\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.12.1.0.2_BP\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_bugValObType as object(fix number, val number)\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_bugValObType FORCE as object(fix number, val number);\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_FCTABTYPE.TYPE.12.1.0.2_BP\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE (BP):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_fcTabType as table of dbms_optim_bugValObType\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_fcTabType as table of dbms_optim_bugValObType;\r\n&gt; \r\n<\/pre>\n<h3><strong>12.2.0.1<\/strong><\/h3>\n<div id=\"DVSYS.KU$_DV_COMMAND_RULE_T.TYPE.12.2.0.1_RU\">DVSYS.KU$_DV_COMMAND_RULE_T &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">4a5\r\n&gt;   oidval          raw(16),                                     \/* unique id *\/\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072649$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072649$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2c2\r\n&lt; type         \"SYS_YOID0000072649$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE))\r\n---\r\n&gt; type         \"SYS_YOID0000072649$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072661$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072661$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2c2\r\n&lt; type         \"SYS_YOID0000072661$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE))\r\n---\r\n&gt; type         \"SYS_YOID0000072661$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072664$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072664$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1,2c1,2\r\n&lt; type         \"SYS_YOID0000072664$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" NUMBER)\r\n&lt; type         \"SYS_YOID0000072664$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" NUMBER)\r\n---\r\n&gt; type         \"SYS_YOID0000072664$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n&gt; type         \"SYS_YOID0000072664$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072667$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072667$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2c2\r\n&lt; type         \"SYS_YOID0000072667$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(100 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE), \"SYS_NC00005$\" VARCHAR2(128 BYTE), \"SYS_NC00006$\" VARCHAR2(128 BYTE), \"SYS_NC00007$\" NUMBER)\r\n---\r\n&gt; type         \"SYS_YOID0000072667$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072694$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072694$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2c2\r\n&lt; type         \"SYS_YOID0000072694$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE))\r\n---\r\n&gt; type         \"SYS_YOID0000072694$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072697$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072697$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2c2\r\n&lt; type         \"SYS_YOID0000072697$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(100 BYTE), \"SYS_NC00004$\" VARCHAR2(128 BYTE), \"SYS_NC00005$\" VARCHAR2(128 BYTE), \"SYS_NC00006$\" VARCHAR2(128 BYTE), \"SYS_NC00007$\" VARCHAR2(128 BYTE))\r\n---\r\n&gt; type         \"SYS_YOID0000072697$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.SYS_YOID0000072870$.TYPE.12.2.0.1_RU\">DVSYS.SYS_YOID0000072870$ &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1\r\n&lt; type         \"SYS_YOID0000072870$\"              as object( \"SYS_NC00001$\" VARCHAR2(128 BYTE), \"SYS_NC00002$\" VARCHAR2(128 BYTE), \"SYS_NC00003$\" VARCHAR2(128 BYTE), \"SYS_NC00004$\" NUMBER)\r\n---\r\n&gt; type         \"SYS_YOID0000072870$\"              as object( \"SYS_NC00001$\" RAW(16))\r\n<\/pre>\n<div id=\"DVSYS.KU$_DV_COMMAND_RULE_VIEW.VIEW.12.2.0.1_RU\">DVSYS.KU$_DV_COMMAND_RULE_VIEW &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1\r\n&lt; select '0','0',\r\n---\r\n&gt; select '0','0', sys_guid(),\r\n<\/pre>\n<div id=\"SYS.DBMS_HADOOP.PACKAGE.12.2.0.1_RU\">SYS.DBMS_HADOOP &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">60a61,65\r\n&gt; FUNCTION GET_USER_MAP(cluster_name  IN VARCHAR2 DEFAULT '[DEFAULT]',\r\n&gt;                       current_database_user IN VARCHAR2)  -- NOT NULL\r\n&gt;                  RETURN VARCHAR2;\r\n&gt; \r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">15a16,20\r\n&gt; \r\n&gt; \r\n&gt; ----------------------------\r\n&gt; --  PROCEDURES AND FUNCTIONS\r\n&gt; ----------------------------\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\">189a190,191\r\n&gt;     -- Bug 29339155: Check for remoteowner being null to avoid ORA-1422 error\r\n&gt;     -- if there were remote PL\/SQL objects depending on oldview.\r\n192c194,195\r\n&lt;                         ' AND TYPE# in (2, 4) and owner# = :2'\r\n---\r\n&gt;                         ' AND TYPE# in (2, 4) and owner# = :2' ||\r\n&gt;                         ' AND REMOTEOWNER is null'\r\n<\/pre>\n<div id=\"SYS.DBMS_HADOOP.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_HADOOP &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">198c198,251\r\n&lt; END;\r\n---\r\n&gt;  \r\n&gt;  \r\n&gt;  \r\n&gt;  \r\n&gt;  \r\n&gt;  FUNCTION GET_USER_MAP(CLUSTER_NAME   IN VARCHAR2 DEFAULT '[DEFAULT]',\r\n&gt;                            CURRENT_DATABASE_USER  IN VARCHAR2)\r\n&gt;                  RETURN VARCHAR2\r\n&gt;   IS\r\n&gt;      TABLE_DOES_NOT_EXIST EXCEPTION;\r\n&gt;      PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942);\r\n&gt;      HDFS_USER_OUT VARCHAR2(128);\r\n&gt;      NAMESPACE VARCHAR2(128);\r\n&gt;      PARM_HADOOP VARCHAR2(128);\r\n&gt;      CURRENT_DATABASE_USER_U VARCHAR2(128) := CURRENT_DATABASE_USER;\r\n&gt;      DEFAULT_CLUSTER_NAME CONSTANT VARCHAR2(9) := '[DEFAULT]';\r\n&gt;      STOPPER_AT CONSTANT CHAR := '@';\r\n&gt;      STOPPER_SLASH CONSTANT CHAR := '\/';\r\n&gt;      AT_LOC PLS_INTEGER;\r\n&gt;      SLASH_LOC PLS_INTEGER;\r\n&gt;      FOUND BOOLEAN;\r\n&gt;      CNT PLS_INTEGER;\r\n&gt;      USE_LEN PLS_INTEGER;\r\n&gt;      USE_THIS_CLUSTER_NAME VARCHAR2(128);\r\n&gt;      MAPPING VARCHAR2(128);\r\n&gt;      MAP_OUT VARCHAR2(128);\r\n&gt;      RC PLS_INTEGER;\r\n&gt;      TRUEORFALSE CHAR(5);\r\n&gt;   BEGIN\r\n&gt;      \r\n&gt;      SELECT SYS_CONTEXT('USERENV', 'ISDBA') INTO TRUEORFALSE FROM DUAL;\r\n&gt; \r\n&gt;      IF TRUEORFALSE != 'TRUE' AND\r\n&gt;         NOT DBMS_SESSION.IS_ROLE_ENABLED('BDSQL_USER') THEN\r\n&gt;         \r\n&gt;         RETURN NULL;\r\n&gt;      END IF;\r\n&gt;      IF CLUSTER_NAME &lt;&gt; DEFAULT_CLUSTER_NAME  THEN\r\n&gt;         USE_THIS_CLUSTER_NAME := CLUSTER_NAME;\r\n&gt;      ELSE\r\n&gt;         USE_THIS_CLUSTER_NAME := DEFAULT_CLUSTER_NAME;\r\n&gt;      END IF;\r\n&gt;     \r\n&gt;      HDFS_USER_OUT := NULL;\r\n&gt;      DBMS_BDSQL.SEL_USERMAP(USE_THIS_CLUSTER_NAME,  CURRENT_DATABASE_USER,\r\n&gt;                             MAPPING, RC);\r\n&gt;      HDFS_USER_OUT := MAPPING;\r\n&gt;      IF (MAPPING IS NULL) THEN MAP_OUT := '&lt;&lt;NULL&gt;&gt;'; \r\n&gt;      ELSE MAP_OUT := MAPPING; END IF;\r\n&gt;      RETURN MAPPING; \r\n&gt; \r\n&gt;   END GET_USER_MAP;\r\n&gt; \r\n&gt; END DBMS_HADOOP;\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12,21d11\r\n&lt; PROCEDURE CREATE_DIRS  IS\r\n&lt;     L_HOME VARCHAR2(255);\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt; BEGIN\r\n&lt;     \r\n&lt;     SYS.DBMS_SYSTEM.GET_ENV('ORACLE_HOME', L_HOME);\r\n&lt; \r\n&lt;     \r\n&lt;     DIR := ADMINDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || ADMINDIR ||  ' as '''||L_HOME||'\/rdbms\/admin''';\r\n23,33d12\r\n&lt;     DIR := LOGDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || LOGDIR || ' as '''||L_HOME||'\/cfgtoollogs''';\r\n&lt; \r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      \r\n&lt;      IF DIR = LOGDIR THEN\r\n&lt;        EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR; \r\n&lt;      END IF;\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', directory creation failed for ' || DIR);\r\n&lt; END CREATE_DIRS;\r\n36,43d14\r\n&lt; PROCEDURE CLEANUP  IS\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt;     OBJID NUMBER;\r\n&lt;     CURSOR C1(OBJNAME VARCHAR2) IS SELECT OBJECT_ID FROM ALL_OBJECTS \r\n&lt;      WHERE OBJECT_TYPE ='DIRECTORY' AND OBJECT_NAME=OBJNAME;\r\n&lt; BEGIN\r\n&lt;   \r\n&lt;   DIR := ADMINDIR;\r\n45,57d15\r\n&lt;   OPEN C1(ADMINDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR;\r\n&lt;   END IF;\r\n&lt;   CLOSE C1;\r\n&lt;   \r\n&lt;   DIR := LOGDIR;\r\n&lt;   OPEN C1(LOGDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || LOGDIR;\r\n&lt;   END IF;\r\n59,71c17\r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', cleanup failed for ' || DIR);\r\n&lt; END CLEANUP;\r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; FUNCTION GET_LOGFILE_NAME RETURN SYS.V$SYSTEM_PARAMETER.VALUE%TYPE\r\n---\r\n&gt; FUNCTION GET_LOGFILE_NAME RETURN \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE\r\n74,75c20\r\n&lt;   LOGFILE  SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&lt; \r\n---\r\n&gt;   LOGFILE  \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n161,162d105\r\n&lt;       \r\n&lt;       CLEANUP;\r\n181,182d123\r\n&lt;     \r\n&lt;     CLEANUP;\r\n254,255d194\r\n&lt;      \r\n&lt;      CLEANUP;\r\n359,360d297\r\n&lt;      \r\n&lt;      CLEANUP;\r\n434,435d370\r\n&lt;      \r\n&lt;      CLEANUP;\r\n453c388\r\n&lt;     SELECT VALUE FROM SYS.V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n---\r\n&gt;     SELECT VALUE FROM \"PUBLIC\".V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n472c407\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in PUBLIC.v$system_fix_control'); \r\n477c412\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in PUBLIC.v$system_fix_control'); \r\n493,494d427\r\n&lt;      \r\n&lt;      CLEANUP;\r\n510c443\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n547,548d479\r\n&lt;      \r\n&lt;      CLEANUP;\r\n564c495\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n616,617d546\r\n&lt;      \r\n&lt;      CLEANUP;\r\n624c553\r\n&lt;   CURSOR C1 IS  SELECT COUNT(*) FROM GV$INSTANCE WHERE STATUS='OPEN';\r\n---\r\n&gt;   CURSOR C1 IS  SELECT COUNT(*) FROM SYS.GV$INSTANCE WHERE STATUS='OPEN';\r\n627c556\r\n&lt;   CURSOR C2 IS SELECT VALUE FROM V$PARAMETER WHERE NAME='cluster_database_instances';\r\n---\r\n&gt;   CURSOR C2 IS SELECT VALUE FROM \"PUBLIC\".V$PARAMETER WHERE NAME='cluster_database_instances';\r\n629c558\r\n&lt;   TOTAL_VAL  SYS.V$PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   TOTAL_VAL  \"PUBLIC\".V$PARAMETER.VALUE%TYPE;\r\n661,662d589\r\n&lt;     \r\n&lt;     CLEANUP;\r\n670c597\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n757c684\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n876c803\r\n&lt;    SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;    SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n990,992d916\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n1003d926\r\n&lt;     CLEANUP;\r\n1013c936\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1049c972\r\n&lt;                'gv$system_fix_control where inst_id= ' || INSTID;\r\n---\r\n&gt;                'sys.gv$system_fix_control where inst_id= ' || INSTID;\r\n1111,1113d1033\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n1124d1043\r\n&lt;     CLEANUP;\r\n1151c1070\r\n&lt;     SELECT OPEN_MODE INTO OPENMODE FROM V$PDBS;\r\n---\r\n&gt;     SELECT OPEN_MODE INTO OPENMODE FROM \"PUBLIC\".V$PDBS;\r\n1174d1092\r\n&lt;     CLEANUP;\r\n1211c1129\r\n&lt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE \r\n---\r\n&gt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE \r\n1224d1141\r\n&lt;   INSTNAMEBIND VARCHAR2(20);\r\n1226c1143\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n1245,1247d1161\r\n&lt;  \r\n&lt;   CREATE_DIRS;\r\n&lt; \r\n1262,1263d1175\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1271,1272d1182\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1296c1206\r\n&lt;   SELECT INSTANCE_NAME INTO INSTNAME FROM V$INSTANCE; \r\n---\r\n&gt;   SELECT INSTANCE_NAME INTO INSTNAME FROM \"PUBLIC\".V$INSTANCE; \r\n1482,1483c1392,1394\r\n&lt;             INSTNAMEBIND := '''' || INSTNAME || '''';\r\n&lt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' || INSTNAMEBIND || 'scope=spfile';\r\n---\r\n&gt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' ||  \r\n&gt;                          SYS.DBMS_ASSERT.ENQUOTE_LITERAL(INSTNAME) || \r\n&gt;                          ' scope=spfile';\r\n1493d1403\r\n&lt;               CLEANUP;\r\n1513,1515d1422\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1521,1522d1427\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1546,1548d1450\r\n&lt;   CREATE_DIRS;\r\n&lt; \r\n&lt;   \r\n1565d1466\r\n&lt;     CLEANUP;\r\n1583d1483\r\n&lt;    CLEANUP;\r\n1663,1665d1562\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1668,1669d1564\r\n&lt;      \r\n&lt;      CLEANUP;\r\n1683,1684d1577\r\n&lt;   \r\n&lt;   CREATE_DIRS;\r\n1704,1705d1596\r\n&lt;   \r\n&lt;   CLEANUP;\r\n1708,1709d1598\r\n&lt;      \r\n&lt;      CLEANUP;\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\">26504a26505,26512\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' ||\r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_plugin_change#=' || \r\n&gt;                              LBREC.DF_PLUGIN_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n26511,26513c26519,26527\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((LBREC.DF_PLUGIN_CHANGE# &gt; LBREC.DF_CREATION_CHANGE#) AND\r\n&gt;                    (LBREC.DF_PLUGIN_CHANGE# &lt;= UNTILSCN))  OR\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.12.2.0.1_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_bugValObType FORCE as object(fix number, val number);\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_bugValObType FORCE as object(fix number, val number);\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_FCTABTYPE.TYPE.12.2.0.1_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_fcTabType as table of dbms_optim_bugValObType;\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_fcTabType as table of dbms_optim_bugValObType;\r\n&gt; \r\n<\/pre>\n<h3><strong>18.0.0.0<\/strong><\/h3>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.18.0.0.0_18.6RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (18.6RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12c12\r\n&lt;   bannerVersion CONSTANT VARCHAR2(15) := '18.06.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.06.01.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.06.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.06.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.06.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.06.01.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.06.01.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.06.01.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.06.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.06.01.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.06.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.06.01.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.06.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.06.01.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.06.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.06.01.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.06.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.05.02.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.06.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.06.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.06.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.05.02.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.05.02.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.05.02.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.06.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.05.02.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.06.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.05.02.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.06.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.05.02.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.06.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.05.02.00',  psn + 1));\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.06.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '18.07.00.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('18.06.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('18.06.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('18.06.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('18.07.00.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('18.07.00.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('18.07.00.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('18.06.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('18.07.00.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('18.06.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('18.07.00.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('18.06.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('18.07.00.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('18.06.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('18.07.00.00',  psn + 1));\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">15a16,20\r\n&gt; \r\n&gt; \r\n&gt; ----------------------------\r\n&gt; --  PROCEDURES AND FUNCTIONS\r\n&gt; ----------------------------\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.6.0.0.0';\r\n---\r\n&gt;                                '18.5.2.0.0';\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.6.0.0.0';\r\n---\r\n&gt;                                '18.7.0.0.0';\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.18.0.0.0_18.6RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE (18.6RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">13c13\r\n&lt;                                '18.6.0.0.0';\r\n---\r\n&gt;                                '18.6.1.0.0';\r\n<\/pre>\n<div id=\"SYS.CDBVIEW_INTERNAL.PACKAGE BODY.18.0.0.0_RU\">SYS.CDBVIEW_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">197a198,199\r\n&gt;     -- Bug 29339155: Check for remoteowner being null to avoid ORA-1422 error\r\n&gt;     -- if there were remote PL\/SQL objects depending on oldview.\r\n200c202,203\r\n&lt;                         ' AND TYPE# in (2, 4) and owner# = :2'\r\n---\r\n&gt;                         ' AND TYPE# in (2, 4) and owner# = :2' ||\r\n&gt;                         ' AND REMOTEOWNER is null'\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12,21d11\r\n&lt; PROCEDURE CREATE_DIRS  IS\r\n&lt;     L_HOME VARCHAR2(255);\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt; BEGIN\r\n&lt;     \r\n&lt;     SYS.DBMS_SYSTEM.GET_ENV('ORACLE_HOME', L_HOME);\r\n&lt; \r\n&lt;     \r\n&lt;     DIR := ADMINDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || ADMINDIR ||  ' as '''||L_HOME||'\/rdbms\/admin''';\r\n23,33d12\r\n&lt;     DIR := LOGDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || LOGDIR || ' as '''||L_HOME||'\/cfgtoollogs''';\r\n&lt; \r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      \r\n&lt;      IF DIR = LOGDIR THEN\r\n&lt;        EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR; \r\n&lt;      END IF;\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', directory creation failed for ' || DIR);\r\n&lt; END CREATE_DIRS;\r\n36,43d14\r\n&lt; PROCEDURE CLEANUP  IS\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt;     OBJID NUMBER;\r\n&lt;     CURSOR C1(OBJNAME VARCHAR2) IS SELECT OBJECT_ID FROM ALL_OBJECTS \r\n&lt;      WHERE OBJECT_TYPE ='DIRECTORY' AND OBJECT_NAME=OBJNAME;\r\n&lt; BEGIN\r\n&lt;   \r\n&lt;   DIR := ADMINDIR;\r\n45,57d15\r\n&lt;   OPEN C1(ADMINDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR;\r\n&lt;   END IF;\r\n&lt;   CLOSE C1;\r\n&lt;   \r\n&lt;   DIR := LOGDIR;\r\n&lt;   OPEN C1(LOGDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || LOGDIR;\r\n&lt;   END IF;\r\n59,71c17\r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', cleanup failed for ' || DIR);\r\n&lt; END CLEANUP;\r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; \r\n&lt; FUNCTION GET_LOGFILE_NAME RETURN SYS.V$SYSTEM_PARAMETER.VALUE%TYPE\r\n---\r\n&gt; FUNCTION GET_LOGFILE_NAME RETURN \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE\r\n74,75c20\r\n&lt;   LOGFILE  SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&lt; \r\n---\r\n&gt;   LOGFILE  \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n161,162d105\r\n&lt;       \r\n&lt;       CLEANUP;\r\n181,182d123\r\n&lt;     \r\n&lt;     CLEANUP;\r\n254,255d194\r\n&lt;      \r\n&lt;      CLEANUP;\r\n362,363d300\r\n&lt;      \r\n&lt;      CLEANUP;\r\n437,438d373\r\n&lt;      \r\n&lt;      CLEANUP;\r\n456c391\r\n&lt;     SELECT VALUE FROM SYS.V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n---\r\n&gt;     SELECT VALUE FROM \"PUBLIC\".V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n475c410\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in PUBLIC.v$system_fix_control'); \r\n480c415\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in v$system_fix_control'); \r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in PUBLIC.v$system_fix_control'); \r\n496,497d430\r\n&lt;      \r\n&lt;      CLEANUP;\r\n513c446\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n550,551d482\r\n&lt;      \r\n&lt;      CLEANUP;\r\n567c498\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n619,620d549\r\n&lt;      \r\n&lt;      CLEANUP;\r\n627c556\r\n&lt;   CURSOR C1 IS  SELECT COUNT(*) FROM GV$INSTANCE WHERE STATUS='OPEN';\r\n---\r\n&gt;   CURSOR C1 IS  SELECT COUNT(*) FROM SYS.GV$INSTANCE WHERE STATUS='OPEN';\r\n630c559\r\n&lt;   CURSOR C2 IS SELECT VALUE FROM V$PARAMETER WHERE NAME='cluster_database_instances';\r\n---\r\n&gt;   CURSOR C2 IS SELECT VALUE FROM \"PUBLIC\".V$PARAMETER WHERE NAME='cluster_database_instances';\r\n632c561\r\n&lt;   TOTAL_VAL  SYS.V$PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   TOTAL_VAL  \"PUBLIC\".V$PARAMETER.VALUE%TYPE;\r\n664,665d592\r\n&lt;     \r\n&lt;     CLEANUP;\r\n673c600\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n760c687\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n882c809\r\n&lt;    SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;    SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1002,1004d928\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n1015d938\r\n&lt;     CLEANUP;\r\n1025c948\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1061c984\r\n&lt;                'gv$system_fix_control where inst_id= ' || INSTID;\r\n---\r\n&gt;                'sys.gv$system_fix_control where inst_id= ' || INSTID;\r\n1123,1125d1045\r\n&lt;     \r\n&lt;     CLEANUP;\r\n&lt; \r\n1136d1055\r\n&lt;     CLEANUP;\r\n1163c1082\r\n&lt;     SELECT OPEN_MODE INTO OPENMODE FROM V$PDBS;\r\n---\r\n&gt;     SELECT OPEN_MODE INTO OPENMODE FROM \"PUBLIC\".V$PDBS;\r\n1186d1104\r\n&lt;     CLEANUP;\r\n1223c1141\r\n&lt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE \r\n---\r\n&gt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE \r\n1236d1153\r\n&lt;   INSTNAMEBIND VARCHAR2(20);\r\n1238c1155\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n1257,1259d1173\r\n&lt;  \r\n&lt;   CREATE_DIRS;\r\n&lt; \r\n1274,1275d1187\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1283,1284d1194\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1308c1218\r\n&lt;   SELECT INSTANCE_NAME INTO INSTNAME FROM V$INSTANCE; \r\n---\r\n&gt;   SELECT INSTANCE_NAME INTO INSTNAME FROM \"PUBLIC\".V$INSTANCE; \r\n1494,1495c1404,1406\r\n&lt;             INSTNAMEBIND := '''' || INSTNAME || '''';\r\n&lt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' || INSTNAMEBIND || 'scope=spfile';\r\n---\r\n&gt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' ||  \r\n&gt;                          SYS.DBMS_ASSERT.ENQUOTE_LITERAL(INSTNAME) || \r\n&gt;                          ' scope=spfile';\r\n1505d1415\r\n&lt;               CLEANUP;\r\n1525,1527d1434\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1533,1534d1439\r\n&lt;     \r\n&lt;     CLEANUP;\r\n1558,1560d1462\r\n&lt;   CREATE_DIRS;\r\n&lt; \r\n&lt;   \r\n1577d1478\r\n&lt;     CLEANUP;\r\n1595d1495\r\n&lt;    CLEANUP;\r\n1675,1677d1574\r\n&lt;   \r\n&lt;   CLEANUP;\r\n&lt; \r\n1680,1681d1576\r\n&lt;      \r\n&lt;      CLEANUP;\r\n1695,1696d1589\r\n&lt;   \r\n&lt;   CREATE_DIRS;\r\n1716,1717d1608\r\n&lt;   \r\n&lt;   CLEANUP;\r\n1720,1721d1610\r\n&lt;      \r\n&lt;      CLEANUP;\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.06.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.05.02.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.06.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.07.00.00'; \r\n26660a26661,26668\r\n&gt;                 DEB(DEB_IN, 'lbRec.completion_time=' || LBREC.COMPLETION_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_ckp_mod_time=' || LBREC.DF_CKP_MOD_TIME);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_checkpoint_change#=' || \r\n&gt;                              LBREC.DF_CHECKPOINT_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_plugin_change#=' || \r\n&gt;                              LBREC.DF_PLUGIN_CHANGE#);\r\n&gt;                 DEB(DEB_IN, 'lbRec.df_creation_change#=' ||\r\n&gt;                              LBREC.DF_CREATION_CHANGE#);\r\n26667,26669c26675,26683\r\n&lt;                    LBREC.DF_CKP_MOD_TIME &lt; UNTILTIME        OR\r\n&lt;                    (UNTILTIME IS NULL AND\r\n&lt;                     LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN)))) THEN\r\n---\r\n&gt;                   ((LBREC.DF_PLUGIN_CHANGE# &gt; LBREC.DF_CREATION_CHANGE#) AND\r\n&gt;                    (LBREC.DF_PLUGIN_CHANGE# &lt;= UNTILSCN))  OR\r\n&gt;                   ((UNTILTIME IS NOT NULL) AND\r\n&gt;                    (NVL(LBREC.COMPLETION_TIME, LBREC.DF_CKP_MOD_TIME)\r\n&gt;                     &lt; UNTILTIME)) OR\r\n&gt;                   ((UNTILTIME IS NULL) AND\r\n&gt;                    (LBREC.DF_CHECKPOINT_CHANGE# &lt;= UNTILSCN))\r\n&gt;                    ))) THEN\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.18.0.0.0_18.6RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (18.6RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122c122\r\n&lt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.06.00.00'; \r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '18.06.01.00'; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.18.0.0.0_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_bugValObType as object(fix number, val number)\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_bugValObType FORCE as object(fix number, val number) NOT PERSISTABLE;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_FCTABTYPE.TYPE.18.0.0.0_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_fcTabType as table of dbms_optim_bugValObType\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_fcTabType as table of (dbms_optim_bugValObType) NOT PERSISTABLE;\r\n&gt; \r\n<\/pre>\n<div id=\"SYS.DBA_APPLY_ERROR.VIEW.18.0.0.0_RU\">SYS.DBA_APPLY_ERROR &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">6a7\r\n&gt;           when e.flags &gt; 255                then 'UNDEFINED'\r\n8c9,10\r\n&lt;           when (bitand(e.flags, 132) = 132) then 'PROCEDURE ERROR WITH LCRS'\r\n---\r\n&gt;           when (bitand(e.flags, 32) = 32)   then 'REPLICAT RETRIED'\r\n&gt;           when (bitand(e.flags, 130) = 130) then 'PROCEDURE ERROR WITH LCRS'\r\n11,14c13,22\r\n&lt;                when (bitand(e.flags, 66) = 66) then 'CONFLICT INFO, RECORD LCR'\r\n&lt;                when (bitand(e.flags, 2) = 2) then 'RECORD LCR'\r\n&lt;                when (bitand(e.flags, 16) = 16) then 'RECORD TXN NO LCRS'\r\n&lt;                else 'RECORD TXN WITH LCRS'\r\n---\r\n&gt;               when (bitand(e.flags, 66) = 66) then 'CONFLICT INFO, RECORD LCR'\r\n&gt;               when (bitand(e.flags, 2) = 2) then 'RECORD LCR'\r\n&gt;               when (bitand(e.flags, 128) = 128) then 'PROCEDURE ERROR NO LCRS'\r\n&gt;               when (bitand(e.flags, 16) = 16) then 'RECORD TXN NO LCRS'\r\n&gt;               else 'RECORD TXN WITH LCRS'\r\n&gt;              end)\r\n&gt;           when (bitand(e.flags, 16) = 16) then\r\n&gt;             (case\r\n&gt;               when (bitand(e.flags, 128) = 128) then 'PROCEDURE ERROR NO LCRS'\r\n&gt;               else 'UNHANDLED ERROR NO LCRS'\r\n16d23\r\n&lt;           when (bitand(e.flags, 16) = 16) then 'UNHANDLED ERROR NO LCRS'\r\n18c25\r\n&lt;           else NULL\r\n---\r\n&gt;           else 'UNHANDLED ERROR WITH LCRS'\r\n<\/pre>\n<h3><strong>19.0.0.0<\/strong><\/h3>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_COMMON.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_COMMON &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">180a181\r\n&gt; chunk_predown  constant number :=3;\r\n184a186\r\n&gt; ctrlchunk_predown    constant number := chunk_predown;\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">833c833,834\r\n&lt;                         removeLink IN BOOLEAN default TRUE);\r\n---\r\n&gt;                        removeLink IN BOOLEAN default TRUE,\r\n&gt;                        fastPath IN BOOLEAN default FALSE );\r\n834a836,838\r\n&gt; PROCEDURE updateMetadataDistrib ( chunk_id  IN BINARY_INTEGER,\r\n&gt;                                   isOGG IN BOOLEAN,\r\n&gt;                                   sh_method IN NUMBER);\r\n883c887\r\n&lt; PROCEDURE importData2( chunk_id NUMBER);\r\n---\r\n&gt; PROCEDURE importData2( chunk_id NUMBER, fastpath NUMBER default 0);\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1733a1734,1737\r\n&gt;\r\n&gt;\r\n&gt; PROCEDURE updateChunkLocationRemote ( chunk_id NUMBER);\r\n&gt;\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_UTILITY.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_UTILITY &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1712c1712\r\n&lt;\r\n---\r\n&gt; msg_move_dn          constant number :=  3877;\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.EXCHANGE.PACKAGE.19.0.0.0_RU\">GSMADMIN_INTERNAL.EXCHANGE &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">35c35,36\r\n&lt;                          NEW_DATAFILES   IN D_TYPE DEFAULT NULL);\r\n---\r\n&gt;                          NEW_DATAFILES   IN D_TYPE DEFAULT NULL,\r\n&gt;                          CHUNK_ID        IN NUMBER DEFAULT 0);\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">5482c5482\r\n&lt;\r\n---\r\n&gt;   CHECKCATALOGLINK;\r\n5775a5776\r\n&gt;   FINISHMOVE (CHUNK_ID, FASTPATH =&gt; TRUE);\r\n5998c5999\r\n&lt; PROCEDURE IMPORTDATA2(CHUNK_ID NUMBER)\r\n---\r\n&gt; PROCEDURE IMPORTDATA2(CHUNK_ID NUMBER,  FASTPATH NUMBER DEFAULT 0)\r\n6001a6003\r\n&gt; CID NUMBER :=0;\r\n6003c6005,6010\r\n&lt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('Start Data import of Chunk');\r\n---\r\n&gt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('Start Data import of Chunk '||CHUNK_ID||\r\n&gt;   ' fastPath: '||FASTPATH );\r\n&gt;\r\n&gt;   IF (FASTPATH = 1) THEN\r\n&gt;     CID := CHUNK_ID;\r\n&gt;   END IF;\r\n6010c6017,6018\r\n&lt;   GSMADMIN_INTERNAL.EXCHANGE.EXCHANGE_IN (TBL_FILTER,DBL_NAME);\r\n---\r\n&gt;   GSMADMIN_INTERNAL.EXCHANGE.EXCHANGE_IN (TBL_FILTER,DBL_NAME,\r\n&gt;                                           CHUNK_ID =&gt; CID);\r\n6241c6249,6288\r\n&lt;\r\n---\r\n&gt; PROCEDURE UPDATEMETADATADISTRIB ( CHUNK_ID  IN BINARY_INTEGER,\r\n&gt;                                   ISOGG     IN BOOLEAN,\r\n&gt;                                   SH_METHOD IN NUMBER)\r\n&gt; IS\r\n&gt;    PRAGMA AUTONOMOUS_TRANSACTION;\r\n&gt;    DBL_NAME VARCHAR2(20);\r\n&gt; BEGIN\r\n&gt;   DBL_NAME := GETDBLINKNAME('C'||TO_CHAR(CHUNK_ID));\r\n&gt;\r\n&gt;   EXECUTE IMMEDIATE 'ALTER SESSION SET GLOBAL_NAMES=FALSE';\r\n&gt;   IF NOT ISOGG THEN\r\n&gt;        UPDATE CHUNKS\r\n&gt;         SET STATE = DBMS_GSM_COMMON.CHUNK_UP\r\n&gt;         WHERE CHUNK_NUMBER = UPDATEMETADATADISTRIB.CHUNK_ID;\r\n&gt;   END IF;\r\n&gt;\r\n&gt;\r\n&gt;   IF SH_METHOD = DBMS_GSM_UTILITY.SH_USERDEF THEN\r\n&gt;      UPDATE GSMADMIN_INTERNAL.SHARD_SPACE A SET CHUNKS =\r\n&gt;             (SELECT COUNT(*) FROM GSMADMIN_INTERNAL.CHUNKS B\r\n&gt;                              WHERE A.SHARDSPACE_ID = B.SHARDSPACE_ID\r\n&gt;                           GROUP BY B.SHARDSPACE_ID);\r\n&gt;   END IF;\r\n&gt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('Update of source chunk metadata');\r\n&gt;   EXECUTE IMMEDIATE   'UPDATE GSMADMIN_INTERNAL.CHUNKS@'||\r\n&gt;                        DBMS_ASSERT.NOOP(DBL_NAME)||\r\n&gt;                        ' set STATE='||TO_CHAR(DBMS_GSM_COMMON.CHUNK_PREDOWN)||\r\n&gt;                        ' WHERE CHUNK_NUMBER = :1'\r\n&gt;                         USING UPDATEMETADATADISTRIB.CHUNK_ID;\r\n&gt;\r\n&gt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('Update of catalog chunk metadata');\r\n&gt;   EXECUTE IMMEDIATE\r\n&gt;   ' begin gsmadmin_internal.dbms_gsm_pooladmin.updateChunkLocationRemote'||\r\n&gt;   '@GDS$CATALOG.LINK(:1); end;' USING UPDATEMETADATADISTRIB.CHUNK_ID;\r\n&gt;\r\n&gt;    IF NOT ISOGG THEN\r\n&gt;       DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove send FAN');\r\n&gt;       CONTROLCHUNK(CHUNK_ID, DBMS_GSM_COMMON.CTRLCHUNK_UP, 0);\r\n&gt;    END IF;\r\n&gt; END UPDATEMETADATADISTRIB;\r\n6249c6296,6297\r\n&lt;                                            REMOVELINK IN BOOLEAN DEFAULT TRUE)\r\n---\r\n&gt;                        REMOVELINK IN BOOLEAN DEFAULT TRUE,\r\n&gt;                        FASTPATH IN BOOLEAN DEFAULT FALSE)\r\n6396a6445,6446\r\n&gt; C_STAT NUMBER:=0;\r\n&gt; SKIPSTEPS BOOLEAN := FALSE;\r\n6563,6564c6613,6657\r\n&lt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove optype: '||OPTYPE||\r\n&lt;                                      ' chunk:'|| CHUNK_ID);\r\n---\r\n&gt;   BEGIN\r\n&gt;     SELECT STATE INTO C_STAT FROM CHUNKS\r\n&gt;     WHERE CHUNK_NUMBER =  FINISHMOVE.CHUNK_ID;\r\n&gt;   EXCEPTION\r\n&gt;     WHEN NO_DATA_FOUND THEN C_STAT := NULL;\r\n&gt;   END;\r\n&gt;   DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove optype: ' || OPTYPE ||\r\n&gt;                                      ' chunk:'|| CHUNK_ID ||\r\n&gt;                                      ' state:'|| C_STAT);\r\n&gt;\r\n&gt;   IF (DB_ROLE = DBMS_GSM_COMMON.MOVECHUNK_TARGET AND\r\n&gt;       C_STAT = DBMS_GSM_COMMON.CHUNK_UP ) THEN\r\n&gt;     IF (OPTYPE=1) THEN\r\n&gt;       DBMS_GSM_COMMON.WRITETOGWMTRACING (\r\n&gt;          'finishMove immediate return after fast path ') ;\r\n&gt;       RETURN;\r\n&gt;     ELSE\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;       DBMS_GSM_COMMON.WRITETOGWMTRACING (\r\n&gt;         'finishMove changing rollback to commit due to the fact that\r\n&gt;          fastpath advanced to no-return point ') ;\r\n&gt;       OPTYPE := 1;\r\n&gt;       SKIPSTEPS := TRUE;\r\n&gt;     END IF;\r\n&gt;   ELSIF (DB_ROLE = DBMS_GSM_COMMON.MOVECHUNK_SOURCE AND\r\n&gt;          C_STAT = DBMS_GSM_COMMON.CHUNK_PREDOWN ) THEN\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;     IF (OPTYPE = 2) THEN\r\n&gt;       DBMS_GSM_COMMON.WRITETOGWMTRACING (\r\n&gt;       'finishMove changing rollback to commit due to the fact that\r\n&gt;       fastpath advanced to no-return point ') ;\r\n&gt;       OPTYPE := 0;\r\n&gt;     END IF;\r\n&gt;   ELSIF (DB_ROLE = DBMS_GSM_COMMON.MOVECHUNK_SOURCE AND C_STAT IS NULL AND NOT FASTPATH )\r\n&gt;   THEN\r\n&gt;     DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove on source is skipped.\r\n&gt;                                        Slow path after full cleanup');\r\n&gt;     RETURN;\r\n&gt;\r\n&gt;   END IF;\r\n&gt;\r\n6858,6878c6951\r\n&lt;\r\n&lt;     OPEN TS_CURSOR FOR TS_C_STR USING FINISHMOVE.CHUNK_ID;\r\n&lt;     LOOP\r\n&lt;       FETCH TS_CURSOR INTO TS_NAME, READ_FL;\r\n&lt;       EXIT WHEN TS_CURSOR%NOTFOUND;\r\n&lt;       BEGIN\r\n&lt;         IF (OPTYPE =1 OR READ_FL=1) THEN\r\n&lt;           DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove TS online: '||\r\n&lt;                                               TS_NAME);\r\n&lt;\r\n&lt;           UPDATE SHARD_TS SET MOVE_FLAG = 0 WHERE TABLESPACE_NAME = TS_NAME;\r\n&lt;           EXECUTE IMMEDIATE ' alter tablespace '|| ENQ_NAME(TS_NAME) ||\r\n&lt;                             ' read write';\r\n&lt;         END IF;\r\n&lt;       EXCEPTION\r\n&lt;         WHEN NOT_READONLY  THEN\r\n&lt;           NULL;\r\n&lt;       END;\r\n&lt;     END LOOP;\r\n&lt;     CLOSE TS_CURSOR;\r\n&lt;     IF (OPTYPE = 1) THEN\r\n---\r\n&gt;     IF (NOT SKIPSTEPS) THEN\r\n6880c6953\r\n&lt;       OPEN TAB_CURSOR FOR SPART_C2_STR USING FINISHMOVE.CHUNK_ID;\r\n---\r\n&gt;       OPEN TS_CURSOR FOR TS_C_STR USING FINISHMOVE.CHUNK_ID;\r\n6882,6891c6955,6969\r\n&lt;         FETCH TAB_CURSOR INTO OWN_NAME, TAB_NAME, PART_NAME, TS_NAME;\r\n&lt;         EXIT WHEN TAB_CURSOR%NOTFOUND;\r\n&lt;\r\n&lt;         DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  part default ts: '\r\n&lt;           || ENQ_NAME(TAB_NAME) || ' owner:' || ENQ_NAME(OWN_NAME) ||\r\n&lt;             'partition:' || ENQ_NAME(PART_NAME) || 'ts:' || ENQ_NAME(TS_NAME));\r\n&lt;\r\n&lt;         ALTERFRAGMENT(OWN_NAME, TAB_NAME, NULL,\r\n&lt;             PART_NAME, TS_NAME, GSM_FRAG_COMPOSITE);\r\n&lt;         MODINDEXPARTTS(OWN_NAME, TAB_NAME, NULL);\r\n---\r\n&gt;         FETCH TS_CURSOR INTO TS_NAME, READ_FL;\r\n&gt;         EXIT WHEN TS_CURSOR%NOTFOUND;\r\n&gt;         BEGIN\r\n&gt;           IF (OPTYPE =1 OR READ_FL=1) THEN\r\n&gt;             DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove TS online: '||\r\n&gt;                                                 TS_NAME);\r\n&gt;\r\n&gt;             UPDATE SHARD_TS SET MOVE_FLAG = 0 WHERE TABLESPACE_NAME = TS_NAME;\r\n&gt;             EXECUTE IMMEDIATE ' alter tablespace '|| ENQ_NAME(TS_NAME) ||\r\n&gt;                               ' read write';\r\n&gt;           END IF;\r\n&gt;         EXCEPTION\r\n&gt;           WHEN NOT_READONLY  THEN\r\n&gt;             NULL;\r\n&gt;         END;\r\n6893,6898c6971,6977\r\n&lt;       CLOSE TAB_CURSOR;\r\n&lt;\r\n&lt;       OPEN TAB_CURSOR FOR PART_C2_STR USING FINISHMOVE.CHUNK_ID;\r\n&lt;       LOOP\r\n&lt;         FETCH TAB_CURSOR INTO OWN_NAME, TAB_NAME,  PART_NAME;\r\n&lt;         EXIT WHEN TAB_CURSOR%NOTFOUND;\r\n---\r\n&gt;       CLOSE TS_CURSOR;\r\n&gt;       IF (OPTYPE = 1) THEN\r\n&gt;\r\n&gt;         OPEN TAB_CURSOR FOR SPART_C2_STR USING FINISHMOVE.CHUNK_ID;\r\n&gt;         LOOP\r\n&gt;           FETCH TAB_CURSOR INTO OWN_NAME, TAB_NAME, PART_NAME, TS_NAME;\r\n&gt;           EXIT WHEN TAB_CURSOR%NOTFOUND;\r\n6900,6902c6979,6981\r\n&lt;         DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  part RW: '\r\n&lt;           || ENQ_NAME(TAB_NAME) || ' owner:' || ENQ_NAME(OWN_NAME) ||\r\n&lt;             'partition:' || ENQ_NAME(PART_NAME));\r\n---\r\n&gt;           DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  part default ts: '\r\n&gt;             || ENQ_NAME(TAB_NAME) || ' owner:' || ENQ_NAME(OWN_NAME) ||\r\n&gt;               'partition:' || ENQ_NAME(PART_NAME) || 'ts:' || ENQ_NAME(TS_NAME));\r\n6904,6910c6983,6992\r\n&lt;             DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  table partition RW');\r\n&lt;         EXECUTE IMMEDIATE ' ALTER TABLE ' || ENQ_QNAME(OWN_NAME, TAB_NAME) ||\r\n&lt;                           ' MODIFY PARTITION '|| ENQ_NAME(PART_NAME) ||\r\n&lt;                           ' READ WRITE';\r\n&lt;       END LOOP;\r\n&lt;       CLOSE TAB_CURSOR;\r\n&lt;     END IF;\r\n---\r\n&gt;           ALTERFRAGMENT(OWN_NAME, TAB_NAME, NULL,\r\n&gt;                         PART_NAME, TS_NAME, GSM_FRAG_COMPOSITE);\r\n&gt;           MODINDEXPARTTS(OWN_NAME, TAB_NAME, NULL);\r\n&gt;         END LOOP;\r\n&gt;         CLOSE TAB_CURSOR;\r\n&gt;\r\n&gt;         OPEN TAB_CURSOR FOR PART_C2_STR USING FINISHMOVE.CHUNK_ID;\r\n&gt;         LOOP\r\n&gt;           FETCH TAB_CURSOR INTO OWN_NAME, TAB_NAME,  PART_NAME;\r\n&gt;           EXIT WHEN TAB_CURSOR%NOTFOUND;\r\n6912,6921c6994,7004\r\n&lt;\r\n&lt;     DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove chunks metadata');\r\n&lt;     IF NOT ISOGG THEN\r\n&lt;       UPDATE CHUNKS\r\n&lt;         SET STATE = DBMS_GSM_COMMON.CHUNK_UP\r\n&lt;         WHERE CHUNK_NUMBER = FINISHMOVE.CHUNK_ID;\r\n&lt;       COMMIT;\r\n&lt;       DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove send FAN');\r\n&lt;       CONTROLCHUNK(CHUNK_ID, DBMS_GSM_COMMON.CTRLCHUNK_UP, 0);\r\n&lt;     END IF;\r\n---\r\n&gt;           DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  part RW: '\r\n&gt;             || ENQ_NAME(TAB_NAME) || ' owner:' || ENQ_NAME(OWN_NAME) ||\r\n&gt;               'partition:' || ENQ_NAME(PART_NAME));\r\n&gt;\r\n&gt;           DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove  table partition RW');\r\n&gt;           EXECUTE IMMEDIATE ' ALTER TABLE ' || ENQ_QNAME(OWN_NAME, TAB_NAME) ||\r\n&gt;                             ' MODIFY PARTITION '|| ENQ_NAME(PART_NAME) ||\r\n&gt;                             ' READ WRITE';\r\n&gt;         END LOOP;\r\n&gt;         CLOSE TAB_CURSOR;\r\n&gt;       END IF;\r\n6923,6930c7006,7018\r\n&lt;\r\n&lt;\r\n&lt;     IF SH_METHOD = DBMS_GSM_UTILITY.SH_USERDEF THEN\r\n&lt;        UPDATE GSMADMIN_INTERNAL.SHARD_SPACE A SET CHUNKS =\r\n&lt;              (SELECT COUNT(*) FROM GSMADMIN_INTERNAL.CHUNKS B\r\n&lt;                              WHERE A.SHARDSPACE_ID = B.SHARDSPACE_ID\r\n&lt;                           GROUP BY B.SHARDSPACE_ID);\r\n&lt;     END IF;\r\n---\r\n&gt;\r\n&gt;       IF (FASTPATH) THEN\r\n&gt;         UPDATEMETADATADISTRIB(CHUNK_ID, ISOGG, SH_METHOD);\r\n&gt;       ELSE\r\n&gt;         DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove chunks metadata');\r\n&gt;         IF NOT ISOGG THEN\r\n&gt;           UPDATE CHUNKS\r\n&gt;           SET STATE = DBMS_GSM_COMMON.CHUNK_UP\r\n&gt;           WHERE CHUNK_NUMBER = FINISHMOVE.CHUNK_ID;\r\n&gt;           COMMIT;\r\n&gt;           DBMS_GSM_COMMON.WRITETOGWMTRACING ('finishMove send FAN');\r\n&gt;           CONTROLCHUNK(CHUNK_ID, DBMS_GSM_COMMON.CTRLCHUNK_UP, 0);\r\n&gt;         END IF;\r\n6931a7020,7029\r\n&gt;\r\n&gt;\r\n&gt;         IF SH_METHOD = DBMS_GSM_UTILITY.SH_USERDEF THEN\r\n&gt;            UPDATE GSMADMIN_INTERNAL.SHARD_SPACE A SET CHUNKS =\r\n&gt;                  (SELECT COUNT(*) FROM GSMADMIN_INTERNAL.CHUNKS B\r\n&gt;                                  WHERE A.SHARDSPACE_ID = B.SHARDSPACE_ID\r\n&gt;                               GROUP BY B.SHARDSPACE_ID);\r\n&gt;         END IF;\r\n&gt;\r\n&gt;       END IF;\r\n6932a7031\r\n&gt;     END IF;\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">11486a11487,11511\r\n&gt;\r\n&gt; PROCEDURE UPDATECHUNKLOCATIONREMOTE ( CHUNK_ID NUMBER)\r\n&gt; IS\r\n&gt;   SDBNUM    NUMBER := 0;\r\n&gt;   TDBNUM    NUMBER := 0;\r\n&gt;   GCTL_ID NUMBER :=0;\r\n&gt;   MESSAGE       VARCHAR2(1024);\r\n&gt; BEGIN\r\n&gt;   SELECT SOURCE_DB,TARGET_DB,GDSCTL_ID\r\n&gt;   INTO  SDBNUM,TDBNUM,GCTL_ID\r\n&gt;   FROM  CATALOG_REQUESTS\r\n&gt;   WHERE\r\n&gt;    STATUS = DBMS_GSM_UTILITY.MOVE_ST_INIT AND\r\n&gt;    OBJ_ID = UPDATECHUNKLOCATIONREMOTE.CHUNK_ID;\r\n&gt;   UPDATECHUNKLOCATION( SDBNUM, TDBNUM, CHUNK_ID);\r\n&gt;\r\n&gt;   COMMIT;\r\n&gt;   IF ( GCTL_ID &gt; 0 )\r\n&gt;   THEN\r\n&gt;     DBMS_GSM_COMMON.GETMSG(DBMS_GSM_UTILITY.MSG_MOVE_DN, MESSAGE, MESSAGE_PARAM_LIST());\r\n&gt;     DBMS_GSM_UTILITY.SEND_GDSCTL_MSG(MESSAGE, GCTL_ID);\r\n&gt;   END IF;\r\n&gt;\r\n&gt; END UPDATECHUNKLOCATIONREMOTE;\r\n&gt;\r\n11515a11541\r\n&gt;  AFTERFP       NUMBER;\r\n11541,11542c11567,11574\r\n&lt;   IF  (STATE = DBMS_GSM_UTILITY.MOVE_ST_MFNT) THEN\r\n&lt;     UPDATECHUNKLOCATION(SDBNUM, TDBNUM, CHUNK);\r\n---\r\n&gt;   IF (STATE = DBMS_GSM_UTILITY.MOVE_ST_MFNT) THEN\r\n&gt;     SELECT COUNT(1) INTO AFTERFP FROM CHUNK_LOC\r\n&gt;     WHERE CHUNK_NUMBER = CHUNK AND DATABASE_NUM = SDBNUM;\r\n&gt;     IF AFTERFP&gt;0 THEN\r\n&gt;       UPDATECHUNKLOCATION(SDBNUM, TDBNUM, CHUNK);\r\n&gt;     ELSE\r\n&gt;       DBMS_GSM_COMMON.WRITETOGWMTRACING('updateMoveState: after Fast PAth');\r\n&gt;     END IF;\r\n<\/pre>\n<div id=\"GSMADMIN_INTERNAL.EXCHANGE.PACKAGE BODY.19.0.0.0_RU\">GSMADMIN_INTERNAL.EXCHANGE &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">32a33,37\r\n&gt;   P_W_HANDLE NUMBER :=NULL;\r\n&gt;   P_TR_HANDLE NUMBER :=NULL;\r\n&gt;   P_OBJ_TYPE VARCHAR2(100) :=NULL;\r\n&gt;   P_OP_NAME VARCHAR2(256) :=NULL;\r\n&gt;\r\n305d309\r\n&lt;\r\n333,340c337,357\r\n&lt;     W_HANDLE := DBMS_METADATA.OPENW(OBJ_TYPE);\r\n&lt;     TR_HANDLE := DBMS_METADATA.ADD_TRANSFORM(W_HANDLE,'DDL');\r\n&lt;     IF OBJ_TYPE NOT LIKE '%PLUGTS%' THEN\r\n&lt;       DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'EXPORT',TRUE);\r\n&lt;       DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'TRANSPORTABLE',1);\r\n&lt;       DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'UNIQUE_NAME',GUID);\r\n&lt;       IF OBJ_TYPE IN ('PARTITION','SUBPARTITION') THEN\r\n&lt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'CONSTRAINTS_AS_ALTER',TRUE);\r\n---\r\n&gt;     IF (P_W_HANDLE IS NOT NULL AND P_OBJ_TYPE=OBJ_TYPE AND\r\n&gt;         (P_OP_NAME = OPERATION OR (P_OP_NAME='CREATE' AND OPERATION IS NULL))) THEN\r\n&gt;        W_HANDLE := P_W_HANDLE;\r\n&gt;     ELSE\r\n&gt;       PUT_LINE('do_ddl new handle obj_type '||OBJ_TYPE||' operation '|| OPERATION);\r\n&gt;       IF (P_W_HANDLE IS NOT NULL) THEN DBMS_METADATA.CLOSE(P_W_HANDLE); END IF;\r\n&gt;       W_HANDLE := DBMS_METADATA.OPENW(OBJ_TYPE);\r\n&gt;       P_W_HANDLE := W_HANDLE;\r\n&gt;       P_OBJ_TYPE := OBJ_TYPE;\r\n&gt;       TR_HANDLE := DBMS_METADATA.ADD_TRANSFORM(W_HANDLE,'DDL');\r\n&gt;       P_TR_HANDLE :=TR_HANDLE;\r\n&gt;       IF OBJ_TYPE NOT LIKE '%PLUGTS%' THEN\r\n&gt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'EXPORT',TRUE);\r\n&gt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'TRANSPORTABLE',1);\r\n&gt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'UNIQUE_NAME',GUID);\r\n&gt;         IF OBJ_TYPE IN ('PARTITION','SUBPARTITION') THEN\r\n&gt;           DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'CONSTRAINTS_AS_ALTER',TRUE);\r\n&gt;           IF EXCHANGE_OPERATION = 'OUT' THEN\r\n&gt;             DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'EXCHANGE_OUT',TRUE);\r\n&gt;           END IF;\r\n&gt;         END IF;\r\n342c359\r\n&lt;           DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'EXCHANGE_OUT',TRUE);\r\n---\r\n&gt;           DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'STORAGE',FALSE);\r\n343a361,367\r\n&gt;         IF OPERATION IS NOT NULL THEN\r\n&gt;           DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'OPERATION_TYPE',OPERATION);\r\n&gt;           OPERATION_NAME := OPERATION;\r\n&gt;         ELSE\r\n&gt;           OPERATION_NAME := 'CREATE';\r\n&gt;         END IF;\r\n&gt;         P_OP_NAME := OPERATION_NAME;\r\n345,354c369,373\r\n&lt;       IF EXCHANGE_OPERATION = 'OUT' THEN\r\n&lt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'SHARD_TABLESPACE',NEW_TBS);\r\n&lt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'STORAGE',FALSE);\r\n&lt;       END IF;\r\n&lt;       IF OPERATION IS NOT NULL THEN\r\n&lt;         DBMS_METADATA.SET_TRANSFORM_PARAM(TR_HANDLE,'OPERATION_TYPE',OPERATION);\r\n&lt;         OPERATION_NAME := OPERATION;\r\n&lt;       ELSE\r\n&lt;         OPERATION_NAME := 'CREATE';\r\n&lt;       END IF;\r\n---\r\n&gt;       DBMS_METADATA.SET_PARSE_ITEM(W_HANDLE,'VERB');\r\n&gt;       DBMS_METADATA.SET_PARSE_ITEM(W_HANDLE,'BIND_PATTERN');\r\n&gt;     END IF;\r\n&gt;     IF EXCHANGE_OPERATION = 'OUT' THEN\r\n&gt;        DBMS_METADATA.SET_TRANSFORM_PARAM(P_TR_HANDLE,'SHARD_TABLESPACE',NEW_TBS);\r\n356,357c375,376\r\n&lt;     DBMS_METADATA.SET_PARSE_ITEM(W_HANDLE,'VERB');\r\n&lt;     DBMS_METADATA.SET_PARSE_ITEM(W_HANDLE,'BIND_PATTERN');\r\n---\r\n&gt;\r\n&gt;     PUT_LINE('Convert ddls ');\r\n359c378\r\n&lt;     DBMS_METADATA.CLOSE(W_HANDLE);\r\n---\r\n&gt;\r\n382,383c401,402\r\n&lt;           IF DOEXEC THEN BEGIN\r\n&lt;             PUT_LINE('do_ddl: operation '||OPERATION_NAME||' - \"'||VERB||\r\n---\r\n&gt;             IF DOEXEC THEN BEGIN\r\n&gt;             PUT_LINE('do_ddl: operation '||P_OP_NAME||' - \"'||VERB||\r\n414c433\r\n&lt;                 PUT_LINE('&gt;&gt;&gt;&gt;ignoring exception for '||OPERATION_NAME||\r\n---\r\n&gt;                 PUT_LINE('&gt;&gt;&gt;&gt;ignoring exception for '||P_OP_NAME||\r\n417c436\r\n&lt;                 PUT_LINE('&gt;&gt;&gt;&gt;exception for operation '||OPERATION_NAME||\r\n---\r\n&gt;                 PUT_LINE('&gt;&gt;&gt;&gt;exception for operation '||P_OP_NAME||\r\n450c469\r\n&lt;         PUT_LINE('&gt;&gt;&gt;&gt;exception during operation '||OPERATION_NAME);\r\n---\r\n&gt;         PUT_LINE('&gt;&gt;&gt;&gt;exception during operation '||P_OP_NAME);\r\n652c671,672\r\n&lt;                          NEW_DATAFILES   IN D_TYPE DEFAULT NULL) IS\r\n---\r\n&gt;                          NEW_DATAFILES   IN D_TYPE DEFAULT NULL,\r\n&gt;                          CHUNK_ID        IN   NUMBER DEFAULT 0) IS\r\n762a783,787\r\n&gt;   IF (CHUNK_ID !=0 ) THEN\r\n&gt;     GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.FINISHMOVE(\r\n&gt;              CHUNK_ID, DBMS_GSM_COMMON.MOVECHUNK_TARGET, FASTPATH=&gt; TRUE);\r\n&gt;   END IF;\r\n&gt;\r\n765a791\r\n&gt;   IF (P_W_HANDLE IS NOT NULL) THEN DBMS_METADATA.CLOSE(P_W_HANDLE); END IF;\r\n<\/pre>\n<div id=\"MDSYS.SDO_GEORX.PACKAGE.19.0.0.0_RU\">MDSYS.SDO_GEORX &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">7c7,12\r\n&lt;   FUNCTION SCHEMAVALIDATE(METADATA IN XMLTYPE)\r\n---\r\n&gt;   FUNCTION SCHEMAVALIDATE\r\n&gt;   (\r\n&gt;     XML IN XMLTYPE,\r\n&gt;     URI IN VARCHAR2,\r\n&gt;     XMLSCHEMA IN XMLTYPE\r\n&gt;   )\r\n<\/pre>\n<div id=\"MDSYS.SDO_CSWADM.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_CSWADM &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">19a20,21\r\n&gt;     NULL;\r\n&gt; \/*\r\n41a44\r\n&gt;     *\/\r\n137a141,142\r\n&gt;     NULL;\r\n&gt;     \/*\r\n148a154\r\n&gt;     *\/\r\n<\/pre>\n<div id=\"MDSYS.SDO_GEOR.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_GEOR &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">4344a4345\r\n&gt;   XSCHEMA XMLTYPE;\r\n4351d4351\r\n&lt;\r\n4353,4355c4353,4366\r\n&lt;     XDOC := GEORASTER.METADATA.CREATESCHEMABASEDXML(URL);\r\n&lt;     XDOC.SCHEMAVALIDATE();\r\n&lt;     RESULT := 'TRUE';\r\n---\r\n&gt;     SELECT XMLTYPE(XMLSCHEMA) INTO XSCHEMA FROM MDSYS.SDO_GEOR_XMLSCHEMA_TABLE\r\n&gt;       WHERE ID = 1;\r\n&gt;     IF XSCHEMA IS NULL THEN\r\n&gt;         MDERR.RAISE_MD_ERROR('MD', 'SDO', -13454);\r\n&gt;         RETURN 'NULL';\r\n&gt;     END IF;\r\n&gt;\r\n&gt;     XDOC := GEORASTER.METADATA;\r\n&gt;     RESULT := MDSYS.SDO_GEORX.SCHEMAVALIDATE(XDOC, URL, XSCHEMA);\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n<\/pre>\n<div id=\"MDSYS.SDO_GEORX.PACKAGE BODY.19.0.0.0_RU\">MDSYS.SDO_GEORX &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3c3,8\r\n&lt;   FUNCTION SCHEMAVALIDATE(METADATA IN XMLTYPE)\r\n---\r\n&gt;   FUNCTION SCHEMAVALIDATE\r\n&gt;   (\r\n&gt;     XML IN XMLTYPE,\r\n&gt;     URI IN VARCHAR2,\r\n&gt;     XMLSCHEMA IN XMLTYPE\r\n&gt;   )\r\n11,12c16,21\r\n&lt;       METADATA,\r\n&lt;       METADATA INDICATOR,\r\n---\r\n&gt;       XML,\r\n&gt;       XML INDICATOR,\r\n&gt;       URI OCISTRING,\r\n&gt;       URI INDICATOR,\r\n&gt;       XMLSCHEMA,\r\n&gt;       XMLSCHEMA INDICATOR,\r\n<\/pre>\n<div id=\"MDSYS.SDO_RDF_TRIPLE_S.TYPE.19.0.0.0_RU\">MDSYS.SDO_RDF_TRIPLE_S &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">284a285,322\r\n&gt;   ALTER TYPE sdo_rdf_triple_s\r\n&gt;       ADD MEMBER FUNCTION get_obj_value RETURN VARCHAR2\r\n&gt;       DETERMINISTIC CASCADE\r\n&gt;   ALTER TYPE sdo_rdf_triple_s\r\n&gt;       ADD MEMBER FUNCTION is_object_clob RETURN VARCHAR2\r\n&gt;       DETERMINISTIC CASCADE\r\n&gt;   ALTER TYPE sdo_rdf_triple_s\r\n&gt;       ADD MEMBER FUNCTION get_model RETURN VARCHAR2\r\n&gt;       DETERMINISTIC CASCADE\r\n&gt;\r\n&gt;        ALTER TYPE sdo_rdf_triple_s\r\n&gt;        DROP MEMBER FUNCTION get_model RETURN VARCHAR2\r\n&gt;        DETERMINISTIC CASCADE\r\n&gt;\r\n&gt;        ALTER TYPE sdo_rdf_triple_s\r\n&gt;        DROP MEMBER FUNCTION get_obj_value RETURN VARCHAR2\r\n&gt;        DETERMINISTIC CASCADE\r\n&gt;\r\n&gt;        ALTER TYPE sdo_rdf_triple_s\r\n&gt;        DROP MEMBER FUNCTION is_object_clob RETURN VARCHAR2\r\n&gt;        DETERMINISTIC CASCADE\r\n&gt;   ALTER TYPE sdo_rdf_triple_s\r\n&gt;         ADD CONSTRUCTOR FUNCTION sdo_rdf_triple_s(model_name VARCHAR2,\r\n&gt;                                         reif_subject VARCHAR2,\r\n&gt;                                         reif_property VARCHAR2,\r\n&gt;                                         subject VARCHAR2,\r\n&gt;                                         property VARCHAR2,\r\n&gt;                                         object CLOB)\r\n&gt;             RETURN SELF AS RESULT DETERMINISTIC CASCADE\r\n&gt;   ALTER TYPE sdo_rdf_triple_s\r\n&gt;             DROP CONSTRUCTOR FUNCTION sdo_rdf_triple_s(\r\n&gt;                                         model_name VARCHAR2,\r\n&gt;                                         reif_subject VARCHAR2,\r\n&gt;                                         reif_property VARCHAR2,\r\n&gt;                                         subject VARCHAR2,\r\n&gt;                                         property VARCHAR2,\r\n&gt;                                         object CLOB)\r\n&gt;             RETURN SELF AS RESULT DETERMINISTIC CASCADE\r\n<\/pre>\n<div id=\"SYS.DBMS_ASH.PACKAGE.19.0.0.0_RU\">SYS.DBMS_ASH &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">62a63,66\r\n&gt;   , SYSTZ             NUMBER\r\n&gt;   , MINAVAILTIMEUTC   DATE\r\n&gt;   , MAXAVAILTIMEUTC   DATE\r\n&gt;\r\n114c118\r\n&lt;   REPORT_INTERNAL_VERSION CONSTANT VARCHAR2(64) := '40';\r\n---\r\n&gt;   REPORT_INTERNAL_VERSION CONSTANT VARCHAR2(64) := '41';\r\n<\/pre>\n<div id=\"SYS.DBMS_AWR_REPORT_LAYOUT.PACKAGE.19.0.0.0_RU\">SYS.DBMS_AWR_REPORT_LAYOUT &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">276a277\r\n&gt;   TOP_NONDB_WAIT_TIME          CONSTANT BINARY_INTEGER := 9200;\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.19.0.0.0_19.3RUR\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE (19.3RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12c12\r\n&lt;   bannerVersion CONSTANT VARCHAR2(15) := '19.03.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '19.03.01.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('19.03.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('19.03.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('19.03.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('19.03.01.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('19.03.01.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('19.03.01.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('19.03.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('19.03.01.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('19.03.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('19.03.01.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('19.03.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('19.03.01.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('19.03.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('19.03.01.00',  psn + 1));\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE.19.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) := '19.03.00.00';\r\n---\r\n&gt;   bannerVersion CONSTANT VARCHAR2(15) := '19.04.00.00';\r\n24,26c24,26\r\n&lt;   fsn  CONSTANT NUMBER := instr('19.03.00.00', '.');\r\n&lt;   msn  CONSTANT NUMBER := instr('19.03.00.00', '.', fsn + 1);\r\n&lt;   psn  CONSTANT NUMBER := instr('19.03.00.00', '.', msn + 1);\r\n---\r\n&gt;   fsn  CONSTANT NUMBER := instr('19.04.00.00', '.');\r\n&gt;   msn  CONSTANT NUMBER := instr('19.04.00.00', '.', fsn + 1);\r\n&gt;   psn  CONSTANT NUMBER := instr('19.04.00.00', '.', msn + 1);\r\n29c29\r\n&lt;                            to_number(substr('19.03.00.00', 1, fsn - 1));\r\n---\r\n&gt;                            to_number(substr('19.04.00.00', 1, fsn - 1));\r\n31c31\r\n&lt;                to_number(substr('19.03.00.00', fsn + 1, msn - fsn - 1));\r\n---\r\n&gt;                to_number(substr('19.04.00.00', fsn + 1, msn - fsn - 1));\r\n33c33\r\n&lt;               to_number(substr('19.03.00.00',  msn + 1, psn - msn - 1));\r\n---\r\n&gt;               to_number(substr('19.04.00.00',  msn + 1, psn - msn - 1));\r\n35c35\r\n&lt;                              to_number(substr('19.03.00.00',  psn + 1));\r\n---\r\n&gt;                              to_number(substr('19.04.00.00',  psn + 1));\r\n9339a9340,9347\r\n&gt;\r\n&gt;   PROCEDURE restoreSetXttfile( pltfrmfr      IN   binary_integer\r\n&gt;                               ,xttincr       IN   boolean\r\n&gt;                               ,pdbid         IN   number);\r\n&gt;   -- Additional input parameters:\r\n&gt;   --  pdbid\r\n&gt;   --    PDB id to which this cross platform restore is performed.\r\n&gt;   --\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">15a16,20\r\n&gt;\r\n&gt;\r\n&gt; ----------------------------\r\n&gt; --  PROCEDURES AND FUNCTIONS\r\n&gt; ----------------------------\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE.19.0.0.0_RU\">SYS.DBMS_RCVMAN &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1269c1269,1271\r\n&lt; -- by the find functions.\r\n---\r\n&gt; -- by the find functions. This tag is also used by report\/delete obsolete\r\n&gt; -- functions to restrict what backups to consider and what backups to filter\r\n&gt; -- for backup optimization.\r\n1273c1275\r\n&lt; --     tag of the datafile copies to be translated\r\n---\r\n&gt; --     tag of the datafile copies\/backup sets to be translated\r\n1274a1277,1278\r\n&gt; --   use_like\r\n&gt; --     input tag parameter to be used similar to LIKE semantics in SQL\r\n1276c1280\r\n&lt; PROCEDURE setTag(tag IN varchar2 DEFAULT NULL);\r\n---\r\n&gt; PROCEDURE setTag(tag IN varchar2 DEFAULT NULL, use_like IN number DEFAULT 0);\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.19.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;                                '19.3.0.0.0';\r\n---\r\n&gt;                                '19.4.0.0.0';\r\n<\/pre>\n<div id=\"SYS.DBMS_REGISTRY.PACKAGE.19.0.0.0_19.3RUR\">SYS.DBMS_REGISTRY &#8211; PACKAGE (19.3RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">13c13\r\n&lt;                                '19.3.0.0.0';\r\n---\r\n&gt;                                '19.3.1.0.0';\r\n<\/pre>\n<div id=\"SYS.DBMS_RMIN_SYS.PACKAGE.19.0.0.0_RU\">SYS.DBMS_RMIN_SYS &#8211; PACKAGE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">376a377,379\r\n&gt;\r\n&gt;  PROCEDURE RM$_VERIFY_PENDING_AREA_ACT;\r\n&gt;\r\n<\/pre>\n<div id=\"SYS.DBMS_ASH.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_ASH &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">135a136,140\r\n&gt;     DBMS_OUTPUT.PUT_LINE('sysTZ = ' || CONTEXT.SYSTZ);\r\n&gt;     DBMS_OUTPUT.PUT_LINE('minAvailTimeUTC = ' ||\r\n&gt;          TO_CHAR(CONTEXT.MINAVAILTIMEUTC, OMC_TIME_FORMAT));\r\n&gt;     DBMS_OUTPUT.PUT_LINE('maxAvailTimeUTC = ' ||\r\n&gt;          TO_CHAR(CONTEXT.MAXAVAILTIMEUTC, OMC_TIME_FORMAT));\r\n405a411,413\r\n&gt;              , CONTEXT.SYSTZ AS \"sysTZ\"\r\n&gt;              , TO_CHAR(CONTEXT.MINAVAILTIMEUTC,OMC_TIME_FORMAT) AS \"minAvailTimeUTC\"\r\n&gt;              , TO_CHAR(CONTEXT.MAXAVAILTIMEUTC,OMC_TIME_FORMAT) AS \"maxAvailTimeUTC\"\r\n448a457,471\r\n&gt;   FUNCTION GETSYSINFOXML(CONTEXT IN OUT NOCOPY CONTEXTTYPE)\r\n&gt;   RETURN   XMLTYPE\r\n&gt;   IS\r\n&gt;     L_RESULT XMLTYPE;\r\n&gt;   BEGIN\r\n&gt;     SELECT XMLELEMENT(\"sys_info\",XMLATTRIBUTES(\r\n&gt;               CONTEXT.SYSTZ AS \"sys_tz\"\r\n&gt;              ,TO_CHAR(CONTEXT.MINAVAILTIMEUTC,OMC_TIME_FORMAT) AS \"min_time\"\r\n&gt;              ,TO_CHAR(CONTEXT.MAXAVAILTIMEUTC,OMC_TIME_FORMAT) AS \"max_time\"\r\n&gt;            ))\r\n&gt;     INTO   L_RESULT\r\n&gt;     FROM   SYS.DUAL;\r\n&gt;     RETURN L_RESULT;\r\n&gt;   END GETSYSINFOXML;\r\n&gt;\r\n579a603,606\r\n&gt;\r\n&gt;     CONTEXT.SYSTZ := CAST(SYSTIMESTAMP AS DATE) - CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE);\r\n&gt;     CONTEXT.SYSTZ := ROUND(CONTEXT.SYSTZ*96,0)\/4;\r\n&gt;\r\n2185a2213\r\n&gt;     L_SYS_INFO XMLTYPE := NULL;\r\n2275a2304\r\n&gt;     L_SYS_INFO := GETSYSINFOXML(CONTEXT);\r\n2282a2312\r\n&gt;              ,L_SYS_INFO\r\n4649a4680\r\n&gt;     L_SYS_INFO    XMLTYPE;\r\n4708a4740\r\n&gt;     L_SYS_INFO := GETSYSINFOXML(CONTEXT);\r\n4720c4752,4753\r\n&lt;               L_TIMING, P_INPUT,L_CPU, CONTEXT.ACTIVITYLINEXML, RETXML)\r\n---\r\n&gt;               L_SYS_INFO,L_TIMING, P_INPUT,\r\n&gt;               L_CPU, CONTEXT.ACTIVITYLINEXML, RETXML)\r\n<\/pre>\n<div id=\"SYS.DBMS_AUTO_INDEX_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_AUTO_INDEX_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1003a1004,1042\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;\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;   PROCEDURE SET_INTERRUPT_MODE(\r\n&gt;     TASK_ID                IN     NUMBER,\r\n&gt;     CAN_CANCEL             IN     INTEGER,\r\n&gt;     CAN_INTERRUPT          IN     INTEGER\r\n&gt;   ) IS\r\n&gt;   EXTERNAL NAME \"kapiSetInterruptMode\" WITH CONTEXT\r\n&gt;   PARAMETERS(CONTEXT,\r\n&gt;     TASK_ID                OCINUMBER,  TASK_ID       INDICATOR  SB4,\r\n&gt;     CAN_CANCEL             OCINUMBER,  CAN_CANCEL    INDICATOR  SB4,\r\n&gt;     CAN_INTERRUPT          OCINUMBER,  CAN_INTERRUPT INDICATOR  SB4\r\n&gt;   )\r\n&gt;   LIBRARY DBMS_AUTO_INDEX_LIB;\r\n&gt;\r\n4904a4944,4984\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;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;   PROCEDURE INTERRUPT_TASK(\r\n&gt;     TASK_NAME VARCHAR2)\r\n&gt;   IS\r\n&gt;   BEGIN\r\n&gt;     DBMS_ADVISOR.INTERRUPT_TASK(TASK_NAME);\r\n&gt;   EXCEPTION\r\n&gt;     WHEN OTHERS THEN\r\n&gt;       IF SQLCODE = -13643 THEN\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;         DUMP_TRACE('interrupt of ' || TASK_NAME ||\r\n&gt;                    ' failed, trying to resume anyway');\r\n&gt;       ELSE\r\n&gt;         RAISE;\r\n&gt;       END IF;\r\n&gt;   END INTERRUPT_TASK;\r\n&gt;\r\n4980c5060\r\n&lt;         DBMS_ADVISOR.INTERRUPT_TASK(P_TASK_NAME);\r\n---\r\n&gt;         INTERRUPT_TASK(P_TASK_NAME);\r\n5750c5830\r\n&lt;              \/*+dynamic_sampling(11)\r\n---\r\n&gt;              \/*+dynamic_sampling(11) NO_XML_QUERY_REWRITE\r\n6351a6432\r\n&gt;                  and sql_text not like '%\/*+%dbms_stats%'\r\n6949c7030\r\n&lt;            \/*+dynamic_sampling(11) *\/\r\n---\r\n&gt;            \/*+dynamic_sampling(11) NO_XML_QUERY_REWRITE *\/\r\n6989a7071\r\n&gt;       AND SQL_TEXT NOT LIKE '%\/*+%dbms_stats%'\r\n7021a7104,7106\r\n&gt;     SET_INTERRUPT_MODE(AI_CTX.TASK_ID, 1, 1);\r\n&gt;\r\n&gt;\r\n7315c7400\r\n&lt;         DBMS_ADVISOR.INTERRUPT_TASK(AI_TASK_NAME);\r\n---\r\n&gt;         INTERRUPT_TASK(AI_TASK_NAME);\r\n<\/pre>\n<div id=\"SYS.DBMS_AWR_REPORT_LAYOUT.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_AWR_REPORT_LAYOUT &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">19365,19366c19365,19445\r\n&lt;\r\n&lt;   IF (INCLUDE_ASH) THEN\r\n---\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;   SEC := TOP_NONDB_WAIT_TIME;\r\n&gt;   COL := 1;\r\n&gt;   MH  := 1;\r\n&gt;   RPT_SECS(SEC).TITLE    := 'Top Non-DB Wait Time';\r\n&gt;   RPT_SECS(SEC).OPTIONS  := OPT_NO_FOOTER + OPT_THIN_HEADING + OPT_FIXED_TABLE;\r\n&gt;   RPT_SECS(SEC).BINDS(1) := BIND_SNAP_RANGE + BIND_DBTIME;\r\n&gt;   RPT_SECS(SEC).BINDS(3) := BIND_CONDBID_LIST;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).SUMMARY  :=\r\n&gt;    'This table displays top non-db wait time events by total wait time';\r\n&gt;   RPT_SECS(SEC).SQLSTR :=\r\n&gt;   'with agg_nondb_event as (' || DT_SRC_SYSEVT_1 || ')\r\n&gt;    select               event\r\n&gt;      , wtfg             waits\r\n&gt;      , tmfg\/1000000     time\r\n&gt;      , decode(wtfg, 0, to_number(null), tmfg\/wtfg)\/1000        avwait\r\n&gt;      , decode(:dbtime, 0, to_number(null), tmfg\/:dbtime)*100   pctwtt\r\n&gt;      , wcls\r\n&gt;   from (\r\n&gt;      select event, wtfg, tmfg, wcls\r\n&gt;      from (\r\n&gt;         select e.event_name                                      event\r\n&gt;              , e.total_waits - nvl(b.total_waits,0)              wtfg\r\n&gt;              , e.time_waited_micro - nvl(b.time_waited_micro,0)  tmfg\r\n&gt;              , e.wait_class                                      wcls\r\n&gt;         from agg_nondb_event b\r\n&gt;            , agg_nondb_event e\r\n&gt;        where b.snap_id  (+) = :bid\r\n&gt;          and e.snap_id      = :eid\r\n&gt;          and e.dbid         = :dbid\r\n&gt;          and e.instance_number = :inst_num\r\n&gt;          and e.dbid            = b.dbid (+)\r\n&gt;          and e.instance_number = b.instance_number (+)\r\n&gt;          and e.event_id        = b.event_id (+)\r\n&gt;          and ((e.total_waits   &gt; nvl(b.total_waits,0)) or\r\n&gt;               (e.time_waited_micro &gt; nvl(b.time_waited_micro,0)))\r\n&gt;          and e.event_name in (''Network Retrans by Server'',\r\n&gt;                               ''Network Retrans by Client'')\r\n&gt;        )\r\n&gt;     order by tmfg desc, wtfg desc, event)';\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := VARCHAR2_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).SUBTYPE := SUBTYPE_ROWHEAD;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT  := 'a30';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := 'Event';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := NUMBER_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT := '99,999,990|blanknull';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := 'Waits';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := NUMBER_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT := 'm10';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := 'Total Wait|Time (sec)';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := NUMBER_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT := 's9|blanknull';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := 'Avg|Wait';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := NUMBER_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT := '999.9|blanknull';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := '% DB|time';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).TYPE := VARCHAR2_TYPE;\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).FORMAT := 'a8';\r\n&gt;   RPT_SECS(SEC).ROW_DESC(COL).HEADING := 'Wait|Class';\r\n&gt;   COL := COL + 1;\r\n&gt;\r\n&gt;   DBMS_SWRF_REPORT_INTERNAL.BUILD_HEADING_INFO(SEC);\r\n&gt;\r\n&gt;\r\n&gt;    IF (INCLUDE_ASH) THEN\r\n<\/pre>\n<div id=\"SYS.DBMS_BACKUP_RESTORE.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_BACKUP_RESTORE &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2781c2781,2782\r\n&lt;                      ,FOREIGNAL        IN BOOLEAN DEFAULT FALSE);\r\n---\r\n&gt;                      ,FOREIGNAL        IN BOOLEAN DEFAULT FALSE\r\n&gt;                      ,PDBID            IN NUMBER DEFAULT NULL);\r\n9603a9605,9613\r\n&gt;     BEGIN\r\n&gt;        RESTORESETXTTFILE(PLTFRMFR =&gt; PLTFRMFR,\r\n&gt;                          XTTINCR  =&gt; XTTINCR,\r\n&gt;                          PDBID    =&gt; NULL);\r\n&gt;     END RESTORESETXTTFILE;\r\n&gt;\r\n&gt; PROCEDURE RESTORESETXTTFILE( PLTFRMFR      IN   BINARY_INTEGER\r\n&gt;                             ,XTTINCR       IN   BOOLEAN\r\n&gt;                             ,PDBID         IN   NUMBER) IS\r\n9619c9629,9630\r\n&lt;                  ,PREPLUGIN        =&gt; FALSE);\r\n---\r\n&gt;                  ,PREPLUGIN        =&gt; FALSE\r\n&gt;                  ,PDBID            =&gt; PDBID);\r\n9626c9637\r\n&lt;     END;\r\n---\r\n&gt;     END RESTORESETXTTFILE;\r\n<\/pre>\n<div id=\"SYS.DBMS_DBFS_SFS.PACKAGE BODY.19.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\">11493a11494\r\n&gt;         GOODLINK        BOOLEAN;\r\n11511a11513,11520\r\n&gt;\r\n&gt;         IF DBMS_DBFS_SFS_ADMIN.GET_PARAM('_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<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUNDLE.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUNDLE &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">12,21d11\r\n&lt; PROCEDURE CREATE_DIRS  IS\r\n&lt;     L_HOME VARCHAR2(255);\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt; BEGIN\r\n&lt;\r\n&lt;     SYS.DBMS_SYSTEM.GET_ENV('ORACLE_HOME', L_HOME);\r\n&lt;\r\n&lt;\r\n&lt;     DIR := ADMINDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || ADMINDIR ||  ' as '''||L_HOME||'\/rdbms\/admin''';\r\n23,33d12\r\n&lt;     DIR := LOGDIR;\r\n&lt;     EXECUTE IMMEDIATE 'create directory ' || LOGDIR || ' as '''||L_HOME||'\/cfgtoollogs''';\r\n&lt;\r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;\r\n&lt;      IF DIR = LOGDIR THEN\r\n&lt;        EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR;\r\n&lt;      END IF;\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', directory creation failed for ' || DIR);\r\n&lt; END CREATE_DIRS;\r\n36,43d14\r\n&lt; PROCEDURE CLEANUP  IS\r\n&lt;     DIR    VARCHAR2(30);\r\n&lt;     OBJID NUMBER;\r\n&lt;     CURSOR C1(OBJNAME VARCHAR2) IS SELECT OBJECT_ID FROM ALL_OBJECTS\r\n&lt;      WHERE OBJECT_TYPE ='DIRECTORY' AND OBJECT_NAME=OBJNAME;\r\n&lt; BEGIN\r\n&lt;\r\n&lt;   DIR := ADMINDIR;\r\n45,57d15\r\n&lt;   OPEN C1(ADMINDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || ADMINDIR;\r\n&lt;   END IF;\r\n&lt;   CLOSE C1;\r\n&lt;\r\n&lt;   DIR := LOGDIR;\r\n&lt;   OPEN C1(LOGDIR);\r\n&lt;   FETCH C1 INTO OBJID;\r\n&lt;   IF C1%FOUND THEN\r\n&lt;     EXECUTE IMMEDIATE 'drop directory ' || LOGDIR;\r\n&lt;   END IF;\r\n59,71c17\r\n&lt; EXCEPTION\r\n&lt;    WHEN OTHERS THEN\r\n&lt;      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', cleanup failed for ' || DIR);\r\n&lt; END CLEANUP;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt; FUNCTION GET_LOGFILE_NAME RETURN SYS.V$SYSTEM_PARAMETER.VALUE%TYPE\r\n---\r\n&gt; FUNCTION GET_LOGFILE_NAME RETURN \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE\r\n74,75c20\r\n&lt;   LOGFILE  SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n&lt;\r\n---\r\n&gt;   LOGFILE  \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n161,162d105\r\n&lt;\r\n&lt;       CLEANUP;\r\n181,182d123\r\n&lt;\r\n&lt;     CLEANUP;\r\n254,255d194\r\n&lt;\r\n&lt;      CLEANUP;\r\n362,363d300\r\n&lt;\r\n&lt;      CLEANUP;\r\n437,438d373\r\n&lt;\r\n&lt;      CLEANUP;\r\n456c391\r\n&lt;     SELECT VALUE FROM SYS.V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n---\r\n&gt;     SELECT VALUE FROM \"PUBLIC\".V$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM;\r\n475c410\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in v$system_fix_control');\r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in PUBLIC.v$system_fix_control');\r\n480c415\r\n&lt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in v$system_fix_control');\r\n---\r\n&gt;        RAISE_APPLICATION_ERROR(-20002, 'get_bundle_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in PUBLIC.v$system_fix_control');\r\n496,497d430\r\n&lt;\r\n&lt;      CLEANUP;\r\n513c446\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n550,551d482\r\n&lt;\r\n&lt;      CLEANUP;\r\n567c498\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n619,620d549\r\n&lt;\r\n&lt;      CLEANUP;\r\n627c556\r\n&lt;   CURSOR C1 IS  SELECT COUNT(*) FROM GV$INSTANCE WHERE STATUS='OPEN';\r\n---\r\n&gt;   CURSOR C1 IS  SELECT COUNT(*) FROM SYS.GV$INSTANCE WHERE STATUS='OPEN';\r\n630c559\r\n&lt;   CURSOR C2 IS SELECT VALUE FROM V$PARAMETER WHERE NAME='cluster_database_instances';\r\n---\r\n&gt;   CURSOR C2 IS SELECT VALUE FROM \"PUBLIC\".V$PARAMETER WHERE NAME='cluster_database_instances';\r\n632c561\r\n&lt;   TOTAL_VAL  SYS.V$PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   TOTAL_VAL  \"PUBLIC\".V$PARAMETER.VALUE%TYPE;\r\n664,665d592\r\n&lt;\r\n&lt;     CLEANUP;\r\n673c600\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n760c687\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n882c809\r\n&lt;    SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;    SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1002,1004d928\r\n&lt;\r\n&lt;     CLEANUP;\r\n&lt;\r\n1015d938\r\n&lt;     CLEANUP;\r\n1025c948\r\n&lt;      SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1061c984\r\n&lt;                'gv$system_fix_control where inst_id= ' || INSTID;\r\n---\r\n&gt;                'sys.gv$system_fix_control where inst_id= ' || INSTID;\r\n1123,1125d1045\r\n&lt;\r\n&lt;     CLEANUP;\r\n&lt;\r\n1136d1055\r\n&lt;     CLEANUP;\r\n1163c1082\r\n&lt;     SELECT OPEN_MODE INTO OPENMODE FROM V$PDBS;\r\n---\r\n&gt;     SELECT OPEN_MODE INTO OPENMODE FROM \"PUBLIC\".V$PDBS;\r\n1186d1104\r\n&lt;     CLEANUP;\r\n1223c1141\r\n&lt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM  GV$INSTANCE\r\n---\r\n&gt;   CURSOR C1 IS SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE\r\n1236d1153\r\n&lt;   INSTNAMEBIND VARCHAR2(20);\r\n1238c1155\r\n&lt;   LOGFILE   SYS.V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n---\r\n&gt;   LOGFILE   \"PUBLIC\".V$SYSTEM_PARAMETER.VALUE%TYPE;\r\n1257,1259d1173\r\n&lt;\r\n&lt;   CREATE_DIRS;\r\n&lt;\r\n1274,1275d1187\r\n&lt;\r\n&lt;     CLEANUP;\r\n1283,1284d1194\r\n&lt;\r\n&lt;     CLEANUP;\r\n1308c1218\r\n&lt;   SELECT INSTANCE_NAME INTO INSTNAME FROM V$INSTANCE;\r\n---\r\n&gt;   SELECT INSTANCE_NAME INTO INSTNAME FROM \"PUBLIC\".V$INSTANCE;\r\n1494,1495c1404,1406\r\n&lt;             INSTNAMEBIND := '''' || INSTNAME || '''';\r\n&lt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' || INSTNAMEBIND || 'scope=spfile';\r\n---\r\n&gt;             SQL_STMT := 'alter system reset \"_fix_control\" SID=' ||\r\n&gt;                          SYS.DBMS_ASSERT.ENQUOTE_LITERAL(INSTNAME) ||\r\n&gt;                          ' scope=spfile';\r\n1505d1415\r\n&lt;               CLEANUP;\r\n1525,1527d1434\r\n&lt;\r\n&lt;   CLEANUP;\r\n&lt;\r\n1533,1534d1439\r\n&lt;\r\n&lt;     CLEANUP;\r\n1558,1560d1462\r\n&lt;   CREATE_DIRS;\r\n&lt;\r\n&lt;\r\n1577d1478\r\n&lt;     CLEANUP;\r\n1595d1495\r\n&lt;    CLEANUP;\r\n1675,1677d1574\r\n&lt;\r\n&lt;   CLEANUP;\r\n&lt;\r\n1680,1681d1576\r\n&lt;\r\n&lt;      CLEANUP;\r\n1695,1696d1589\r\n&lt;\r\n&lt;   CREATE_DIRS;\r\n1716,1717d1608\r\n&lt;\r\n&lt;   CLEANUP;\r\n1720,1721d1610\r\n&lt;\r\n&lt;      CLEANUP;\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.19.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) := '19.03.00.00';\r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '19.04.00.00';\r\n211a212\r\n&gt; TAG_LIKE        NUMBER := 0;\r\n665a667,669\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n947a952,954\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1056a1064\r\n&gt;        AND RESTORETAG IS NULL\r\n1128a1137,1139\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1199a1211,1213\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1333a1348,1350\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1441a1459,1461\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1760a1781,1783\r\n&gt;               AND (RESTORETAG IS NULL OR\r\n&gt;                    ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                     (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1884a1908,1910\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n1982a2009,2011\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n2111a2141,2143\r\n&gt;            AND (RESTORETAG IS NULL OR\r\n&gt;                 ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                  (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n2167a2200,2202\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n2304a2340,2342\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n2830a2869,2871\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n2919a2961,2963\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3015a3060,3062\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3098a3146,3148\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3225a3276\r\n&gt;       AND RESTORETAG IS NULL\r\n3446a3498,3500\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3665a3720,3722\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3778a3836,3838\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3825a3886,3888\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3847a3911,3913\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3873a3940,3942\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3908a3978,3980\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n3968a4041,4043\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n4016a4092,4094\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n4066a4145,4147\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n4105a4187,4189\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7282a7367,7369\r\n&gt;     AND (RESTORETAG IS NULL OR\r\n&gt;          ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;           (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7297a7385,7387\r\n&gt;     AND (RESTORETAG IS NULL OR\r\n&gt;          ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;           (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7431a7522,7524\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7478a7572,7574\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7518a7615,7617\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7602a7702,7704\r\n&gt;               AND (RESTORETAG IS NULL OR\r\n&gt;                    ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                     (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7682a7785,7787\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7750a7856,7858\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7825a7934,7936\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7856a7968,7970\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n7927a8042,8044\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8004a8122,8124\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8064a8185,8187\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8117a8241,8243\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8203a8330,8332\r\n&gt;              AND (RESTORETAG IS NULL OR\r\n&gt;                   ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                    (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8277a8407,8409\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8339a8472,8474\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8392a8528,8530\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8484a8623,8625\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8501a8643,8645\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8524c8668,8671\r\n&lt;           WHERE (STATUS = 'A' OR STATUS = 'X')) DC\r\n---\r\n&gt;           WHERE (STATUS = 'A' OR STATUS = 'X')\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))) DC\r\n8554a8702,8704\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND XDF.TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND XDF.TAG = RESTORETAG)))\r\n8580a8731,8733\r\n&gt;             AND (RESTORETAG IS NULL OR\r\n&gt;                  ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                   (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8623a8777,8779\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND XAL.TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND XAL.TAG = RESTORETAG)))\r\n8692a8849,8851\r\n&gt;                  AND (RESTORETAG IS NULL OR\r\n&gt;                       ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                        (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8722a8882,8884\r\n&gt;                   AND (RESTORETAG IS NULL OR\r\n&gt;                        ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                         (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8791a8954,8956\r\n&gt;               AND (RESTORETAG IS NULL OR\r\n&gt;                    ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                     (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8908a9074,9076\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n8951a9120,9122\r\n&gt;      AND (RESTORETAG IS NULL OR\r\n&gt;           ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n9201a9373,9375\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n9445a9620,9622\r\n&gt;               AND (RESTORETAG IS NULL OR\r\n&gt;                    ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                     (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n9571a9749,9751\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n9795c9975,9976\r\n&lt;            C1REC.TAG_CON = RESTORETAG OR\r\n---\r\n&gt;            ((TAG_LIKE = 1 AND C1REC.TAG_CON LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND C1REC.TAG_CON = RESTORETAG)) OR\r\n9911a10093\r\n&gt;\r\n10009c10191,10192\r\n&lt;            C1REC.TAG_CON = RESTORETAG OR\r\n---\r\n&gt;            ((TAG_LIKE = 1 AND C1REC.TAG_CON LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND C1REC.TAG_CON = RESTORETAG)) OR\r\n11173c11356\r\n&lt;       IF (TAG IS NOT NULL AND NOT TAGMATCHREQUIRED) THEN\r\n---\r\n&gt;       IF (TAG IS NOT NULL AND TAGMATCHREQUIRED) THEN\r\n11178c11361,11362\r\n&lt;          IF (TAG = LOCAL.TAG) THEN\r\n---\r\n&gt;          IF ((TAG_LIKE = 1 AND LOCAL.TAG LIKE TAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND LOCAL.TAG = TAG)) THEN\r\n11194c11378,11379\r\n&lt;             DEB(DEB_IN, 'tag does not match, continuing search');\r\n---\r\n&gt;             DEB(DEB_IN, 'tag does not match, continuing search:' ||\r\n&gt;                 LOCAL.TAG);\r\n11899,11900c12084,12088\r\n&lt;           (ACTION.TAG_CON &lt;&gt; RESTORETAG OR ACTION.TAG_CON IS NULL)) THEN\r\n&lt;       DEB(DEB_PRINT, 'isValidAction: tag mismatch - skipped:');\r\n---\r\n&gt;           (((TAG_LIKE = 1 AND ACTION.TAG_CON NOT LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND ACTION.TAG_CON &lt;&gt; RESTORETAG)) OR\r\n&gt;            ACTION.TAG_CON IS NULL)) THEN\r\n&gt;       DEB(DEB_PRINT, 'isValidAction: tag mismatch - skipped:' ||\r\n&gt;           NVL(ACTION.TAG_CON, '&lt;NUL&gt;'));\r\n12908c13096,13099\r\n&lt;    IF (NVL(TAG, '  ') != NVL(CACHEBSRECTABLE.TAG, NVL(TAG, '  '))) THEN\r\n---\r\n&gt;    IF ((TAG_LIKE = 1 AND\r\n&gt;         NVL(TAG, ' ') NOT LIKE NVL(CACHEBSRECTABLE.TAG, NVL(TAG, ' '))) OR\r\n&gt;        (TAG_LIKE &lt;&gt; 1 AND\r\n&gt;         NVL(TAG, ' ') != NVL(CACHEBSRECTABLE.TAG, NVL(TAG, ' ')))) THEN\r\n13876a14068,14071\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n14115,14116c14310,14311\r\n&lt;\r\n&lt;       IF (RMANCMD != OBSOLETECMD_T) THEN\r\n---\r\n&gt;       IF (RMANCMD != OBSOLETECMD_T OR\r\n&gt;           (RESTORETAG IS NOT NULL AND RMANCMD = OBSOLETECMD_T)) THEN\r\n14264d14458\r\n&lt;\r\n14266,14267c14460\r\n&lt;        ACTION.TYPE_CON  = BACKUPSET_CON_T AND\r\n&lt;        RMANCMD         != OBSOLETECMD_T ) THEN\r\n---\r\n&gt;        ACTION.TYPE_CON  = BACKUPSET_CON_T) THEN\r\n14276c14469,14470\r\n&lt;       IF (VALIDATIONREC.TAG = RESTORETAG OR\r\n---\r\n&gt;       IF (((TAG_LIKE = 1 AND VALIDATIONREC.TAG LIKE RESTORETAG) OR\r\n&gt;            (TAG_LIKE &lt;&gt; 1 AND VALIDATIONREC.TAG = RESTORETAG)) OR\r\n14336,14341d14529\r\n&lt;\r\n&lt;    IF (RMANCMD = OBSOLETECMD_T AND NOT ISVALIDACTION(ACTION)) THEN\r\n&lt;       DEB(DEB_EXIT, 'with action_SKIP');\r\n&lt;       RETURN ACTION_SKIP;\r\n&lt;    END IF;\r\n&lt;\r\n17797c17985,17988\r\n&lt;    IF (NVL(TAG, '  ') != NVL(CACHEBSRECTABLE.TAG, NVL(TAG, '  '))) THEN\r\n---\r\n&gt;    IF ((TAG_LIKE = 1 AND\r\n&gt;         NVL(TAG, ' ') NOT LIKE NVL(CACHEBSRECTABLE.TAG, NVL(TAG, ' '))) OR\r\n&gt;        (TAG_LIKE &lt;&gt; 1 AND\r\n&gt;         NVL(TAG, ' ') != NVL(CACHEBSRECTABLE.TAG, NVL(TAG, ' ')))) THEN\r\n18093a18285,18287\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n18375a18570,18572\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n18467a18665\r\n&gt;        AND RESTORETAG IS NULL\r\n18540a18739,18741\r\n&gt;        AND (RESTORETAG IS NULL OR\r\n&gt;             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n18611a18813,18815\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19180c19384,19385\r\n&lt;             AL.FIRST_CHANGE# &lt;  D2.NEXT_RESETLOGS_CHANGE#));\r\n---\r\n&gt;             AL.FIRST_CHANGE# &lt;  D2.NEXT_RESETLOGS_CHANGE#))\r\n&gt;       AND RESTORETAG IS NULL;\r\n19222c19427,19430\r\n&lt;             XAL.FIRST_CHANGE# &lt;  D2.NEXT_RESETLOGS_CHANGE#));\r\n---\r\n&gt;             XAL.FIRST_CHANGE# &lt;  D2.NEXT_RESETLOGS_CHANGE#))\r\n&gt;       AND (RESTORETAG IS NULL OR\r\n&gt;            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)));\r\n19269a19478\r\n&gt;                       AND RESTORETAG IS NULL\r\n19320a19530,19532\r\n&gt;                       AND (RESTORETAG IS NULL OR\r\n&gt;                            ((TAG_LIKE = 1 AND XAL.TAG LIKE RESTORETAG) OR\r\n&gt;                             (TAG_LIKE &lt;&gt; 1 AND XAL.TAG = RESTORETAG)))\r\n19386a19599\r\n&gt;                       AND RESTORETAG IS NULL\r\n19421a19635,19637\r\n&gt;                        AND (RESTORETAG IS NULL OR\r\n&gt;                             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19450a19667,19669\r\n&gt;                        AND (RESTORETAG IS NULL OR\r\n&gt;                             ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                              (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19508c19727\r\n&lt;\r\n---\r\n&gt;                     AND RESTORETAG IS NULL\r\n19539a19759,19761\r\n&gt;                     AND (RESTORETAG IS NULL OR\r\n&gt;                          ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                           (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19564a19787,19789\r\n&gt;                     AND (RESTORETAG IS NULL OR\r\n&gt;                          ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                           (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19639a19865\r\n&gt;                       AND RESTORETAG IS NULL\r\n19678a19905,19907\r\n&gt;                       AND (RESTORETAG IS NULL OR\r\n&gt;                            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n19710a19940,19942\r\n&gt;                       AND (RESTORETAG IS NULL OR\r\n&gt;                            ((TAG_LIKE = 1 AND TAG LIKE RESTORETAG) OR\r\n&gt;                             (TAG_LIKE &lt;&gt; 1 AND TAG = RESTORETAG)))\r\n20298c20530,20531\r\n&lt;    TAG IN VARCHAR2 DEFAULT NULL)\r\n---\r\n&gt;    TAG IN VARCHAR2 DEFAULT NULL,\r\n&gt;    USE_LIKE IN NUMBER DEFAULT 0)\r\n20300a20534,20539\r\n&gt;\r\n&gt;\r\n&gt;    IF (NVL(TAG, ' ') &lt;&gt; NVL(RESTORETAG, ' ') AND RCVRECCURSOR1_C%ISOPEN) THEN\r\n&gt;       DEB(DEB_PRINT, 'closing cursor rcRecCursor_c');\r\n&gt;       CLOSE RCVRECCURSOR1_C;\r\n&gt;    END IF;\r\n20301a20541,20542\r\n&gt;    TAG_LIKE := USE_LIKE;\r\n&gt;    DEB(DEB_PRINT, 'restoreTag='|| RESTORETAG ||  ',tag_like='|| TAG_LIKE);\r\n25918a26160,26162\r\n&gt;\r\n&gt;   VALIDATIONREC        VALIDBACKUPSETREC_T;\r\n&gt;   BS_RCVREC            RCVREC_T;\r\n26576a26821,26822\r\n&gt;   &lt;&lt;NEXTROW&gt;&gt;\r\n&gt;\r\n26803a27050,27085\r\n&gt;     END IF;\r\n&gt;\r\n&gt;\r\n&gt;     IF (LBREC.BACKUP_TYPE = BACKUPSET_TXT AND RESTORETAG IS NOT NULL) THEN\r\n&gt;        BS_RCVREC.BSKEY_CON := LBREC.BS_KEY;\r\n&gt;        BS_RCVREC.SETCOUNT_CON := LBREC.BS_COUNT;\r\n&gt;        BS_RCVREC.SETSTAMP_CON := LBREC.BS_STAMP;\r\n&gt;        BS_RCVREC.PIECECOUNT_CON := LBREC.BS_PIECES;\r\n&gt;        IF (LBREC.FILE_TYPE = ARCHIVEDLOG_TXT) THEN\r\n&gt;           BS_RCVREC.LOGLOWSCN_OBJ := LBREC.RL_FIRST_CHANGE#;\r\n&gt;           BS_RCVREC.LOGTHREAD_OBJ := LBREC.RL_THREAD#;\r\n&gt;           BS_RCVREC.LOGSEQUENCE_OBJ := LBREC.RL_SEQUENCE#;\r\n&gt;        ELSIF (LBREC.FILE_TYPE IN (SPFILE_TXT, CONTROLFILE_TXT)) THEN\r\n&gt;           BS_RCVREC.DFNUMBER_OBJ := 0;\r\n&gt;           BS_RCVREC.FROMSCN_ACT := 0;\r\n&gt;        ELSIF (LBREC.FILE_TYPE = DATAFILE_TXT) THEN\r\n&gt;           BS_RCVREC.DFNUMBER_OBJ := 0;\r\n&gt;           BS_RCVREC.FROMSCN_ACT := LBREC.DF_CHECKPOINT_CHANGE#;\r\n&gt;           IF (LBREC.DF_INCREMENTAL_CHANGE# = LBREC.DF_CREATION_CHANGE# OR\r\n&gt;               LBREC.BS_INCR_TYPE = FULL_TXT) THEN\r\n&gt;              BS_RCVREC.FROMSCN_ACT := 0;\r\n&gt;           ELSIF (LBREC.BS_INCR_TYPE &lt;&gt; FULL_TXT) THEN\r\n&gt;              BS_RCVREC.FROMSCN_ACT := LBREC.DF_INCREMENTAL_CHANGE#;\r\n&gt;           END IF;\r\n&gt;        END IF;\r\n&gt;\r\n&gt;        IF VALIDATEBACKUPSET(BACKUPSETREC=&gt; BS_RCVREC,\r\n&gt;                  TAG                    =&gt; RESTORETAG,\r\n&gt;                  TAGMATCHREQUIRED       =&gt; TRUE,\r\n&gt;                  CHECKDEVICEISALLOCATED =&gt; TRUE,\r\n&gt;                  AVAILABLEMASK          =&gt; BSAVAILABLE,\r\n&gt;                  VALIDREC               =&gt; VALIDATIONREC) &lt;&gt; SUCCESS THEN\r\n&gt;          DEB(DEB_IN, 'tag does not match: bs_key=' || LBREC.BS_KEY);\r\n&gt;          GOTO NEXTROW;\r\n&gt;       END IF;\r\n&gt;\r\n28103c28385\r\n&lt;   ,ATANYSCN        IN   BOOLEAN  DEFAULT FALSE)\r\n---\r\n&gt;   ,ATANYSCN        IN   BOOLEAN  DEFAULT FALSE)\r\n28720c29002\r\n&lt;             DEB(DEB_IN, 'tag does not match');\r\n---\r\n&gt;             DEB(DEB_IN, 'tag does not match for controlfile proxy copy');\r\n29045c29327\r\n&lt;             DEB(DEB_EXIT, 'tag does not match');\r\n---\r\n&gt;             DEB(DEB_EXIT, 'tag does not match for proxy copy:'||BRLREC.TAG_CON);\r\n29284,29296c29566,29572\r\n&lt;       IF (RMANCMD = OBSOLETECMD_T) THEN\r\n&lt;\r\n&lt;\r\n&lt;          VALRC := SUCCESS;\r\n&lt;       ELSE\r\n&lt;          VALRC := VALIDATEBACKUPSET(\r\n&lt;                BACKUPSETREC           =&gt; BSFREC,\r\n&lt;                TAG                    =&gt; RESTORETAG,\r\n&lt;                TAGMATCHREQUIRED       =&gt; TRUE,\r\n&lt;                CHECKDEVICEISALLOCATED =&gt; TRUE,\r\n&lt;                AVAILABLEMASK          =&gt; BSAVAILABLE,\r\n&lt;                VALIDREC               =&gt; VALIDATEREC);\r\n&lt;       END IF;\r\n---\r\n&gt;       VALRC := VALIDATEBACKUPSET(\r\n&gt;             BACKUPSETREC           =&gt; BSFREC,\r\n&gt;             TAG                    =&gt; RESTORETAG,\r\n&gt;             TAGMATCHREQUIRED       =&gt; TRUE,\r\n&gt;             CHECKDEVICEISALLOCATED =&gt; TRUE,\r\n&gt;             AVAILABLEMASK          =&gt; BSAVAILABLE,\r\n&gt;             VALIDREC               =&gt; VALIDATEREC);\r\n29313,29322d29588\r\n&lt;          ELSIF (RMANCMD = OBSOLETECMD_T) THEN\r\n&lt;             DEB(DEB_IN, ' Added bsfRec:');\r\n&lt;\r\n&lt;             RCVRECPUSH(BSFREC);\r\n&lt;             GETBS_STATUS := SUCCESS;\r\n&lt;             IF (LCOPIES &gt; 1) THEN\r\n&lt;                LCOPIES := LCOPIES - 1;\r\n&lt;             ELSE\r\n&lt;                EXIT;\r\n&lt;             END IF;\r\n29590a29857\r\n&gt;    DEB(DEB_PRINT, 'getRA_likePattern='|| PATTERN);\r\n<\/pre>\n<div id=\"SYS.DBMS_RCVMAN.PACKAGE BODY.19.0.0.0_19.3RUR\">SYS.DBMS_RCVMAN &#8211; PACKAGE BODY (19.3RUR):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">122c122\r\n&lt; CATALOGVERSION CONSTANT VARCHAR2(11) := '19.03.00.00';\r\n---\r\n&gt; CATALOGVERSION CONSTANT VARCHAR2(11) := '19.03.01.00';\r\n<\/pre>\n<div id=\"SYS.DBMS_RESOURCE_MANAGER.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_RESOURCE_MANAGER &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">643a644,648\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;    DBMS_RMIN_SYS.RM$_CLRPAREA(FALSE);\r\n&gt;\r\n681,683c686,688\r\n&lt; PENDING_AREA         BOOLEAN;\r\n&lt; PENDING_AREA_EXISTS  EXCEPTION;\r\n&lt; PRAGMA EXCEPTION_INIT(PENDING_AREA_EXISTS, -29370);\r\n---\r\n&gt; PENDING_AREA_CREATED BOOLEAN;\r\n&gt; NO_PENDING_AREA  EXCEPTION;\r\n&gt; PRAGMA EXCEPTION_INIT(NO_PENDING_AREA, -29371);\r\n696,698c701,702\r\n&lt;      PENDING_AREA := FALSE;\r\n&lt;      DBMS_RMIN_SYS.RM$_CRTPAREA(FALSE);\r\n&lt;\r\n---\r\n&gt;      PENDING_AREA_CREATED := FALSE;\r\n&gt;      DBMS_RMIN_SYS.RM$_VERIFY_PENDING_AREA_ACT;\r\n700,702c704,705\r\n&lt;      WHEN PENDING_AREA_EXISTS THEN\r\n&lt;\r\n&lt;        PENDING_AREA := TRUE;\r\n---\r\n&gt;      WHEN NO_PENDING_AREA THEN\r\n&gt;        PENDING_AREA_CREATED := TRUE;\r\n707a711,714\r\n&gt;    IF PENDING_AREA_CREATED THEN\r\n&gt;      DBMS_RMIN_SYS.RM$_CRTPAREA(FALSE);\r\n&gt;    END IF;\r\n&gt;\r\n712c719\r\n&lt;      IF (NOT PENDING_AREA) THEN\r\n---\r\n&gt;      IF (PENDING_AREA_CREATED) THEN\r\n718c725\r\n&lt;        IF (NOT PENDING_AREA) THEN\r\n---\r\n&gt;        IF (PENDING_AREA_CREATED) THEN\r\n<\/pre>\n<div id=\"SYS.DBMS_SPM.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SPM &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">83a84\r\n&gt;   PAR_ALTERNATE_BASELINE  CONSTANT VARCHAR2(23) := 'ALTERNATE_PLAN_BASELINE';\r\n537a539,545\r\n&gt;\r\n&gt;\r\n&gt;         DBMS_ADVISOR.SET_TASK_PARAMETER(\r\n&gt;           DBMS_SPM_INTERNAL.AUTO_EVOLVE_TASK_NAME,\r\n&gt;           PAR_ALTERNATE_BASELINE,\r\n&gt;           DBMS_SPM_INTERNAL.AUTO_EVOLVE_TASK_ALTERNATE_VAL);\r\n&gt;\r\n2736a2745,2750\r\n&gt;\r\n&gt;\r\n&gt;     IF (PARAMETER = PAR_ALTERNATE_BASELINE AND\r\n&gt;         VALUE     = DBMS_SPM_INTERNAL.AUTO_EVOLVE_TASK_ALTERNATE_VAL) THEN\r\n&gt;       SYS.DBMS_SPM_INTERNAL.CHECK_AUTO_SPM_ENABLED;\r\n&gt;     END IF;\r\n<\/pre>\n<div id=\"SYS.DBMS_SPM_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SPM_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">2613,2617d2612\r\n&lt;     PRVT_ADVISOR.SET_TASK_PARAMETER(TASK_NAME =&gt; TNAME,\r\n&lt;                                     PARAMETER =&gt; 'ALTERNATE_PLAN_BASELINE',\r\n&lt;                                     DATA =&gt; AUTO_EVOLVE_TASK_ALTERNATE_VAL,\r\n&lt;                                     TASK_OWNER_ID =&gt; PRVT_ADVISOR.SYS_USER_ID);\r\n&lt;\r\n4219a4215,4265\r\n&gt;   PROCEDURE AUTO_SPM_ENABLED_CALLOUT(\r\n&gt;     AUTO_SPM_IS_ENABLED    OUT    NUMBER\r\n&gt;   ) IS\r\n&gt;   EXTERNAL NAME \"kapspmEnabled\" WITH CONTEXT\r\n&gt;   PARAMETERS(CONTEXT,\r\n&gt;     AUTO_SPM_IS_ENABLED OCINUMBER\r\n&gt;   )\r\n&gt;   LIBRARY DBMS_SPM_LIB;\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 CHECK_AUTO_SPM_ENABLED\r\n&gt;   RETURN BOOLEAN\r\n&gt;   IS\r\n&gt;     ENABLED_CODE NUMBER;\r\n&gt;   BEGIN\r\n&gt;     AUTO_SPM_ENABLED_CALLOUT(ENABLED_CODE);\r\n&gt;\r\n&gt;     IF (ENABLED_CODE = 0) THEN\r\n&gt;       RETURN FALSE;\r\n&gt;     END IF;\r\n&gt;\r\n&gt;     RETURN TRUE;\r\n&gt;   END CHECK_AUTO_SPM_ENABLED;\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;\r\n&gt;\r\n4299c4345,4347\r\n&lt;      IF (BASELINES LIKE '%AUTO%') THEN\r\n---\r\n&gt;\r\n&gt;\r\n&gt;     IF (BASELINES LIKE '%AUTO%' AND CHECK_AUTO_SPM_ENABLED) THEN\r\n6018,6041d6065\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;\r\n&lt;   PROCEDURE AUTO_SPM_ENABLED_CALLOUT(\r\n&lt;     AUTO_SPM_IS_ENABLED    OUT    NUMBER\r\n&lt;   ) IS\r\n&lt;   EXTERNAL NAME \"kapspmEnabled\" WITH CONTEXT\r\n&lt;   PARAMETERS(CONTEXT,\r\n&lt;     AUTO_SPM_IS_ENABLED OCINUMBER\r\n&lt;   )\r\n&lt;   LIBRARY DBMS_SPM_LIB;\r\n<\/pre>\n<div id=\"SYS.DBMS_STATS.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_STATS &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">32624d32623\r\n&lt;\r\n32626c32625\r\n&lt;\r\n---\r\n&gt;\r\n32628c32627\r\n&lt;         FETCH SYS.DBMS_STATS_INTERNAL.OBJ_NAME_QRY\r\n---\r\n&gt;         FETCH SYS.DBMS_STATS_INTERNAL.OBJ_NAME_QRY\r\n50983c50982,50985\r\n&lt;         SELECT CGU.OBJ# OBJ#, DSC_DMLMON_FLGS_MISSING_EXTN FLGS\r\n---\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;         SELECT DISTINCT CGU.OBJ# OBJ#, DSC_DMLMON_FLGS_MISSING_EXTN FLGS\r\n50990a50993,50998\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;           BITAND(CGU.FLAGS,\r\n&gt;             DBMS_STATS_INTERNAL.DSC_CG_SRC_SEED+\r\n&gt;             DBMS_STATS_INTERNAL.DSC_CG_SRC_DIR) &gt; 0 AND\r\n<\/pre>\n<div id=\"SYS.DBMS_SWRF_REPORT_INTERNAL.PACKAGE BODY.19.0.0.0_RU\">SYS.DBMS_SWRF_REPORT_INTERNAL &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">14195a14196,14200\r\n&gt;     REPORT_SECTION(DBMS_AWR_REPORT_LAYOUT.TOP_NONDB_WAIT_TIME, TO_HTML);\r\n&gt;\r\n&gt;\r\n&gt;\r\n&gt;\r\n<\/pre>\n<div id=\"SYS.KUPM$MCP.PACKAGE BODY.19.0.0.0_RU\">SYS.KUPM$MCP &#8211; PACKAGE BODY (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">3318c3318\r\n&lt;                                 '(file_type &lt;&gt; :2)';\r\n---\r\n&gt;                                '(file_type NOT IN (:2, :3))';\r\n3322c3322,3323\r\n&lt;                                KUPCC.MT_FILE_TYPE_DISK;\r\n---\r\n&gt;                                 KUPCC.MT_FILE_TYPE_DISK,\r\n&gt;                                 KUPCC.MT_FILE_TYPE_URIDISK;\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_BUGVALOBTYPE.TYPE.19.0.0.0_RU\">SYS.DBMS_OPTIM_BUGVALOBTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_bugValObType as object(fix number, val number)\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_bugValObType FORCE as object(fix number, val number) NOT PERSISTABLE;\r\n&gt;\r\n<\/pre>\n<div id=\"SYS.DBMS_OPTIM_FCTABTYPE.TYPE.19.0.0.0_RU\">SYS.DBMS_OPTIM_FCTABTYPE &#8211; TYPE (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1,3\r\n&lt; TYPE dbms_optim_fcTabType as table of dbms_optim_bugValObType\r\n---\r\n&gt; TYPE\r\n&gt;   dbms_optim_fcTabType as table of (dbms_optim_bugValObType) NOT PERSISTABLE;\r\n&gt;\r\n<\/pre>\n<div id=\"SYS.CDB_TAB_COLS_V$.VIEW.19.0.0.0_RU\">SYS.CDB_TAB_COLS_V$ &#8211; VIEW (RU):<\/div>\n<pre class=\"EnlighterJSRAW enlighter-collapse\" data-enlighter-language=\"diff\" data-enlighter-linenumbers=\"false\">1c1\r\n&lt; SELECT k.\"OWNER\",k.\"TABLE_NAME\",k.\"TABLE_ID\",k.\"COLUMN_NAME\",k.\"COLUMN_INT_ID\",k.\"DATA_TYPE\",k.\"DATA_TYPE_MOD\",k.\"DATA_TYPE_OWNER\",k.\"DATA_LENGTH\",k.\"DATA_PRECISION\",k.\"DATA_SCALE\",k.\"NULLABLE\",k.\"COLUMN_ID\",k.\"DEFAULT_LENGTH\",k.\"NUM_DISTINCT\",k.\"LOW_VALUE\",k.\"HIGH_VALUE\",k.\"DENSITY\",k.\"NUM_NULLS\",k.\"NUM_BUCKETS\",k.\"LAST_ANALYZED\",k.\"SAMPLE_SIZE\",k.\"CHARACTER_SET_NAME\",k.\"CHAR_COL_DECL_LENGTH\",k.\"GLOBAL_STATS\",k.\"USER_STATS\",k.\"NOTES\",k.\"AVG_COL_LEN\",k.\"CHAR_LENGTH\",k.\"CHAR_USED\",k.\"V80_FMT_IMAGE\",k.\"DATA_UPGRADED\",k.\"HIDDEN_COLUMN\",k.\"VIRTUAL_COLUMN\",k.\"SEGMENT_COLUMN_ID\",k.\"INTERNAL_COLUMN_ID\",k.\"HISTOGRAM\",k.\"QUALIFIED_COL_NAME\",k.\"USER_GENERATED\",k.\"DEFAULT_ON_NULL\",k.\"IDENTITY_COLUMN\",k.\"SENSITIVE_COLUMN\",k.\"EVALUATION_EDITION\",k.\"UNUSABLE_BEFORE\",k.\"UNUSABLE_BEGINNING\",k.\"COLLATION\",k.\"COLLATED_COLUMN_ID\",k.\"CON_ID\", k.CON$NAME, k.CDB$NAME, k.CON$ERRNUM, k.CON$ERRMSG FROM CONTAINERS(\"SYS\".\"DBA_TAB_COLS_V$\") k\r\n---\r\n&gt; SELECT k.\"OWNER\",k.\"OWNER_ID\",k.\"TABLE_NAME\",k.\"TABLE_ID\",k.\"COLUMN_NAME\",k.\"COLUMN_INT_ID\",k.\"DATA_TYPE\",k.\"DATA_TYPE_MOD\",k.\"DATA_TYPE_OWNER\",k.\"DATA_LENGTH\",k.\"DATA_PRECISION\",k.\"DATA_SCALE\",k.\"NULLABLE\",k.\"COLUMN_ID\",k.\"DEFAULT_LENGTH\",k.\"NUM_DISTINCT\",k.\"LOW_VALUE\",k.\"HIGH_VALUE\",k.\"DENSITY\",k.\"NUM_NULLS\",k.\"NUM_BUCKETS\",k.\"LAST_ANALYZED\",k.\"SAMPLE_SIZE\",k.\"CHARACTER_SET_NAME\",k.\"CHAR_COL_DECL_LENGTH\",k.\"GLOBAL_STATS\",k.\"USER_STATS\",k.\"NOTES\",k.\"AVG_COL_LEN\",k.\"CHAR_LENGTH\",k.\"CHAR_USED\",k.\"V80_FMT_IMAGE\",k.\"DATA_UPGRADED\",k.\"HIDDEN_COLUMN\",k.\"VIRTUAL_COLUMN\",k.\"SEGMENT_COLUMN_ID\",k.\"INTERNAL_COLUMN_ID\",k.\"HISTOGRAM\",k.\"QUALIFIED_COL_NAME\",k.\"USER_GENERATED\",k.\"DEFAULT_ON_NULL\",k.\"IDENTITY_COLUMN\",k.\"SENSITIVE_COLUMN\",k.\"EVALUATION_EDITION\",k.\"UNUSABLE_BEFORE\",k.\"UNUSABLE_BEGINNING\",k.\"COLLATION\",k.\"COLLATED_COLUMN_ID\",k.\"CON_ID\", k.CON$NAME, k.CDB$NAME, k.CON$ERRNUM, k.CON$ERRMSG FROM CONTAINERS(\"SYS\".\"DBA_TAB_COLS_V$\") k\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 July CPU: <a href=\"https:\/\/www.oracle.com\/technetwork\/security-advisory\/cpujul2019-5072835.html\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.oracle.com\/technetwork\/security-advisory\/cpujul2019-5072835.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-4250 jlk' href='javascript:void(0)' data-task='like' data-post_id='4250' 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-4250 lc'>0<\/span><\/a><\/div><\/div> <div class='status-4250 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 190416 BP, PSU, RU and RUR Dissecting 190115 BP, PSU, RU and RUR Dissecting 181016 BP, PSU, RU and RUR &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-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-4250","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 190716 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"All the changes performed by Oracle July 2019 Database CPU (190716) 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\/08\/dissecting-190716-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=\"102 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\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Dissecting 190716 BP, PSU, RU and RUR\",\"datePublished\":\"2019-08-19T00:05:46+00:00\",\"dateModified\":\"2019-09-24T15:19:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/\"},\"wordCount\":1551,\"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\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/\",\"name\":\"Dissecting 190716 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2019-08-19T00:05:46+00:00\",\"dateModified\":\"2019-09-24T15:19:47+00:00\",\"description\":\"All the changes performed by Oracle July 2019 Database CPU (190716) dissected.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-bp-psu-ru-and-rur\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2019\\\/08\\\/dissecting-190716-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 190716 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 190716 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"All the changes performed by Oracle July 2019 Database CPU (190716) 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\/08\/dissecting-190716-bp-psu-ru-and-rur\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"102 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Dissecting 190716 BP, PSU, RU and RUR","datePublished":"2019-08-19T00:05:46+00:00","dateModified":"2019-09-24T15:19:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/"},"wordCount":1551,"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\/08\/dissecting-190716-bp-psu-ru-and-rur\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/","url":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/","name":"Dissecting 190716 BP, PSU, RU and RUR - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2019-08-19T00:05:46+00:00","dateModified":"2019-09-24T15:19:47+00:00","description":"All the changes performed by Oracle July 2019 Database CPU (190716) dissected.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-bp-psu-ru-and-rur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2019\/08\/dissecting-190716-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 190716 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\/4250","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=4250"}],"version-history":[{"count":5,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4250\/revisions"}],"predecessor-version":[{"id":4282,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4250\/revisions\/4282"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=4250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=4250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=4250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}