12cR2 lots of new instance parameters

Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters:

adg_imc_enabled                               TRUE                 Enable IMC support on ADG                                                                                                  
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                              0                    number of I/O processes per domain in the ASM IOSERVER instance                                                            
cdb_cluster                                   FALSE                if TRUE startup in CDB Cluster mode                                                                                        
cdb_cluster_name                              cfcdba1              CDB Cluster name                                                                                                           
clonedb_dir                                                        CloneDB Directory                                                                                                          
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                                                                                                
default_sharing                               metadata             Default sharing clause                                                                                                     
disable_pdb_feature                           0                    Disable features                                                                                                           
enable_dnfs_dispatcher                        FALSE                Enable DNFS Dispatcher                                                                                                     
enable_pdb_isolation                          FALSE                Enables Pluggable Database isolation inside a CDB                                                                          
enabled_PDBs_on_standby                       *                    List of Enabled PDB patterns                                                                                               
encrypt_new_tablespaces                       ALWAYS               whether to encrypt newly created tablespaces                                                                               
external_keystore_credential_location         +DATA/wallets/tde/us external keystore credential location                                                                                      
inmemory_expressions_capture                  DISABLE              Controls detection of frequently used costly expressions                                                                   
inmemory_expressions_usage                    ENABLE               Controls which In-Memory Expressions are populated in-memory                                                               
inmemory_virtual_columns                      ENABLE               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                                                      
long_module_action                            TRUE                 Use longer module and action                                                                                               
max_idle_time                                 60                   maximum session idle time in minutes                                                                                       
max_iops                                      0                    MAX IO per second                                                                                                          
max_mbps                                      0                    MAX MB per second                                                                                                          
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_statistics                 FALSE                controls all types of adaptive statistics                                                                                  
outbound_dblink_protocols                     ALL                  Outbound DBLINK Protocols allowed                                                                                          
pga_aggregate_xmem_limit                      0                    limit of aggregate PGA XMEM memory consumed by the instance                                                                
remote_recovery_file_dest                                          default remote database recovery file location for refresh/relocate                                                        
sec_protocol_allow_deprecated_rpcs            YES                  Allow deprecated TTC RPCs                                                                                                  
standby_db_preserve_states                    NONE                 Preserve state cross standby role transition                                                                               
target_pdbs                                   525                  Parameter is a hint to adjust certain attributes of the CDB                                                                
uniform_log_timestamp_format                  TRUE                 use uniform timestamp formats vs pre-12.2 formats

A lot of them are to do with Multitenant. The others? Well, some are fairly obvious, some used to be _underscore parameters. As for the others, I’ll have to wait until I can study the docs.

—
John Watson
Oracle Certified Master DBA
https://skillbuilders.com