One of my first steps is to check the documentation to see what changed. Unfortunately not all changes are documented, So we have to document these pieces on our own.
One of the interesting values are defined in v$session_fix_control. I compared the values between Version 21.9 and the "free" one which identifies itself as 23.3.
These bugnos were removed:
These bugnos were removed:
| BUGNO | VALUE | SQL_FEATURE | DESCRIPTION | OPTIMIZER_FEATURE_ ENABLE |
EVENT |
|---|---|---|---|---|---|
| 29222233 | 1 | QKSFM_OWS_29222233 | XDB Oracle Web Services WSDL output | 12.1.0.1 | 0 |
| 31545400 | 0 | QKSFM_PQ_31545400 | Delay in setting QERTBTEMPCSH when kxttIsIMCDTEnabled is safe to | 0 |
These bugnos were added:
| BUGNO | VALUE | SQL_FEATURE | DESCRIPTION | OPTIMIZER_FEATURE_ ENABLE |
EVENT |
|---|---|---|---|---|---|
| 11775759 | 1 | QKSFM_EXECUTION_11775759 | correctly disable non-PUBLIC roles in definer rights | 8.0.0 | 0 |
| 18655662 | 1 | QKSFM_MVIEWS_18655662 | Translate obj# during KGL load of summary detail sub ordintae se | 8.0.0 | 0 |
| 23220873 | 1 | QKSFM_CARDINALITY_23220873 | cap join column NDV by inlist element count | 23.1.0 | 0 |
| 25869323 | 1 | QKSFM_OBJ_EXT_25869323 | allow correlated user-defined aggregates | 8.0.0 | 0 |
| 26314866 | 1 | QKSFM_OBJ_EXT_26314866 | allow data mining opts returning collections to run in parallel | 23.1.0 | 0 |
| 27655144 | 1 | QKSFM_FILTER_PUSH_PRED_27655144 | improve adding single table predicates from OR chains | 23.1.0 | 0 |
| 27982637 | 1 | QKSFM_CARDINALITY_27982637 | fix column group not null sel when one of the columns is all nul | 23.1.0 | 0 |
| 28133919 | 0 | QKSFM_TRANSFORMATION_28133919 | Disable cleanup of unreferenced subqueries removed as false pred | 0 | |
| 28320774 | 1 | QKSFM_EXECUTION_28320774 | Offload NLSSORT to Exa cells | 8.0.0 | 0 |
| 28327761 | 1 | QKSFM_CBO_28327761 | improved selectivity for NOT LIKE predicates using escape | 23.1.0 | 0 |
| 28853347 | 1 | QKSFM_ACCESS_PATH_28853347 | check for leading wildcard in LIKE with concatenation | 23.1.0 | 0 |
| 29015273 | 0 | QKSFM_COMPILATION_29015273 | Disable bug 29015273 ambiguous column reference validation | 0 | |
| 29127192 | 1 | QKSFM_JPPD_29127192 | allow OJPPD to union view with DUAL in one branch | 23.1.0 | 0 |
| 29452971 | 2 | QKSFM_PLACE_GROUP_BY_29452971 | Extend GBP to arithmetic expressions and no group-by clauses | 23.1.0 | 0 |
| 29967896 | 0 | QKSFM_GROUPING_SET_XFORM_29967896 | Do not clear qbcfpt before copy during grouping set transformati | 0 | |
| 30483200 | 1 | QKSFM_VECTOR_AGG_30483200 | multi-col DGK est will use extended stats or std method for SET | 23.1.0 | 0 |
| 30559864 | 1 | QKSFM_SVM_30559864 | perform rows restriction check for secure view merging | 23.1.0 | 0 |
| 30618406 | 1 | QKSFM_PQ_30618406 | use the largest partition ndv for bloom filter size | 23.1.0 | 0 |
| 30887435 | 1 | QKSFM_PARTITION_30887435 | control scanning to unnecessary partitions | 23.1.0 | 0 |
| 30888789 | 100 | QKSFM_TRANSFORMATION_30888789 | cutoff cost of subquery blocks during SU search | 23.1.0 | 0 |
| 30978868 | 1 | QKSFM_ACCESS_PATH_30978868 | better pruning for indexed table on right of nested loops join | 23.1.0 | 0 |
| 31050103 | 1 | QKSFM_FDA_31050103 | FDA will batch archive txns in cdb environment whenever possible | 23.1.0 | 0 |
| 31060590 | 1 | QKSFM_CBO_31060590 | accounting for subquery filtering cost in OR chain | 23.1.0 | 0 |
| 31163561 | 7 | QKSFM_TRANSFORMATION_31163561 | stop SU early for low-cost query blocks and cap correlated NDVs | 23.1.0 | 0 |
| 31195441 | 0 | QKSFM_SQL_CODE_GENERATOR_31195441 | Avoid fully traversal of OPTCSR operator | 0 | |
| 31209735 | 1 | QKSFM_CBO_31209735 | revise multi-match costing for SMJ and MJC | 23.1.0 | 0 |
| 31219054 | 1 | QKSFM_ANSI_REARCH_31219054 | Allow LATERAL view merge with 2-tab join expr1(c1) <op> expr2(c2 | 23.1.0 | 0 |
| 31313036 | 1 | QKSFM_PQ_31313036 | use parallel_min_degree for DDL statements | 23.1.0 | 0 |
| 31428395 | 1 | QKSFM_ACCESS_PATH_31428395 | corrections to unique index scan selection | 23.1.0 | 0 |
| 31441092 | 1 | QKSFM_COMPILATION_31441092 | materialized with clause column pruning | 8.0.0 | 0 |
| 31455066 | 0 | QKSFM_TYPECHECKING_31455066 | Allows character functions to coerce XML/JSON into CHAR | 0 | |
| 31476436 | 1 | QKSFM_EXECUTION_31476436 | filter rows on the cells for CC2 pop scan | 8.0.0 | 0 |
| 31495387 | 1 | QKSFM_ANSI_REARCH_31495387 | allow ANSI Rearchitectureallow with WITH clause views | 21.1.0 | 0 |
| 31515468 | 0 | QKSFM_CBO_31515468 | disable memory optimization in kkegvl | 0 | |
| 31582179 | 1 | QKSFM_BITMAP_TREE_31582179 | Enable index full scan in BITMAP_TREE hint | 8.0.0 | 0 |
| 31891143 | 0 | QKSFM_COMPILATION_31891143 | resolve objects in view schema in view DDLs | 0 | |
| 31925765 | 0 | QKSFM_CBO_31925765 | disable caching equality join selectivity result | 0 | |
| 31954734 | 1 | QKSFM_VECTOR_AGG_31954734 | support multiple partition filters in a key vector | 23.1.0 | 0 |
| 31966442 | 1 | QKSFM_JPPD_31966442 | reject JPPD in set block parent if JPPD is rejected in a branch | 23.1.0 | 0 |
| 32061341 | 1 | QKSFM_CBO_32061341 | do not use empty indexes for column groups | 23.1.0 | 0 |
| 32103198 | 0 | QKSFM_STATS_32103198 | staleness not considering stats gathering frequency or obj owner | 0 | |
| 32108311 | 0 | QKSFM_STATS_32108311 | Allow auto stats to skip stats consistency check | 0 | |
| 32133426 | 1 | QKSFM_CBO_32133426 | convert <col> LIKE <col> to <col> IS NOT NULL | 23.1.0 | 0 |
| 32230780 | 1 | QKSFM_ANSI_REARCH_32230780 | add into froljc only if the column belongs to outside of the vie | 23.1.0 | 0 |
| 32313119 | 0 | QKSFM_STATS_32313119 | allow auto stats to gather stats on empty objects | 0 | |
| 32361128 | 1 | QKSFM_EXECUTION_32361128 | support Inmemory expressions for CTAS and DML | 8.0.0 | 0 |
| 32363981 | 1 | QKSFM_TRANSFORMATION_32363981 | allow cast operator in subquery removal using window function | 23.1.0 | 0 |
| 32396085 | 1 | QKSFM_COLUMN_STATS_32396085 | Fix the stats of correlated col projected from the union view | 23.1.0 | 0 |
| 32455005 | 1 | QKSFM_DML_32455005 | Avoid blocking dml lock for delete on unindexed foreign key | 8.0.0 | 0 |
| 32471594 | 1 | QKSFM_CBO_32471594 | Fix the selectivity of semi join C1 <> C2 | 23.1.0 | 0 |
| 32498602 | 1 | QKSFM_OPT_ESTIMATE_32498602 | Normalisation for number values with many digits | 23.1.0 | 0 |
| 32508585 | 1 | QKSFM_PQ_32508585 | null skew handling improvement for parallel outer joins for adm | 21.1.0 | 0 |
| 32522208 | 1 | QKSFM_COALESCE_SQ_32522208 | allow subquery coalescing for CTAS and IAS | 23.1.0 | 0 |
| 32524953 | 0 | QKSFM_STATS_32524953 | no max_run_time extension | 0 | |
| 32527739 | 1 | QKSFM_AUTO_INDEX_32527739 | Additional auto index pruning criteria and metrics | 23.1.0 | 0 |
| 32603537 | 1 | QKSFM_STATS_32603537 | revised dbms_stats.copy_table_stats aggregation | 23.1.0 | 0 |
| 32614157 | 1 | QKSFM_INDEX_32614157 | allow inlist iterator after IS NULL key | 23.1.0 | 0 |
| 32616683 | 1 | QKSFM_SQL_CODE_GENERATOR_32616683 | use table hint alias in qkn signature computation | 8.0.0 | 0 |
| 32642004 | 1 | QKSFM_OR_EXPAND_32642004 | Allow legacy OR expansion when order by clause contains subquery | 23.1.0 | 0 |
| 32656022 | 0 | QKSFM_SQL_PLAN_MANAGEMENT_32656022 | drop adaptive plan baselie if better resolved plan baseline exis | 0 | |
| 32664918 | 1 | QKSFM_SQL_CODE_GENERATOR_32664918 | clump data redistribution for HASH GROUP BY | 23.1.0 | 0 |
| 32785016 | 1 | QKSFM_SUBSUME_32785016 | subsumption of views and subqueries | 23.1.0 | 0 |
| 32806672 | 1 | QKSFM_SQL_CODE_GENERATOR_32806672 | use hash gby/unique when the DFO will never be restarted | 23.1.0 | 0 |
| 32874571 | 0 | QKSFM_OR_EXPAND_32874571 | Cost-based ORE transformation for NVL/DECODE predicates | 23.1.0 | 0 |
| 32909932 | 1 | QKSFM_ADAPTIVE_PLAN_32909932 | fix adaptive plan hash value computation | 8.0.0 | 0 |
| 32933936 | 0 | QKSFM_SQL_PLAN_MANAGEMENT_32933936 | Load plan rows when loading outline hints | 0 | |
| 32963191 | 1 | QKSFM_DYNAMIC_SAMPLING_32963191 | Enable dyn sampling on index skip scan with leading access pred | 23.1.0 | 0 |
| 33069936 | 1 | QKSFM_DDL_33069936 | or expansion happens more in first pass and inlist conversion | 23.1.0 | 0 |
| 33157188 | 1 | QKSFM_SQL_CODE_GENERATOR_33157188 | bloom filter processing for Exadata CC2 tables | 23.1.0 | 0 |
| 33206564 | 1 | QKSFM_SCAN_33206564 | allow fast eval of ora_rowscn | 23.1.0 | 0 |
| 33236729 | 1 | QKSFM_SQL_PLAN_MANAGEMENT_33236729 | reduce invalidations from DDL on SPM baseline plans | 8.0.0 | 0 |
| 33272827 | 1 | QKSFM_SQL_CODE_GENERATOR_33272827 | Avoid redundant sort when window function is clumped with GBY | 23.1.0 | 0 |
| 33303725 | 1 | QKSFM_VECTOR_AGG_33303725 | allow VT when join is removed with indexed one row joins | 23.1.0 | 0 |
| 33311488 | 1 | QKSFM_JPPD_33311488 | OJPPD: try search by frodef if search by offset failed | 23.1.0 | 0 |
| 33329027 | 1 | QKSFM_SQL_CODE_GENERATOR_33329027 | allow parallel FILTER with global temp tables references | 23.1.0 | 0 |
| 33354270 | 1 | QKSFM_STATS_33354270 | auto stats check stats consistency | 8.0.0 | 0 |
| 33369863 | 1 | QKSFM_VECTOR_AGG_33369863 | push key vectors through nested UNION ALL and joins | 23.1.0 | 0 |
| 33381775 | 1 | QKSFM_EXECUTION_33381775 | relax restrictions on null skew handling | 23.1.0 | 0 |
| 33381981 | 0 | QKSFM_STATS_33381981 | new way to collect hard parse statistics | 0 | |
| 33392317 | 0 | QKSFM_PQ_33392317 | allow bloom filter row source filtering | 0 | |
| 33421972 | 0 | QKSFM_JSON_33421972 | disable json_table transformation | 0 | |
| 33441136 | 2 | QKSFM_JSON_33441136 | Allow returning VBL (Value Based LOB) for JSON operators | 8.0.0 | 0 |
| 33443834 | 1 | QKSFM_INDEX_STATS_33443834 | amend scaling for partitioned index statistics | 23.1.0 | 0 |
| 33514826 | 0 | QKSFM_STATS_33514826 | index stats gathering failure aborts table stats gathering | 0 | |
| 33538756 | 0 | QKSFM_JSON_33538756 | disable post-filter for JSON Search Index range-search query | 0 | |
| 33547527 | 1 | QKSFM_UNNEST_33547527 | Defer force unnesting until after CBQT | 23.1.0 | 0 |
| 33548186 | 0 | QKSFM_CBO_33548186 | disable cache histograms in column stats | 0 | |
| 33549743 | 0 | QKSFM_TRANSFORMATION_33549743 | disable reuse of memory for pgactx chains across transformations | 0 | |
| 33561572 | 1 | QKSFM_JSON_33561572 | JSON table self join rewrite | 23.1.0 | 0 |
| 33627879 | 1 | QKSFM_CURSOR_SHARING_33627879 | enable Adaptive Cursor Sharing for DML statements | 23.1.0 | 0 |
| 33635969 | 1 | QKSFM_OBJ_EXT_33635969 | allow domain index scan to project score for text-index | 23.1.0 | 0 |
| 33636280 | 0 | QKSFM_EXTTAB_33636280 | fix for serializable transaction | 0 | |
| 33649782 | 1 | QKSFM_OR_EXPAND_33649782 | Try LORE after ORE rejected due to LOB structure | 23.1.0 | 0 |
| 33659818 | 0 | QKSFM_PQ_33659818 | disable PKEY/LOCAL distribution if partition sizes are skewed | 23.1.0 | 0 |
| 33667505 | 1 | QKSFM_OR_EXPAND_33667505 | enhance index check in presence of NLSSORT function based index | 23.1.0 | 0 |
| 33730024 | 1 | QKSFM_CPU_COSTING_33730024 | use non-cached level and leaf blocks during index CPU costing | 23.1.0 | 0 |
| 33745469 | 1 | QKSFM_VECTOR_AGG_33745469 | allow VT 1-row optimization with bind variables | 23.1.0 | 0 |
| 33753810 | 1 | QKSFM_PQ_33753810 | obey [no]parallel statement hint for MTI | 23.1.0 | 0 |
| 33781860 | 1 | QKSFM_PLACE_GROUP_BY_33781860 | group-by placement with having clause | 23.1.0 | 0 |
| 33790922 | 1 | QKSFM_UNNEST_33790922 | allow unnesting subqueries for sharded dmls | 23.1.0 | 0 |
| 33904967 | 1 | QKSFM_SCAN_33904967 | serial direct reads for IOTs based on segment size | 23.1.0 | 0 |
| 33906515 | 1 | QKSFM_VECTOR_AGG_33906515 | vector transform support for distinct aggregates | 23.1.0 | 0 |
| 33926164 | 1 | QKSFM_PQ_33926164 | make load brokered for PKEY to facilitate randomization of NULLs | 23.1.0 | 0 |
| 33926416 | 1 | QKSFM_UNNEST_33926416 | disallow FKR in the first no-unnested state of exhaustive SU | 23.1.0 | 0 |
| 33933711 | 0 | QKSFM_SQL_PLAN_MANAGEMENT_33933711 | Disable SPM for recursive queries by default | 0 | |
| 33942999 | 1 | QKSFM_JSON_33942999 | enable JSON_VALUE to return boolean datatype | 23.1.0 | 0 |
| 33987911 | 1 | QKSFM_SVM_33987911 | allow SVM in presence of multiple column reference | 23.1.0 | 0 |
| 34012219 | 1 | QKSFM_PRED_MANAGEMENT_34012219 | Simplify LNNVL(col <relop> val) if col is (not) null | 23.1.0 | 0 |
| 34014503 | 1 | QKSFM_JOIN_METHOD_34014503 | skip NL with single part joining in favor of HJ with bloom pruni | 23.1.0 | 0 |
| 34024184 | 1 | QKSFM_PQ_34024184 | disallow in-memory CDT replication in RAC | 23.1.0 | 0 |
| 34028486 | 1 | QKSFM_SVM_34028486 | allow SVM in presence of REGEXP | 23.1.0 | 0 |
| 34044661 | 1 | QKSFM_CARDINALITY_34044661 | cyclic join selectivity of 31487332 for serial plans | 23.1.0 | 0 |
| 34052073 | 1 | QKSFM_STATS_34052073 | Track expression even if child has relatonal operator | 23.1.0 | 0 |
| 34054474 | 1 | QKSFM_SQL_CODE_GENERATOR_34054474 | use hash gby/unique for PIV stage vector GBY | 23.1.0 | 0 |
| 34092979 | 0 | QKSFM_PQ_34092979 | Let RM queue PQ from scheduler job at any pgadep | 0 | |
| 34123350 | 1 | QKSFM_PQ_34123350 | not cap parallel if table look up on the right side of a NLJ | 8.0.0 | 0 |
| 34131435 | 1 | QKSFM_OBJ_EXT_34131435 | enable PDML for spatial_index with c-Btree index | 23.1.0 | 0 |
| 34144133 | 1 | QKSFM_ACCESS_PATH_34144133 | allow rowid access path for hybrid partitioned tables | 23.1.0 | 0 |
| 34166850 | 1 | QKSFM_LOBS_34166850 | Allow PDML for LOB columns with constraint/index/virtual columns | 23.1.0 | 0 |
| 34177326 | 1 | QKSFM_ALL_34177326 | for use only under direction of Oracle Support | 8.0.0 | 0 |
| 34195589 | 1 | QKSFM_DYNAMIC_SAMPLING_34195589 | Trigger ADS System for tables with missing column stats | 23.1.0 | 0 |
| 34201264 | 1 | QKSFM_DYNAMIC_SAMPLING_34201264 | Do not set DS level to 11 if ADS System was used | 23.1.0 | 0 |
| 34215953 | 1 | QKSFM_DYNAMIC_SAMPLING_34215953 | Set ADS time limit to a floor of 10 seconds | 23.1.0 | 0 |
| 34220088 | 1 | QKSFM_AUTO_INDEX_34220088 | Altered auto index pruning metrics | 23.1.0 | 0 |
| 34225667 | 1 | QKSFM_PQ_34225667 | dump PX plan signature diagnostic info | 23.1.0 | 0 |
| 34242575 | 1 | QKSFM_JSON_34242575 | JSON function-based index can be null safe | 23.1.0 | 0 |
| 34265760 | 1 | QKSFM_TRANSFORMATION_34265760 | enable non-well-formed post-join predicates for native FOJ | 23.1.0 | 0 |
| 34275901 | 1 | QKSFM_PARTITION_34275901 | enable predicate elimination for interval-partitioned tables | 23.1.0 | 0 |
| 34280393 | 1 | QKSFM_SCAN_34280393 | avoid predicate evalation after qualifying index offload scan | 23.1.0 | 0 |
| 34286108 | 0 | QKSFM_STATS_34286108 | restore stats after time out | 0 | |
| 34291494 | 0 | QKSFM_PQ_34291494 | Reduce DOP for a PX when concurrent PXs are active | 0 | |
| 34340011 | 1 | QKSFM_LOBS_34340011 | Enables Inline Smart Lobs creation | 8.0.0 | 0 |
| 34384239 | 1 | QKSFM_VECTOR_AGG_34384239 | for CC2 tables do not generate a vector group by predicate | 23.1.0 | 0 |
| 34390912 | 0 | QKSFM_SPACE_34390912 | Enable segflags syntax in storage clause | 0 | |
| 34396205 | 1 | QKSFM_CARDINALITY_34396205 | derive UNION view stats from branches | 23.1.0 | 0 |
| 34424818 | 1 | QKSFM_XML_REWRITE_34424818 | Extend segmented array upper bound for XML/OR | 23.1.0 | 0 |
| 34461652 | 0 | QKSFM_STATS_34461652 | call stats gathering auto task on demand | 0 | |
| 34516743 | 0 | QKSFM_TRANSFORMATION_34516743 | Do not use transformation heap for operand allocation in kokq | 0 | |
| 34580872 | 1 | QKSFM_PARTITION_34580872 | eliminiate join predicates added for virtual col partition pruni | 23.1.0 | 0 |
| 34605396 | 1 | QKSFM_SQL_CODE_GENERATOR_34605396 | create a single column bloom filter based on predicate selectivi | 23.1.0 | 0 |
| 34642025 | 0 | QKSFM_SQL_PLAN_MANAGEMENT_34642025 | Disable heap memory usage check for SMO data | 0 | |
| 34685578 | 1 | QKSFM_JSON_34685578 | avoid JSON_TABLE rewrite involving windowing functions | 23.1.0 | 0 |
| 34701323 | 1 | QKSFM_PQ_34701323 | Keep order of predicates on GV$ views | 23.1.0 | 0 |
| 34721367 | 1 | QKSFM_PQ_34721367 | supply concurrent px info to RM | 23.1.0 | 0 |
| 34743394 | 0 | QKSFM_SHARD_QUERY_34743394 | Disable pushing expressions in group by to shards | 0 | |
| 34784064 | 1 | QKSFM_VECTOR_AGG_34784064 | allow KV reuse with top level UNION ALL | 23.1.0 | 0 |
| 34795905 | 1 | QKSFM_PQ_34795905 | treat nested PX as possibly serial for IMCDT | 23.1.0 | 0 |
| 34807859 | 1 | QKSFM_VECTOR_AGG_34807859 | increase VT cost for big NDV fact grp keys and 0,1 filter joins | 23.1.0 | 0 |
| 34816383 | 0 | QKSFM_STATS_FEEDBACK_34816383 | Do not use AR context to set reparse in kkocfbCheckCardEst | 0 | |
| 34870092 | 1 | QKSFM_WITH_SUBQUERY_34870092 | share base column stats with materialized query block column | 23.1.0 | 0 |
| 34888588 | 1 | QKSFM_PRED_MANAGEMENT_34888588 | Correctly mark shared predicates in transitive pred generation | 23.1.0 | 0 |
| 34993248 | 0 | QKSFM_VECTOR_AGG_34993248 | on RAC disallow VT if the query references a GV$ view | 0 | |
| 35012562 | 1 | QKSFM_OR_EXPAND_35012562 | allow OR expansion with STRTSETR within user-defined operator | 23.1.0 | 0 |
| 35019058 | 1 | QKSFM_PX_JOIN_FILTER_35019058 | allow bloom pruning push down under adaptive distribution method | 23.1.0 | 0 |
| 35069142 | 1 | QKSFM_CBO_35069142 | use ADVANCED format for plan display in SQL Monitor | 8.0.0 | 0 |
let's hope we never need any of these 155 new values!
Keine Kommentare:
Kommentar veröffentlichen