Hi, this is with respect to version 19C Oracle Exadata. We have few of the lower environments moved to 19c recently, one of the things which we were thinking initially to not to move to .1 version as we were having bad experience with bug etc with version .1 of earlier releases. And DBAs stating that the current version is 19.5 but not 19.1 which we are migrating to. But i see below in the v$ views.
I am bit confused, as because gv$version, BANNER_FULL showing "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0". Gv$parameter showing "optimizer_features_enable" as 19.1.0. dba_registry_sqlpatch showing as 19.5.0.0.191015.
So my question was if we have DB version 19.5.0 but the optimizer feature is set as 19.1, which we should updated to 19.5.0? DBAs saying it wont work that way in 19C a it used to work on 11 or 12 releases. And by just setting the optimizer feature as 19.5.0 is not going to add additional CBO feature to it( as it used to happen in earlier versions), so we are good with that optimizer_features_enable as 19.1.0. Just wanted to know from experts , if this understanding is correct and we are really going to get all latest optimizer fixes as of the versions 19.5 but not 19.1 with below setup? Then it means there will be no difference in behavior by setting the "optimizer_features_enable" as 19.1.0 or 19.5.0?
select * from gv$version where inst_id=1
INST_ID BANNER BANNER_FULL BANNER_LEGACY CON_ID
1 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0
select inst_id, value from gv$parameter where name like '%optimizer_features_enable%'
INST_ID VALUE
1 19.1.0
select description from dba_registry_sqlpatch;
DESCRIPTION
--------------------------------------------------------------------------------
OJVM RELEASE UPDATE: 19.5.0.0.191015 (30128191)
Database Release Update : 19.5.0.0.191015 (30125133)