What’s new with Oracle database 11.2.0.4.200114 versus 11.2.0.4.200414
This blogpost takes a look at the technical differences between Oracle database 11.2.0.4 PSU 200114 (january 2020) and 200414 (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 11.2.0.4.200114 versus 11.2.0.4.200414 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- kgiLRUResize (kgi)LRUResize kernel generic instantiation manager ?? ktspbrkshklck (ktsp)brkshklck kernel transaction segment management segment pagetable ?? ktspgfbs (ktsp)gfbs kernel transaction segment management segment pagetable ?? code symbol names unique in version 11.2.0.4.200414 versus 11.2.0.4.200114 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- kglPinClearNiv (kgl)PinClearNiv kernel generic library cache management ?? kgldtCheckParent (kgldt)CheckParent kernel generic library cache management dependency table ?? kjctr_updatetkt_in (kjc)tr_updatetkt_in kernel lock management communication ?? knld_EventFillInfo (knl)d_EventFillInfo kernel replication streams replication ?? kqltemptablod (kql)temptablod kernel query library cache ?? ktspgsp_main2 (ktspgsp_main)2 kernel transaction segment management segment pagetable get space for inserts ??
this is what you would expect from a version that is essentially out of support, this to me looks like a low number of functions removed and added.
Parameters
parameters unique in version 11.2.0.4.200114 versus 11.2.0.4.200414 NAME -------------------------------------------------- _thirty-eighth_spare_parameter parameters unique in version 11.2.0.4.200414 versus 11.2.0.4.200114 NAME -------------------------------------------------- _disable_actualization_for_grant
It seems one spare parameter was traded for an underscore parameter. I have no idea what the purpose of this parameter is.
No other changes in the data dictionary have been found.
parameter values changed isdefault between 11.2.0.4.200114 versus 11.2.0.4.200414 parameter values unique to 11.2.0.4.200114 versus 11.2.0.4.200414 parameter values unique to 11.2.0.4.200414 versus 11.2.0.4.200114 waitevents unique in version 11.2.0.4.200114 versus 11.2.0.4.200414 waitevents unique in version 11.2.0.4.200414 versus 11.2.0.4.200114 waitevents changed parameter description between 11.2.0.4.200114 versus 11.2.0.4.200414 x$ tables unique to 11.2.0.4.200114 versus 11.2.0.4.200414 x$ tables unique to 11.2.0.4.200414 versus 11.2.0.4.200114 x$ tables columns unique to 11.2.0.4.200114 versus 11.2.0.4.200414 x$ tables columns unique to 11.2.0.4.200414 versus 11.2.0.4.200114 v$ tables unique to 11.2.0.4.200114 versus 11.2.0.4.200414 v$ tables unique to 11.2.0.4.200414 versus 11.2.0.4.200114 v$ tables columns unique to 11.2.0.4.200114 versus 11.2.0.4.200414 v$ tables columns unique to 11.2.0.4.200414 versus 11.2.0.4.200114 gv$ tables unique to 11.2.0.4.200114 versus 11.2.0.4.200414 gv$ tables unique to 11.2.0.4.200414 versus 11.2.0.4.200114 gv$ tables columns unique to 11.2.0.4.200114 versus 11.2.0.4.200414 gv$ tables columns unique to 11.2.0.4.200414 versus 11.2.0.4.200114 sysstat statistics unique to 11.2.0.4.200114 versus 11.2.0.4.200414 sysstat statistics unique to 11.2.0.4.200414 versus 11.2.0.4.200114 sys_time_model statistics unique to 11.2.0.4.200114 versus 11.2.0.4.200414 sys_time_model statistics unique to 11.2.0.4.200414 versus 11.2.0.4.200114 dba tables unique to 11.2.0.4.200114 versus 11.2.0.4.200414 dba tables unique to 11.2.0.4.200414 versus 11.2.0.4.200114 dba tables columns unique to 11.2.0.4.200414 versus 11.2.0.4.200114 dba tables columns unique to 11.2.0.4.200114 versus 11.2.0.4.200414 cdb tables unique to 11.2.0.4.200114 versus 11.2.0.4.200414 cdb tables unique to 11.2.0.4.200414 versus 11.2.0.4.200114 cdb tables column unique to 11.2.0.4.200114 versus 11.2.0.4.200414 cdb tables column unique to 11.2.0.4.200414 versus 11.2.0.4.200114
Frits Hoogland Weblog 