Oracle Database 12.2.0.1 New Init Parameters

Oracle Database 12.2.0.1 is available now in the Oracle Cloud.
And this is the list of 46 new init.ora/spfile parameters compared to Oracle Database 12.1.0.2 - including the links (where possible) to the Oracle Database 12.2 Reference documentation.

Parameter Description allow_global_dblinks LDAP lookup for DBLINKS allow_group_access_to_sga Allow read access for SGA to users of Oracle owner group approx_for_aggregation Replace exact aggregation with approximate aggregation approx_for_count_distinct Replace count distinct with approx_count_distinct approx_for_percentile Replace percentile_* with approx_percentile asm_io_processes number of I/O processes per domain in the ASM IOSERVER instance autotask_max_active_pdbs Setting for Autotask Maximum Maintenance PDBs awr_pdb_autoflush_enabled Enable/Disable AWR automatic PDB flushing cdb_cluster [undocumented if TRUE startup in CDB Cluster mode cdb_cluster_name [undocumented] CDB Cluster name clonedb_dir CloneDB Directory containers_parallel_degree Parallel degree for a CONTAINERS() query cursor_invalidation default for DDL cursor invalidation semantics data_guard_sync_latency Data Guard SYNC latency data_transfer_cache_size Size of data transfer cache default_sharing Default sharing clause disable_pdb_feature [undocumented] Disable features enable_automatic_maintenance_pdb Enable/Disable Automated Maintenance for Non-Root PDB enable_dnfs_dispatcher Enable DNFS Dispatcher enabled_PDBs_on_standby List of Enabled PDB patterns encrypt_new_tablespaces whether to encrypt newly created tablespaces exafusion_enabled Enable Exafusion external_keystore_credential_location external keystore credential location inmemory_adg_enabled Enable IMC support on ADG inmemory_expressions_usage Controls which In-Memory Expressions are populated in-memory inmemory_virtual_columns Controls which user-defined virtual columns are stored in-memory instance_abort_delay_time time to delay an internal initiated abort (in seconds) instance_mode indicates whether the instance read-only or read-write or read-mostly long_module_action Use longer module and action max_datapump_jobs_per_pdb maximum number of concurrent Data Pump Jobs per PDB max_idle_time maximum session idle time in minutes max_iops MAX IO per second max_mbps MAX MB per second max_pdbs max number of pdbs allowed in CDB or Application ROOT ofs_threads Number of OFS threads one_step_plugin_for_pdb_with_tde [undocumented] Facilitate one-step plugin for PDB with TDE encrypted data optimizer_adaptive_plans controls all types of adaptive plans optimizer_adaptive_statistics controls all types of adaptive statistics outbound_dblink_protocols Outbound DBLINK Protocols allowed remote_recovery_file_dest default remote database recovery file location for refresh/relocate resource_manage_goldengate goldengate resource manager enabled sga_min_size Minimum, guaranteed size of PDB's SGA shrd_dupl_table_refresh_rate duplicated table refresh rate (in seconds) standby_db_preserve_states Preserve state cross standby role transition target_pdbs [undocumented] Parameter is a hint to adjust certain attributes of the CDB uniform_log_timestamp_format use uniform timestamp formats vs pre-12.2 formats