New SPFILE parameters in Oracle Database 12.2.0.1

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

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

 

–Mike

6 thoughts on “New SPFILE parameters in Oracle Database 12.2.0.1

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

  2. Pingback: Deprecated Parameters in Oracle Database 12.2.0.1 | 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!

  5. Pingback: Alert.log: New timestamp format in Oracle 12.2 – Upgrade your Database - NOW!

  6. 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

Leave a Reply

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