What’s new with Oracle database 18.9 versus 18.10

This blogpost takes a look at the technical differences between Oracle database 18 PSU 9 (january 2020) and 10 (april 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 18.9 versus 18.10.0.0.200414

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
kdpFreeAggVecs                                               (kdp)FreeAggVecs                                             kernel data archive compression: pcode ??
kdpLoopVisitInstr                                            (kdp)LoopVisitInstr                                          kernel data archive compression: pcode ??
kdp_generate_pcode_proj_agg_rowset                           (kdp)_generate_pcode_proj_agg_rowset                         kernel data archive compression: pcode ??
kdp_op_is_char                                               (kdp)_op_is_char                                             kernel data archive compression: pcode ??
kdp_pcode_calc_constant_area                                 (kdp)_pcode_calc_constant_area                               kernel data archive compression: pcode ??
kdp_pcode_setup_cbks                                         (kdp)_pcode_setup_cbks                                       kernel data archive compression: pcode ??
kebmtrlog_add                                                (keb)mtrlog_add                                              kernel event MMON/MMNL infrastructure ??
kgskltyp                                                     (kgsk)ltyp                                                   kernel generic service resource manager ??
kjznhcdn                                                     (kjzn)hcdn                                                   kernel lock management DIAG node layer ??
kjznhcds                                                     (kjzn)hcds                                                   kernel lock management DIAG node layer ??
kkqoreAndDriver                                              (kkqore)AndDriver                                            kernel compile query  or-expansion ??
krvxdsr                                                      (krvx)dsr                                                    kernel redo recovery extract ??
kseinpre                                                     (kse)inpre                                                   kernel service  error ??
kseipre                                                      (kse)ipre                                                    kernel service  error ??
ktspnsc_repair_endtask                                       (ktsp)nsc_repair_endtask                                     kernel transaction segment management segment pagetable ??
kubsCRCheckDirLink                                           (kubsCR)CheckDirLink                                         kernel utility big data sql consistent read (?) ??
skudmisyml                                                   (sk)udmisyml                                                 operating system dependent kernel ??

code symbol names unique in version 18.10.0.0.200414 versus 18.9

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
kcoclnup                                                     (kco)clnup                                                   kernel cache operation ??
kfGcSubHeap                                                  (kf)GcSubHeap                                                kernel automatic storage management ??
kfSgaFrHeapParamCb                                           (kf)SgaFrHeapParamCb                                         kernel automatic storage management ??
kfSgaFrHeapPercParamCb                                       (kf)SgaFrHeapPercParamCb                                     kernel automatic storage management ??
kffFdChkSize                                                 (kff)FdChkSize                                               kernel automatic storage management KFF ??
kffmapFree                                                   (kffm)apFree                                                 kernel automatic storage management KFF map header ??
kfgGetOfflineEnqueue                                         (kfg)GetOfflineEnqueue                                       kernel automatic storage management diskgroups ??
kfgReleaseOfflineEnqueue                                     (kfg)ReleaseOfflineEnqueue                                   kernel automatic storage management diskgroups ??
kfgpnReleaseOfflineEnqueue                                   (kfg)pnReleaseOfflineEnqueue                                 kernel automatic storage management diskgroups ??
kjac_allow_tg                                                (kjac)_allow_tg                                              kernel lock management application continuity  ??
kjctccti                                                     (kjc)tccti                                                   kernel lock management communication ??
kkdlpGetObjn                                                 (kkdl)pGetObjn                                               kernel compile dictionary lookup ??
kkqtutlSelItemMatches                                        (kkqt)utlSelItemMatches                                      kernel compile query  table ??
kokaugi_iobs                                                 (koka)ugi_iobs                                               kernel objects kernel side access ??
kpoxcAppContPDBNotify                                        (kpo)xcAppContPDBNotify                                      kernel programmatic interface oracle ??
krvxgtf                                                      (krvx)gtf                                                    kernel redo recovery extract ??
krvxrsr_SkipRedo                                             (krvx)rsr_SkipRedo                                           kernel redo recovery extract ??
ksdxcmdoutmemclnt_has_output                                 (ksd)xcmdoutmemclnt_has_output                               kernel service  debug internal errors ??
ksfqsrfn                                                     (ksfq)srfn                                                   kernel service  functions sequential file io interface ??
ktsmgPublishNameSvc                                          (ktsmg)PublishNameSvc                                        kernel transaction segment management merge ??
ktsmgSearchNameSvc                                           (ktsmg)SearchNameSvc                                         kernel transaction segment management merge ??
ktsmg_mql_chore_pdb                                          (ktsmg)_mql_chore_pdb                                        kernel transaction segment management merge ??
ktsmguuf_pdb                                                 (ktsmg)uuf_pdb                                               kernel transaction segment management merge ??
kzdmchkerpna                                                 (kzd)mchkerpna                                               kernel security dictionary access support ??
kzdmqcterpna                                                 (kzd)mqcterpna                                               kernel security dictionary access support ??
kzthsm_get_pdb_ctx                                           (kz)thsm_get_pdb_ctx                                         kernel security ??
kzthsminit_load_pkcs_lib                                     (kz)thsminit_load_pkcs_lib                                   kernel security ??
kzthsminit_session                                           (kz)thsminit_session                                         kernel security ??
kzthsminit_session_for_united_mode_pdb                       (kz)thsminit_session_for_united_mode_pdb                     kernel security ??
qcsoPreNameres_ProcOpt                                       (qcso)PreNameres_ProcOpt                                     query compile semantic analysis (parser) OBJECTS ??
qerxlCanAllocMut                                             (qerxl)CanAllocMut                                           query execute rowsource vector translate ??
qkspmTravInit                                                (qkspm)TravInit                                              query kernel sql plan management ??
slrac_end_lock                                               (slrac)_end_lock                                             operating system (dependent) library verify (memory) read

This is is what I would expect from a version that is not long term supported. Some functions removed, notably a group of functions starting with kdp (kernel data archive compression, alias HCC), and some functions added, some kf (kernel ASM). Essentially nothing to exciting.

Parameters

parameters unique in version 18.9 versus 18.10.0.0.200414

NAME
--------------------------------------------------
_fourteenth_spare_parameter
_ninth_spare_parameter
_one-hundred-and-fifty-second_spare_parameter
_thirteenth_spare_parameter
_twelfth_spare_parameter

parameters unique in version 18.10.0.0.200414 versus 18.9

NAME
--------------------------------------------------
_asm_max_kfsg_free_heap_perc
_asm_max_kfsg_free_heap_size
_bug30352623_asm_enable_vfreloc_on_rm
_cvw_examine_tables_in_from_list_subqry
_second_spare_parameter

It’s clear here some spare parameters have been taken to add undocumented parameters. One of them is a ‘bugswitch’, two of them are regarding ASM, which are also added for april 2020 PSU for 12.2.0.1.

DBA/CDB tables
It seems the bug regarding DBA_REGISTRY_BACKPORTS that was found the previous period has not been implemented everywhere. This was confirmed a bug then, so I assume this view gone missing here with the new version is a bug.

dba tables unique to 18.9 versus 18.10.0.0.200414

NAME
----------------------------------------------------------------------------------------------------
DBA_REGISTRY_BACKPORTS

cdb tables unique to 18.9 versus 18.10.0.0.200414

NAME
----------------------------------------------------------------------------------------------------
CDB_REGISTRY_BACKPORTS

DBA/CDB table columns
This is something I have not seen before. This looks like one column in two DBA views has been removed, and then added to their CDB counterparts.

dba tables columns unique to 18.9 versus 18.10.0.0.200414

NAME												     COLUMN_NAME
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
DBA_WORKLOAD_CAPTURES										     ENCRYPTION_VERIFIER
DBA_WORKLOAD_REPLAY_FILTER_SET									     DEFAULT_ACTION

cdb tables column unique to 18.10.0.0.200414 versus 18.9

NAME												     COLUMN_NAME
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CDB_WORKLOAD_CAPTURES										     ENCRYPTION_VERIFIER
CDB_WORKLOAD_REPLAY_FILTER_SET									     DEFAULT_ACTION

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: