What’s new with Oracle database 18.8 versus 18.7
The amount of changes between version 18.7 and 18.8 is truly minimal. There’s one spare parameter renamed to an underscore parameter, which seems to be a back port of functionality created version 19:
DATABASE_VERSION NAME ---------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- 18.8 _ldap_password_oneway_auth 19.2 _ldap_password_oneway_auth 19.3 _ldap_password_oneway_auth 19.4 _ldap_password_oneway_auth 19.5 _ldap_password_oneway_auth
And it seems the DBA view DBA_REGISTRY_BACKPORTS is corrupted with 18.8, there only is a synonym with that name, which throws an ORA 1775: looping chain of synonyms when used. This is the reason it shows as gone in 18.8 (unique to version 18.7).
parameters unique in version 18.7 versus 18.8 NAME -------------------------------------------------- _one-hundred-and-forty-sixth_spare_parameter parameters unique in version 18.8 versus 18.7 NAME -------------------------------------------------- _ldap_password_oneway_auth parameter values changed isdefault between 18.7 versus 18.8 parameter values unique to 18.7 versus 18.8 parameter values unique to 18.8 versus 18.7 waitevents unique in version 18.7 versus 18.8 waitevents unique in version 18.8 versus 18.7 waitevents changed parameter description between 18.7 versus 18.8 x$ tables unique to 18.7 versus 18.8 x$ tables unique to 18.8 versus 18.7 x$ tables columns unique to 18.7 versus 18.8 x$ tables columns unique to 18.8 versus 18.7 v$ tables unique to 18.7 versus 18.8 v$ tables unique to 18.8 versus 18.7 v$ tables columns unique to 18.7 versus 18.8 v$ tables columns unique to 18.8 versus 18.7 gv$ tables unique to 18.7 versus 18.8 gv$ tables unique to 18.8 versus 18.7 gv$ tables columns unique to 18.7 versus 18.8 gv$ tables columns unique to 18.8 versus 18.7 sysstat statistics unique to 18.7 versus 18.8 sysstat statistics unique to 18.8 versus 18.7 sys_time_model statistics unique to 18.7 versus 18.8 sys_time_model statistics unique to 18.8 versus 18.7 dba tables unique to 18.7 versus 18.8 NAME ---------------------------------------------------------------------------------------------------- DBA_REGISTRY_BACKPORTS dba tables unique to 18.8 versus 18.7 dba tables columns unique to 18.8 versus 18.7 dba tables columns unique to 18.7 versus 18.8 cdb tables unique to 18.7 versus 18.8 NAME ---------------------------------------------------------------------------------------------------- CDB_REGISTRY_BACKPORTS cdb tables unique to 18.8 versus 18.7 cdb tables column unique to 18.7 versus 18.8 cdb tables column unique to 18.8 versus 18.7
And here are the differences in symbols (c functions).
The amount of functions added and removed is not huge this time (remember last time littecms was added).
The same java/domain functions as seen with version 19 have been removed, and the same PLSQL codegen layer functions, plus a singe DBMS_SODA function. There are some other functions that do not align with 19 removed.
The same batch of DBMS_SODA related functions are added, plus a lot of functions different than version 19.
code symbol names unique in version 18.7 versus 18.8 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- joncl_at_domains (jon)cl_at_domains java ?? joncl_domains (jon)cl_domains java ?? joncl_set_domains (jon)cl_set_domains java ?? joncl_snor_domains (jon)cl_snor_domains java ?? joniul_at_domains (jon)iul_at_domains java ?? joniul_domains (jon)iul_domains java ?? joniul_set_domains (jon)iul_set_domains java ?? joniul_snor_domains (jon)iul_snor_domains java ?? jonndl_at_domains (jon)ndl_at_domains java ?? jonndl_domains (jon)ndl_domains java ?? jonndl_set_domains (jon)ndl_set_domains java ?? jonndl_snor_domains (jon)ndl_snor_domains java ?? jonoce_at_domains (jon)oce_at_domains java ?? jonoce_domains (jon)oce_domains java ?? jonoce_set_domains (jon)oce_set_domains java ?? jonoce_snor_domains (jon)oce_snor_domains java ?? jonosd_at_domains (jon)osd_at_domains java ?? jonosd_domains (jon)osd_domains java ?? jonosd_set_domains (jon)osd_set_domains java ?? jonosd_snor_domains (jon)osd_snor_domains java ?? jonvcl_at_domains (jon)vcl_at_domains java ?? jonvcl_domains (jon)vcl_domains java ?? jonvcl_set_domains (jon)vcl_set_domains java ?? jonvcl_snor_domains (jon)vcl_snor_domains java ?? kestsInitTCB (kest)sInitTCB kernel event SQL manageability tokenize (?) ?? kglsim_get_bucket_info (kglsim)_get_bucket_info kernel generic library cache management simulator (library cache advise) ?? kgskltyp (kgsk)ltyp kernel generic service resource manager ?? krvxdsr (krvx)dsr kernel redo recovery extract ?? pdzdM60_Make_RBST (pdz)dM60_Make_RBST PLSQL code execution codegen infrastructure ?? pdzdM66_Insert_At_Root (pdz)dM66_Insert_At_Root PLSQL code execution codegen infrastructure ?? qcsoPreNameres_ProcOpt (qcso)PreNameres_ProcOpt query compile semantic analysis (parser) OBJECTS ?? qsodasqlGetInsertOneSQL (qsoda)sqlGetInsertOneSQL query system DBMS_SODA ?? code symbol names unique in version 18.8 versus 18.7 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- audIsSenCol (aud)IsSenCol audit ?? audOptTab (aud)OptTab audit ?? audstwlk (aud)stwlk audit ?? kcfis_clear_lob (kcfis)_clear_lob kernel cache file management intelligent storage ?? kclcsb (kcl)csb kernel cache lock manager/buffer cache ?? kds_update_turbo_scan_pivot_statistics (kds)_update_turbo_scan_pivot_statistics kernel data seek/scan ?? kesdtcbResetDiagEvent (kes)dtcbResetDiagEvent kernel event SQL manageability ?? kfdDskComputeHashForRow (kfd)DskComputeHashForRow kernel automatic storage management disk ?? kfdp_chkSufOlnFGAvl (kfdp)_chkSufOlnFGAvl kernel automatic storage management disk PST ?? kfioSrMsgBuf_ack (kfio)SrMsgBuf_ack kernel automatic storage management translation I/O layer ?? kfkcrRefresh (kfk)crRefresh kernel automatic storage management KFK ?? kfnFreeKfnpnmMem (kfn)FreeKfnpnmMem kernel automatic storage management networking subsystem ?? kgfvTermSkvol (kgf)vTermSkvol kernel generic ASM ?? kjznhcdn (kjzn)hcdn kernel lock management DIAG node layer ?? kjznhcds (kjzn)hcds kernel lock management DIAG node layer ?? kkopinlpInt (kko)pinlpInt kernel compile optimizer ?? kkquIsCorrTransInList (kkqu)IsCorrTransInList kernel compile query subquery unnesting ?? knlpmaxfmsgsize (knl)pmaxfmsgsize kernel replication streams replication ?? kpuxsoCurPrefetchFree (kpu)xsoCurPrefetchFree kernel programmatic interface user ?? kpuxsoDocContentSet (kpu)xsoDocContentSet kernel programmatic interface user ?? kpuxsoOperInit (kpu)xsoOperInit kernel programmatic interface user ?? krb_devtype_chk (krb)_devtype_chk kernel redo backup/restore ?? krvxgtf (krvx)gtf kernel redo recovery extract ?? krvxrsr_SkipRedo (krvx)rsr_SkipRedo kernel redo recovery extract ?? kzan_set_ddl_lock_timeout (kza)n_set_ddl_lock_timeout kernel security audit ?? kzckmWalletInArchive (kzck)mWalletInArchive kernel security Code-Based Access Control encryption support ?? kzckmrOpenRootOnPlug (kzck)mrOpenRootOnPlug kernel security Code-Based Access Control encryption support ?? kzckmrXmlVldTDEKeys (kzck)mrXmlVldTDEKeys kernel security Code-Based Access Control encryption support ?? kzckmrXmlVldTDEKeysFile (kzck)mrXmlVldTDEKeysFile kernel security Code-Based Access Control encryption support ?? kzckmrXmlVldTDEMetaHSM (kzck)mrXmlVldTDEMetaHSM kernel security Code-Based Access Control encryption support ?? pfrcrt (pfr)crt PLSQL Code Execution runtime ?? qsodasqlGetContentDefine (qsoda)sqlGetContentDefine query system DBMS_SODA ?? qsodasqlGetCreatedOnDefine (qsoda)sqlGetCreatedOnDefine query system DBMS_SODA ?? qsodasqlGetInsertSQL (qsoda)sqlGetInsertSQL query system DBMS_SODA ?? qsodasqlGetKeyDefine (qsoda)sqlGetKeyDefine query system DBMS_SODA ?? qsodasqlGetLastModDefine (qsoda)sqlGetLastModDefine query system DBMS_SODA ?? qsodasqlGetMediaDefine (qsoda)sqlGetMediaDefine query system DBMS_SODA ?? qsodasqlGetVersionDefine (qsoda)sqlGetVersionDefine query system DBMS_SODA ?? qsodasqlPrefetchPrepare (qsoda)sqlPrefetchPrepare query system DBMS_SODA ?? qsodasqlSelectDocFieldsSQL (qsoda)sqlSelectDocFieldsSQL query system DBMS_SODA ?? qsodaxArrayFetchDocuments (qsoda)xArrayFetchDocuments query system DBMS_SODA ?? qsodaxDefineDocumentFields (qsoda)xDefineDocumentFields query system DBMS_SODA ?? qsodaxGetPrefetchDocument (qsoda)xGetPrefetchDocument query system DBMS_SODA ?? slmeset_s (sl)meset_s operating system (dependent) library ??