New SPFILE parameters in Oracle Database 12.2.0.1

Adinath Kamode says:

On premise 12.2 installation
NAME VALUE DESCRIPTION
DBFIPS_140 FALSE Enable use of crypographic libraries in FIPS mode, public
_upgrade_capture_noops FALSE do not skip capturing noops during upgrade
_upgrade_optim FALSE Upgrade optimization enabled
allow_global_dblinks FALSE LDAP lookup for DBLINKS
allow_group_access_to_sga FALSE Allow read access for SGA to users of Oracle owner group
approx_for_aggregation FALSE Replace exact aggregation with approximate aggregation
approx_for_count_distinct FALSE Replace count distinct with approx_count_distinct
approx_for_percentile none Replace percentile_* with approx_percentile
asm_io_processes 20 number of I/O processes per domain in the ASM IOSERVER instance
autotask_max_active_pdbs 2 Setting for Autotask Maximum Maintenance PDBs
awr_pdb_autoflush_enabled FALSE Enable/Disable AWR automatic PDB flushing
awr_snapshot_time_offset 0 Setting for AWR Snapshot Time Offset
cdb_cluster FALSE if TRUE startup in CDB Cluster mode
cdb_cluster_name DOPS10 CDB Cluster name
cell_offloadgroup_name Set the offload group name
clonedb FALSE clone database
clonedb_dir CloneDB Directory
common_user_prefix C## Enforce restriction on a prefix of a Common User/Role/Profile name
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) connection brokers specification
containers_parallel_degree 65535 Parallel degree for a CONTAINERS() query
cursor_invalidation IMMEDIATE default for DDL cursor invalidation semantics
data_guard_sync_latency 0 Data Guard SYNC latency
data_transfer_cache_size 0 Size of data transfer cache
db_big_table_cache_percent_target 0 Big table cache target size in percentage
db_index_compression_inheritance NONE options for table or tablespace level compression inheritance
db_performance_profile Database performance category
default_sharing metadata Default sharing clause
disable_pdb_feature 0 Disable features
dnfs_batch_size 4096 Max number of dNFS asynch I/O requests queued per session
enable_automatic_maintenance_pdb TRUE Enable/Disable Automated Maintenance for Non-Root PDB
enable_dnfs_dispatcher FALSE Enable DNFS Dispatcher
enable_goldengate_replication FALSE goldengate replication enabled
enable_pluggable_database FALSE Enable Pluggable Database
enabled_PDBs_on_standby * List of Enabled PDB patterns
encrypt_new_tablespaces CLOUD_ONLY whether to encrypt newly created tablespaces
exafusion_enabled 1 Enable Exafusion
external_keystore_credential_location external keystore credential location
heat_map OFF ILM Heatmap Tracking
inmemory_adg_enabled TRUE Enable IMC support on ADG
inmemory_clause_default Default in-memory clause for new tables
inmemory_expressions_usage ENABLE Controls which In-Memory Expressions are populated in-memory
inmemory_force DEFAULT Force tables to be in-memory or not
inmemory_max_populate_servers 0 maximum inmemory populate servers
inmemory_query ENABLE Specifies whether in-memory queries are allowed
inmemory_size 0 size in bytes of in-memory area
inmemory_trickle_repopulate_servers_percent 1 inmemory trickle repopulate servers percent
inmemory_virtual_columns MANUAL Controls which user-defined virtual columns are stored in-memory
instance_abort_delay_time 0 time to delay an internal initiated abort (in seconds)
instance_mode READ-WRITE indicates whether the instance read-only or read-write or read-mostly
instant_restore FALSE instant repopulation of datafiles
java_restrict none Restrict Java VM Access
long_module_action TRUE Use longer module and action
max_datapump_jobs_per_pdb 100 maximum number of concurrent Data Pump Jobs per PDB
max_idle_time 0 maximum session idle time in minutes
max_iops 0 MAX IO per second
max_mbps 0 MAX MB per second
max_pdbs 4098 max number of pdbs allowed in CDB or Application ROOT
max_string_size STANDARD controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
noncdb_compatible FALSE Non-CDB Compatible
ofs_threads 4 Number of OFS threads
one_step_plugin_for_pdb_with_tde FALSE Facilitate one-step plugin for PDB with TDE encrypted data
optimizer_adaptive_plans TRUE controls all types of adaptive plans
optimizer_adaptive_reporting_only FALSE use reporting-only mode for adaptive optimizations
optimizer_adaptive_statistics TRUE controls all types of adaptive statistics
optimizer_inmemory_aware TRUE optimizer in-memory columnar awareness
outbound_dblink_protocols ALL Outbound DBLINK Protocols allowed
pdb_file_name_convert PDB file name convert patterns and strings for create cdb/pdb
pdb_lockdown pluggable database lockdown profile
pdb_os_credential pluggable database OS credential to bind
pga_aggregate_limit 0 limit of aggregate PGA memory for the instance or PDB
processor_group_name Name of the processor group that this instance should run in.
remote_recovery_file_dest default remote database recovery file location for refresh/relocate
resource_manage_goldengate FALSE goldengate resource manager enabled
sga_min_size 0 Minimum, guaranteed size of PDB’s SGA
shrd_dupl_table_refresh_rate 60 duplicated table refresh rate (in seconds)
spatial_vector_acceleration FALSE enable spatial vector acceleration
standby_db_preserve_states NONE Preserve state cross standby role transition
target_pdbs 0 Parameter is a hint to adjust certain attributes of the CDB
temp_undo_enabled FALSE is temporary undo enabled
threaded_execution FALSE Threaded Execution Mode
unified_audit_sga_queue_size 1048576 Size of Unified audit SGA Queue
uniform_log_timestamp_format TRUE use uniform timestamp formats vs pre-12.2 formats
use_dedicated_broker FALSE Use dedicated connection broker