What’s new with Oracle database 12.2.0.1.200714 versus 12.2.0.1.201020
This blogpost takes a look at the technical differences between Oracle database 12.2.0.1 PSU 200714 (july 2020) and PSU 201020 (october 2020). This gives technical specialists an idea of the differences, and gives them the ability to assess if the PSU impacts anything.
Functions
code symbol names unique in version 12.2.0.1.200714 versus 12.2.0.1.201020 NAME RESOLVE ANNOTATION ARCHIVE_OBJECT ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------------------------------------ ------------------------------------------------------------ NAME RESOLVE ANNOTATION ARCHIVE_OBJECT COUNT(*) -------------------------------------------------- -------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------ ---------- kcbo kcbo kernel cache buffers object queue 1 kkdl kkdl kernel compile dictionary lookup 1 kmgs kmgs kernel multi threaded/mman manage (sga) space (?) 1 kzpR (kzp)R kernel security privileges ?? 1 qcso qcso query compile semantic analysis (parser) OBJECTS 1 qeae qeae query execute aggregate (order by) elimination (?) 1 qkaI (qka)I query kernel allocation ?? 1 qkex (qke)x query kernel expressions ?? 1 qksh (qks)h query kernel sql ?? 1 qksp (qks)p query kernel sql ?? 1 krvx krvx kernel redo recovery extract 2 kxtt kxtt kernel execution temporary table operations 2 Java Java java classes 6 code symbol names unique in version 12.2.0.1.201020 versus 12.2.0.1.200714 NAME RESOLVE ANNOTATION ARCHIVE_OBJECT COUNT(*) -------------------------------------------------- -------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------ ---------- ECGr (EC)Gr elleptic curve cryptography ?? libjavavm12.a:ecl.o 7 Java Java java classes libjavavm12.a:ShapeSpanIterator.o 7 ec_G (ec_)G elleptic curve cryptography ?? libjavavm12.a:ecp_jac.o 7 mp_c (mp_)c multiple precision cryptography ?? libjavavm12.a:mpi.o 7 mp_i (mp_)i multiple precision cryptography ?? libjavavm12.a:mpi.o 7 mp_t (mp_)t multiple precision cryptography ?? libjavavm12.a:mpi.o 7 mp_b (mp_)b multiple precision cryptography ?? libjavavm12.a:mp_gf2m.o 8 mp_s (mp_)s multiple precision cryptography ?? libjavavm12.a:mpi.o 11 ec_G (ec_)G elleptic curve cryptography ?? libjavavm12.a:ecl_gf.o 21 s_mp s_mp cryptography multiple precision libjavavm12.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, this is an update. 20 functions have been removed in total. The archive:object annotation is not there, I started doing that for the latest PSU.
For the functions that were added, the vast majority comes from libjavavm18, and seem to be cryptographic related functions.
It should be noted that if you compare the added functions and the changed functions with the Oracle 18 ones, a fair share of them are equal, but there are also functions unique to each version. Of course the equal functions probably are related to huge issues that must be fixed in all versions. The functions that are unique to this version are likely to be (minor-)version specific issues.
Frits Hoogland Weblog 