What’s new with Oracle database 12.2.0.1.191015 versus 12.2.0.1.200114
For the difference between Oracle database versions 12.2.0.1.191015 and 12.2.0.1.200114 this too follows the line of a low amount of differences.
There have been two spare parameters that have been changed to named undocumented parameters, and no data dictionary changes.
parameters unique in version 12.2.0.1.191015 versus 12.2.0.1.200114 NAME -------------------------------------------------- _fifth_spare_parameter _one-hundred-and-forty-eighth_spare_parameter parameters unique in version 12.2.0.1.200114 versus 12.2.0.1.191015 NAME -------------------------------------------------- _bug29825525_bct_public_dba_buffer_dynresize_delay _enable_ptime_update_for_sys
On the C function side, there have been a group of AWR functions that have been removed and a group of SGA management functions, among other functions. There functions that have been added are random and diverse.
code symbol names unique in version 12.2.0.1.191015 versus 12.2.0.1.200114 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- R_CR_entropy_resource_init R_CR_entropy_resource_init ?? kcbzdra (kcbz)dra kernel cache buffers subroutines for kcb ?? kdmsCreateSampleInvBlkList (kdm)sCreateSampleInvBlkList kernel data in-memory data layer ?? kdmsFillSampleList (kdm)sFillSampleList kernel data in-memory data layer ?? kewmfdms_flush_drmsum (kewm)fdms_flush_drmsum kernel event AWR metrics ?? kewmgaeidct (kewm)gaeidct kernel event AWR metrics ?? kewmusmdb_update_smdbuf (kewm)usmdb_update_smdbuf kernel event AWR metrics ?? kewramcs_app_map_condbid_str (kewr)amcs_app_map_condbid_str kernel event AWR repository ?? kewramvn_append_mdb_vvwname (kewr)amvn_append_mdb_vvwname kernel event AWR repository ?? kewrccsq_collect_csql (kewr)ccsq_collect_csql kernel event AWR repository ?? kewrfosp2_fos_mdb_part2 (kewrf)osp2_fos_mdb_part2 kernel event AWR repository flush ?? kewrfosp3_fos_mdb_part3 (kewrf)osp3_fos_mdb_part3 kernel event AWR repository flush ?? kewrgcfes_get_cacheid_from_enum_str (kewr)gcfes_get_cacheid_from_enum_str kernel event AWR repository ?? kewrggd_get_group_descriptor (kewr)ggd_get_group_descriptor kernel event AWR repository ?? kewrggf_grp_get_flags (kewr)ggf_grp_get_flags kernel event AWR repository ?? kewrggh_grp_get_handle (kewr)ggh_grp_get_handle kernel event AWR repository ?? kewrggmc_grp_get_member_count (kewr)ggmc_grp_get_member_count kernel event AWR repository ?? kewrgltn_gen_lrgtest_tab_name (kewr)gltn_gen_lrgtest_tab_name kernel event AWR repository ?? kewrgvm_grp_valid_member (kewr)gvm_grp_valid_member kernel event AWR repository ?? kewrice_is_cache_enabled (kewr)ice_is_cache_enabled kernel event AWR repository ?? kewrmfp_map_flush_phase (kewr)mfp_map_flush_phase kernel event AWR repository ?? kewrmplvl_map_snap_level (kewr)mplvl_map_snap_level kernel event AWR repository ?? kewrpfbue_pdb_from_buffer_entry (kewr)pfbue_pdb_from_buffer_entry kernel event AWR repository ?? kewrptsq_prep_topsql (kewr)ptsq_prep_topsql kernel event AWR repository ?? kewrrc_release_cache (kewr)rc_release_cache kernel event AWR repository ?? kewrsaobn_set_all_objnames (kewr)saobn_set_all_objnames kernel event AWR repository ?? kewrsonie_set_object_names_in_entry (kewr)sonie_set_object_names_in_entry kernel event AWR repository ?? kewrsqlc_sql_iscolored_cb (kewr)sqlc_sql_iscolored_cb kernel event AWR repository ?? kgskltyp (kgsk)ltyp kernel generic service resource manager ?? kkeutlCopyAllocatorState (kke)utlCopyAllocatorState kernel compile cost engine ?? kkeutlIsAllocStructureSame (kke)utlIsAllocStructureSame kernel compile cost engine ?? kmgs_check_uninited_comp (kmgs)_check_uninited_comp kernel multi threaded/mman manage (sga) space (?) ?? kmgs_dump_partial_inuse_list_comp (kmgs)_dump_partial_inuse_list_comp kernel multi threaded/mman manage (sga) space (?) ?? kmgs_dump_quiesce_list (kmgs)_dump_quiesce_list kernel multi threaded/mman manage (sga) space (?) ?? kmgs_dump_resize_summary (kmgs)_dump_resize_summary kernel multi threaded/mman manage (sga) space (?) ?? kmgs_fill_start_sizes (kmgs)_fill_start_sizes kernel multi threaded/mman manage (sga) space (?) ?? kmgs_get_min_cache_grans (kmgs)_get_min_cache_grans kernel multi threaded/mman manage (sga) space (?) ?? kmgs_getgran_from_comp_pg (kmgs)_getgran_from_comp_pg kernel multi threaded/mman manage (sga) space (?) ?? kmgs_init_sgapga_comps (kmgs)_init_sgapga_comps kernel multi threaded/mman manage (sga) space (?) ?? kmgs_nvmksmid_2_kcbpoolid (kmgs)_nvmksmid_2_kcbpoolid kernel multi threaded/mman manage (sga) space (?) ?? kmgs_recv_and_donor_are_caches (kmgs)_recv_and_donor_are_caches kernel multi threaded/mman manage (sga) space (?) ?? kmgs_shrink_gran (kmgs)_shrink_gran kernel multi threaded/mman manage (sga) space (?) ?? kmgs_update_param_manual_helper (kmgs)_update_param_manual_helper kernel multi threaded/mman manage (sga) space (?) ?? kmgs_update_resize_summary (kmgs)_update_resize_summary kernel multi threaded/mman manage (sga) space (?) ?? kmgsb_in_range (kmgs)b_in_range kernel multi threaded/mman manage (sga) space (?) ?? kmgsdpgl (kmgs)dpgl kernel multi threaded/mman manage (sga) space (?) ?? kmgsset_timestamp (kmgs)set_timestamp kernel multi threaded/mman manage (sga) space (?) ?? krvxgtf (krvx)gtf kernel redo recovery extract ?? krvxrte (krvx)rte kernel redo recovery extract ?? kslsesftcb_int (ksl)sesftcb_int kernel service latching and post-wait ?? ksmg_estimate_sgamax (ksm)g_estimate_sgamax kernel service memory ?? ktcxbFlgPrint (ktc)xbFlgPrint kernel transaction control component ?? kzagetcid (kza)getcid kernel security audit ?? kzekmdcw (kz)ekmdcw kernel security ?? qeroiFirstPart (qeroi)FirstPart query execute rowsource extensibel indexing query component ?? qksbgUnderOFE (qksbg)UnderOFE query kernel sql bind (variable) management(?) ?? ri_entcb_cmd_func ri_entcb_cmd_func ?? zt_yield_entropy_source_cb (zt)_yield_entropy_source_cb security encryption ?? code symbol names unique in version 12.2.0.1.200114 versus 12.2.0.1.191015 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- apagwnrn (apa)gwnrn SQL Access Path Analysis ?? apagwnrnprd (apa)gwnrnprd SQL Access Path Analysis ?? apatwnrn (apa)twnrn SQL Access Path Analysis ?? kafcpy_one_row (kaf)cpy_one_row kernel access fetch ?? kcbz_eff_bsz (kcbz)_eff_bsz kernel cache buffers subroutines for kcb ?? kdilm_row_diskcompress_policy_type (kdil)m_row_diskcompress_policy_type kernel data index load ?? kdsReadAheadSafe (kds)ReadAheadSafe kernel data seek/scan ?? kfdFreeReqs (kfd)FreeReqs kernel automatic storage management disk ?? kfdp_getNormalFgCnt (kfdp)_getNormalFgCnt kernel automatic storage management disk PST ?? kghunalo (kgh)unalo kernel generic heap manager ?? kjcts_syncseq_incident_dump (kjc)ts_syncseq_incident_dump kernel lock management communication ?? kkfdIsXlate (kkfd)IsXlate kernel compile fast dataflow (PQ DFO) ?? kkoRowNumLimit_Int (kko)RowNumLimit_Int kernel compile optimizer ?? kkoWnRowNumLimit (kko)WnRowNumLimit kernel compile optimizer ?? kkoarFreeStats (kkoar)FreeStats kernel compile optimizer automatic (sql) reoptimisation ?? kkqgbpValidPredCB (kkqgbp)ValidPredCB kernel compile query group by placement ?? kkqoreApplyFKR (kkqore)ApplyFKR kernel compile query or-expansion ?? kkqstIsOneToOneFunc (kkq)stIsOneToOneFunc kernel compile query ?? kkquReplSCInMWithRefCB (kkqu)ReplSCInMWithRefCB kernel compile query subquery unnesting ?? kkqvtOpnInView (kkqvt)OpnInView kernel compile query vector transformation ?? kokujJsonSerialize (kok)ujJsonSerialize kernel objects kernel side ?? kpdbCheckCommonprofileCbk (kpdb)CheckCommonprofileCbk kernel programmatic interface pluggable database ?? kpdbSyncCreateProfile (kpdbSync)CreateProfile kernel programmatic interface pluggable database DBMS_PDB.KPDBSYNC SYNC_PDB ?? krvfptai_PutTxAuditInfo (krv)fptai_PutTxAuditInfo kernel redo recovery ?? krvtab (krvt)ab kernel redo recovery log miner viewer support ?? krvxdsr (krvx)dsr kernel redo recovery extract ?? ksmg_estimate_nonimc_sga_size (ksm)g_estimate_nonimc_sga_size kernel service memory ?? ktspFetchMeta1 (ktsp)FetchMeta1 kernel transaction segment management segment pagetable ?? kzekmckdcw (kz)ekmckdcw kernel security ?? kzekmckdcw_cbk (kz)ekmckdcw_cbk kernel security ?? opiBindReorderInfo (opi)BindReorderInfo oracle program interface ?? qcpiJsonSerialize (qcpi)JsonSerialize query compile parse interim ?? qcsSqnLegalCB (qcs)SqnLegalCB query compile semantic analysis (parser) ?? qergiSetFirstPartFlag (qergi)SetFirstPartFlag query execute rowsource granule iterator (partitioning? or PX granules?) ?? qeroiFindGranuleIter (qeroi)FindGranuleIter query execute rowsource extensibel indexing query component ?? qesblZero (qesbl)Zero query execute services bloom filter ?? qjsnIsDollarOnly (qjsn)IsDollarOnly query json ?? qjsnJsonCreatDom (qjsn)JsonCreatDom query json ?? qjsn_ferrh (qjsn)_ferrh query json ?? qkaGetClusteringFactor (qka)GetClusteringFactor query kernel allocation ?? qkaIsRTRIMRequiredForViewCol (qka)IsRTRIMRequiredForViewCol query kernel allocation ?? qksopCheckConstOrOptWithBindInAndChains (qksop)CheckConstOrOptWithBindInAndChains query kernel sql compilter operand processing ?? qksqbCorrToNonParent (qksqb)CorrToNonParent query kernel sql Query compilation for query blocks ?? qksvcCloneHJPred (qksvc)CloneHJPred query kernel sql Virtual Column ??
(disclaimer: I can’t look at the sourcecode, which means I look at the oracle executable with normal, modern tools. This also means that there’s a of stuff that I don’t see, for example if functionality has been added inside an existing function, then that’s totally invisible to me)
Frits Hoogland Weblog 