Dissecting Oracle Database 19.11.1 vs 19.11.0

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.

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 (49)

Coded objects

Included in DBA_SOURCE/DBA_VIEWS (1)

Removed from DBA_SOURCE/DBA_VIEWS (1)

Changed on DBA_SOURCE/DBA_VIEWS (17)

$ORACLE_HOME non-binary files

Included in $ORACLE_HOME (5)

Removed from $ORACLE_HOME (2)

Changed on $ORACLE_HOME (97)

Table privileges

Removed from DBA_TAB_PRIVS (1)

Changes in Coded Objects (17)

     3	  context mdsys.SDOAggr,                              |   -- context mdsys.SDOAggr,
     5	  -- context raw(4),                                  |   -- bug 31844560: sdo_aggr_concat_line with group by
     6	                                                      >   context raw(4),

     4	 RETURN NUMBER IS                                                             |  RETURN NUMBER
     5	   ENABLED VARCHAR2(5);                                                       <
     6	 BEGIN                                                                        <
     7	   IF ( SDO_UTIL.IS_SPATIAL_ENABLED() ) THEN                                  <
     8	     ENABLED := 'YES';                                                        <
     9	   ELSE                                                                       <
    10	     ENABLED := 'NO';                                                         <
    11	   END IF;                                                                    <
    12	   MDSYS.MDPRVT_FEATURE.SDO_REGISTER_FEATURE('AGGREGATES', ENABLED);          <
    13	                                                                              <
    14	   SCTX := AGGRCONCAT(MDSYS.SDOAGGR(NULL, NULL, 0, 'SDO_CONCAT', NULL,NULL)); <
    15	   RETURN ODCICONST.SUCCESS;                                                  <
    16	 END;                                                                         <
    19	                                                                              >    AS LANGUAGE C
    20	                                                                              >     LIBRARY ORDMD_AG_LIBS
    21	                                                                              >     NAME "mdconcinit"
    22	                                                                              >     WITH CONTEXT
    24	                                                                              >        CONTEXT,
    25	                                                                              >        SCTX,
    26	                                                                              >        SCTX INDICATOR STRUCT,
    27	                                                                              >        RETURN OCINUMBER );
    39	 MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,                 <
    40	    GEOM IN MDSYS.SDO_GEOMETRY)                                               <
    41	   RETURN NUMBER IS                                                           <
    42	   BEGIN                                                                      <
    43	     RETURN CONTEXT.ODCIAGGREGATEITERATE(MDSYS.SDOAGGRTYPE(GEOM,NULL));       <
    44	   END;                                                                       <
    45	                                                                              <
    46	                                                                              <
    47	                                                                              <
    52	                                                                              >  MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,
    53	                                                                              >     GEOM IN MDSYS.SDO_GEOMETRY)
    54	                                                                              >  RETURN NUMBER
    57	                                                                              >     AS LANGUAGE C
    58	                                                                              >     LIBRARY ORDMD_AG_LIBS
    59	                                                                              >     NAME "mdconciter"
    60	                                                                              >     WITH CONTEXT
    62	                                                                              >       CONTEXT,
    63	                                                                              >       SELF,
    64	                                                                              >       SELF INDICATOR STRUCT,
    65	                                                                              >       GEOM,
    66	                                                                              >       GEOM INDICATOR STRUCT,
    67	                                                                              >       RETURN OCINUMBER);
    77	  RETURN NUMBER IS                                                            |  RETURN NUMBER
    78	  BEGIN                                                                       <
    79	     RETURNVALUE := CONTEXT.GEOMETRY;                                         <
    80	     RETURN ODCICONST.SUCCESS;                                                <
    81	   END;                                                                       <
    82	                                                                              <
    83	                                                                              <
    84	                                                                              <
    85	                                                                              <
    86	                                                                              <
    87	                                                                              <
    88	                                                                              <
    89	                                                                              <
    92	                                                                              >     AS LANGUAGE C
    93	                                                                              >     LIBRARY ORDMD_AG_LIBS
    94	                                                                              >     NAME "mdconcterm"
    95	                                                                              >     WITH CONTEXT
    97	                                                                              >       CONTEXT,
    98	                                                                              >       SELF,
    99	                                                                              >       SELF INDICATOR STRUCT,
   100	                                                                              >       RETURNVALUE,
   101	                                                                              >       RETURNVALUE INDICATOR STRUCT,
   102	                                                                              >       FLAGS,
   103	                                                                              >       FLAGS INDICATOR,
   104	                                                                              >       RETURN OCINUMBER);
   114	   RETURN NUMBER IS                                                           |  RETURN NUMBER
   115	   BEGIN                                                                      <
   116	     RETURN CONTEXT.ODCIAGGREGATEMERGE(SCTX2.CONTEXT);                        <
   117	   END;                                                                       <
   118	                                                                              <
   119	                                                                              <
   120	                                                                              <
   121	                                                                              <
   122	                                                                              <
   123	                                                                              <
   126	                                                                              >     AS LANGUAGE C
   127	                                                                              >     LIBRARY ORDMD_AG_LIBS
   128	                                                                              >     NAME "mdconcmerg"
   129	                                                                              >     WITH CONTEXT
   131	                                                                              >       CONTEXT,
   132	                                                                              >       SELF,
   133	                                                                              >       SELF INDICATOR STRUCT,
   134	                                                                              >       SCTX2,
   135	                                                                              >       SCTX2 INDICATOR STRUCT,
   136	                                                                              >       RETURN OCINUMBER);

  2055	       GEOM2 := GEOM_OPERATION_INT(DIM2,GEOM,10,DIM2,GEOM);                  |        GEOM2 := MDSYS.SDO_UTIL.RECTIFY_GEOMETRY(GEOM, DIM(1).SDO_TOLERANCE);
  2535	                                                                             >     GEOM2   MDSYS.SDO_GEOMETRY;
  2536	                                                                             >     VAR1    NUMBER;
  2540	    RETURN GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);             |     VAR1 := MDSYS.SDO_3GL.GET_EVENT(54677);
  2541	                                                                             |     MDSYS.SDO_3GL.SET_EVENT(54677, (VAR1+64));
  2542	                                                                             >     GEOM2 := GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);
  2543	                                                                             >     MDSYS.SDO_3GL.SET_EVENT(54677, VAR1);
  2544	                                                                             >     RETURN GEOM2;

  6653	        IF((MMM_VALUE*2>MM_PIX)AND(MMM_MEDIAN=-32769))  |         IF((MMM_VALUE*2>=MM_PIX)AND(MMM_MEDIAN=-32769))
  6662	                                                        >       MMM_MODE:= MMM_MODE-128;
  6666	                                                        >       MMM_MODE:= MMM_MODE-32768;

  5106	 FUNCTION INTERIOR_POINT (GEOM MDSYS.SDO_GEOMETRY, TOL NUMBER := 0.00000000005)      |  FUNCTION INTERIOR_POINT(GEOM MDSYS.SDO_GEOMETRY,
  5107	                                                                                     >                          TOL NUMBER := 0.00000000005)
  5113	                                                                                     >    SDO_FULL RAW(255);
  5114	                                                                                     >    LEN_1 BINARY_INTEGER;
  5115	                                                                                     >    LEN_2 BINARY_INTEGER;
  5130	 LGEOM MDSYS.SDO_GEOMETRY;                                                           |    LINE_GEOM MDSYS.SDO_GEOMETRY;
  5132	 NGEOM MDSYS.SDO_GEOMETRY;                                                           |    TILE_CENTER MDSYS.SDO_GEOMETRY;
  5134	 CGEOM MDSYS.SDO_GEOMETRY;                                                           |    CENTER_POINT MDSYS.SDO_GEOMETRY;
  5135	                                                                                     >    RGEOM_SET_TO_CENTER BOOLEAN;
  5144	         ITOL := TOL/100000;                                                         |        ITOL := ITOL/100000;
  5150	                                                                                     >    IF ( G.SDO_ORDINATES.COUNT < 4 ) THEN
  5151	                                                                                     >      MDERR.RAISE_MD_ERROR('MD', 'SDO', -13199,
  5152	                                                                                     >                           'Insufficient number of ordinate values');
  5153	                                                                                     >      RETURN NULL;
  5154	                                                                                     >    END IF;
  5155	                                                                                     >
  5161	                                                                                     >    G := NULL;
  5162	                                                                                     >
  5168	     CGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                                |
  5169	                MDSYS.SDO_POINT_TYPE((BX1+BX2)/2., (BY1+BY2)/2., NULL), NULL, NULL); |    RGEOM_SET_TO_CENTER := FALSE;
  5170	     LGEOM := SDO_UTIL.POLYGONTOLINE(GEOM);                                          |    CENTER_POINT := MDSYS.SDO_GEOMETRY(2001,
  5171	                                                                                     >                                       GEOM.SDO_SRID,
  5173	                                                                                     >                                         (BX1+BX2)/2.0,
  5174	                                                                                     >                                         (BY1+BY2)/2.0,
  5175	                                                                                     >                                         NULL),
  5176	                                                                                     >                                       NULL,
  5177	                                                                                     >                                       NULL);
  5178	                                                                                     >    LINE_GEOM := SDO_UTIL.POLYGONTOLINE(GEOM);
  5179	                                                                                     >
  5190	     FOR SDO_LVL  IN 3 ..10  LOOP                                                    |    FOR SDO_LVL IN 3 .. 15
  5191	                                                                                     >    LOOP
  5193	       FOR IDX IN 1 .. FIX_TILES.COUNT LOOP                                          |
  5194	                                                                                     >      FOR IDX IN 1 .. FIX_TILES.COUNT
  5195	                                                                                     >      LOOP
  5200	            X1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          SDO_FULL := FIX_TILE.SDO_CODE||SDO_META;
  5201	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MIN'));                        |          LEN_1 := MDSYS.HHLENGTH(SDO_FULL, 1);
  5202	            Y1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          LEN_2 := MDSYS.HHLENGTH(SDO_FULL, 2);
  5203	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MIN'));                        |
  5204	                                                                                     |          X1 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MIN');
  5205	            X2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          Y1 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MIN');
  5206	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MAX'));                        |
  5207	            Y2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          X2 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MAX');
  5208	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MAX'));                        |          Y2 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MAX');
  5209	                                                                                     |
  5210	                                                                                     |
  5211	          IF ((CGEOM.SDO_POINT.X > X1) AND (CGEOM.SDO_POINT.X < X2) AND              |          IF ((NOT RGEOM_SET_TO_CENTER) AND
  5212	              (CGEOM.SDO_POINT.Y > Y1) AND (CGEOM.SDO_POINT.Y < Y2)) THEN            |              (CENTER_POINT.SDO_POINT.X > X1) AND
  5213	            NDIST := 10;                                                             |              (CENTER_POINT.SDO_POINT.X < X2) AND
  5214	            RGEOM := CGEOM;                                                          |              (CENTER_POINT.SDO_POINT.Y > Y1) AND
  5215	                                                                                     >              (CENTER_POINT.SDO_POINT.Y < Y2)) THEN
  5216	                                                                                     >            RGEOM := CENTER_POINT;
  5217	                                                                                     >            RGEOM_SET_TO_CENTER := TRUE;
  5221	                                                                                     >          TILE_CENTER := MDSYS.SDO_GEOMETRY(2001,
  5222	                                                                                     >                                            GEOM.SDO_SRID,
  5224	                                                                                     >                                              (X1+X2)/2.0,
  5225	                                                                                     >                                              (Y1+Y2)/2.0,
  5226	                                                                                     >                                              NULL),
  5227	                                                                                     >                                            NULL,
  5228	                                                                                     >                                            NULL);
  5230	           NGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                          |          NDIST := SDO_GEOM.SDO_DISTANCE(TILE_CENTER, LINE_GEOM, ITOL);
  5231	                MDSYS.SDO_POINT_TYPE((X1+X2)/2., (Y1+Y2)/2., NULL), NULL, NULL);     <
  5232	           NDIST := SDO_GEOM.SDO_DISTANCE(NGEOM, LGEOM, ITOL);                       <
  5234	              RGEOM := NGEOM;                                                        |            RGEOM := TILE_CENTER;
  5235	                                                                                     >            RGEOM_SET_TO_CENTER := FALSE;
  5238	                                                                                     >          TILE_CENTER := NULL;

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

   122	CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.00.00'; | CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.01.00';

    13	                               '19.11.0.0.0'; |                                '19.11.1.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