前回に続き、Oracle Database19cと23cの隠しパラメータを比較した結果のうち、23cで新規に登場した隠しパラメータについての纏め。
新規登場のパラメータ数が1388個と非常に多いため、4回に分けて記載することとし、今回は_a～_fで始まる隠しパラメータを記載する。
※19cとの比較による新規隠しパラメータの抽出であるため、20c,21cで新規登場したものも23cでの新規として記載する。隠しパラメータ数が多いため、PCでの閲覧推奨。
5.新規隠しパラメータ(_a* ～ _f*)
新規の隠しパラメータは1388個存在し、_a* ～ _f*な隠しパラメータは413個存在した。
| パラメータ名 | デフォルト値 | ALTER SESSION | ALTER SYSTEM | パラメータ概要 |
|---|---|---|---|---|
| _aco_disable_options | 0 | FALSE | FALSE | ACO feature disable options |
| _actgrp_spawn_offload | FALSE | FALSE | FALSE | action group spawn offload |
| _active_dgpdb | FALSE | FALSE | FALSE | active PDB dataguard |
| _active_dgpdb_qscn_count | 20 | FALSE | FALSE | active PDB dataguard query SCN service max count |
| _adaptive_scalable_log_writer_evaluation_fraction | 100 | FALSE | IMMEDIATE | Serial/parallel log writer evaluation fraction (in 10000ths) |
| _adaptive_scalable_log_writer_evaluation_interval | 15 | FALSE | IMMEDIATE | Serial/parallel log writer evaluation interval (in seconds) |
| _affected_row_threshold_for_dst_upgrade_using_dml | 100 | FALSE | IMMEDIATE | affected row threshold for DST upgrade using DML |
| _age_block_batch_timeout_ms | 1000 | FALSE | IMMEDIATE | timeout before shipping out the batched age blockmessages in milliseconds |
| _ahub_data_file_loc | FALSE | FALSE | AHub Data File Location | |
| _alert_segment_size | 50 | FALSE | IMMEDIATE | Alert-log segment size in MBs (1024*1024) |
| _alert_segment_textfile | TRUE | FALSE | IMMEDIATE | Alert-log text-file also to be segmented |
| _alert_segments_max | 20 | FALSE | IMMEDIATE | Alert-log max segments to retain, 0 for unlimited |
| _all_sync_restrict_list | FALSE | IMMEDIATE | List of applications to ignore in all sync | |
| _allow_cross_version_ddl | 0 | TRUE | IMMEDIATE | allow cross version DDL execution |
| _allow_fallback_to_dbkey | FALSE | TRUE | IMMEDIATE | if TRUE, allow fallback to dbkey |
| _allow_fga_mixed_mode | FALSE | FALSE | IMMEDIATE | write FGA records to fga_log$ |
| _allow_imc_adaptive_grow | TRUE | FALSE | IMMEDIATE | if TRUE, allow imc to grow adaptively in broker's auto tuning. |
| _allow_imc_adaptive_shrink | TRUE | FALSE | IMMEDIATE | if TRUE, allow imc to shrink adaptively in broker's auto tuning. |
| _allow_modify_lockdown | FALSE | TRUE | FALSE | Allow restricted operations like set lockdown inside the PDB |
| _allow_operator_access | FALSE | FALSE | IMMEDIATE | Allow cloud operator to access local user objects |
| _allow_privileged_session_dblink_conn | FALSE | TRUE | IMMEDIATE | Allow privileged session for dblink connection |
| _allow_same_cdb_refresh_switchover | TRUE | TRUE | IMMEDIATE | allow refresh switchover in one cdb |
| _allow_synonym_for_credential | TRUE | FALSE | IMMEDIATE | Allow public/private synonym for scheduler credential |
| _allow_sysosenv_context | FALSE | FALSE | IMMEDIATE | Allow OS Environment Variable Application Context |
| _allow_system_wallet | TRUE | FALSE | IMMEDIATE | Allow Usage of SYSTEM Wallet Path for Outbound Communication |
| _allow_traditional_audit_configuration | FALSE | TRUE | IMMEDIATE | allow traditional audit configuration |
| _allow_triggers_on_vpd_table | FALSE | FALSE | FALSE | Allow triggers on VPD protected table in DML |
| _allow_unenc_ts_without_tde_master_key | FALSE | FALSE | IMMEDIATE | if TRUE, allow unencrypted tablespace creation even when master key is not set, but encrypt_new_tablespace is set to always if FALSE, throw 28361 error during tablespace creation if master key is not set and encrypt_new_tablespace is set to always |
| _allow_user$_col_update | NONE | FALSE | IMMEDIATE | List of user$ columns which are allowed to be updated |
| _allow_xdb_anonymous_logon | FALSE | TRUE | IMMEDIATE | Allow XDB anonymous logon |
| _allowed_pvf_owners | FALSE | IMMEDIATE | List of schemas allowed to own password verification function | |
| _alter_table_modify_column_nop_flags | 1 | TRUE | IMMEDIATE | Alter table modify column NOP flags |
| _ansi_join_mv_rewrite_enabled | TRUE | TRUE | IMMEDIATE | enable/disable ansi join mv rewrite |
| _aps_flush_enabled | FALSE | FALSE | IMMEDIATE | Enable/Disable APS Flushing functionality |
| _aq_bufop_svc_create | 1 | FALSE | IMMEDIATE | create queue service for buffered operations |
| _aq_deq_flowcontrol | 0 | TRUE | IMMEDIATE | Deq flow control |
| _aq_opt_list_oper_latches | 8 | FALSE | FALSE | OPT subshard operation latches |
| _aq_queue_global_service | NONE | FALSE | IMMEDIATE | AQ queue global service |
| _aq_scramble_deq | 0 | TRUE | IMMEDIATE | Scrambled Deq |
| _aq_tm_processes_dump_interval | 12 | FALSE | IMMEDIATE | Time(minutes) between consecutive Dumps in alert log |
| _aqsharded_cache_policy_lowmem | 0 | FALSE | FALSE | AQ: caching policy in low memory |
| _aqsharded_cached_hint | 0 | FALSE | IMMEDIATE | sharded queue cached hint |
| _aqsharded_enq_fresh_ptn_reload | TRUE | FALSE | IMMEDIATE | start enqueueing to a fresh partition on reload |
| _aqsharded_lowmem_timeout | 1000 | FALSE | IMMEDIATE | sharded queue low mem timeout (in centiseconds) |
| _aqsharded_reload_tune | 2 | FALSE | IMMEDIATE | sharded queue tune reload behaviour |
| _asm_allow_appliance_offlineonline | FALSE | TRUE | IMMEDIATE | Allow OFFLINE/ONLINE DISK/FAILUREGROUP on ASM Appliances |
| _asm_asmb_exa_rcvto | 30 | TRUE | IMMEDIATE | Receive timeout for ASMB in exadata env in seconds |
| _asm_ate_conversion_batch_size | 1024 | TRUE | IMMEDIATE | ATE conversion batch size |
| _asm_bdbmr_max_ent_inprgrs | 2000 | TRUE | IMMEDIATE | Limit of BADFDA7A entries in progress of recovery |
| _asm_buffer_overlap_tracer | FALSE | FALSE | IMMEDIATE | Enables kfioBufOverlapTracer |
| _asm_checksum_migration_chunk_size | 128 | TRUE | IMMEDIATE | Number of asm metadata blocks for checksum migration in one batch |
| _asm_disable_pstcard | FALSE | FALSE | IMMEDIATE | Disable pst cardinality layout checks |
| _asm_diskgroup_renew_timeout | 20 | FALSE | IMMEDIATE | timeout FENC will give former ASMB group owner to renew |
| _asm_dump_split_pw | 10 | TRUE | IMMEDIATE | Seconds to wait before requesting dump of split pending writes |
| _asm_dynamic_timeout_interval | 20 | FALSE | IMMEDIATE | Dynamic timeout update intervals of 3 seconds |
| _asm_enable_map_share | TRUE | FALSE | IMMEDIATE | Enable ASM extent map share |
| _asm_enable_pstreloc_on_rm | FALSE | FALSE | IMMEDIATE | Enable pst layout relocation on rolling migration |
| _asm_enable_vfreloc_on_rm | FALSE | FALSE | IMMEDIATE | Enable voting file relocation on rolling migration |
| _asm_frag_threshold | 50 | FALSE | IMMEDIATE | Percentage threshold before disk/diskgroup is deemed fragmented |
| _asm_hard_check | TRUE | TRUE | IMMEDIATE | H.A.R.D. check buffer before write operation |
| _asm_identify_advisory_locks | 2 | FALSE | IMMEDIATE | enables ASM file identify advisory locks |
| _asm_iosfailover_freq | 3 | FALSE | IMMEDIATE | Frequency limit after which db gives up on failing over to IOS |
| _asm_iosfailover_timeout | 5 | FALSE | IMMEDIATE | Time window within which db tries to failover to IOS |
| _asm_max_kfsg_free_heap_perc | 10 | FALSE | IMMEDIATE | Max percentage of SGA memory reserved for kfsga free heap |
| _asm_max_kfsg_free_heap_size | 524288000 | FALSE | IMMEDIATE | Max buffer size reserved for kfsga free heap |
| _asm_max_occupied | 90 | FALSE | IMMEDIATE | Maximum percentage of disk occupied to check for fragmentation |
| _asm_min_occupied | 50 | FALSE | IMMEDIATE | Minimum percentage of disk occupied to check for fragmentation |
| _asm_node_number | FALSE | IMMEDIATE | ASM node number | |
| _asm_offline_wait_timeout | 300 | TRUE | IMMEDIATE | Timeout for offline wait |
| _asm_ownerid_trace_timeout | 600 | FALSE | IMMEDIATE | ownerid tracing threshold in seconds |
| _asm_pst_rsinfo | 0 | FALSE | IMMEDIATE | file redundancies to consider during PST liveness checks |
| _asm_quorum_hb | FALSE | TRUE | IMMEDIATE | Allow Quorum Disk Heartbeat |
| _asm_read_cancel_dynamic_delta | 20 | FALSE | IMMEDIATE | Dynamic read timeout delta to multiply with median wait time |
| _asm_read_cancel_timeout_limit | 15000 | FALSE | IMMEDIATE | Timeout limit for dynamic read timeout update |
| _asm_read_cancel_timeout_min | 5000 | FALSE | IMMEDIATE | Minimum wait time for dynamic read timeout |
| _asm_reloc_restart_timeout | 600 | FALSE | IMMEDIATE | csecs before signaling ORA-15424 when waiting for orphans |
| _asm_scrub_max_cod_wait | 5 | FALSE | IMMEDIATE | Number of minutes to delay scrub COD recovery |
| _asm_shared_pool_latch_timeout | 30 | FALSE | IMMEDIATE | seconds before terminating inst if ASMB is waiting for shared pool latch during shutdown |
| _asm_showpdb_asmtbl | FALSE | FALSE | IMMEDIATE | Allow asm table values to be shown in pdb |
| _asm_skip_cod_recovery_diskgroups | FALSE | IMMEDIATE | ASM disk groups for which COD recovery is disabled | |
| _asm_slow_client_timeout_percentage | 50 | FALSE | IMMEDIATE | Percentage of the write cancel timeout to detect slow client. |
| _asm_write_cancel_dynamic_delta | 30 | FALSE | IMMEDIATE | Dynamic write timeout delta to multiply with median wait time |
| _asm_write_cancel_timeout_limit | 90000 | FALSE | IMMEDIATE | Timeout limit for dynamic write timeout update |
| _asm_write_cancel_timeout_min | 15000 | FALSE | IMMEDIATE | Minimum wait time for dynamic write timeout |
| _asm_write_cancel_timeout_percentage | 30 | FALSE | IMMEDIATE | Percentage of the write timeout to wait before optional offline |
| _asm_xrov_cachelgio | 1 | FALSE | IMMEDIATE | ADVM cache large IO |
| _assert_invalidation | 0 | TRUE | IMMEDIATE | assert on invalidation of an object |
| _assert_single_current_buffer | FALSE | FALSE | IMMEDIATE | if TRUE, check and assert only one current buffer |
| _assm_auto_tracing_threshold | 0 | TRUE | IMMEDIATE | ASSM threshold to start space search tracing |
| _audit_operator_access | FALSE | TRUE | IMMEDIATE | enable audit of Cloud Operator access |
| _auto_clustering | FALSE | TRUE | IMMEDIATE | enable auto clustering related processing |
| _auto_clustering_sqlset | TRUE | IMMEDIATE | SQL tuning set for auto clustering processing | |
| _auto_db_lost_write_protect_fsfo_lag_limit_percent | 67 | FALSE | IMMEDIATE | FastStartFailoverLagLimit percent for auto lost write protection |
| _auto_db_lost_write_protect_max_lag_secs | 60 | FALSE | IMMEDIATE | Max apply lag in seconds for auto lost write protection |
| _auto_im_batch_size | 10 | FALSE | IMMEDIATE | Auto IM batch size |
| _auto_im_cache_join_opt | FALSE | TRUE | FALSE | Enable Autonomous Cached Join Optimization |
| _auto_im_join_group | FALSE | TRUE | FALSE | Enable Autonomous Inmemory Join group |
| _auto_im_max_perf_candidates | 3 | FALSE | IMMEDIATE | Auto IM Max Performance Candidates Per AutoIM cycle |
| _auto_im_monitor_interval | 1440 | FALSE | IMMEDIATE | Auto IM Monitor Interval |
| _auto_im_optimized_arithmetic | FALSE | TRUE | FALSE | Enable Autonomous Inmemory Optimized Arithmetic |
| _auto_im_perf_threshold | 10 | FALSE | IMMEDIATE | Auto IM performance threshold |
| _auto_im_play_area | 10 | FALSE | IMMEDIATE | Auto IM play area |
| _auto_im_rac_enabled | FALSE | FALSE | IMMEDIATE | Enable Auto IM on RAC |
| _auto_im_task_mode | 0 | TRUE | FALSE | Enables Auto IM auto task to run in various modes |
| _auto_im_vector_gby_opt | FALSE | TRUE | FALSE | Enable Autonomous Vector Group By Optimization |
| _auto_manage_max_num_cells_offline | 65535 | TRUE | IMMEDIATE | Max. number of offline cells allowed |
| _auto_manage_remount_eligible_dg | TRUE | TRUE | IMMEDIATE | Periodically check for dismounte DGs, but they have in CRSthe attributes TARGET=ONLINE ENABLED=1 |
| _auto_mv_enabled | FALSE | TRUE | IMMEDIATE | enable/disable Auto MV logic in the sql access advisor |
| _auto_temp_shrink_pdb_floor | 0 | FALSE | IMMEDIATE | auto temp tablespace shrink pdb floor |
| _autocomp_inact_pct | 98 | TRUE | IMMEDIATE | Sub-segment data inactivity percentage threshold |
| _autocomp_move_max_mb | 128 | TRUE | IMMEDIATE | KDZADO UFC batch size |
| _autoconf_mv_rewrite_metadata | TRUE | TRUE | IMMEDIATE | enable/disable mv metadata auto config logic |
| _autoptn_config | NONE | TRUE | IMMEDIATE | DBMS_AUTO_PARTITION flags |
| _autoptn_costing | FALSE | TRUE | FALSE | DBMS_AUTO_PARTITION is compiling query for cost estimates |
| _autoptn_flags | 0 | TRUE | FALSE | DBMS_AUTO_PARTITION flags |
| _autoptn_translate_table_name | TRUE | FALSE | DBMS_AUTO_PARTITION table name translation | |
| _autoptn_workload_id | 0 | TRUE | FALSE | DBMS_AUTO_PARTITION workload id |
| _autosts_capture_control | 3 | TRUE | IMMEDIATE | internal controls for auto STS capture |
| _autosts_long_interval | 0 | FALSE | IMMEDIATE | Auto STS long flush interval |
| _autosts_retention_interval | 31 | FALSE | IMMEDIATE | Auto STS retention interval |
| _autosts_short_interval | 300 | FALSE | IMMEDIATE | Auto STS short flush interval |
| _autotbs_quota_override | FALSE | TRUE | FALSE | Override Auto TableSpace During Tablespace Quota DDLs |
| _aux_storage_size | 0 | FALSE | IMMEDIATE | Auxillary storage for PDB. |
| _awr_colored_app_enabled | FALSE | FALSE | IMMEDIATE | Enable/Disable AWR Colored Application functionality |
| _awr_data_masking | FALSE | FALSE | IMMEDIATE | Enable/Disable AWR data masking functionality |
| _awr_hub_autoimp_inline | FALSE | FALSE | IMMEDIATE | Enable/Disable AutoIMP in the same session handling requests |
| _awr_hub_consumer_group | ORA$AUTOTASK | FALSE | IMMEDIATE | Setting of Hub Consumer Group |
| _awr_hub_num_conc_imp | 2 | FALSE | IMMEDIATE | Setting for the number of concurrent IMP tasks at a Hub Server |
| _awr_max_registrations | 1024 | FALSE | IMMEDIATE | maximum number of registered dbids in AWR |
| _awr_sqltext_redaction | FALSE | FALSE | IMMEDIATE | Enable/Disable AWR SQL Text Redaction |
| _awrextr_include_sqlmon | FALSE | TRUE | FALSE | Enable/disable including SQLMon data in AWR Extract |
| _backup_interrupt_wait_time | 1000 | TRUE | IMMEDIATE | specifies interrupt wait time in centi seconds |
| _backup_kgc_zstd_high_complevel | 14 | TRUE | IMMEDIATE | specifies compression (performance) level for ZSTD compression |
| _bct_auto_ctf_shrink | FALSE | TRUE | IMMEDIATE | allow change tracking file shrink on resize |
| _bct_dba_buffer_reap_threshold | 2000 | TRUE | IMMEDIATE | threshold for reaping changes per strand at a time |
| _bct_ext_alo_count | 320 | TRUE | IMMEDIATE | extent granule size to use during ctf resize |
| _bct_ext_min_count | 320 | TRUE | IMMEDIATE | min extents to allocate in change tracking file |
| _bct_imt_suppress_charset_validation | 3 | FALSE | FALSE | blockchain/immutable table character validation level |
| _bct_min_switch_freq | 43200 | TRUE | IMMEDIATE | Min time interval between bitmap switches in seconds |
| _bct_public_dba_buffer_dynresize_delay | 3600 | TRUE | IMMEDIATE | control frequency of dynamic resizing of public dba buffers |
| _bct_wait_before_trace_dump | 120 | TRUE | IMMEDIATE | seconds after which BCT would dump traces for debugging |
| _bctab_max_system_chains | 1024 | FALSE | IMMEDIATE | blockchain table's maximum number of system chains |
| _bctab_optimize_commit_performance | FALSE | TRUE | FALSE | optimize blockchain table commit performance |
| _beirut_timeout_minutes | 10 | TRUE | IMMEDIATE | beirut wait timeout in minutes |
| _bigdata_offload_flag | FALSE | FALSE | IMMEDIATE | BigDataSQL offload flag |
| _bind_undotbs | DISABLED | TRUE | IMMEDIATE | Bind to undo tbs according to size |
| _block_change_tracking_file | FALSE | IMMEDIATE | file location for broker to reenable BCT | |
| _block_corruption_track_limit | 1000 | TRUE | IMMEDIATE | block corruption track limit |
| _blockchain_forced_off | NOT_SET | TRUE | IMMEDIATE | force off blockchain |
| _blockchain_immutable_table | FALSE | IMMEDIATE | blockchain/immutable table behavior | |
| _blockchain_txn_apis_enabled | TRUE | FALSE | FALSE | If true, the txn layer blockchain API'S kick in |
| _blockchain_txn_test_lvl | 0 | FALSE | IMMEDIATE | blockchain txn test lvl |
| _blockchainHeapSize | 0 | TRUE | IMMEDIATE | Set the heap size in bytes for blockchain |
| _blockchainTracing | 0 | TRUE | IMMEDIATE | Set tracing for blockchain |
| _bloom_filter_multi_bit | FALSE | TRUE | IMMEDIATE | Multi-bit bloom filter |
| _bloom_pushing_folding_density | 4 | TRUE | IMMEDIATE | bloom filter pushing folding density lower bound pushing to sage |
| _boc_mode | AUTO | FALSE | FALSE | Broadcast-on-commit mode |
| _boc_rdma_wait_time | 0 | FALSE | FALSE | BOC RDMA busy wait time (microseconds) |
| _broker_imc_max_utilstep | 95 | FALSE | IMMEDIATE | max util percentage for imc by bg auto tuning. |
| _buffer_requests_to_drain | 5 | FALSE | IMMEDIATE | Buffer for requests to drain before planned failover |
| _bypass_sensitive_context | FALSE | FALSE | IMMEDIATE | bypass sensitive handling for specific SYS_CONTEXT() parameters |
| _cache_fusion_pipelined_updates_enable | TRUE | FALSE | IMMEDIATE | Enable smart fusion block transfer |
| _cdb_init_batch_size | 100 | TRUE | IMMEDIATE | Batch size for reading pdb info during CDB mount |
| _cdb_svlt_use_tcps | FALSE | FALSE | IMMEDIATE | Use TCPS for CDB Servlet |
| _cdb_view_serial_ok | FALSE | TRUE | IMMEDIATE | is serial OK for cross-container |
| _cell_iot_scan_enabled | TRUE | TRUE | IMMEDIATE | enable CELL processing of IOT FFS |
| _cell_metadata_compression | AUTO | TRUE | IMMEDIATE | Cell metadata compression strategy |
| _cell_offload_vector_groupby_external | TRUE | TRUE | IMMEDIATE | enable cell offload of vector group by with external tables |
| _cell_trace_size | 0 | TRUE | IMMEDIATE | max trace size in bytes shipped back to server per filtering task |
| _cgs_clscevents_dumpinterval | 600 | FALSE | IMMEDIATE | cgs clsce events statistics dump interval in seconds |
| _cgs_publish_netinfo_collect_event_chmjf | TRUE | FALSE | IMMEDIATE | enable cgs publish collect_netinfo event to event stream for CHM with CHM'S JASON format |
| _cgs_publish_netinfo_collect_event_chmjf_batchsz | 0 | FALSE | IMMEDIATE | batch size of cgs events publishing to CHM in json format via clsce event stream |
| _cgs_query_net_interface | SCLSI | FALSE | IMMEDIATE | api to query network interface |
| _cleanup_file_copy | TRUE | TRUE | IMMEDIATE | Enable file cleanup in Create PDB |
| _client_ntfn_max_cleanup_interval | 7200 | FALSE | IMMEDIATE | max limit for cleanup interval |
| _cloud_domain | TRUE | IMMEDIATE | internal domain name used for cloud deployments | |
| _cloud_mandatory_profile_setup | FALSE | FALSE | IMMEDIATE | Mandatory Profile Setup for Multitenant Cloud Environment |
| _cloud_operator_user | FALSE | IMMEDIATE | list of Cloud Operator users | |
| _cloud_trace | 0 | TRUE | IMMEDIATE | send supported trace file types to the cloud |
| _cloud_trace_bucket_fill_percent | 50 | TRUE | IMMEDIATE | cloud trace bucket fill threshold |
| _cloud_trace_bucket_size | 10485760 | TRUE | IMMEDIATE | cloud trace bucket size |
| _cloud_trace_temp_table | NONE | TRUE | IMMEDIATE | cloud tracing temp table |
| _cloudops_common_users | FALSE | IMMEDIATE | List of common users to be treated as Cloud Ops | |
| _cloudops_sensitive_masking | OFF | TRUE | IMMEDIATE | Mask sensitive information in customer PDBs from Cloud Ops |
| _cloudsql_offload_enabled | TRUE | FALSE | IMMEDIATE | enable CloudSQL cell offload support |
| _cluster_database_instances | FALSE | FALSE | number of instances to use for sizing cluster db SGA structures | |
| _con_number_reuse_threshold | 2147483647 | FALSE | IMMEDIATE | CON# begin reuse threshold |
| _connection_broker_error_new_limit | 100 | FALSE | IMMEDIATE | connection broker error limit for new connections |
| _connstr_test_param | 0 | TRUE | FALSE | connect string workload behavior spare param |
| _consensus_follower_election_timeout | 12000 | TRUE | IMMEDIATE | consensus follower's election timeout |
| _consensus_leader_heartbeat_interval | 6000 | TRUE | IMMEDIATE | consensus leader's heartbeat interval |
| _consensus_leader_maximum_heartbeats | TRUE | IMMEDIATE | consensus leader's maximum heartbeats | |
| _consensus_queue_maximum_elements | 10 | TRUE | IMMEDIATE | consensus queue maximum elements |
| _consensus_slaves_maximum_count | 5 | TRUE | IMMEDIATE | consensus slaves maximum count |
| _containers_dop_use_remote | FALSE | TRUE | IMMEDIATE | should dop take into account PDBs open on a remote instance |
| _controlfile_block_corruption_keep_records | 4294967294 | TRUE | IMMEDIATE | block corruption records to keep |
| _controlfile_cache_bpb | 4 | FALSE | FALSE | Control file cache buffers per bucket |
| _controlfile_cache_bpp | 32 | FALSE | FALSE | Control file cache buckets per pool |
| _controlfile_cache_size | 0 | FALSE | FALSE | Size of control file cache in blocks |
| _controlfile_cache_timer | 600 | FALSE | FALSE | Control file cache buffers per bucket |
| _controlfile_enable_rdma_read | TRUE | FALSE | IMMEDIATE | enable controlfile rdma read |
| _controlfile_validate_on_search | FALSE | FALSE | IMMEDIATE | Validate control file blocks on search |
| _cp_del_free_sess | TRUE | FALSE | IMMEDIATE | connection pool: delete free sessions when at PDB limit |
| _cp_del_free_sess_limit_secs | 1 | FALSE | IMMEDIATE | connection pool: delete free sessions time limit (in seconds) |
| _cputime_limit_parallel_fptr | 60 | FALSE | IMMEDIATE | CPU-time limit for for parallel first-pass recovery |
| _cr_rollbacks | 2000 | FALSE | IMMEDIATE | Maximum number of CR rollbacks per block under CR server |
| _create_pdb_disable_mirror_reads | FALSE | TRUE | IMMEDIATE | Disable mirror reads during create pdb |
| _create_pdb_flashback_barrier | FALSE | TRUE | IMMEDIATE | force flashback barrier for create pdb |
| _cross_con_remove_pushed_preds | FALSE | TRUE | IMMEDIATE | remove pushed predicates from query fetching across containers |
| _ctas_numfrags_hint | 0 | TRUE | IMMEDIATE | Hint for number of partition fragments to be loaded in a CTAS |
| _ctex_fk_copy_mode | 1 | TRUE | IMMEDIATE | Create table for exchange Copy mode for referential constraints |
| _current_session_at_dbtimezone | FALSE | TRUE | FALSE | Set default session timezone to PDB timezone |
| _current_time_at_dbtimezone | FALSE | FALSE | FALSE | use DB timezone when computing current time |
| _cursor_stats_purge_threshold | 0 | FALSE | IMMEDIATE | Cursor stats purge threshold in minutes |
| _data_access_stats | FALSE | TRUE | FALSE | Track data access queries to collect stats |
| _data_guard_redo_statistics | 31 | FALSE | IMMEDIATE | Enable/Disable redo statistics |
| _data_guard_val_redo | 65537 | FALSE | IMMEDIATE | Enable/Disable redo validation |
| _datapump_bypass_tstz_check | FALSE | FALSE | IMMEDIATE | Bypass Data Pump TSTZ version checking during import. |
| _datapump_hide_cdb_warning | FALSE | FALSE | IMMEDIATE | Hide Data Pump warning for CDB$ROOT and PDB$SEED |
| _datapump_net_transfer_size | 0 | TRUE | IMMEDIATE | data pump direct path network unload transfer size |
| _db_active_prewarm_expiration | 240 | FALSE | IMMEDIATE | active prewarming file expiration interval |
| _db_active_prewarm_interval | 60 | FALSE | IMMEDIATE | active prewarming interval |
| _db_active_prewarm_spare1 | 0 | FALSE | IMMEDIATE | active prewarming spare |
| _db_active_prewarm_spare2 | 0 | FALSE | IMMEDIATE | active prewarming spare 2 |
| _db_buffer_cache_percent | 0 | FALSE | FALSE | Buffer cache percent of sga |
| _db_cache_advice_size_submultiple | 10 | FALSE | FALSE | cache advisory size submultiple |
| _db_cache_pmem_confidence_try | 0 | FALSE | IMMEDIATE | DB Cache PMEM buffer promote attempts for greater confidence |
| _db_cache_pmem_promotion_touch_rate_reset_interval | 300 | FALSE | IMMEDIATE | DB Cache PMEM promotion touch rate reset interval in sec |
| _db_cache_pmem_promotion_touch_rate_threshold_time | 30 | FALSE | IMMEDIATE | DB Cache PMEM promotion touch rate threshold time in sec |
| _db_cache_pmem_touch_rate_compare_per | 95 | FALSE | IMMEDIATE | DB Cache PMEM buffer touch rate additive percentage when comparingagainst dram touch rate |
| _db_cache_pmemp_len | 10000 | FALSE | IMMEDIATE | DB Cache PMEM promotion list max length |
| _db_cache_xmem_promotion_algo_chosen | 38 | FALSE | IMMEDIATE | DB Cache Xmem/Pmem promotion algo |
| _db_lost_write_protect_timer_interval_secs | 60 | FALSE | IMMEDIATE | Lost write protection periodic tasks interval in seconds |
| _db_nvm_promotion_deferred_tchcnt | 195 | FALSE | FALSE | touch count threshold which allows deferred background based nvm buffer promotion |
| _db_obj_cnt_for_file_ckpt | 1000000 | FALSE | IMMEDIATE | object count after that go for file checkpoint |
| _db_obj_to_file_for_file_ckpt | 10000 | FALSE | IMMEDIATE | object to file ratio after that go for file checkpoint |
| _db_open_links | 0 | FALSE | IMMEDIATE | Max allowed open dblinks for a pdb. |
| _db_pmem_auto_resize_interval | 10 | FALSE | IMMEDIATE | PMEM auto resize interval in minutes |
| _db_pmem_direct_map_size | 0 | FALSE | IMMEDIATE | Size of direct mappable PMEM buffer cache |
| _db_replay_security_config | FALSE | IMMEDIATE | Database Replay Security Configuration | |
| _dblink_internal_gateway | FALSE | TRUE | IMMEDIATE | database link goes through Internal Gateway |
| _dblink_multiple_address_transform | FALSE | TRUE | IMMEDIATE | Enable multiple address transformation |
| _dblink_rce_dns_proxy | FALSE | TRUE | IMMEDIATE | Enable RCE DNS Proxy for database link |
| _dblink_topology | TRUE | FALSE | IMMEDIATE | Enable topology-driven database links |
| _dbms_shared_pool_allow_hot_oso | TRUE | TRUE | IMMEDIATE | restrict markhot or unmarkhot |
| _dbnest_pdb_network_ip | FALSE | IMMEDIATE | PDB network ip configuration | |
| _dbnest_resource_opts | 0 | FALSE | FALSE | dbNest - resource options |
| _dbnest_skip_fed_root | TRUE | FALSE | FALSE | Fed root is skipped so CDB nest is root of all pdbs |
| _dbopen_breakpoint | none | FALSE | IMMEDIATE | ALTER DATABASE OPEN codepath breakpoint |
| _dbreplay_mpk_key | FALSE | IMMEDIATE | Database Replay Package Key | |
| _ddlapply_enable | FALSE | FALSE | FALSE | DDL VIA APPLY Enable |
| _default_ini_trans_index | 0 | TRUE | IMMEDIATE | Default value of INI_TRANS enforced by DWCS lockdown for indexes |
| _default_ini_trans_table | 0 | TRUE | IMMEDIATE | Default value of INI_TRANS enforced by DWCS lockdown for tables |
| _default_oracle_fs_type | ofs | FALSE | IMMEDIATE | default file system type for an oracle file system |
| _default_pdb_filecopy_dop | 0 | TRUE | IMMEDIATE | default pdb file copy degree of parallelism |
| _default_service | 1 | TRUE | IMMEDIATE | Run default service in various modes |
| _defer_rcv_pdb_attach | TRUE | FALSE | IMMEDIATE | Defer PDB domain attach in instance recovery |
| _defer_rewrap_controlfile_key_history | FALSE | FALSE | IMMEDIATE | if TRUE, defer rewrap control file TS keys under next PDB open |
| _del_qsvc_last_bufsub_drop | FALSE | FALSE | IMMEDIATE | delete queue service on last buffered subscriber drop |
| _dgb_dgpdb_appst | NONE | FALSE | IMMEDIATE | DGPDBs with apply state off |
| _dgpdb_cf_retention | 10080 | FALSE | IMMEDIATE | number of minutes to keep the control file copy made during role change to primary |
| _dgpdb_file_name_convert | FALSE | IMMEDIATE | datafile name convert patterns and strings for per PDB standby | |
| _dgpdb_pcf_cf_apply_time | 600 | FALSE | IMMEDIATE | DGPDB pcf to cf mark apply time in seconds |
| _dgpdb_pcf_cf_sync_time | 43200 | FALSE | IMMEDIATE | DGPDB pcf to cf sync time in seconds |
| _dgpdb_standby_controlfile_name | dgpdb_stdby_cf_pdbid_%u_%u_%u.cf | FALSE | FALSE | a name template with three %u's for DGPDB standby controlfile |
| _diag_alert_log_enable_attention_prefix | TRUE | FALSE | FALSE | Enable/Disable attention prefix for alert log entries |
| _diag_css_lock_wait_retry_count | 100 | FALSE | IMMEDIATE | DIAG process kjzm lock wait retry count |
| _diag_css_lock_wait_timeout | 5 | FALSE | IMMEDIATE | DIAG process kjzm lock wait timeout centisecs |
| _diag_dd_global_blockers_dump | FALSE | FALSE | IMMEDIATE | if TRUE enables Global blockers dump |
| _diag_deadlock_detection_enabled | TRUE | FALSE | IMMEDIATE | Deadlock detection enabled in diag |
| _diag_hang_analyze_elapsed_time_limit | 1800 | FALSE | IMMEDIATE | Diag Hang Analyze elapsed time limit in seconds |
| _diag_kjzcmsg_limit | 8388608 | FALSE | IMMEDIATE | If non-zero value, upper limit of allocation of kjzcmsg in bytes |
| _direct_io_via_mapped_pmem | TRUE | TRUE | IMMEDIATE | if TRUE, direct path I/O will attempt to memory map files on PMEM |
| _disable_block_corruption_track | FALSE | TRUE | IMMEDIATE | disable block corruption tracking |
| _disable_cross_shard_row_movement | FALSE | TRUE | IMMEDIATE | disable cross shard row movement |
| _disable_flashback_data_archive | FALSE | FALSE | IMMEDIATE | disable pdb-level flashback archiving |
| _disable_foreign_scn_adjust | FALSE | TRUE | IMMEDIATE | Disable foreign SCN adjustment |
| _disable_hybrid_tg | FALSE | TRUE | IMMEDIATE | Disable Hybrid Transaction Guard |
| _disable_ilm_internal | FALSE | FALSE | IMMEDIATE | Force disable internal ilm stats and drop ilm segment |
| _disable_index_pk_using_nonunique | FALSE | TRUE | FALSE | disable sys tbs index primary key using non unique index |
| _disable_last_successful_login_time | FALSE | FALSE | IMMEDIATE | Disable writing Last Successful Login Time to USER$ |
| _disable_last_successful_login_time_unlimited_iat | FALSE | FALSE | IMMEDIATE | Disable writing LSLT for users with Unlimited IAT |
| _disable_mandatory_profile_for_import | FALSE | FALSE | IMMEDIATE | Disable Mandatory Profile check for IMPDP invocation inside a PDB |
| _disable_mandatory_profile_onclone | FALSE | FALSE | IMMEDIATE | Disable Mandatory Profile check on clone of a PDB |
| _disable_marking_noops | FALSE | TRUE | IMMEDIATE | Don't mark any captured statements as no-ops. |
| _disable_mt_rfs | FALSE | FALSE | IMMEDIATE | disable MT RFS server |
| _disable_mt_rfs_tracking | FALSE | FALSE | IMMEDIATE | disable MT RFS tracking |
| _disable_orphan_pdb_recovery | FALSE | FALSE | IMMEDIATE | Disable PDB PITR/FB to orphan PDB incarnation |
| _disable_pdb_space_check | FALSE | TRUE | FALSE | Disable pdb storage usage check in the session |
| _disable_privilege_cache_in_auth_table | FALSE | FALSE | FALSE | disables caching privileges used in auth table |
| _disable_restricted_rac_rolling | 0 | FALSE | IMMEDIATE | Disable 2 Phase RAC Rolling Patch feature |
| _disable_row_movement_auto_rollback | FALSE | TRUE | IMMEDIATE | disable row movement auto rollback |
| _disable_sga_filedel | FALSE | FALSE | FALSE | disable deletion of files used for SGA |
| _disable_sv_shared_mode | FALSE | TRUE | IMMEDIATE | Force exclusive instance lock acquire for ordered sequences |
| _disallow_osu_edition_obj_in_pdb | TRUE | TRUE | IMMEDIATE | disallow oracle supplied edition objects in pdb |
| _dixinv_flags | 0 | TRUE | FALSE | flags for invalidation of dependent objects during DROP INDEX |
| _dmm_ser_test | 0 | TRUE | IMMEDIATE | Stress testing for serialized models |
| _dmm_xgboost_max_memory | 1000000000 | TRUE | IMMEDIATE | xgboost maximum memory |
| _dp_force_length_semantics | NONE | FALSE | IMMEDIATE | Force nls length semantics |
| _duality_view_enable_bulk_load | FALSE | TRUE | FALSE | If true, bulk loading will be enabled for inserts |
| _duality_view_etag_required | FALSE | TRUE | IMMEDIATE | If true, etag will be required in input for updates |
| _dump_diag_audrec_fail_tab | FALSE | FALSE | IMMEDIATE | Dump diagnostics on failure of audit record write to table |
| _dump_scheduler_inmemory_trace_on_error | TRUE | TRUE | IMMEDIATE | autodump scheduler imt on error |
| _dump_scheduler_inmemory_trace_on_timeout | TRUE | TRUE | IMMEDIATE | autodump scheduler imt on timeout |
| _duplicate_database_key_to_omts | TRUE | FALSE | IMMEDIATE | if TRUE, duplicate DB key to OMTS if they do not have a key |
| _dynamic_hash_bucket_array | TRUE | FALSE | IMMEDIATE | dynamic hash bucket array |
| _dynamic_processes_force_timeout | 6 | FALSE | IMMEDIATE | dynamic process force timeout |
| _dynamic_processes_max_oom_timeout | 300 | FALSE | IMMEDIATE | dynamic process max timeout for out of memory |
| _dynamic_processes_wait_timeout | 100 | FALSE | IMMEDIATE | dynamic process wait timeout for new process |
| _eighteenth_spare_pdb_parameter | TRUE | IMMEDIATE | eighteenth spare pdb parameter - integer | |
| _eighth_spare_pdb_parameter | TRUE | IMMEDIATE | eighth spare pdb parameter - integer | |
| _eighty-second_spare_parameter | NONE | TRUE | IMMEDIATE | eighty-second spare parameter - string |
| _eleventh_spare_pdb_parameter | TRUE | IMMEDIATE | eleventh spare pdb parameter - integer | |
| _enable_asm_unified_auditing | FALSE | FALSE | FALSE | Enabling ALL auditing in ASM with Unified Auditing |
| _enable_auto_check_constraints_for_dst_upgrade | TRUE | FALSE | IMMEDIATE | enable/disable auto check constraints for DST upgrade |
| _enable_bug_29838374 | 0 | TRUE | IMMEDIATE | enable/disable bug fix 29838374 |
| _enable_capture_select | FALSE | TRUE | IMMEDIATE | Parameter to enable capture of SELECT statements |
| _enable_cdb_all_sync | FALSE | TRUE | FALSE | Is CDB-wide ALL sync enabled |
| _enable_concurrent_refresh | TRUE | TRUE | IMMEDIATE | enable/disable on-commit concurrent mv refresh |
| _enable_create_protected_profile | FALSE | TRUE | FALSE | Enable protected profile creation |
| _enable_dbwr_parallel_invalidations | TRUE | FALSE | IMMEDIATE | if TRUE, enables flush and invalidate by DBWRs |
| _enable_dynamic_processes | FALSE | FALSE | FALSE | dynamic process SOs |
| _enable_fsdirect_odmlib | TRUE | FALSE | FALSE | enable or disable FsDirect static ODM library |
| _enable_fsdirect_pin | TRUE | FALSE | IMMEDIATE | enable direct pin of FsDirect blocks |
| _enable_fsdirect_rac | FALSE | FALSE | IMMEDIATE | enable FsDirect in RAC |
| _enable_gsm_listener_networks | TRUE | FALSE | IMMEDIATE | gsm listener in listener networks |
| _enable_ignorable_error_capture | FALSE | TRUE | IMMEDIATE | Capture statement if error is ignorable |
| _enable_increase_lms_process | TRUE | FALSE | IMMEDIATE | set to true to allow _increase_lms_process changes |
| _enable_iou | NONE | FALSE | FALSE | enable io_uring for SYNC IO, ASYNC IO or both |
| _enable_json_uga_save_restore | FALSE | TRUE | IMMEDIATE | enable json uga save and restore during pdb switch |
| _enable_load_from_clone | TRUE | FALSE | IMMEDIATE | Is load from a Root Clone allowed |
| _enable_load_using_app_version | TRUE | TRUE | IMMEDIATE | Enables Oracle-supplied common object loading using app version |
| _enable_lock_down_on_mv_internal_ddls | TRUE | TRUE | IMMEDIATE | Enable Lock down on internal MV DDLs |
| _enable_log_memory_protection_key | TRUE | FALSE | FALSE | enable memory protection keys (log) |
| _enable_memory_protection_keys | FALSE | FALSE | FALSE | Enable memory protection keys usage |
| _enable_meta_snap | FALSE | TRUE | IMMEDIATE | Is metadata snapshot allowed |
| _enable_noncdb_capture | FALSE | FALSE | IMMEDIATE | Parameter to enable capture in non-CDB |
| _enable_pdb_skiplist_recovery | TRUE | TRUE | IMMEDIATE | Enable pdb skip list setup during media recovery. |
| _enable_pdb_skiplist_redogen | TRUE | FALSE | IMMEDIATE | Enable pdb skip list setup during redo generation. |
| _enable_pdc | FALSE | FALSE | FALSE | enable pmem direct commit |
| _enable_per_container_acl | FALSE | FALSE | IMMEDIATE | Enable Per Container ACL |
| _enable_perpdb_suplog | FALSE | FALSE | IMMEDIATE | per pdb supplemental logging |
| _enable_pmem_direct_cache | TRUE | FALSE | IMMEDIATE | if TRUE, enable PMEM direct mapped buffers |
| _enable_pmem_exchange | TRUE | FALSE | IMMEDIATE | if TRUE, enable PMEM exchange during promotion |
| _enable_pmem_prefetch | FALSE | FALSE | IMMEDIATE | if TRUE, enable prefecting from PMEM |
| _enable_protected_audit_policy | FALSE | TRUE | FALSE | Allow Protected Unified Audit Policy Enforcement |
| _enable_ptime_update_for_sys | FALSE | TRUE | IMMEDIATE | Enable/Disable update of user$ for sys |
| _enable_session_heaps_in_mga | TRUE | FALSE | FALSE | Enable using MGA for session heaps |
| _enable_shared_multitarget_dblink | 0 | FALSE | IMMEDIATE | enable SHARED multitarget database links to shards |
| _enable_streams_pool_subpools | FALSE | FALSE | FALSE | enable streams pool multiple subpools |
| _enable_sysaux_metadata_clone | FALSE | FALSE | IMMEDIATE | enable sysaux metadata clone |
| _enable_tenant_id_check | FALSE | FALSE | IMMEDIATE | Enable Tenant Id check for database link |
| _enable_tenant_id_transfer | FALSE | FALSE | IMMEDIATE | Enable Tenant Id transfer |
| _enable_unified_memory | FALSE | FALSE | FALSE | Enable use of unified PGA pool |
| _enable_user_pdb_close_abort | FALSE | TRUE | IMMEDIATE | Enable user-initiated PDB close abort |
| _endprot_stack_segments | FALSE | FALSE | FALSE | overrun protection for kgh stack segments |
| _enforce_lockdown_hardening | FALSE | FALSE | IMMEDIATE | Enforce hardening on lockdown related operations inside the PDB |
| _enforce_minimum_password_rollover_time | TRUE | FALSE | FALSE | Enforce minimum PASSWORD_ROLLOVER_TIME of one hour |
| _enforce_set_container_hardening | FALSE | IMMEDIATE | Enforce hardening on SET CONTAINER inside the PDB | |
| _enqueue_wall_clock_time | FALSE | FALSE | IMMEDIATE | if TRUE, use KSUFTIME timer |
| _exa_internal_parameters | TRUE | IMMEDIATE | Exascale internal parameters | |
| _exa_pmemlog_threshold_usec | 100 | FALSE | IMMEDIATE | maximum i/o time (usecs) for enabled Exadata PMEMLog |
| _export_data_parquet_temp_dir | DATA_PUMP_DIR | TRUE | IMMEDIATE | Temporary directory used for intermediate files for export data |
| _failover_svrcsum | FALSE | TRUE | IMMEDIATE | enable server checksum to optimize failover |
| _fb_log_max_rereads | 100 | FALSE | IMMEDIATE | Maximum number of rereads after reading a corrupt flashback block |
| _fb_recovery_slave_count | 0 | FALSE | IMMEDIATE | Number of recovery slaves to be used by the FLASHBACK DATABASE |
| _fbda_adv_gbl_bscn_bcast_interval | 0 | FALSE | IMMEDIATE | flashback archiver broadcast interval to advance global barrier SCN |
| _fbda_bscn_lag_warning | 600 | FALSE | IMMEDIATE | flashback archiver barrierscn lag warning threshold |
| _fbda_limit_warning_frequency | 21600 | FALSE | IMMEDIATE | flashback archiver barrier scn lag warning frequency |
| _ffs_in_range_scan_threshold | 50 | TRUE | IMMEDIATE | threshold of min percentage of block read to use ffs in rs |
| _fifteenth_spare_pdb_parameter | TRUE | IMMEDIATE | fifteenth spare pdb parameter - integer | |
| _fifth_spare_pdb_parameter | TRUE | IMMEDIATE | fifth spare pdb parameter - integer | |
| _fiftieth_spare_pdb_parameter | TRUE | IMMEDIATE | fiftieth spare pdb parameter - string list | |
| _fifty-eighth_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-eighth spare pdb parameter - boolean |
| _fifty-fifth_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-fifth spare pdb parameter - boolean |
| _fifty-first_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-first spare pdb parameter - boolean |
| _fifty-fourth_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-fourth spare pdb parameter - boolean |
| _fifty-ninth_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-ninth spare pdb parameter - boolean |
| _fifty-second_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-second spare pdb parameter - boolean |
| _fifty-seventh_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-seventh spare pdb parameter - boolean |
| _fifty-sixth_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-sixth spare pdb parameter - boolean |
| _fifty-third_spare_pdb_parameter | TRUE | TRUE | IMMEDIATE | fifty-third spare pdb parameter - boolean |
| _first_spare_pdb_parameter | TRUE | IMMEDIATE | first spare pdb parameter - integer | |
| _fix_control_1 | FALSE | IMMEDIATE | bug fix control overflow parameter-1 | |
| _fix_control_2 | FALSE | IMMEDIATE | bug fix control overflow parameter-2 | |
| _fix_control_3 | FALSE | IMMEDIATE | bug fix control overflow parameter-3 | |
| _fix_control_4 | FALSE | IMMEDIATE | bug fix control overflow parameter-4 | |
| _fix_control_5 | FALSE | IMMEDIATE | bug fix control overflow parameter-5 | |
| _fixup_all_apps | FALSE | TRUE | FALSE | Callback to fix up replay state of all applications |
| _fixup_app_pdb_status_in_root | TRUE | IMMEDIATE | application name whose PDB application status should be fixed up | |
| _fixup_cdb_apps | FALSE | TRUE | FALSE | Callback to fix up replay state of CDB-wide applications |
| _flashback_pdb_thread_filter_disable | FALSE | FALSE | FALSE | disable per PDB thread filter optimization |
| _force_backupset_zt_decryption | FALSE | TRUE | IMMEDIATE | Force ZT decryption for backupsets |
| _force_create_cloud_credential | FALSE | TRUE | IMMEDIATE | Force create a scheduler credential as DBMS_CLOUD credential |
| _force_dax_io_err | 0 | FALSE | IMMEDIATE | Force I/O error on online/standby redo log |
| _force_level0_for_local_create_df | FALSE | TRUE | IMMEDIATE | Force level 0 backup for locally created datafile |
| _force_pmem_direct_mapped_cache_scan | TRUE | TRUE | IMMEDIATE | if TRUE, force PMEM mapped direct path scan to cache path scan |
| _force_prvtreslv_hostpattern | FALSE | IMMEDIATE | Host name pattern forced to be privately resolved | |
| _forceopen_bind_undotbs | FALSE | TRUE | IMMEDIATE | Bind to any undo tbs during force open |
| _foreground_idle_check_timeout | 30 | FALSE | IMMEDIATE | idle foreground check timeout |
| _fortieth_spare_pdb_parameter | TRUE | IMMEDIATE | fortieth spare pdb parameter - string | |
| _forty-eighth_spare_pdb_parameter | TRUE | IMMEDIATE | forty-eighth spare pdb parameter - string list | |
| _forty-fifth_spare_pdb_parameter | TRUE | IMMEDIATE | forty-fifth spare pdb parameter - string list | |
| _forty-first_spare_pdb_parameter | TRUE | IMMEDIATE | forty-first spare pdb parameter - string list | |
| _forty-fourth_spare_pdb_parameter | TRUE | IMMEDIATE | forty-fourth spare pdb parameter - string list | |
| _forty-ninth_spare_pdb_parameter | TRUE | IMMEDIATE | forty-ninth spare pdb parameter - string list | |
| _forty-second_spare_pdb_parameter | TRUE | IMMEDIATE | forty-second spare pdb parameter - string list | |
| _forty-seventh_spare_pdb_parameter | TRUE | IMMEDIATE | forty-seventh spare pdb parameter - string list | |
| _forty-sixth_spare_pdb_parameter | TRUE | IMMEDIATE | forty-sixth spare pdb parameter - string list | |
| _forty-third_spare_pdb_parameter | TRUE | IMMEDIATE | forty-third spare pdb parameter - string list | |
| _fourteenth_spare_pdb_parameter | TRUE | IMMEDIATE | fourteenth spare pdb parameter - integer | |
| _fourth_spare_pdb_parameter | TRUE | IMMEDIATE | fourth spare pdb parameter - integer | |
| _fsdirect_fast_file_create | TRUE | TRUE | IMMEDIATE | Allow optimized file creation path for FsDirects |
_g以降から始まる隠しパラメータについては、次回。
前回の記事：Oracle19cと23cの隠しパラメータの差分について調べてみた ～その2～
