New SPFILE parameters in Oracle Database

This is the 1st posting in my series about init.ora/SPFILE parameters in Oracle Database

Oracle Database is available now in the Oracle Cloud.

And this is the list of 46 new init.ora/spfile parameters compared to Oracle Database – including the links (where possible) to the Oracle Database 12.2 Reference documentation.




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
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
inmemory_virtual_columns Controls which user-defined virtual columns are stored
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
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
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
uniform_log_timestamp_format use uniform timestamp formats vs pre-12.2 formats



4 thoughts on “New SPFILE parameters in Oracle Database

  1. Pingback: Obsolete SPFILE Parameters in Oracle Database | Upgrade your Database - NOW!

  2. Pingback: Deprecated Parameters in Oracle Database | Upgrade your Database - NOW!

  3. Pingback: Default Changes SPFILE Parameters – Oracle 12.2 | Upgrade your Database - NOW!

  4. Pingback: SGA_MIN_SIZE in Oracle Database 12.2 | Upgrade your Database - NOW!

Leave a Reply

Your email address will not be published. Required fields are marked *