What’s new with Oracle database 19.6 versus 19.5
As expected, there aren’t any really drastic differences between Oracle database version 19.5 and 19.6. Now that I am doing these series on differences for all the versions every quarter the new release updates are coming out, there is a certain line, and this release does follow that.
As always, there are some parameters that have changed from being undocumented spare to being undocumented with a name. There is one documented parameter that was added: optimizer_session_type, which has gone official from “_optimizer_auto_index_allow”; see bug 29632611.
parameters unique in version 19.5 versus 19.6 NAME -------------------------------------------------- _fifth_spare_parameter _one-hundred-and-fifty-fifth_spare_parameter _one-hundred-and-fifty-fourth_spare_parameter _one-hundred-and-fifty-sixth_spare_parameter _optimizer_auto_index_allow _sixth_spare_parameter parameters unique in version 19.6 versus 19.5 NAME -------------------------------------------------- _bug29825525_bct_public_dba_buffer_dynresize_delay _bug30224950_kjac_direct_path_enabled _enable_ptime_update_for_sys _path_prefix_create_dir _smart_log_threshold_usec optimizer_session_type
No data dictionary changes have been found.
On the C function side, it becomes apparent that there’s development taking place. For the functions that have been removed, there’s a bunch that deal with ASM (kfd), some with kubs which has to do with big data SQL and some XDB/XML stuff.
There’s way more functions that gotten into the newest release update. There’s a lot of unknowns, ASM, application continuity, lots of big data SQL, JSON, polymorphic table functions, XML, and something that looks like it has to do with SIMD processing (skfSIMD) for which I don’t know what the ‘f’ is there (functions?). There’s also a whole batch of functions starting with ‘rest_nhp’, I yet have to look into these.
code symbol names unique in version 19.5 versus 19.6 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- jskqJobQReadDiskCbk (js)kqJobQReadDiskCbk job scheduing ?? kcbo_incr_doc (kcbo)_incr_doc kernel cache buffers object queue ?? kcfis_clear_lob (kcfis)_clear_lob kernel cache file management intelligent storage ?? kcoclnup602 (kco)clnup602 kernel cache operation ?? kewraxc_attribute_xcb (kewr)axc_attribute_xcb kernel event AWR repository ?? kfMaxParityHoles (kf)MaxParityHoles kernel automatic storage management ?? kfdDskComputeHashForRow (kfd)DskComputeHashForRow kernel automatic storage management disk ?? kfdDskTableCbInternal (kfd)DskTableCbInternal kernel automatic storage management disk ?? kfgComputeGrpProp (kfg)ComputeGrpProp kernel automatic storage management diskgroups ?? kfgGrpTableCbInternal (kfg)GrpTableCbInternal kernel automatic storage management diskgroups ?? kgds_dump_callers_sub (kgds)_dump_callers_sub kernel generic vos generic stack trace ?? kgfdDiscoverSubmit (kgfd)DiscoverSubmit kernel generic ASM io subsystem driver ?? kgh_size_sanity_check (kgh)_size_sanity_check kernel generic heap manager ?? kjccspbat (kjc)cspbat kernel lock management communication ?? kkeTbRowCPUCost (kke)TbRowCPUCost kernel compile cost engine ?? kkqjePatchCol (kkqj)ePatchCol kernel compile query join analysis ?? krbbCountThreads (krbb)CountThreads kernel redo backup/restore creation of a backuppiece ?? ksadmb ksadmb kernel service asynchronous messages deallocate message buffer ksdhng_wdat_rem_dup (ksdhng)_wdat_rem_dup kernel service debug internal errors hang analyze ?? kubsprqcrio_close (kubsprq)crio_close kernel utility big data sql parquet ?? kubsprqcrio_read (kubsprq)crio_read kernel utility big data sql parquet ?? kubsprqcrio_seek (kubsprq)crio_seek kernel utility big data sql parquet ?? kubsprqioAdvise (kubsprq)ioAdvise kernel utility big data sql parquet ?? kubsprqioClose (kubsprq)ioClose kernel utility big data sql parquet ?? kubsprqioOpen (kubsprq)ioOpen kernel utility big data sql parquet ?? kubsprqioRead (kubsprq)ioRead kernel utility big data sql parquet ?? kzagetcid (kza)getcid kernel security audit ?? qeroiFirstPart (qeroi)FirstPart query execute rowsource extensibel indexing query component ?? qjsnGetBinFromOSON (qjsn)GetBinFromOSON query json ?? qksptfOCIerr (qksptf)OCIerr query kernel sql polymorphic table functions compilation ?? qmxgniCheckLOBSize (qmx)gniCheckLOBSize query XDB XML Objects ?? qmxgniHasNodeIdOrCSX (qmx)gniHasNodeIdOrCSX query XDB XML Objects ?? qmxgniReturnString (qmx)gniReturnString query XDB XML Objects ?? qmxgniUnderEvent (qmx)gniUnderEvent query XDB XML Objects ?? rwssid_andv (rws)sid_andv row source ?? code symbol names unique in version 19.6 versus 19.5 NAME RESOLVE ANNOTATION ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------------------------------------- CJPathConsumer2D_create CJPathConsumer2D_create ?? CJPathConsumer2D_staticFinalize CJPathConsumer2D_staticFinalize ?? CJPathConsumer2D_staticInitialize CJPathConsumer2D_staticInitialize ?? Java_sun_dc_pr_PathStroker_cInitialize2D Java_sun_dc_pr_PathStroker_cInitialize2D ?? PC2D__cleanup PC2D__cleanup ?? PC2D__enumCoObs PC2D__enumCoObs ?? PC2D_appendCubic PC2D_appendCubic ?? PC2D_appendLine PC2D_appendLine ?? PC2D_appendQuad PC2D_appendQuad ?? PC2D_beginPath PC2D_beginPath ?? PC2D_beginSubpath PC2D_beginSubpath ?? PC2D_className PC2D_className ?? PC2D_closedSubpath PC2D_closedSubpath ?? PC2D_copy PC2D_copy ?? PC2D_endPath PC2D_endPath ?? PC2D_useProxy PC2D_useProxy ?? crio_close crio_close ?? crio_read crio_read ?? crio_seek crio_seek ?? dbnest_etime_op (dbnest)_etime_op dbnest ?? dcpr_PCClosePath dcpr_PCClosePath ?? dcpr_PCCubicTo dcpr_PCCubicTo ?? dcpr_PCLineTo dcpr_PCLineTo ?? dcpr_PCMoveTo dcpr_PCMoveTo ?? dcpr_PCPathDone dcpr_PCPathDone ?? dcpr_PCQuadTo dcpr_PCQuadTo ?? dmqlDeserLogicalCheck dmqlDeserLogicalCheck ?? dmsarProdDump dmsarProdDump ?? dmsspKroneckerChk dmsspKroneckerChk ?? dmsspProdDump dmsspProdDump ?? dtbfti_find_tobedrp_ix (dtb)fti_find_tobedrp_ix drop table ?? jskqCountClassesUsingService (js)kqCountClassesUsingService job scheduing ?? jskqJobQueuePDBReload (js)kqJobQueuePDBReload job scheduing ?? jskqUpdateQueueNextRunTime (js)kqUpdateQueueNextRunTime job scheduing ?? jznDecodeOSON4IMCJMetaD (jzn)DecodeOSON4IMCJMetaD json ?? jznOctDistFnmAllocSz (jzn)OctDistFnmAllocSz json ?? jznoctGetArraySizeI (jzn)octGetArraySizeI json ?? jznoctIsTopScalar (jzn)octIsTopScalar json ?? kciVARCHAR2sz (kci)VARCHAR2sz kernel cache oracle text ?? kcoclnup (kco)clnup kernel cache operation ?? kcrfw_alfs_sl_emulate (kcrfw_alfs)_sl_emulate kernel cache recovery file write/broadcast SCN adaptive log file sync ?? kcrfw_alfs_sl_save_redowrite_time (kcrfw_alfs)_sl_save_redowrite_time kernel cache recovery file write/broadcast SCN adaptive log file sync ?? kcrfw_alfs_sl_update_mode (kcrfw_alfs)_sl_update_mode kernel cache recovery file write/broadcast SCN adaptive log file sync ?? kcrfw_dax_is_smart_log (kcrfw)_dax_is_smart_log kernel cache recovery file write/broadcast SCN ?? kewrcc_bind_cb (kewr)cc_bind_cb kernel event AWR repository ?? kewrcc_check_columns (kewr)cc_check_columns kernel event AWR repository ?? kewrcc_fetch_cb (kewr)cc_fetch_cb kernel event AWR repository ?? kfGetParityFailureMask (kf)GetParityFailureMask kernel automatic storage management ?? kfParityCalP (kf)ParityCalP kernel automatic storage management ?? kfParityCalP0 (kf)ParityCalP0 kernel automatic storage management ?? kfParityCalQ (kf)ParityCalQ kernel automatic storage management ?? kfParityCalQ0 (kf)ParityCalQ0 kernel automatic storage management ?? kfdBlockContentCheck (kfd)BlockContentCheck kernel automatic storage management disk ?? kfdp_getNormalFgCnt (kfdp)_getNormalFgCnt kernel automatic storage management disk PST ?? kfknodecFreeCb (kfk)nodecFreeCb kernel automatic storage management KFK ?? kfnASMBnRunning (kfn)ASMBnRunning kernel automatic storage management networking subsystem ?? kglLockWaitTime (kglLock)WaitTime kernel generic library cache management library cache lock ?? kgskltyp (kgsk)ltyp kernel generic service resource manager ?? kgwsm_reset (kg)wsm_reset kernel generic ?? kjac_dp_alloc (kjac)_dp_alloc kernel lock management application continuity ?? kjac_dp_bind_tim (kjac)_dp_bind_tim kernel lock management application continuity ?? kjac_dp_bind_uin (kjac)_dp_bind_uin kernel lock management application continuity ?? kjac_dp_comp_bin (kjac)_dp_comp_bin kernel lock management application continuity ?? kjac_dp_comp_uin (kjac)_dp_comp_uin kernel lock management application continuity ?? kjac_dp_enabled_cbk (kjac)_dp_enabled_cbk kernel lock management application continuity ?? kjac_dp_free (kjac)_dp_free kernel lock management application continuity ?? kjac_dp_insert_init (kjac)_dp_insert_init kernel lock management application continuity ?? kjac_dp_md_init (kjac)_dp_md_init kernel lock management application continuity ?? kjac_dp_open (kjac)_dp_open kernel lock management application continuity ?? kjac_dp_recover (kjac)_dp_recover kernel lock management application continuity ?? kjac_dp_update (kjac)_dp_update kernel lock management application continuity ?? kjac_dp_update_init (kjac)_dp_update_init kernel lock management application continuity ?? kjac_dp_update_state (kjac)_dp_update_state kernel lock management application continuity ?? kjac_dpctx_alloc (kjac)_dpctx_alloc kernel lock management application continuity ?? kjac_dpctx_free (kjac)_dpctx_free kernel lock management application continuity ?? kjac_dpinfo_close (kjac)_dpinfo_close kernel lock management application continuity ?? kjac_dpinfo_open (kjac)_dpinfo_open kernel lock management application continuity ?? kjac_sql_ltxid_tabid (kjac)_sql_ltxid_tabid kernel lock management application continuity ?? kjac_sql_materialize_part (kjac)_sql_materialize_part kernel lock management application continuity ?? kjac_trace_event_cbk (kjac)_trace_event_cbk kernel lock management application continuity ?? kjfclmdrsc (kj)fclmdrsc kernel lock management ?? kjfclmdsgvbi (kj)fclmdsgvbi kernel lock management ?? kjgcr_GetTopCPU (kj)gcr_GetTopCPU kernel lock management ?? kjgcr_RunSyncTask (kj)gcr_RunSyncTask kernel lock management ?? kjgcr_SlaveReqGetSlot (kj)gcr_SlaveReqGetSlot kernel lock management ?? kkbati_add_tbd_ix (kkb)ati_add_tbd_ix kernel compile table ?? kkbdti_drop_tbd_ix (kkb)dti_drop_tbd_ix kernel compile table ?? kkdlVirtColCB (kkdl)VirtColCB kernel compile dictionary lookup ?? kkoUpdOrdTabWithOrdSubqHints (kko)UpdOrdTabWithOrdSubqHints kernel compile optimizer ?? kkqjfCopyFroNoChn (kkqjf)CopyFroNoChn kernel compile query join analysis join factorization ?? kpdbcCheckRedoApplyNeeded (kpdb)cCheckRedoApplyNeeded kernel programmatic interface pluggable database ?? kpoxcAppContPDBNotify (kpo)xcAppContPDBNotify kernel programmatic interface oracle ?? kpudpParquetInt96 (kpudp)ParquetInt96 kernel programmatic interface user DPAPI Load ?? ksfqsrfn (ksfq)srfn kernel service functions sequential file io interface ?? kswsLdiToInt (ksws)LdiToInt kernel service workgroup services ?? ksws_alb_colocation_tag_cbk (ksws)_alb_colocation_tag_cbk kernel service workgroup services ?? ksws_alb_mark_stale_colocated_sessions (ksws)_alb_mark_stale_colocated_sessions kernel service workgroup services ?? ksws_alb_set_session_colocation (ksws)_alb_set_session_colocation kernel service workgroup services ?? kubsBUFioAdvise (kubs)BUFioAdvise kernel utility big data sql ?? kubsBUFioClose (kubs)BUFioClose kernel utility big data sql ?? kubsBUFioOpen (kubs)BUFioOpen kernel utility big data sql ?? kubsBUFioRead (kubs)BUFioRead kernel utility big data sql ?? kubsCRioODM_close (kubs)CRioODM_close kernel utility big data sql ?? kubsCRioODM_finish (kubs)CRioODM_finish kernel utility big data sql ?? kubsCRioODM_finishHelper (kubs)CRioODM_finishHelper kernel utility big data sql ?? kubsCRioODM_init (kubs)CRioODM_init kernel utility big data sql ?? kubsCRioODM_initHelper (kubs)CRioODM_initHelper kernel utility big data sql ?? kubsCRioODM_opcsetupgp (kubs)CRioODM_opcsetupgp kernel utility big data sql ?? kubsCRioODM_openHelper (kubs)CRioODM_openHelper kernel utility big data sql ?? kubsCRioODM_read (kubs)CRioODM_read kernel utility big data sql ?? kubsCRioODM_readHelper (kubs)CRioODM_readHelper kernel utility big data sql ?? kubsCRioREST_allocNextFromDSArray (kubs)CRioREST_allocNextFromDSArray kernel utility big data sql ?? kubsCRioREST_close (kubs)CRioREST_close kernel utility big data sql ?? kubsCRioREST_finish (kubs)CRioREST_finish kernel utility big data sql ?? kubsCRioREST_httpInit (kubs)CRioREST_httpInit kernel utility big data sql ?? kubsCRioREST_httpRequest (kubs)CRioREST_httpRequest kernel utility big data sql ?? kubsCRioREST_id (kubs)CRioREST_id kernel utility big data sql ?? kubsCRioREST_id_add (kubs)CRioREST_id_add kernel utility big data sql ?? kubsCRioREST_init (kubs)CRioREST_init kernel utility big data sql ?? kubsCRioREST_read (kubs)CRioREST_read kernel utility big data sql ?? kubsCRioREST_validate_url (kubs)CRioREST_validate_url kernel utility big data sql ?? kubsCRioSPescape (kubs)CRioSPescape kernel utility big data sql ?? kubsCRioURLencode (kubs)CRioURLencode kernel utility big data sql ?? kubsCRio_get_cell_wallet_path (kubs)CRio_get_cell_wallet_path kernel utility big data sql ?? kubsCRio_get_rdbms_wallet_path (kubs)CRio_get_rdbms_wallet_path kernel utility big data sql ?? kubsavroGetDecimalTpeProp (kubsavro)GetDecimalTpeProp kernel utility big data sql avro ?? kubsprqGetBoolProp (kubsprq)GetBoolProp kernel utility big data sql parquet ?? kubsprqtGetData (kubsprq)tGetData kernel utility big data sql parquet ?? kubsprqtGetDataByte (kubsprq)tGetDataByte kernel utility big data sql parquet ?? kubsprqtRead (kubsprq)tRead kernel utility big data sql parquet ?? kubsprqtReadVarint (kubsprq)tReadVarint kernel utility big data sql parquet ?? kubsprquReadZVarint (kubsprq)uReadZVarint kernel utility big data sql parquet ?? kubsxGetConfigList (kubs)xGetConfigList kernel utility big data sql ?? kubsxiGetLocalCreds (kubs)xiGetLocalCreds kernel utility big data sql ?? kubsxiGetNextCell (kubs)xiGetNextCell kernel utility big data sql ?? kupaxisosf (kup)axisosf kernel utility datapump ?? kwqaexgcur (kwqa)exgcur kernel advanced queuing administration ?? kwqaexgcurobc (kwqa)exgcurobc kernel advanced queuing administration ?? kxes_sqlcomp_check_1 (kx)es_sqlcomp_check_1 kernel execution ?? kxes_sqlcomp_check_macro (kx)es_sqlcomp_check_macro kernel execution ?? kzvCheckGrantInRoot_cbk (kz)vCheckGrantInRoot_cbk kernel security ?? kzvGrantedCommonlyInRoot (kz)vGrantedCommonlyInRoot kernel security ?? ntt_pptlv (ntt)_pptlv network transport (drivers) tcp/ip ?? odm_apg (odm)_apg oracle disk manager ?? odm_fpg (odm)_fpg oracle disk manager ?? odm_get_creds (odm)_get_creds oracle disk manager ?? odm_get_proxy (odm)_get_proxy oracle disk manager ?? odm_oua (odm)_oua oracle disk manager ?? odm_pec (odm)_pec oracle disk manager ?? odm_printf (odm)_printf oracle disk manager ?? odm_wrf (odm)_wrf oracle disk manager ?? ph2osfm_setup_function_metadata (ph2)osfm_setup_function_metadata PLSQL phase 2 (semantic analyzer) ?? ph2scs_semantic_checks_for_sqm (ph2)scs_semantic_checks_for_sqm PLSQL phase 2 (semantic analyzer) ?? qctoj_obadi4DateTimeStuff (qcto)j_obadi4DateTimeStuff query compile type check operations operators ?? qergiSetFirstPartFlag (qergi)SetFirstPartFlag query execute rowsource granule iterator (partitioning? or PX granules?) ?? qeroiFindGranuleIter (qeroi)FindGranuleIter query execute rowsource extensibel indexing query component ?? qertrcGetEncMaxLen (qer)trcGetEncMaxLen query execute rowsource ?? qerupFindChiHC (qerup)FindChiHC query execute rowsource update ?? qerupUpdStatsCbk (qerup)UpdStatsCbk query execute rowsource update ?? qerxjConvertToBinaryNumber (qerxj)ConvertToBinaryNumber query execute rowsource json ?? qerxjConvertToInterval (qerxj)ConvertToInterval query execute rowsource json ?? qjsnJSON_DML_OptimOccurred (qjsn)JSON_DML_OptimOccurred query json ?? qjsnOKToApplySkipCpOSONOptim (qjsn)OKToApplySkipCpOSONOptim query json ?? qjsnRetBinaryNumber (qjsn)RetBinaryNumber query json ?? qjsnRetInterval (qjsn)RetInterval query json ?? qjsn_can_skip_cpy_oson_bytes (qjsn)_can_skip_cpy_oson_bytes query json ?? qjsn_can_skip_is_json_validation (qjsn)_can_skip_is_json_validation query json ?? qjsngGetBinFromOSON (qjsn)gGetBinFromOSON query json ?? qjsngRaiseSQLError (qjsn)gRaiseSQLError query json ?? qjsngStringToDateDty3 (qjsn)gStringToDateDty3 query json ?? qjsnlobCheckLobPatch (qjsn)lobCheckLobPatch query json ?? qkaIsRTRIMRequiredForViewCol (qka)IsRTRIMRequiredForViewCol query kernel allocation ?? qksopCheckConstOrOptWithBindInAndChains (qksop)CheckConstOrOptWithBindInAndChains query kernel sql compilter operand processing ?? qksopFindQbByName (qksop)FindQbByName query kernel sql operand processing ?? qksopSplitPreds (qksop)SplitPreds query kernel sql operand processing ?? qksopVisitPredsInt (qksop)VisitPredsInt query kernel sql operand processing ?? qksopVisitPredsPostOrder (qksop)VisitPredsPostOrder query kernel sql compilter operand processing ?? qksptfContainNestedScalar (qksptf)ContainNestedScalar query kernel sql polymorphic table functions compilation ?? qksptfDescribePTF (qksptf)DescribePTF query kernel sql polymorphic table functions compilation ?? qksptfOCIerr_ (qksptf)OCIerr_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_Check_Errors (qksptf)SQM_Check_Errors query kernel sql polymorphic table functions compilation ?? qksptfSQM_CleanupTDOs (qksptf)SQM_CleanupTDOs query kernel sql polymorphic table functions compilation ?? qksptfSQM_Describe (qksptf)SQM_Describe query kernel sql polymorphic table functions compilation ?? qksptfSQM_ExpRepl_ (qksptf)SQM_ExpRepl_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_GetTxt (qksptf)SQM_GetTxt query kernel sql polymorphic table functions compilation ?? qksptfSQM_Init (qksptf)SQM_Init query kernel sql polymorphic table functions compilation ?? qksptfSQM_Laz_ (qksptf)SQM_Laz_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_Model_Check (qksptf)SQM_Model_Check query kernel sql polymorphic table functions compilation ?? qksptfSQM_Parse (qksptf)SQM_Parse query kernel sql polymorphic table functions compilation ?? qksptfSQM_Parse_errors (qksptf)SQM_Parse_errors query kernel sql polymorphic table functions compilation ?? qksptfSQM_PstPrc (qksptf)SQM_PstPrc query kernel sql polymorphic table functions compilation ?? qksptfSQM_PstPrc1_ (qksptf)SQM_PstPrc1_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_QbcRelExp_ (qksptf)SQM_QbcRelExp_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_RplExpA (qksptf)SQM_RplExpA query kernel sql polymorphic table functions compilation ?? qksptfSQM_RplExpB (qksptf)SQM_RplExpB query kernel sql polymorphic table functions compilation ?? qksptfSQM_SetIQB_ (qksptf)SQM_SetIQB_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_SetSQM_ (qksptf)SQM_SetSQM_ query kernel sql polymorphic table functions compilation ?? qksptfSQM_Template (qksptf)SQM_Template query kernel sql polymorphic table functions compilation ?? qksptfSQM_rm_vqb (qksptf)SQM_rm_vqb query kernel sql polymorphic table functions compilation ?? qksptfSubExprContainScalar (qksptf)SubExprContainScalar query kernel sql polymorphic table functions compilation ?? qmxtigCheckLOBSize (qmxt)igCheckLOBSize query XDB XML Objects XML ?? qmxtigCreXMLImgFromLob (qmxt)igCreXMLImgFromLob query XDB XML Objects XML ?? qmxtigGetXMLImgInfo (qmxt)igGetXMLImgInfo query XDB XML Objects XML ?? qmxtigImgNdsCnv (qmxt)igImgNdsCnv query XDB XML Objects XML ?? qmxtigReturnString (qmxt)igReturnString query XDB XML Objects XML ?? qmxtigUnderEvent (qmxt)igUnderEvent query XDB XML Objects XML ?? qmxtigUpdateReplayChecksum (qmxt)igUpdateReplayChecksum query XDB XML Objects XML ?? qmxtigValidateXmlImage (qmxt)igValidateXmlImage query XDB XML Objects XML ?? qmxtigValidateXmlImgBody (qmxt)igValidateXmlImgBody query XDB XML Objects XML ?? qmxtigValidateXmlImgHdr (qmxt)igValidateXmlImgHdr query XDB XML Objects XML ?? qxxqGetCredentials (qx)xqGetCredentials query query execution ?? qxxqGetProxy (qx)xqGetProxy query query execution ?? qxxqGetSSLWallet (qx)xqGetSSLWallet query query execution ?? rest_nhpavail rest_nhpavail ?? rest_nhpconnect rest_nhpconnect ?? rest_nhpdisconnect rest_nhpdisconnect ?? rest_nhpflush rest_nhpflush ?? rest_nhpfree rest_nhpfree ?? rest_nhpmalloc rest_nhpmalloc ?? rest_nhprealloc rest_nhprealloc ?? rest_nhprecv rest_nhprecv ?? rest_nhprequestauth rest_nhprequestauth ?? rest_nhpsend rest_nhpsend ?? rest_nhptrace rest_nhptrace ?? rest_nhpwalletauth rest_nhpwalletauth ?? rwssecondtop (rws)secondtop row source ?? setJPathConsumer2D setJPathConsumer2D ?? skfParityGDiv (sk)fParityGDiv operating system dependent kernel ?? skfParityGMul (sk)fParityGMul operating system dependent kernel ?? skfSIMDAvail (sk)fSIMDAvail operating system dependent kernel ?? skfSIMDCalP (sk)fSIMDCalP operating system dependent kernel ?? skfSIMDCalP0 (sk)fSIMDCalP0 operating system dependent kernel ?? skfSIMDCalQ (sk)fSIMDCalQ operating system dependent kernel ?? skfSIMDCalQ0 (sk)fSIMDCalQ0 operating system dependent kernel ?? skfSIMDMultiplicationLookupTable (sk)fSIMDMultiplicationLookupTable operating system dependent kernel ?? skfSIMDRecoverOneDataFromQ (sk)fSIMDRecoverOneDataFromQ operating system dependent kernel ?? skfSIMDRecoverTwoDataFromPQ (sk)fSIMDRecoverTwoDataFromPQ operating system dependent kernel ??
(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)
Hi Fritz,
There are several polymorphic table functions (qksptf) containing SQM, such as: qksptfSQM_GetTxt, qksptfSQM_Template, etc.
They should be coming from the SQL Macro functionality that was partially backported to 19.6:
Bug 30324180 SQL Macro should be backported to 19.5 (you can find a sample code using SQL Macros in 19.6 at: https://gist.github.com/mvelikikh/01eb283d6c053d8631f16f21e1bc58e3)
Could you please update their description on http://orafun.info ?
Regards,
Mikhail.
Hi Mikhail, thank you for the heads up!
I added qksptfSQM with ‘sql macro’ if you know more specifics of what the functions do, please let me know.