首页 » ORACLE 9i-23ai » What is new in Oracle Database 23ai VS 19c?

What is new in Oracle Database 23ai VS 19c?

这前总是通过 修改optimizer_feature_enable为不同版本，然后对比级联的参数变化，比较不同的数据库版本之间的参数差异，在Oracle 有个  ORAdiff app: https://oradiff.oracle.com/ 你也可以自己查询。

如19.3 vs 23.5 XD c参数有新增约100个

NAME

 TYPE

 DEFAULT_VALUE

 ISSES_MODIFIABLE

 ISSYS_MODIFIABLE

 ISPDB_MODIFIABLE

 ISINSTANCE_MODIFIABLE

 ISDEPRECATED

 ISBASIC

 DESCRIPTION
allow_legacy_reco_protocol 1 TRUE FALSE FALSE TRUE FALSE FALSE FALSE Should the database allow the legacy RECO protocol
allow_weak_crypto 1 TRUE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Allow weak crypto usage in DBMS_CRYPTO
auto_start_pdb_services 1 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Automatically start all PDB services on PDB Open
blockchain_table_max_no_drop 3 FALSE IMMEDIATE TRUE TRUE FALSE FALSE maximum idle retention minutes for blockchain tables
blockchain_table_retention_threshold 3 16 FALSE IMMEDIATE TRUE TRUE FALSE FALSE maximum retention without TABLE RETENTION privilege
client_prefetch_rows 3 0 TRUE IMMEDIATE TRUE TRUE FALSE FALSE Client prefetch rows value
container_data 2 ALL TRUE FALSE TRUE FALSE FALSE FALSE which containers should data be returned from?
db_flashback_log_dest 2 NONE FALSE IMMEDIATE FALSE FALSE FALSE FALSE Separate creation directory for flashback database logs
db_flashback_log_dest_size 6 0 FALSE IMMEDIATE FALSE FALSE FALSE FALSE Size limit of separate creation directory for flashback database logs
db_recovery_auto_rekey 2 ON FALSE IMMEDIATE FALSE TRUE FALSE FALSE enable automatic tablespace rekey recovery
dbnest_enable 2 NONE FALSE FALSE FALSE FALSE FALSE FALSE database Nest enable
dbnest_pdb_fs_conf 2 FALSE FALSE FALSE FALSE FALSE FALSE PDB Filesystem configuration
default_credential 2 NONE TRUE FALSE FALSE FALSE FALSE FALSE default credential session parameter
diagnostics_control 2 IGNORE FALSE IMMEDIATE FALSE TRUE FALSE FALSE controls response when ‘enabling diagnostics’ privilege is absent
drcp_connection_limit 3 FALSE IMMEDIATE TRUE TRUE FALSE FALSE DRCP connection limit
drcp_dedicated_opt 2 NO FALSE IMMEDIATE TRUE TRUE FALSE FALSE Turn on/off dedicated optimization for DRCP
enable_per_pdb_drcp 1 FALSE FALSE FALSE FALSE FALSE FALSE FALSE Turn on/off per PDB DRCP
error_message_details 2 ON TRUE IMMEDIATE TRUE TRUE FALSE FALSE print additional explanatory error details
group_by_position_enabled 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable/disable group by position
heartbeat_batch_size 3 5 FALSE IMMEDIATE TRUE TRUE FALSE FALSE Number of heartbeats to be sent in a batch
hybrid_read_only 1 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Hybrid read only mode allows CDB common user to patch the PDB
identity_provider_config 2 NONE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Identity Provider Configuration
identity_provider_type 2 NONE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Identity Provider Type
ignore_session_set_param_errors 2 TRUE IMMEDIATE TRUE TRUE FALSE FALSE Ignore errors during alter session param set
inmemory_deep_vectorization 1 TRUE TRUE IMMEDIATE TRUE TRUE FALSE FALSE In-Memory Deep Vectorization Enabled
inmemory_graph_algorithm_execution 2 DEFAULT TRUE IMMEDIATE TRUE TRUE FALSE FALSE Controls the fall-back action of graph algorithm execution if in-memory execution is not possible
inmemory_optimized_date 2 DISABLE TRUE IMMEDIATE TRUE TRUE FALSE FALSE Enables feature to accelerate date queries
iorm_limit_policy 2 RM_PLAN FALSE IMMEDIATE FALSE TRUE FALSE FALSE Policy used to compute Exadata IORM limit
ipddb_enable 1 FALSE FALSE IMMEDIATE FALSE TRUE FALSE FALSE Enable IPD/DB data collection
json_behavior 2 NONE TRUE FALSE FALSE FALSE FALSE FALSE control json behaviors
json_expression_check 2 off TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable/disable JSON query statement check
kafka_config_file 2 FALSE IMMEDIATE TRUE TRUE FALSE FALSE KSR pub/sub external message bus(KGMPS) CONFIGuration file
load_without_compile 2 none TRUE IMMEDIATE TRUE TRUE FALSE FALSE Load PL/SQL or Database objects without compilation
lockfree_reservation 2 on FALSE IMMEDIATE TRUE TRUE FALSE FALSE enable/disable lockfree reservation
main_workload_type 2 OLTP FALSE IMMEDIATE TRUE TRUE FALSE FALSE Main workload type
mandatory_user_profile 2 NONE FALSE IMMEDIATE TRUE TRUE FALSE FALSE Enforce Mandatory Password Profile for multitenant database
max_auth_servers 3 25 FALSE IMMEDIATE TRUE TRUE FALSE FALSE Maximum size of auth pool
max_columns 2 STANDARD FALSE FALSE TRUE FALSE FALSE FALSE maximum number of columns allowed in table or view
max_saga_duration 3 86400 FALSE IMMEDIATE FALSE TRUE FALSE FALSE default value for max saga duration
memoptimize_write_area_size 6 0 FALSE IMMEDIATE FALSE TRUE FALSE FALSE changes memoptimize write area size
memoptimize_writes 2 HINT TRUE FALSE FALSE FALSE FALSE FALSE write data to IGA without memoptimize_write hint
memory_max_size 6 0 FALSE FALSE FALSE FALSE FALSE FALSE Maximum memory size
memory_size 6 0 FALSE IMMEDIATE FALSE TRUE FALSE FALSE Target memory size
min_auth_servers 3 1 FALSE IMMEDIATE TRUE TRUE FALSE FALSE Minimum size of auth pool
mle_prog_languages 2 all TRUE IMMEDIATE TRUE TRUE FALSE FALSE Enable Multilingual Engine
native_blockchain_features 2 NONE FALSE FALSE TRUE FALSE FALSE FALSE Native block chain enable/disable
optimizer_capture_sql_quarantine 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable automatic creation/update of sql quarantine configuration
optimizer_cross_shard_resiliency 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE enables resilient execution of cross shard queries
optimizer_real_time_statistics 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE optimizer real time statistics on conventional DML
optimizer_session_type 2 NORMAL TRUE FALSE FALSE FALSE FALSE FALSE Controls Auto Index
optimizer_use_sql_quarantine 1 TRUE TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable use of sql quarantine
paranoid_concurrency_mode 1 FALSE FALSE FALSE TRUE FALSE FALSE FALSE Enable strictly durable query data gets
pdb_lockdown_error 2 RAISE TRUE IMMEDIATE TRUE TRUE FALSE FALSE Mode to ignore or raise PDB lockdown error
pdc_file_size 6 0 FALSE FALSE FALSE FALSE FALSE FALSE size (in bytes) of the pmem direct commit file
pkcs11_library_location 2 NONE FALSE IMMEDIATE TRUE TRUE FALSE FALSE PKCS#11 library location for Transparent Data Encryption
plsql_implicit_conversion_bool 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE PL/SQL: Implicit conversion for boolean
pmem_filestore 2 FALSE FALSE FALSE FALSE FALSE FALSE Persistent Memory Filestore list
priority_txns_high_wait_target 3 2147483647 FALSE IMMEDIATE TRUE TRUE FALSE FALSE Auto abort wait for high pri txns
priority_txns_medium_wait_target 3 2147483647 FALSE IMMEDIATE TRUE TRUE FALSE FALSE Auto abort wait for medium pri txns
priority_txns_mode 2 ROLLBACK FALSE IMMEDIATE TRUE TRUE FALSE FALSE Modes for Priority Transactions feature
read_only 1 FALSE TRUE FALSE FALSE FALSE FALSE FALSE Restrict WRITE operations in user session
resource_manager_cpu_scope 2 INSTANCE_ONLY FALSE FALSE FALSE FALSE FALSE FALSE scope of CPU resource management
result_cache_auto_blocklist 2 ON FALSE IMMEDIATE TRUE TRUE FALSE FALSE whether to run the auto blocklisting algorithm
result_cache_execution_threshold 3 2 FALSE IMMEDIATE TRUE TRUE FALSE FALSE minimum executions before a PL/SQL function is cached
result_cache_integrity 2 TRUSTED FALSE IMMEDIATE TRUE TRUE FALSE FALSE result cache deterministic PLSQL functions
result_cache_max_temp_result 3 5 FALSE IMMEDIATE TRUE TRUE FALSE FALSE maximum temp per result as percent of total temp for result cache
result_cache_max_temp_size 6 0 FALSE IMMEDIATE TRUE TRUE FALSE FALSE maximum amount of temp space to be used
rman_restore_file_storage_metadata 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE restore file’s storage metadata
run_addm_for_awr_report 2 NONE TRUE IMMEDIATE TRUE TRUE FALSE FALSE types of AWR snapshots for which ADDM can be run inside AWR report
saga_hist_retention 3 43200 FALSE IMMEDIATE FALSE TRUE FALSE FALSE default value for retention of completed sagas
session_exit_on_package_state_error 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE Request client to exit when PL/SQL package state is discarded
shard_apply_max_memory_size 3 0 FALSE IMMEDIATE TRUE TRUE FALSE FALSE SNR Apply max memory size in bytes
shard_enable_raft_follower_read 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable read from follower replications units in a shard
shard_queries_restricted_by_key 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE add shard key predicates to the query
shard_raft_logfile_size 6 1073741824 FALSE IMMEDIATE TRUE TRUE FALSE FALSE size of raft log file in byte
soda_behavior 2 NONE TRUE IMMEDIATE TRUE TRUE FALSE FALSE control soda behaviors
sql_error_mitigation 2 on TRUE IMMEDIATE TRUE TRUE FALSE FALSE enables automatic error mitigation
sql_history_enabled 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE SQL Query History is enabled when TRUE
sql_transpiler 2 OFF TRUE IMMEDIATE TRUE TRUE FALSE FALSE Enable SQL transpiler
statement_redirect_service 2 NONE FALSE IMMEDIATE TRUE TRUE FALSE FALSE statement redirect service
sysdate_at_dbtimezone 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE use DB timezone while computing sysdate and systimestamp value
tablespace_encryption 2 MANUAL_ENABLE FALSE FALSE FALSE FALSE FALSE FALSE Tablepsace encryption in hybrid ADG
tablespace_encryption_default_algorithm 2 AES256 FALSE IMMEDIATE TRUE TRUE FALSE FALSE default tablespace encryption block cipher mode
tablespace_encryption_default_cipher_mode 2 XTS FALSE IMMEDIATE TRUE TRUE FALSE FALSE default tablespace encryption block cipher mode
tde_key_cache 1 FALSE TRUE IMMEDIATE TRUE TRUE FALSE FALSE Enable caching of TDE intermediate key
time_at_dbtimezone 2 off FALSE FALSE TRUE FALSE FALSE FALSE use DB timezone when computing current time
timezone_version_upgrade_integrity 2 enforced FALSE IMMEDIATE TRUE TRUE FALSE FALSE perform DST upgrade leveraging constraints with desired integrity
timezone_version_upgrade_online 1 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE enable/disable time zone version upgrade online
tracefile_content_classification 2 DEFAULT FALSE FALSE FALSE FALSE FALSE FALSE enable output of trace record security label prefix
transaction_recovery 2 ENABLED FALSE IMMEDIATE TRUE TRUE FALSE FALSE Transaction recovery is enabled when set to ENABLED
true_cache 1 FALSE FALSE FALSE FALSE FALSE FALSE FALSE Enable True Cache
txn_auto_rollback_high_priority_wait_target 3 2147483647 FALSE IMMEDIATE TRUE TRUE TRUE FALSE Auto abort wait for high pri txns
txn_auto_rollback_medium_priority_wait_target 3 2147483647 FALSE IMMEDIATE TRUE TRUE TRUE FALSE Auto abort wait for medium pri txns
txn_auto_rollback_mode 2 ROLLBACK FALSE IMMEDIATE TRUE TRUE TRUE FALSE Modes for Priority Transactions feature
txn_priority 2 HIGH TRUE FALSE FALSE FALSE FALSE FALSE Priority of a transaction in a session
vector_index_neighbor_graph_reload 2 RESTART TRUE IMMEDIATE TRUE TRUE FALSE FALSE specifies whether HNSW reload is enabled
vector_memory_size 6 0 FALSE IMMEDIATE TRUE TRUE FALSE FALSE size in bytes of vector memory area
vector_query_capture 2 ON TRUE IMMEDIATE TRUE TRUE FALSE FALSE Specifies whether vector query capture is enabled
xml_client_side_decoding 2 true TRUE IMMEDIATE TRUE TRUE FALSE FALSE enable/disable xml client-side decoding
xml_handling_of_invalid_chars 2 raise_error TRUE IMMEDIATE TRUE TRUE FALSE FALSE Handle invalid chars during xmlelement

user roles 增加

ROLE

 PASSWORD_REQUIRED

 AUTHENTICATION_TYPE

 COMMON

 ORACLE_MAINTAINED

 INHERITED

 IMPLICIT

 EXTERNAL_NAME
ACCHK_READ NO NONE YES Y NO NO
AVTUNE_PKG_ROLE NO NONE YES Y NO NO
DATAPUMP_CLOUD_EXP NO NONE YES Y NO NO
DATAPUMP_CLOUD_IMP NO NONE YES Y NO NO
DB_DEVELOPER_ROLE NO NONE YES Y NO NO
DGPDB_ROLE NO NONE YES Y NO NO
GRAPH_ADMINISTRATOR NO NONE YES Y NO NO
GRAPH_DEVELOPER NO NONE YES Y NO NO
GRAPH_USER NO NONE YES Y NO NO
GSMCATUSER_ROLE NO NONE YES Y NO NO
MAINTPLAN_APP NO NONE YES Y NO NO
NOTIFICATIONS_ADMIN NO NONE YES Y NO NO
NOTIFICATIONS_USER NO NONE YES Y NO NO
OGG_APPLY NO NONE YES Y NO NO
OGG_APPLY_PROCREP NO NONE YES Y NO NO
OGG_CAPTURE NO NONE YES Y NO NO
OGG_SHARED_CAPTURE NO NONE YES Y NO NO
OSAK_ADMIN_ROLE NO NONE YES Y NO NO
PGX_SERVER_GET_INFO NO NONE YES Y NO NO
PGX_SERVER_MANAGE NO NONE YES Y NO NO
PGX_SESSION_ADD_PUBLISHED_GRAPH NO NONE YES Y NO NO
PGX_SESSION_COMPILE_ALGORITHM NO NONE YES Y NO NO
PGX_SESSION_CREATE NO NONE YES Y NO NO
PGX_SESSION_GET_PUBLISHED_GRAPH NO NONE YES Y NO NO
PGX_SESSION_MODIFY_MODEL NO NONE YES Y NO NO
PGX_SESSION_NEW_GRAPH NO NONE YES Y NO NO
PGX_SESSION_READ_MODEL NO NONE YES Y NO NO
PPLB_ROLE NO NONE YES Y NO NO
SAGA_ADM_ROLE NO NONE YES Y NO NO
SAGA_CONNECT_ROLE NO NONE YES Y NO NO
SAGA_PARTICIPANT_ROLE NO NONE YES Y NO NO
SHARDED_SCHEMA_OWNER NO NONE YES Y NO NO
SQL_FIREWALL_ADMIN NO NONE YES Y NO NO
SQL_FIREWALL_VIEWER NO NONE YES Y NO NO
XSTREAM_APPLY NO NONE YES Y NO NO
XSTREAM_CAPTURE NO NONE YES Y NO NO

user profile 增加

Profile

 Resource Name

 Resource Type

 Limit

 Common

 Inherited

 Implicit

 Oracle Maintained

 Mandatory
DEFAULT PASSWORD_ROLLOVER_TIME PASSWORD 0 NO NO NO YES NO
ORA_CIS_PROFILE SESSIONS_PER_USER KERNEL 10 NO NO NO YES NO
ORA_CIS_PROFILE PRIVATE_SGA KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE IDLE_TIME KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE CPU_PER_CALL KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 5 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_REUSE_MAX PASSWORD 20 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD ORA12C_VERIFY_FUNCTION NO NO NO YES NO
ORA_CIS_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE CPU_PER_SESSION KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE CONNECT_TIME KERNEL DEFAULT NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_LIFE_TIME PASSWORD 90 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_REUSE_TIME PASSWORD 365 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_GRACE_TIME PASSWORD 5 NO NO NO YES NO
ORA_CIS_PROFILE INACTIVE_ACCOUNT_TIME PASSWORD 120 NO NO NO YES NO
ORA_CIS_PROFILE PASSWORD_ROLLOVER_TIME PASSWORD DEFAULT NO NO NO YES NO
ORA_STIG_PROFILE PASSWORD_ROLLOVER_TIME PASSWORD DEFAULT NO NO NO YES NO

fixed view增加了475个，不再列。

oracle error 增加或变更message的3136个，这也是我之前写不建议Oceanbase和其他国产库模仿oracle error的原因，跟起来就渐行渐远了。 自行查看 ./rdbms/mesg/oraus.msg

保留字 新的 399个。

SQL HINT 44个

NAME

 SQL_FEATURE

 CLASS

 INVERSE

 TARGET_LEVEL

 PROPERTY

 VERSION

 VERSION_OUTLINE
ANALYTIC_VIEW_SQL QKSFM_COMPILATION ANALYTIC_VIEW_SQL 2 0 21.1.0
CELL_TRACE QKSFM_ALL CELL_TRACE 1 256 19.1.0
CHUNK_PRUNING QKSFM_SHARD_QUERY CHUNK_PRUNING NO_CHUNK_PRUNING 1 16 19.1.0 19.1.0
COMPRESS_IMMEDIATE QKSFM_EXECUTION COMPRESS_IMMEDIATE NO_COMPRESS_IMMEDIATE 1 0 23.1.0
CURSOR_SHARING_FORCE QKSFM_CURSOR_SHARING CURSOR_SHARING_EXACT CURSOR_SHARING_EXACT 1 0 23.1.0
DAGG_OPTIM_GSETS QKSFM_GROUPING_SET_XFORM DAGG_OPTIM_GSETS NO_DAGG_OPTIM_GSETS 2 0 21.1.0 21.1.0
DENORM_AV QKSFM_COMPILATION DENORM_AV 2 0 21.1.0
DR_IN_RECUR QKSFM_EXECUTION DR_IN_RECUR NO_DR_IN_RECUR 1 0 23.1.0
FORCE_JSON_TABLE_TRANSFORM QKSFM_JSON_REWRITE FORCE_JSON_TABLE_TRANSFORM NO_JSON_TABLE_TRANSFORM 1 0 21.1.0 21.1.0
HASHSET_BUILD QKSFM_EXECUTION HASHSET_BUILD 2 16 21.1.0 21.1.0
JOIN_SPECIFIC_MV QKSFM_MVIEWS JOIN_SPECIFIC_MV NO_JOIN_SPECIFIC_MV 2 0 23.1.0
JSON_QRYOVERGEN_REWRITE QKSFM_JSON_REWRITE JSON_QRYOVERGEN_REWRITE NO_JSON_QRYOVERGEN_REWRITE 2 0 23.1.0 23.1.0
JSON_REFERENCE_FOR_UPDATE QKSFM_JSON JSON_REFERENCE_FOR_UPDATE 1 0 23.1.0 23.1.0
LOAD_METHOD QKSFM_EXECUTION LOAD_METHOD 4 400 23.1.0 23.1.0
LOAD_TYPE QKSFM_EXECUTION LOAD_TYPE 4 400 23.1.0 23.1.0
MULTI_APPEND QKSFM_EXECUTION MULTI_APPEND NO_MULTI_APPEND 1 0 23.1.0
NO_CHUNK_PRUNING QKSFM_SHARD_QUERY CHUNK_PRUNING CHUNK_PRUNING 1 16 19.1.0 19.1.0
NO_COMPRESS_IMMEDIATE QKSFM_EXECUTION COMPRESS_IMMEDIATE COMPRESS_IMMEDIATE 1 0 23.1.0
NO_DAGG_OPTIM_GSETS QKSFM_GROUPING_SET_XFORM DAGG_OPTIM_GSETS DAGG_OPTIM_GSETS 2 0 21.1.0 21.1.0
NO_DR_IN_RECUR QKSFM_EXECUTION DR_IN_RECUR DR_IN_RECUR 1 0 23.1.0
NO_JOIN_SPECIFIC_MV QKSFM_MVIEWS JOIN_SPECIFIC_MV JOIN_SPECIFIC_MV 2 0 23.1.0
NO_JSON_QRYOVERGEN_REWRITE QKSFM_JSON_REWRITE JSON_QRYOVERGEN_REWRITE JSON_QRYOVERGEN_REWRITE 2 0 23.1.0 23.1.0
NO_JSON_TABLE_TRANSFORM QKSFM_JSON_REWRITE FORCE_JSON_TABLE_TRANSFORM FORCE_JSON_TABLE_TRANSFORM 1 0 21.1.0 21.1.0
NO_MULTI_APPEND QKSFM_EXECUTION MULTI_APPEND MULTI_APPEND 1 0 23.1.0
NO_OBY_GBYPD_SEPARATE QKSFM_PQ OBY_GBYPD_SEPARATE OBY_GBYPD_SEPARATE 2 16 21.1.0 21.1.0
NO_PQ_NONLEAF_SKEW QKSFM_PQ PQ_NONLEAF_SKEW PQ_NONLEAF_SKEW 4 272 21.1.0 21.1.0
NO_PUSH_GBY_INTO_UNION_ALL QKSFM_PUSH_GBY_INTO_UNION_ALL PUSH_GBY_INTO_UNION_ALL PUSH_GBY_INTO_UNION_ALL 2 16 23.1.0 23.1.0
NO_SET_GBY_PUSHDOWN QKSFM_ALL SET_GBY_PUSHDOWN SET_GBY_PUSHDOWN 2 16 21.1.0 21.1.0
NO_SUBGROUP QKSFM_SUBGROUP SUBGROUP SUBGROUP 2 16 23.1.0 23.1.0
NO_SUBSUME QKSFM_SUBSUME SUBSUME SUBSUME 2 16 23.1.0 23.1.0
NO_UNPIVOT_TRANS QKSFM_UNPIVOT_TRANS UNPIVOT_TRANS UNPIVOT_TRANS 4 272 23.1.0 23.1.0
NO_VECTOR_INDEX_SCAN QKSFM_VECTOR_INDEX_SCAN NO_VECTOR_INDEX_SCAN VECTOR_INDEX_SCAN 4 304 23.1.0 23.1.0
NO_VECTOR_INDEX_TRANSFORM QKSFM_VECTOR_INDEX_TRANSFORM VECTOR_INDEX_TRANSFORM VECTOR_INDEX_TRANSFORM 4 304 23.1.0 23.1.0
OBY_GBYPD_SEPARATE QKSFM_PQ OBY_GBYPD_SEPARATE NO_OBY_GBYPD_SEPARATE 2 16 21.1.0 21.1.0
ORDER_KEY_VECTOR_USE QKSFM_VECTOR_AGG ORDER_KEY_VECTOR_USE 2 272 21.1.0 21.1.0
OSON_GET_CONTENT QKSFM_JSON OSON_GET_CONTENT 1 0 21.1.0 21.1.0
PQ_NONLEAF_SKEW QKSFM_PQ PQ_NONLEAF_SKEW NO_PQ_NONLEAF_SKEW 4 272 21.1.0 21.1.0
PUSH_GBY_INTO_UNION_ALL QKSFM_PUSH_GBY_INTO_UNION_ALL PUSH_GBY_INTO_UNION_ALL NO_PUSH_GBY_INTO_UNION_ALL 2 16 23.1.0 23.1.0
SET_GBY_PUSHDOWN QKSFM_ALL SET_GBY_PUSHDOWN NO_SET_GBY_PUSHDOWN 2 16 21.1.0 21.1.0
SUBGROUP QKSFM_SUBGROUP SUBGROUP NO_SUBGROUP 2 16 23.1.0 23.1.0
SUBSUME QKSFM_SUBSUME SUBSUME NO_SUBSUME 2 16 23.1.0 23.1.0
UNPIVOT_TRANS QKSFM_UNPIVOT_TRANS UNPIVOT_TRANS NO_UNPIVOT_TRANS 4 272 23.1.0 23.1.0
VECTOR_INDEX_SCAN QKSFM_VECTOR_INDEX_SCAN ACCESS NO_VECTOR_INDEX_SCAN 4 304 23.1.0 23.1.0
VECTOR_INDEX_TRANSFORM QKSFM_VECTOR_INDEX_TRANSFORM VECTOR_INDEX_TRANSFORM NO_VECTOR_INDEX_TRANSFORM 4 304 23.1.0 23.1.0

后台JOB 也有一些增加 比如增加了为OGG 自动DICT的创建。

— over —

打赏

目前这篇文章还没有评论(Rss)

我要评论

上一篇：

下一篇：