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

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: