Dissecting Oracle Database 19.10.3 vs 19.10.2

Starting this patch cycle (July-2021), I will write quarterly blog posts giving much more details about the internal changes performed by patches in Oracle internal dictionary views and files. In the past, those changes included only code changes.

To understand why it is 19.10.3 and not 19.10.2, check this article.

Please leave in the comments if you think that anything would worth to be included.

For some other changes in this same July-2021 cycle, check the links:
- Dissecting Oracle Database 19.12.0 vs 19.11.0
- Dissecting Oracle Database 19.11.1 vs 19.11.0
- Dissecting Oracle Database 19.10.3 vs 19.10.2

Events

Included in V_$EVENT_NAME (1)

Removed from V_$EVENT_NAME (1)

Bugs fixed

Included in $ORACLE_HOME (44)

Coded objects

Changed on DBA_SOURCE/DBA_VIEWS (12)

$ORACLE_HOME non-binary files

Included in $ORACLE_HOME (5)

Removed from $ORACLE_HOME (2)

Changed on $ORACLE_HOME (91)

Table privileges

Removed from DBA_TAB_PRIVS (1)

Changes in Coded Objects (12)

    12	  bannerVersion CONSTANT VARCHAR2(15) := '19.10.02.00';                  |   bannerVersion CONSTANT VARCHAR2(15) := '19.10.03.00';
    24	  fsn  CONSTANT NUMBER := instr('19.10.02.00', '.');                     |   fsn  CONSTANT NUMBER := instr('19.10.03.00', '.');
    25	  msn  CONSTANT NUMBER := instr('19.10.02.00', '.', fsn + 1);            |   msn  CONSTANT NUMBER := instr('19.10.03.00', '.', fsn + 1);
    26	  psn  CONSTANT NUMBER := instr('19.10.02.00', '.', msn + 1);            |   psn  CONSTANT NUMBER := instr('19.10.03.00', '.', msn + 1);
    29	                           to_number(substr('19.10.02.00', 1, fsn - 1)); |                            to_number(substr('19.10.03.00', 1, fsn - 1));
    31	               to_number(substr('19.10.02.00', fsn + 1, msn - fsn - 1)); |                to_number(substr('19.10.03.00', fsn + 1, msn - fsn - 1));
    33	              to_number(substr('19.10.02.00',  msn + 1, psn - msn - 1)); |               to_number(substr('19.10.03.00',  msn + 1, psn - msn - 1));
    35	                             to_number(substr('19.10.02.00',  psn + 1)); |                              to_number(substr('19.10.03.00',  psn + 1));

   122	CATALOGVERSION CONSTANT VARCHAR2(11) := '19.10.02.00'; | CATALOGVERSION CONSTANT VARCHAR2(11) := '19.10.03.00';

    13	                               '19.10.2.0.0'; |                                '19.10.3.0.0';

     7	           dbms_json.format_flat, dbms_json.pretty) "DATAGUIDE"          |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty) "DATAGUIDE"
    33	           dbms_json.format_flat, dbms_json.pretty)  "DATAGUIDE"         |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty)  "DATAGUIDE"

     4	                                          DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                           XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
    16	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                  |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

     2	                           format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                            format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,

    20	  OMX_VERSION           CONSTANT VARCHAR2(20) := '1.51.0-200917.184935'; |   OMX_VERSION           CONSTANT VARCHAR2(20) := '1.54.0-210504.174846';

     2	                            format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                             format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,

   113	    ctxsys.drue.text_on_stack(sqlerrm, 'validate_context'); <
   115	    ctxsys.drue.raise;                                      |   raise_application_error(-20000,
   116	                                                            >     'Oracle Text error:' || '
   117	                                                            > ' || 'DRG-50857: oracle error in validate_context' || '
   118	                                                            > ' || sqlerrm || '
   119	                                                            > ' );

    72	                                                   HIERARCHY_TYPE);                |                               OBJECT_SCHEMA, OBJECT_NAME, HIERARCHY_TYPE);

   129	                                    DBMS_XDBZ.ENABLE_CONTENTS,            |                                     XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   145	                                        := DBMS_XDBZ.DISABLE_ALL,         |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   153	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)

   263	   HIERARCHY_TYPE IN PLS_INTEGER := DBMS_XDBZ.ENABLE_CONTENTS,                  |    HIERARCHY_TYPE IN PLS_INTEGER := XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   332	                                     DBMS_XDBZ.IS_ENABLED_VERSION);             |                                      XDB.DBMS_XDBZ.IS_ENABLED_VERSION);
   340	                                            DBMS_XDBZ.IS_ENABLED_CONTENTS);     |                                             XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS);
   348	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   361	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   644	                                        := DBMS_XDBZ.DISABLE_ALL,               |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   714	       HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |        HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   733	     IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                           |      IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   753	   IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   858	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)           |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
   878	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_VERSION) =                   |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_VERSION) =
   879	              DBMS_XDBZ.IS_ENABLED_VERSION) THEN                                |               XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   903	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_VERSION) THEN                      |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   907	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_CONTENTS) =                  |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) =
   908	              DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                               |               XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

0