What’s new with Oracle database 18.11 versus 18.12
This blogpost takes a look at the technical differences between Oracle database 18 RU 11 (july 2020) and RU 12 (october 2020). This gives technical specialists an idea of the differences, and gives them the ability to assess if the RU impacts anything.
Functions
code symbol names unique in version 18.11 versus 18.12 -- so removed functions in RU 12. NAME RESOLVE ANNOTATION ARCHIVE_OBJECT ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------------------------------------ ------------------------------------------------------------ Java_sun_java2d_pipe_ShapeSpanIterator_appendCubic (Java_sun_java2d_pipe_ShapeSpanIterator_)appendCubic java classes sun. java2d. pipe. ShapeSpanIterator. ?? Java_sun_java2d_pipe_ShapeSpanIterator_appendLine (Java_sun_java2d_pipe_ShapeSpanIterator_)appendLine java classes sun. java2d. pipe. ShapeSpanIterator. ?? Java_sun_java2d_pipe_ShapeSpanIterator_appendQuadratic (Java_sun_java2d_pipe_ShapeSpanIterator_)appendQuadratic java classes sun. java2d. pipe. ShapeSpanIterator. ?? Java_sun_java2d_pipe_ShapeSpanIterator_beginSubpath (Java_sun_java2d_pipe_ShapeSpanIterator_)beginSubpath java classes sun. java2d. pipe. ShapeSpanIterator. ?? Java_sun_java2d_pipe_ShapeSpanIterator_endPath (Java_sun_java2d_pipe_ShapeSpanIterator_)endPath java classes sun. java2d. pipe. ShapeSpanIterator. ?? Java_sun_java2d_pipe_ShapeSpanIterator_getCPathConsumer (Java_sun_java2d_pipe_ShapeSpanIterator_)getCPathConsumer java classes sun. java2d. pipe. ShapeSpanIterator. ?? kkdlpGetObjn (kkdl)pGetObjn kernel compile dictionary lookup ?? kxttSCNGet (kxtt)SCNGet kernel execution temporary table operations ?? kxttSCNGetBoth (kxtt)SCNGetBoth kernel execution temporary table operations ?? kzpRoleEnabled (kzp)RoleEnabled kernel security privileges ?? qkspmTravInit (qkspm)TravInit query kernel sql plan management ?? skgpgprocstat (skg)pgprocstat operating system dependent kernel generic ?? skgpgthrstat (skg)pgthrstat operating system dependent kernel generic ?? code symbol names unique in version 18.11 versus 18.12 (top 11) -- so added in the RU 12. NAME RESOLVE ANNOTATION ARCHIVE_OBJECT COUNT(*) -------------------------------------------------- -------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------ ---------- ECGr (EC)Gr elleptic curve cryptography ?? libjavavm18.a:ecl.o 7 Java Java java classes libjavavm18.a:ShapeSpanIterator.o 7 ec_G (ec_)G elleptic curve cryptography ?? libjavavm18.a:ecp_jac.o 7 mp_c (mp_)c multiple precision cryptography ?? libjavavm18.a:mpi.o 7 mp_i (mp_)i multiple precision cryptography ?? libjavavm18.a:mpi.o 7 mp_t (mp_)t multiple precision cryptography ?? libjavavm18.a:mpi.o 7 mp_b (mp_)b multiple precision cryptography ?? libjavavm18.a:mp_gf2m.o 8 mp_s (mp_)s multiple precision cryptography ?? libjavavm18.a:mpi.o 11 kewr kewr kernel event AWR repository libserver18.a:kewr.o 14 ec_G (ec_)G elleptic curve cryptography ?? libjavavm18.a:ecl_gf.o 21 s_mp s_mp cryptography multiple precision libjavavm18.a:mpi.o 49
This is a poor, yet one of the only ways to understand what is going on inside the oracle executable.
There aren’t that many thing removed, which is understandable. Therefore I listed all the functions that were removed, not a as a grouped overview. The archive:object annotation is not there, I started doing that for the latest RU.
For the functions that were added, the vast majority comes from libjavavm18, and seem to be cryptographic related functions.
The only group that might show something is kewr (AWR), however I cannot see something in general that is changed, the names seem random:
NAME RESOLVE ANNOTATION ARCHIVE_OBJECT ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------------------------------------ ------------------------------------------------------------ kewramcs_app_map_condbid_str (kewr)amcs_app_map_condbid_str kernel event AWR repository ?? libserver18.a:kewr.o kewramvn_append_mdb_vvwname (kewr)amvn_append_mdb_vvwname kernel event AWR repository ?? libserver18.a:kewr.o kewraxc_attribute_xcb (kewr)axc_attribute_xcb kernel event AWR repository ?? libserver18.a:kewr.o kewrbtsg_build_topseg (kewr)btsg_build_topseg kernel event AWR repository ?? libserver18.a:kewr.o kewrccsq_collect_csql (kewr)ccsq_collect_csql kernel event AWR repository ?? libserver18.a:kewr.o kewrgcfes_get_cacheid_from_enum_str (kewr)gcfes_get_cacheid_from_enum_str kernel event AWR repository ?? libserver18.a:kewr.o kewrmplvl_map_snap_level (kewr)mplvl_map_snap_level kernel event AWR repository ?? libserver18.a:kewr.o kewrpfbue_pdb_from_buffer_entry (kewr)pfbue_pdb_from_buffer_entry kernel event AWR repository ?? libserver18.a:kewr.o kewrptsq_prep_topsql (kewr)ptsq_prep_topsql kernel event AWR repository ?? libserver18.a:kewr.o kewrrdsi_rank_dstat_item (kewr)rdsi_rank_dstat_item kernel event AWR repository ?? libserver18.a:kewr.o kewrrtsq_rank_topsql (kewr)rtsq_rank_topsql kernel event AWR repository ?? libserver18.a:kewr.o kewrsaobn_set_all_objnames (kewr)saobn_set_all_objnames kernel event AWR repository ?? libserver18.a:kewr.o kewrsonie_set_object_names_in_entry (kewr)sonie_set_object_names_in_entry kernel event AWR repository ?? libserver18.a:kewr.o kewrsqlc_sql_iscolored_cb (kewr)sqlc_sql_iscolored_cb kernel event AWR repository ?? libserver18.a:kewr.o
Outside of code changes, there isn’t anything changed in the data dictionary.