やったこと
Oracle Databsae 23c (FREE) と 19c の初期化パラメータを比較してみました。
注意：2023/5時点で正式な製品版ではないため、正式リリース前の事前検証用になります。
環境
・Oracle Linux 8.8
・Oracle Database 23c Free (Developer Release) ／ Database 19c Enterprise Edition
結果サマリ
・19c->23cで増えたパラメータ 84個
・19c->23cで減ったパラメータ 5個
・19c->23cでデフォルト値が変わったパラメータ 74個
結構かわってるなという印象です。
データベースパラメータシートの修正がが多そうです。
なお増えたパラメータについては現段階でマニュアル（リファレンス）にのっていないものもいくつかあります。
https://docs.oracle.com/cd/F82042_01/refrn/initialization-parameters.html#GUID-6F1C3203-0AA0-4AF1-921C-A027DD7CB6A9
次回は、減ったパラメータによる影響が気になるので確認していこうと思います
| 19c | 23c (FREE) | 比較結果 | ||||||
|---|---|---|---|---|---|---|---|---|
| NAME | VALUE | DEFAULT_VALUE | NAME | VALUE | DEFAULT_VALUE | 増加 | 減少 | デフォルト値変更 |
| DBFIPS_140 | FALSE | FALSE | DBFIPS_140 | FALSE | FALSE | |||
| active_instance_count | 0 | 0 | active_instance_count | |||||
| adg_account_info_tracking | LOCAL | LOCAL | adg_account_info_tracking | LOCAL | LOCAL | |||
| adg_redirect_dml | FALSE | FALSE | adg_redirect_dml | FALSE | FALSE | |||
| allow_global_dblinks | FALSE | FALSE | allow_global_dblinks | FALSE | FALSE | |||
| allow_group_access_to_sga | FALSE | FALSE | allow_group_access_to_sga | FALSE | FALSE | |||
| allow_legacy_reco_protocol | TRUE | TRUE | ● | ● | ||||
| allow_rowid_column_type | FALSE | FALSE | allow_rowid_column_type | FALSE | FALSE | |||
| allow_weak_crypto | TRUE | TRUE | ● | ● | ||||
| approx_for_aggregation | FALSE | FALSE | approx_for_aggregation | FALSE | FALSE | |||
| approx_for_count_distinct | FALSE | FALSE | approx_for_count_distinct | FALSE | FALSE | |||
| approx_for_percentile | none | none | approx_for_percentile | NONE | none | |||
| aq_tm_processes | 1 | 1 | aq_tm_processes | 1 | 1 | |||
| archive_lag_target | 0 | 0 | archive_lag_target | 0 | 0 | |||
| asm_diskstring | 0 | 0 | asm_diskstring | |||||
| asm_preferred_read_failure_groups | 0 | 0 | asm_preferred_read_failure_groups | |||||
| audit_file_dest | /oracle/db/admin/repdb/adump | $ORACLE_BASE/admin/@/adump | audit_file_dest | /opt/oracle/admin/FREE/adump | $ORACLE_BASE/admin/@/adump | |||
| audit_sys_operations | TRUE | TRUE | audit_sys_operations | FALSE | FALSE | ● | ||
| audit_syslog_level | 0 | 0 | audit_syslog_level | |||||
| audit_trail | DB | none | audit_trail | DB | none | |||
| auto_start_pdb_services | FALSE | FALSE | ● | |||||
| autotask_max_active_pdbs | 2 | 2 | autotask_max_active_pdbs | 2 | 2 | |||
| awr_pdb_autoflush_enabled | FALSE | FALSE | awr_pdb_autoflush_enabled | TRUE | TRUE | ● | ||
| awr_pdb_max_parallel_slaves | 10 | 10 | awr_pdb_max_parallel_slaves | 10 | 10 | |||
| awr_snapshot_time_offset | 0 | 0 | awr_snapshot_time_offset | 0 | 0 | |||
| background_core_dump | partial | partial | background_core_dump | partial | partial | |||
| background_dump_dest | /oracle/db/product/19.0.0/db1/rdbms/log | $ORACLE_BASE/admin/@/bdump | background_dump_dest | /opt/oracle/product/23c/dbhomeFree/rdbms/log | $ORACLE_BASE/admin/@/bdump | |||
| backup_tape_io_slaves | FALSE | FALSE | backup_tape_io_slaves | FALSE | FALSE | |||
| bitmap_merge_area_size | 1048576 | 1048576 | bitmap_merge_area_size | 1048576 | 1048576 | |||
| blank_trimming | FALSE | FALSE | blank_trimming | FALSE | FALSE | |||
| blockchain_table_max_no_drop | ● | |||||||
| blockchain_table_retention_threshold | 16 | 16 | ● | ● | ||||
| buffer_pool_keep | 0 | NONE | buffer_pool_keep | NONE | ||||
| buffer_pool_recycle | 0 | NONE | buffer_pool_recycle | NONE | ||||
| cdb_cluster | FALSE | FALSE | cdb_cluster | FALSE | FALSE | |||
| cdb_cluster_name | 0 | NONE | cdb_cluster_name | NONE | ||||
| cell_offload_compaction | ADAPTIVE | ADAPTIVE | cell_offload_compaction | ADAPTIVE | ADAPTIVE | |||
| cell_offload_decryption | TRUE | TRUE | cell_offload_decryption | TRUE | TRUE | |||
| cell_offload_parameters | 0 | NONE | cell_offload_parameters | NONE | ||||
| cell_offload_plan_display | AUTO | AUTO | cell_offload_plan_display | AUTO | AUTO | |||
| cell_offload_processing | TRUE | TRUE | cell_offload_processing | TRUE | TRUE | |||
| cell_offloadgroup_name | 0 | 0 | cell_offloadgroup_name | |||||
| circuits | 0 | 0 | circuits | |||||
| client_prefetch_rows | 0 | 0 | ● | |||||
| client_result_cache_lag | 3000 | 3000 | client_result_cache_lag | 3000 | 3000 | |||
| client_result_cache_size | 0 | 0 | client_result_cache_size | 0 | 0 | |||
| client_statistics_level | TYPICAL | TYPICAL | client_statistics_level | TYPICAL | TYPICAL | |||
| clonedb | FALSE | FALSE | clonedb | FALSE | FALSE | |||
| clonedb_dir | 0 | 0 | clonedb_dir | |||||
| cluster_database | FALSE | FALSE | cluster_database | FALSE | FALSE | |||
| cluster_database_instances | 1 | ● | ||||||
| cluster_interconnects | 0 | NONE | cluster_interconnects | NONE | ||||
| commit_logging | 0 | 0 | commit_logging | |||||
| commit_point_strength | 1 | 1 | commit_point_strength | 1 | 1 | |||
| commit_wait | 0 | 0 | commit_wait | |||||
| commit_write | 0 | 0 | commit_write | |||||
| common_user_prefix | 0 | NONE | common_user_prefix | NONE | ||||
| compatible | 19.0.0 | 0 | compatible | 23.0.0 | 23.0.0 | ● | ||
| connection_brokers | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) | 0 | connection_brokers | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) | ||||
| container_data | ALL | ALL | ● | ● | ||||
| containers_parallel_degree | 65535 | 65535 | containers_parallel_degree | 65535 | 65535 | |||
| control_file_record_keep_time | 7 | 7 | control_file_record_keep_time | 7 | 7 | |||
| control_files | /oracle/db/oradata/REPDB/control01.ctl, /oracle/db/oradata/REPDB/control02.ctl | ?=/dbs/cntrl@.dbf | control_files | /opt/oracle/oradata/FREE/control01.ctl, /opt/oracle/oradata/FREE/control02.ctl | ?=/dbs/cntrl@.dbf | |||
| control_management_pack_access | DIAGNOSTIC+TUNING | DIAGNOSTIC+TUNING | control_management_pack_access | NONE | DIAGNOSTIC+TUNING | |||
| core_dump_dest | /oracle/db/diag/rdbms/repdb/repdb/cdump | $ORACLE_BASE/admin/@/cdump | core_dump_dest | /opt/oracle/diag/rdbms/free/FREE/cdump | $ORACLE_BASE/admin/@/cdump | |||
| cpu_count | 4 | 0 | cpu_count | 2 | 0 | |||
| cpu_min_count | 4 | 0 | cpu_min_count | 2 | ||||
| create_bitmap_area_size | 8388608 | 8388608 | create_bitmap_area_size | 8388608 | 8388608 | |||
| create_stored_outlines | 0 | 0 | create_stored_outlines | |||||
| cursor_bind_capture_destination | memory+disk | memory+disk | cursor_bind_capture_destination | memory+disk | memory+disk | |||
| cursor_invalidation | IMMEDIATE | IMMEDIATE | cursor_invalidation | IMMEDIATE | IMMEDIATE | |||
| cursor_sharing | EXACT | EXACT | cursor_sharing | EXACT | EXACT | |||
| cursor_space_for_time | FALSE | FALSE | cursor_space_for_time | FALSE | FALSE | |||
| data_guard_max_io_time | 240 | 240 | data_guard_max_io_time | 240 | 240 | |||
| data_guard_max_longio_time | 240 | 240 | data_guard_max_longio_time | 240 | 240 | |||
| data_guard_sync_latency | 0 | 0 | data_guard_sync_latency | 0 | 0 | |||
| data_transfer_cache_size | 0 | 0 | data_transfer_cache_size | 0 | 0 | |||
| db_16k_cache_size | 0 | 0 | db_16k_cache_size | 0 | 0 | |||
| db_2k_cache_size | 0 | 0 | db_2k_cache_size | 0 | 0 | |||
| db_32k_cache_size | 0 | 0 | db_32k_cache_size | 0 | 0 | |||
| db_4k_cache_size | 0 | 0 | db_4k_cache_size | 0 | 0 | |||
| db_8k_cache_size | 0 | 0 | db_8k_cache_size | 0 | 0 | |||
| db_big_table_cache_percent_target | 0 | 0 | db_big_table_cache_percent_target | 0 | 0 | |||
| db_block_buffers | 0 | 0 | db_block_buffers | 0 | 0 | |||
| db_block_checking | FALSE | FALSE | db_block_checking | FALSE | FALSE | |||
| db_block_checksum | TYPICAL | TYPICAL | db_block_checksum | TYPICAL | TYPICAL | |||
| db_block_size | 8192 | 8192 | db_block_size | 8192 | 8192 | |||
| db_cache_advice | ON | OFF | db_cache_advice | ON | OFF | |||
| db_cache_size | 0 | 0 | db_cache_size | 0 | 0 | |||
| db_create_file_dest | 0 | NONE | db_create_file_dest | NONE | ||||
| db_create_online_log_dest_1 | 0 | NONE | db_create_online_log_dest_1 | NONE | ||||
| db_create_online_log_dest_2 | 0 | NONE | db_create_online_log_dest_2 | NONE | ||||
| db_create_online_log_dest_3 | 0 | NONE | db_create_online_log_dest_3 | NONE | ||||
| db_create_online_log_dest_4 | 0 | NONE | db_create_online_log_dest_4 | NONE | ||||
| db_create_online_log_dest_5 | 0 | NONE | db_create_online_log_dest_5 | NONE | ||||
| db_domain | 0 | 0 | db_domain | |||||
| db_file_multiblock_read_count | 128 | 0 | db_file_multiblock_read_count | 128 | 0 | |||
| db_file_name_convert | 0 | 0 | db_file_name_convert | |||||
| db_files | 200 | 200 | db_files | 200 | 200 | |||
| db_flash_cache_file | 0 | NONE | db_flash_cache_file | NONE | ||||
| db_flash_cache_size | 0 | 0 | db_flash_cache_size | 0 | 0 | |||
| db_flashback_log_dest | NONE | ● | ● | |||||
| db_flashback_log_dest_size | 0 | 0 | ● | |||||
| db_flashback_retention_target | 1440 | 1440 | db_flashback_retention_target | 1440 | 1440 | |||
| db_index_compression_inheritance | NONE | NONE | db_index_compression_inheritance | NONE | NONE | |||
| db_keep_cache_size | 0 | 0 | db_keep_cache_size | 0 | 0 | |||
| db_lost_write_protect | NONE | NONE | db_lost_write_protect | AUTO | AUTO | ● | ||
| db_name | repdb | NONE | db_name | FREE | NONE | |||
| db_performance_profile | 0 | 0 | db_performance_profile | |||||
| db_recovery_file_dest | 0 | NONE | db_recovery_file_dest | NONE | ||||
| db_recovery_file_dest_size | 0 | 0 | db_recovery_file_dest_size | 0 | 0 | |||
| db_recycle_cache_size | 0 | 0 | db_recycle_cache_size | 0 | 0 | |||
| db_securefile | PREFERRED | PERMITTED | db_securefile | PREFERRED | PREFERRED | ● | ||
| db_ultra_safe | OFF | OFF | db_ultra_safe | OFF | OFF | |||
| db_unique_name | repdb | NONE | db_unique_name | FREE | NONE | |||
| db_unrecoverable_scn_tracking | TRUE | TRUE | db_unrecoverable_scn_tracking | TRUE | TRUE | |||
| db_writer_processes | 1 | 0 | db_writer_processes | 1 | 0 | |||
| dbnest_enable | NONE | NONE | ● | ● | ||||
| dbnest_pdb_fs_conf | ● | |||||||
| dbwr_io_slaves | 0 | 0 | dbwr_io_slaves | 0 | ||||
| ddl_lock_timeout | 0 | 0 | ddl_lock_timeout | 0 | 0 | |||
| default_credential | NONE | ● | ● | |||||
| default_sharing | metadata | metadata | default_sharing | metadata | metadata | |||
| deferred_segment_creation | TRUE | TRUE | deferred_segment_creation | TRUE | TRUE | |||
| dg_broker_config_file1 | /oracle/db/product/19.0.0/db1/dbs/dr1repdb.dat | 0 | dg_broker_config_file1 | /opt/oracle/product/23c/dbhomeFree/dbs/dr1FREE.dat | ||||
| dg_broker_config_file2 | /oracle/db/product/19.0.0/db1/dbs/dr2repdb.dat | 0 | dg_broker_config_file2 | /opt/oracle/product/23c/dbhomeFree/dbs/dr2FREE.dat | ||||
| dg_broker_start | FALSE | FALSE | dg_broker_start | FALSE | FALSE | |||
| diagnostic_dest | /oracle/db | ?#/log | diagnostic_dest | /opt/oracle | ?#/log | |||
| diagnostics_control | IGNORE | IGNORE | ● | ● | ||||
| disable_pdb_feature | 0 | 0 | disable_pdb_feature | 0 | 0 | |||
| disk_asynch_io | TRUE | TRUE | disk_asynch_io | TRUE | TRUE | |||
| dispatchers | (PROT=tcp)(DISP=5), (PROT=tcps)(DISP=3) | 0 | dispatchers | (PROTOCOL=TCP) (SERVICE=FREEXDB) | ||||
| distributed_lock_timeout | 60 | 60 | distributed_lock_timeout | 60 | 60 | |||
| dml_locks | 2216 | 0 | dml_locks | 2076 | ||||
| dnfs_batch_size | 4096 | 4096 | dnfs_batch_size | 4096 | 4096 | |||
| drcp_connection_limit | 0 | ● | ||||||
| drcp_dedicated_opt | NO | NO | ● | ● | ||||
| dst_upgrade_insert_conv | TRUE | TRUE | dst_upgrade_insert_conv | TRUE | TRUE | |||
| enable_automatic_maintenance_pdb | TRUE | TRUE | enable_automatic_maintenance_pdb | TRUE | TRUE | |||
| enable_ddl_logging | FALSE | FALSE | enable_ddl_logging | FALSE | FALSE | |||
| enable_dnfs_dispatcher | FALSE | FALSE | enable_dnfs_dispatcher | FALSE | FALSE | |||
| enable_goldengate_replication | FALSE | FALSE | enable_goldengate_replication | FALSE | FALSE | |||
| enable_imc_with_mira | FALSE | FALSE | enable_imc_with_mira | FALSE | FALSE | |||
| enable_per_pdb_drcp | FALSE | FALSE | ● | |||||
| enable_pluggable_database | TRUE | FALSE | enable_pluggable_database | TRUE | TRUE | ● | ||
| enabled_PDBs_on_standby | * | * | enabled_PDBs_on_standby | * | * | |||
| encrypt_new_tablespaces | CLOUD_ONLY | CLOUD_ONLY | encrypt_new_tablespaces | CLOUD_ONLY | CLOUD_ONLY | |||
| event | 0 | NONE | event | NONE | ||||
| external_keystore_credential_location | 0 | NONE | external_keystore_credential_location | NONE | ||||
| fal_client | 0 | NONE | fal_client | NONE | ||||
| fal_server | 0 | NONE | fal_server | NONE | ||||
| fast_start_io_target | 0 | 0 | fast_start_io_target | 0 | 0 | |||
| fast_start_mttr_target | 0 | 0 | fast_start_mttr_target | 0 | 0 | |||
| fast_start_parallel_rollback | LOW | LOW | fast_start_parallel_rollback | LOW | LOW | |||
| file_mapping | FALSE | FALSE | file_mapping | FALSE | FALSE | |||
| fileio_network_adapters | 0 | 0 | fileio_network_adapters | |||||
| filesystemio_options | none | asynch | filesystemio_options | none | asynch | |||
| fixed_date | 0 | NONE | fixed_date | NONE | ||||
| forward_listener | 0 | 0 | forward_listener | |||||
| gcs_server_processes | 0 | 0 | gcs_server_processes | 0 | 0 | |||
| global_names | FALSE | FALSE | global_names | FALSE | FALSE | |||
| global_txn_processes | 1 | 1 | global_txn_processes | 1 | 1 | |||
| group_by_position_enabled | FALSE | FALSE | ● | |||||
| hash_area_size | 131072 | 0 | hash_area_size | 131072 | 0 | |||
| heartbeat_batch_size | 5 | 5 | ● | ● | ||||
| heat_map | OFF | OFF | heat_map | OFF | OFF | |||
| hi_shared_memory_address | 0 | 0 | hi_shared_memory_address | 0 | 0 | |||
| hs_autoregister | TRUE | TRUE | hs_autoregister | TRUE | TRUE | |||
| http_proxy | 0 | 0 | http_proxy | |||||
| hybrid_read_only | FALSE | FALSE | ● | |||||
| identity_provider_config | NONE | ● | ● | |||||
| identity_provider_type | NONE | NONE | ● | ● | ||||
| ifile | 0 | 0 | ifile | |||||
| ignore_session_set_param_errors | ● | |||||||
| inmemory_adg_enabled | TRUE | TRUE | inmemory_adg_enabled | TRUE | TRUE | |||
| inmemory_automatic_level | OFF | OFF | inmemory_automatic_level | OFF | OFF | |||
| inmemory_clause_default | 0 | NONE | inmemory_clause_default | NONE | ||||
| inmemory_deep_vectorization | TRUE | TRUE | ● | ● | ||||
| inmemory_expressions_usage | ENABLE | ENABLE | inmemory_expressions_usage | ENABLE | ENABLE | |||
| inmemory_force | DEFAULT | DEFAULT | inmemory_force | DEFAULT | DEFAULT | |||
| inmemory_graph_algorithm_execution | DEFAULT | DEFAULT | ● | ● | ||||
| inmemory_max_populate_servers | 0 | 65535 | inmemory_max_populate_servers | 0 | 65535 | |||
| inmemory_optimized_arithmetic | DISABLE | DISABLE | inmemory_optimized_arithmetic | DISABLE | DISABLE | |||
| inmemory_prefer_xmem_memcompress | 0 | NONE | inmemory_prefer_xmem_memcompress | NONE | ||||
| inmemory_prefer_xmem_priority | 0 | NONE | inmemory_prefer_xmem_priority | NONE | ||||
| inmemory_query | ENABLE | ENABLE | inmemory_query | ENABLE | ENABLE | |||
| inmemory_size | 0 | 0 | inmemory_size | 0 | 0 | |||
| inmemory_trickle_repopulate_servers_percent | 1 | 1 | inmemory_trickle_repopulate_servers_percent | 1 | 1 | |||
| inmemory_virtual_columns | MANUAL | MANUAL | inmemory_virtual_columns | MANUAL | MANUAL | |||
| inmemory_xmem_size | 0 | 0 | inmemory_xmem_size | 0 | 0 | |||
| instance_abort_delay_time | 0 | 0 | instance_abort_delay_time | 0 | 0 | |||
| instance_groups | 0 | 0 | instance_groups | |||||
| instance_mode | READ-WRITE | read-write | instance_mode | READ-WRITE | read-write | |||
| instance_name | repdb | 0 | instance_name | FREE | ||||
| instance_number | 0 | 0 | instance_number | 0 | 0 | |||
| instance_type | RDBMS | RDBMS | instance_type | RDBMS | RDBMS | |||
| instant_restore | FALSE | FALSE | instant_restore | FALSE | FALSE | |||
| iorm_limit_policy | RM_PLAN | RM_PLAN | ● | ● | ||||
| ipddb_enable | FALSE | FALSE | ● | |||||
| java_jit_enabled | TRUE | TRUE | java_jit_enabled | TRUE | TRUE | |||
| java_max_sessionspace_size | 0 | 0 | java_max_sessionspace_size | 0 | 0 | |||
| java_pool_size | 0 | 25165824 | java_pool_size | 0 | 25165824 | |||
| java_restrict | none | none | java_restrict | none | none | |||
| java_soft_sessionspace_limit | 0 | 0 | java_soft_sessionspace_limit | 0 | 0 | |||
| job_queue_processes | 80 | 4000 | job_queue_processes | 40 | 4000 | |||
| json_behavior_flags | NONE | ● | ● | |||||
| json_expression_check | off | off | ● | ● | ||||
| kafka_config_file | ● | |||||||
| large_pool_size | 0 | 1.34E+08 | large_pool_size | 0 | 1.51E+08 | ● | ||
| ldap_directory_access | NONE | NONE | ldap_directory_access | NONE | NONE | |||
| ldap_directory_sysauth | no | no | ldap_directory_sysauth | no | no | |||
| license_max_sessions | 0 | 0 | license_max_sessions | 0 | 0 | |||
| license_max_users | 0 | 0 | license_max_users | 0 | 0 | |||
| license_sessions_warning | 0 | 0 | license_sessions_warning | 0 | 0 | |||
| listener_networks | 0 | 0 | listener_networks | |||||
| load_without_compile | NONE | none | ● | ● | ||||
| lob_signature_enable | FALSE | FALSE | lob_signature_enable | FALSE | FALSE | |||
| local_listener | LISTENER_REPDB | 0 | local_listener | LISTENER_FREE | ||||
| lock_name_space | 0 | 0 | lock_name_space | |||||
| lock_sga | FALSE | FALSE | lock_sga | FALSE | FALSE | |||
| log_archive_config | 0 | NONE | log_archive_config | NONE | ||||
| log_archive_dest | 0 | NONE | log_archive_dest | NONE | ||||
| log_archive_dest_1 | 0 | NONE | log_archive_dest_1 | NONE | ||||
| log_archive_dest_10 | 0 | NONE | log_archive_dest_10 | NONE | ||||
| log_archive_dest_11 | 0 | NONE | log_archive_dest_11 | NONE | ||||
| log_archive_dest_12 | 0 | NONE | log_archive_dest_12 | NONE | ||||
| log_archive_dest_13 | 0 | NONE | log_archive_dest_13 | NONE | ||||
| log_archive_dest_14 | 0 | NONE | log_archive_dest_14 | NONE | ||||
| log_archive_dest_15 | 0 | NONE | log_archive_dest_15 | NONE | ||||
| log_archive_dest_16 | 0 | NONE | log_archive_dest_16 | NONE | ||||
| log_archive_dest_17 | 0 | NONE | log_archive_dest_17 | NONE | ||||
| log_archive_dest_18 | 0 | NONE | log_archive_dest_18 | NONE | ||||
| log_archive_dest_19 | 0 | NONE | log_archive_dest_19 | NONE | ||||
| log_archive_dest_2 | 0 | NONE | log_archive_dest_2 | NONE | ||||
| log_archive_dest_20 | 0 | NONE | log_archive_dest_20 | NONE | ||||
| log_archive_dest_21 | 0 | NONE | log_archive_dest_21 | NONE | ||||
| log_archive_dest_22 | 0 | NONE | log_archive_dest_22 | NONE | ||||
| log_archive_dest_23 | 0 | NONE | log_archive_dest_23 | NONE | ||||
| log_archive_dest_24 | 0 | NONE | log_archive_dest_24 | NONE | ||||
| log_archive_dest_25 | 0 | NONE | log_archive_dest_25 | NONE | ||||
| log_archive_dest_26 | 0 | NONE | log_archive_dest_26 | NONE | ||||
| log_archive_dest_27 | 0 | NONE | log_archive_dest_27 | NONE | ||||
| log_archive_dest_28 | 0 | NONE | log_archive_dest_28 | NONE | ||||
| log_archive_dest_29 | 0 | NONE | log_archive_dest_29 | NONE | ||||
| log_archive_dest_3 | 0 | NONE | log_archive_dest_3 | NONE | ||||
| log_archive_dest_30 | 0 | NONE | log_archive_dest_30 | NONE | ||||
| log_archive_dest_31 | 0 | NONE | log_archive_dest_31 | NONE | ||||
| log_archive_dest_4 | 0 | NONE | log_archive_dest_4 | NONE | ||||
| log_archive_dest_5 | 0 | NONE | log_archive_dest_5 | NONE | ||||
| log_archive_dest_6 | 0 | NONE | log_archive_dest_6 | NONE | ||||
| log_archive_dest_7 | 0 | NONE | log_archive_dest_7 | NONE | ||||
| log_archive_dest_8 | 0 | NONE | log_archive_dest_8 | NONE | ||||
| log_archive_dest_9 | 0 | NONE | log_archive_dest_9 | NONE | ||||
| log_archive_dest_state_1 | enable | enable | log_archive_dest_state_1 | enable | enable | |||
| log_archive_dest_state_10 | enable | enable | log_archive_dest_state_10 | enable | enable | |||
| log_archive_dest_state_11 | enable | enable | log_archive_dest_state_11 | enable | enable | |||
| log_archive_dest_state_12 | enable | enable | log_archive_dest_state_12 | enable | enable | |||
| log_archive_dest_state_13 | enable | enable | log_archive_dest_state_13 | enable | enable | |||
| log_archive_dest_state_14 | enable | enable | log_archive_dest_state_14 | enable | enable | |||
| log_archive_dest_state_15 | enable | enable | log_archive_dest_state_15 | enable | enable | |||
| log_archive_dest_state_16 | enable | enable | log_archive_dest_state_16 | enable | enable | |||
| log_archive_dest_state_17 | enable | enable | log_archive_dest_state_17 | enable | enable | |||
| log_archive_dest_state_18 | enable | enable | log_archive_dest_state_18 | enable | enable | |||
| log_archive_dest_state_19 | enable | enable | log_archive_dest_state_19 | enable | enable | |||
| log_archive_dest_state_2 | enable | enable | log_archive_dest_state_2 | enable | enable | |||
| log_archive_dest_state_20 | enable | enable | log_archive_dest_state_20 | enable | enable | |||
| log_archive_dest_state_21 | enable | enable | log_archive_dest_state_21 | enable | enable | |||
| log_archive_dest_state_22 | enable | enable | log_archive_dest_state_22 | enable | enable | |||
| log_archive_dest_state_23 | enable | enable | log_archive_dest_state_23 | enable | enable | |||
| log_archive_dest_state_24 | enable | enable | log_archive_dest_state_24 | enable | enable | |||
| log_archive_dest_state_25 | enable | enable | log_archive_dest_state_25 | enable | enable | |||
| log_archive_dest_state_26 | enable | enable | log_archive_dest_state_26 | enable | enable | |||
| log_archive_dest_state_27 | enable | enable | log_archive_dest_state_27 | enable | enable | |||
| log_archive_dest_state_28 | enable | enable | log_archive_dest_state_28 | enable | enable | |||
| log_archive_dest_state_29 | enable | enable | log_archive_dest_state_29 | enable | enable | |||
| log_archive_dest_state_3 | enable | enable | log_archive_dest_state_3 | enable | enable | |||
| log_archive_dest_state_30 | enable | enable | log_archive_dest_state_30 | enable | enable | |||
| log_archive_dest_state_31 | enable | enable | log_archive_dest_state_31 | enable | enable | |||
| log_archive_dest_state_4 | enable | enable | log_archive_dest_state_4 | enable | enable | |||
| log_archive_dest_state_5 | enable | enable | log_archive_dest_state_5 | enable | enable | |||
| log_archive_dest_state_6 | enable | enable | log_archive_dest_state_6 | enable | enable | |||
| log_archive_dest_state_7 | enable | enable | log_archive_dest_state_7 | enable | enable | |||
| log_archive_dest_state_8 | enable | enable | log_archive_dest_state_8 | enable | enable | |||
| log_archive_dest_state_9 | enable | enable | log_archive_dest_state_9 | enable | enable | |||
| log_archive_duplex_dest | 0 | NONE | log_archive_duplex_dest | NONE | ||||
| log_archive_format | %t_%s_%r.dbf | %t_%s_%r.dbf | log_archive_format | %t_%s_%r.dbf | %t_%s_%r.dbf | |||
| log_archive_max_processes | 4 | 4 | log_archive_max_processes | 4 | 4 | |||
| log_archive_min_succeed_dest | 1 | 1 | log_archive_min_succeed_dest | 1 | 1 | |||
| log_archive_start | FALSE | FALSE | ● | |||||
| log_archive_trace | 0 | 0 | log_archive_trace | 0 | 0 | |||
| log_buffer | 7307264 | 0 | log_buffer | 4292608 | 0 | |||
| log_checkpoint_interval | 0 | 0 | log_checkpoint_interval | 0 | 0 | |||
| log_checkpoint_timeout | 1800 | 1800 | log_checkpoint_timeout | 1800 | 1800 | |||
| log_checkpoints_to_alert | FALSE | FALSE | log_checkpoints_to_alert | FALSE | FALSE | |||
| log_file_name_convert | 0 | 0 | log_file_name_convert | |||||
| long_module_action | TRUE | TRUE | long_module_action | TRUE | TRUE | |||
| main_workload_type | OLTP | OLTP | ● | ● | ||||
| mandatory_user_profile | NONE | ● | ● | |||||
| max_auth_servers | 25 | 25 | ● | ● | ||||
| max_columns | STANDARD | STANDARD | ● | ● | ||||
| max_datapump_jobs_per_pdb | 100 | 100 | max_datapump_jobs_per_pdb | AUTO | AUTO | ● | ||
| max_datapump_parallel_per_job | 50 | 50 | max_datapump_parallel_per_job | AUTO | AUTO | ● | ||
| max_dispatchers | 10 | 0 | max_dispatchers | |||||
| max_dump_file_size | unlimited | unlimited | max_dump_file_size | 32M | 32M | ● | ||
| max_idle_blocker_time | 0 | 0 | max_idle_blocker_time | 0 | 0 | |||
| max_idle_time | 0 | 0 | max_idle_time | 0 | 0 | |||
| max_iops | 0 | 0 | max_iops | 0 | 0 | |||
| max_mbps | 0 | 0 | max_mbps | 0 | 0 | |||
| max_pdbs | 254 | 4098 | max_pdbs | 254 | 4098 | |||
| max_saga_duration | 86400 | 86400 | ● | ● | ||||
| max_shared_servers | 30 | 0 | max_shared_servers | |||||
| max_string_size | STANDARD | STANDARD | max_string_size | STANDARD | STANDARD | |||
| memoptimize_pool_size | 0 | 0 | memoptimize_pool_size | 0 | 0 | |||
| memoptimize_write_area_size | 0 | 0 | ● | |||||
| memoptimize_writes | HINT | HINT | ● | ● | ||||
| memory_max_size | 0 | 0 | ● | |||||
| memory_max_target | 0 | 0 | memory_max_target | 0 | 0 | |||
| memory_size | 0 | 0 | ● | |||||
| memory_target | 0 | 0 | memory_target | 0 | 0 | |||
| min_auth_servers | 1 | 1 | ● | ● | ||||
| multilingual_engine | enable | enable | ● | ● | ||||
| multishard_query_data_consistency | strong | strong | multishard_query_data_consistency | strong | strong | |||
| multishard_query_partial_results | not allowed | not allowed | multishard_query_partial_results | not allowed | not allowed | |||
| native_blockchain_features | NONE | ● | ● | |||||
| nls_calendar | GREGORIAN | NONE | nls_calendar | GREGORIAN | NONE | |||
| nls_comp | BINARY | BINARY | nls_comp | BINARY | BINARY | |||
| nls_currency | \ | NONE | nls_currency | \ | NONE | |||
| nls_date_format | RR-MM-DD | NONE | nls_date_format | RR-MM-DD | NONE | |||
| nls_date_language | JAPANESE | NONE | nls_date_language | JAPANESE | NONE | |||
| nls_dual_currency | \ | NONE | nls_dual_currency | \ | NONE | |||
| nls_iso_currency | JAPAN | NONE | nls_iso_currency | JAPAN | NONE | |||
| nls_language | JAPANESE | AMERICAN | nls_language | JAPANESE | AMERICAN | |||
| nls_length_semantics | BYTE | BYTE | nls_length_semantics | BYTE | BYTE | |||
| nls_nchar_conv_excp | FALSE | FALSE | nls_nchar_conv_excp | FALSE | FALSE | |||
| nls_numeric_characters | ., | NONE | nls_numeric_characters | ., | NONE | |||
| nls_sort | BINARY | NONE | nls_sort | BINARY | NONE | |||
| nls_territory | JAPAN | AMERICA | nls_territory | JAPAN | AMERICA | |||
| nls_time_format | HH24:MI:SSXFF | NONE | nls_time_format | HH24:MI:SSXFF | NONE | |||
| nls_time_tz_format | HH24:MI:SSXFF TZR | NONE | nls_time_tz_format | HH24:MI:SSXFF TZR | NONE | |||
| nls_timestamp_format | RR-MM-DD HH24:MI:SSXFF | NONE | nls_timestamp_format | RR-MM-DD HH24:MI:SSXFF | NONE | |||
| nls_timestamp_tz_format | RR-MM-DD HH24:MI:SSXFF TZR | NONE | nls_timestamp_tz_format | RR-MM-DD HH24:MI:SSXFF TZR | NONE | |||
| noncdb_compatible | FALSE | FALSE | noncdb_compatible | FALSE | FALSE | |||
| object_cache_max_size_percent | 10 | 10 | object_cache_max_size_percent | 10 | 10 | |||
| object_cache_optimal_size | 10240000 | 10240000 | object_cache_optimal_size | 51200000 | 51200000 | ● | ||
| ofs_threads | 4 | 4 | ofs_threads | 4 | 4 | |||
| olap_page_pool_size | 0 | 0 | olap_page_pool_size | 0 | 0 | |||
| one_step_plugin_for_pdb_with_tde | FALSE | FALSE | one_step_plugin_for_pdb_with_tde | FALSE | FALSE | |||
| open_cursors | 300 | 50 | open_cursors | 300 | 50 | |||
| open_links | 4 | 4 | open_links | 4 | 4 | |||
| open_links_per_instance | 4 | 4 | open_links_per_instance | 4 | 4 | |||
| optimizer_adaptive_plans | TRUE | TRUE | optimizer_adaptive_plans | TRUE | TRUE | |||
| optimizer_adaptive_reporting_only | FALSE | FALSE | optimizer_adaptive_reporting_only | FALSE | FALSE | |||
| optimizer_adaptive_statistics | FALSE | FALSE | optimizer_adaptive_statistics | FALSE | FALSE | |||
| optimizer_capture_sql_plan_baselines | FALSE | FALSE | optimizer_capture_sql_plan_baselines | FALSE | FALSE | |||
| optimizer_capture_sql_quarantine | FALSE | FALSE | ● | |||||
| optimizer_cross_shard_resiliency | FALSE | FALSE | ● | |||||
| optimizer_dynamic_sampling | 2 | 2 | optimizer_dynamic_sampling | 2 | 2 | |||
| optimizer_features_enable | 19.1.0 | 19.1.0 | optimizer_features_enable | 23.1.0 | 23.1.0 | ● | ||
| optimizer_ignore_hints | FALSE | FALSE | optimizer_ignore_hints | FALSE | FALSE | |||
| optimizer_ignore_parallel_hints | FALSE | FALSE | optimizer_ignore_parallel_hints | FALSE | FALSE | |||
| optimizer_index_caching | 0 | 0 | optimizer_index_caching | 0 | 0 | |||
| optimizer_index_cost_adj | 100 | 100 | optimizer_index_cost_adj | 100 | 100 | |||
| optimizer_inmemory_aware | TRUE | TRUE | optimizer_inmemory_aware | TRUE | TRUE | |||
| optimizer_mode | ALL_ROWS | all_rows | optimizer_mode | ALL_ROWS | all_rows | |||
| optimizer_real_time_statistics | FALSE | FALSE | ● | |||||
| optimizer_secure_view_merging | TRUE | TRUE | optimizer_secure_view_merging | TRUE | TRUE | |||
| optimizer_session_type | NORMAL | NORMAL | ● | ● | ||||
| optimizer_use_invisible_indexes | FALSE | FALSE | optimizer_use_invisible_indexes | FALSE | FALSE | |||
| optimizer_use_pending_statistics | FALSE | FALSE | optimizer_use_pending_statistics | FALSE | FALSE | |||
| optimizer_use_sql_plan_baselines | TRUE | TRUE | optimizer_use_sql_plan_baselines | TRUE | TRUE | |||
| optimizer_use_sql_quarantine | TRUE | TRUE | ● | ● | ||||
| os_authent_prefix | ops$ | ops$ | os_authent_prefix | ops$ | ops$ | |||
| os_roles | FALSE | FALSE | os_roles | FALSE | FALSE | |||
| outbound_dblink_protocols | ALL | ALL | outbound_dblink_protocols | ALL | ALL | |||
| parallel_adaptive_multi_user | FALSE | FALSE | parallel_adaptive_multi_user | FALSE | FALSE | |||
| parallel_degree_limit | CPU | CPU | parallel_degree_limit | CPU | CPU | |||
| parallel_degree_policy | MANUAL | MANUAL | parallel_degree_policy | MANUAL | MANUAL | |||
| parallel_execution_message_size | 16384 | 0 | parallel_execution_message_size | 16384 | ||||
| parallel_force_local | FALSE | FALSE | parallel_force_local | FALSE | FALSE | |||
| parallel_instance_group | 0 | NONE | parallel_instance_group | NONE | ||||
| parallel_max_servers | 80 | 0 | parallel_max_servers | 1 | ||||
| parallel_min_degree | 1 | 1 | parallel_min_degree | 1 | 1 | |||
| parallel_min_percent | 0 | 0 | parallel_min_percent | 0 | 0 | |||
| parallel_min_servers | 8 | 0 | parallel_min_servers | 1 | 0 | |||
| parallel_min_time_threshold | AUTO | AUTO | parallel_min_time_threshold | AUTO | AUTO | |||
| parallel_servers_target | 32 | 0 | parallel_servers_target | 1 | 0 | |||
| parallel_threads_per_cpu | 1 | 1 | parallel_threads_per_cpu | 1 | 1 | |||
| pdb_file_name_convert | 0 | 0 | pdb_file_name_convert | |||||
| pdb_lockdown | 0 | 0 | pdb_lockdown | |||||
| pdb_os_credential | 0 | 0 | pdb_os_credential | |||||
| pdb_template | 0 | 0 | pdb_template | |||||
| pdc_file_size | 2101248 | 0 | ● | |||||
| permit_92_wrap_format | TRUE | TRUE | permit_92_wrap_format | FALSE | FALSE | ● | ||
| pga_aggregate_limit | 2.15E+09 | 0 | pga_aggregate_limit | 2.15E+09 | 0 | |||
| pga_aggregate_target | 1.07E+09 | 0 | pga_aggregate_target | 5.37E+08 | 0 | |||
| pkcs11_library_location | NONE | ● | ● | |||||
| plscope_settings | IDENTIFIERS:NONE | IDENTIFIERS:NONE | plscope_settings | IDENTIFIERS:NONE | IDENTIFIERS:NONE | |||
| plsql_ccflags | 0 | NONE | plsql_ccflags | NONE | ||||
| plsql_code_type | INTERPRETED | INTERPRETED | plsql_code_type | INTERPRETED | INTERPRETED | |||
| plsql_debug | FALSE | FALSE | plsql_debug | FALSE | FALSE | |||
| plsql_implicit_conversion_bool | FALSE | FALSE | ● | |||||
| plsql_optimize_level | 2 | 2 | plsql_optimize_level | 2 | 2 | |||
| plsql_v2_compatibility | FALSE | FALSE | plsql_v2_compatibility | FALSE | FALSE | |||
| plsql_warnings | DISABLE:ALL | NONE | plsql_warnings | DISABLE:ALL | NONE | |||
| pmem_filestore | ● | |||||||
| pre_page_sga | TRUE | TRUE | pre_page_sga | TRUE | TRUE | |||
| private_temp_table_prefix | ORA$PTT_ | ORA$PTT_ | private_temp_table_prefix | ORA$PTT_ | ORA$PTT_ | |||
| processes | 320 | 0 | processes | 300 | 0 | |||
| processor_group_name | 0 | 0 | processor_group_name | |||||
| query_rewrite_enabled | TRUE | TRUE | query_rewrite_enabled | TRUE | TRUE | |||
| query_rewrite_integrity | enforced | enforced | query_rewrite_integrity | enforced | enforced | |||
| rdbms_server_dn | 0 | NONE | rdbms_server_dn | NONE | ||||
| read_only | FALSE | FALSE | ● | |||||
| read_only_open_delayed | FALSE | FALSE | read_only_open_delayed | FALSE | FALSE | |||
| recovery_parallelism | 0 | 0 | recovery_parallelism | 0 | 0 | |||
| recyclebin | on | on | recyclebin | on | on | |||
| redo_transport_user | 0 | NONE | redo_transport_user | NONE | ||||
| remote_dependencies_mode | TIMESTAMP | timestamp | remote_dependencies_mode | TIMESTAMP | timestamp | |||
| remote_listener | 0 | 0 | remote_listener | |||||
| remote_login_passwordfile | EXCLUSIVE | exclusive | remote_login_passwordfile | EXCLUSIVE | exclusive | |||
| remote_os_authent | FALSE | FALSE | ● | |||||
| remote_os_roles | FALSE | FALSE | remote_os_roles | FALSE | FALSE | |||
| remote_recovery_file_dest | 0 | NONE | remote_recovery_file_dest | NONE | ||||
| replication_dependency_tracking | TRUE | TRUE | replication_dependency_tracking | TRUE | TRUE | |||
| resource_limit | TRUE | TRUE | resource_limit | TRUE | TRUE | |||
| resource_manage_goldengate | FALSE | FALSE | resource_manage_goldengate | FALSE | FALSE | |||
| resource_manager_cpu_allocation | 4 | 0 | resource_manager_cpu_allocation | 0 | 0 | |||
| resource_manager_cpu_scope | INSTANCE_ONLY | INSTANCE_ONLY | ● | ● | ||||
| resource_manager_plan | 0 | 0 | resource_manager_plan | |||||
| result_cache_auto_blocklist | ON | ON | ● | ● | ||||
| result_cache_execution_threshold | 2 | 2 | ● | ● | ||||
| result_cache_integrity | TRUSTED | TRUSTED | ● | ● | ||||
| result_cache_max_result | 5 | 5 | result_cache_max_result | 5 | 5 | |||
| result_cache_max_size | 10747904 | 1 | result_cache_max_size | 8126464 | 1 | |||
| result_cache_max_temp_result | 5 | 5 | ● | ● | ||||
| result_cache_max_temp_size | 81264640 | 0 | ● | |||||
| result_cache_mode | MANUAL | MANUAL | result_cache_mode | MANUAL | MANUAL | |||
| result_cache_remote_expiration | 0 | 0 | result_cache_remote_expiration | 0 | 0 | |||
| resumable_timeout | 0 | 0 | resumable_timeout | 0 | 0 | |||
| rollback_segments | 0 | 0 | rollback_segments | |||||
| saga_hist_retention | 43200 | 43200 | ● | ● | ||||
| scheduler_follow_pdbtz | FALSE | FALSE | scheduler_follow_pdbtz | FALSE | FALSE | |||
| sec_case_sensitive_logon | TRUE | TRUE | ● | ● | ||||
| sec_max_failed_login_attempts | 3 | 3 | sec_max_failed_login_attempts | 3 | 3 | |||
| sec_protocol_error_further_action | (DROP,3) | (DROP,3) | sec_protocol_error_further_action | (DROP,3) | (DROP,3) | |||
| sec_protocol_error_trace_action | TRACE | TRACE | sec_protocol_error_trace_action | TRACE | TRACE | |||
| sec_return_server_release_banner | FALSE | FALSE | sec_return_server_release_banner | FALSE | FALSE | |||
| serial_reuse | disable | disable | serial_reuse | disable | disable | |||
| service_names | repdb | 0 | service_names | FREE | ||||
| session_cached_cursors | 50 | 50 | session_cached_cursors | 50 | 50 | |||
| session_exit_on_package_state_error | FALSE | FALSE | ● | |||||
| session_max_open_files | 10 | 10 | session_max_open_files | 10 | 10 | |||
| sessions | 504 | 0 | sessions | 472 | ||||
| sga_max_size | 2.15E+09 | 0 | sga_max_size | 1.61E+09 | 0 | |||
| sga_min_size | 0 | 0 | sga_min_size | 0 | 0 | |||
| sga_target | 0 | 0 | sga_target | 0 | 0 | |||
| shadow_core_dump | partial | partial | shadow_core_dump | partial | partial | |||
| shard_enable_raft_follower_read | TRUE | TRUE | ● | ● | ||||
| shard_queries_restricted_by_key | FALSE | FALSE | ● | |||||
| shared_memory_address | 0 | 0 | shared_memory_address | 0 | 0 | |||
| shared_pool_reserved_size | 23488102 | 0 | shared_pool_reserved_size | 25836912 | 0 | |||
| shared_pool_size | 0 | 1.34E+08 | shared_pool_size | 0 | 1.51E+08 | ● | ||
| shared_server_sessions | 0 | 0 | shared_server_sessions | |||||
| shared_servers | 10 | 4.29E+09 | shared_servers | 1 | 0 | ● | ||
| shrd_dupl_table_refresh_rate | 60 | 60 | shrd_dupl_table_refresh_rate | 60 | 60 | |||
| skip_unusable_indexes | TRUE | TRUE | skip_unusable_indexes | TRUE | TRUE | |||
| smtp_out_server | 0 | 0 | smtp_out_server | |||||
| soda_behavior_flags | NONE | ● | ● | |||||
| sort_area_retained_size | 0 | 0 | sort_area_retained_size | 0 | 0 | |||
| sort_area_size | 65536 | 65536 | sort_area_size | 65536 | 65536 | |||
| spatial_vector_acceleration | FALSE | FALSE | spatial_vector_acceleration | TRUE | TRUE | ● | ||
| spfile | /oracle/db/product/19.0.0/db1/dbs/spfilerepdb.ora | NONE | spfile | /opt/oracle/product/23c/dbhomeFree/dbs/spfileFREE.ora | NONE | |||
| sql92_security | TRUE | TRUE | sql92_security | TRUE | TRUE | |||
| sql_error_mitigation | off | off | ● | ● | ||||
| sql_history_enabled | FALSE | FALSE | ● | |||||
| sql_trace | FALSE | FALSE | sql_trace | FALSE | FALSE | |||
| sql_transpiler | OFF | OFF | ● | ● | ||||
| sqltune_category | DEFAULT | DEFAULT | sqltune_category | DEFAULT | DEFAULT | |||
| ssl_wallet | 0 | 0 | ssl_wallet | |||||
| standby_db_preserve_states | NONE | NONE | standby_db_preserve_states | NONE | NONE | |||
| standby_file_management | AUTO | MANUAL | standby_file_management | MANUAL | MANUAL | |||
| standby_pdb_source_file_dblink | 0 | 0 | standby_pdb_source_file_dblink | |||||
| standby_pdb_source_file_directory | 0 | 0 | standby_pdb_source_file_directory | |||||
| star_transformation_enabled | FALSE | FALSE | star_transformation_enabled | FALSE | FALSE | |||
| statement_redirect_service | NONE | ● | ● | |||||
| statistics_level | TYPICAL | TYPICAL | statistics_level | TYPICAL | TYPICAL | |||
| streams_pool_size | 0 | 0 | streams_pool_size | 0 | 0 | |||
| sysdate_at_dbtimezone | FALSE | FALSE | ● | |||||
| tablespace_encryption | MANUAL_ENABLE | MANUAL_ENABLE | ● | ● | ||||
| tablespace_encryption_default_algorithm | AES256 | AES256 | ● | ● | ||||
| tape_asynch_io | TRUE | TRUE | tape_asynch_io | TRUE | TRUE | |||
| target_pdbs | 4 | 1 | target_pdbs | 3 | 1 | |||
| tde_configuration | 0 | NONE | tde_configuration | NONE | ||||
| tde_key_cache | FALSE | FALSE | ● | |||||
| temp_undo_enabled | FALSE | FALSE | temp_undo_enabled | FALSE | FALSE | |||
| thread | 0 | 0 | thread | 0 | 0 | |||
| threaded_execution | FALSE | FALSE | threaded_execution | FALSE | FALSE | |||
| time_at_dbtimezone | off | off | ● | ● | ||||
| timed_os_statistics | 0 | 0 | timed_os_statistics | 0 | 0 | |||
| timed_statistics | TRUE | FALSE | timed_statistics | TRUE | FALSE | |||
| timezone_version_upgrade_integrity | enforced | enforced | ● | ● | ||||
| timezone_version_upgrade_online | FALSE | FALSE | ● | |||||
| trace_enabled | TRUE | TRUE | trace_enabled | TRUE | TRUE | |||
| tracefile_content_classification | DISABLE | DISABLE | ● | ● | ||||
| tracefile_identifier | 0 | 0 | tracefile_identifier | |||||
| transactions | 554 | 0 | transactions | 519 | ||||
| transactions_per_rollback_segment | 5 | 5 | transactions_per_rollback_segment | 5 | 5 | |||
| true_cache | FALSE | FALSE | ● | |||||
| txn_auto_rollback_high_priority_wait_target | 2.15E+09 | 2.15E+09 | ● | ● | ||||
| txn_auto_rollback_medium_priority_wait_target | 2.15E+09 | 2.15E+09 | ● | ● | ||||
| txn_auto_rollback_mode | ROLLBACK | ROLLBACK | ● | ● | ||||
| txn_priority | HIGH | HIGH | ● | ● | ||||
| undo_management | AUTO | AUTO | undo_management | AUTO | AUTO | |||
| undo_retention | 5400 | 900 | undo_retention | 900 | 900 | |||
| undo_tablespace | UNDOTBS1 | NONE | undo_tablespace | UNDOTBS1 | NONE | |||
| unified_audit_common_systemlog | 0 | 0 | unified_audit_common_systemlog | |||||
| unified_audit_sga_queue_size | 1048576 | 1048576 | ● | ● | ||||
| unified_audit_systemlog | 0 | 0 | unified_audit_systemlog | |||||
| uniform_log_timestamp_format | TRUE | TRUE | uniform_log_timestamp_format | TRUE | TRUE | |||
| use_dedicated_broker | FALSE | TRUE | use_dedicated_broker | NONE | NONE | ● | ||
| use_large_pages | TRUE | TRUE | use_large_pages | TRUE | TRUE | |||
| user_dump_dest | /oracle/db/product/19.0.0/db1/rdbms/log | $ORACLE_BASE/admin/@/udump | user_dump_dest | /opt/oracle/product/23c/dbhomeFree/rdbms/log | $ORACLE_BASE/admin/@/udump | |||
| wallet_root | 0 | NONE | wallet_root | NONE | ||||
| workarea_size_policy | AUTO | AUTO | workarea_size_policy | AUTO | AUTO | |||
| xml_client_side_decoding | TRUE | TRUE | ● | ● | ||||
| xml_db_events | enable | enable | xml_db_events | enable | enable | |||
| xml_handling_of_invalid_chars | raise_error | raise_error | ● | ● |