Nuevos parámetros SPFILE en base de datos Oracle 12.2.0.1

La Base de Datos Oracle 12.2.0.1 está disponible ahora en la nube de Oracle.

Y esta es la lista de los 46 nuevos parámetros init.ora / spfile comparados con la base de datos Oracle 12.1.0.2. Ojo que algunos de ellos están sin documentar a día de hoy.

Parameter	Description
allow_global_dblinks	ALLOW_GLOBAL_DBLINKS specifies whether LDAP lookup for database links is allowed for the database.
allow_group_access_to_sga	ALLOW_GROUP_ACCESS_TO_SGA controls group access to shared memory on UNIX platforms. The default value is false, which means that database shared memory is created with owner access only. In Oracle Database releases prior to Oracle Database 12c Release 2 (12.2.0.1), database shared memory was created with owner and group access.
approx_for_aggregation	APPROX_FOR_AGGREGATION replaces exact query processing for aggregation queries with approximate query processing. Data analysis applications heavily use aggregate function and analytic function queries. Aggregation functions and analytic functions require sorting of large volumes of data, and exact query answering requires lots of memory, and can be time consuming. With approximate query processing, the results of aggregate function and analytic function queries are returned much faster than with exact query processing.
approx_for_count_distinct	APPROX_FOR_COUNT_DISTINCT automatically replaces COUNT (DISTINCT expr) queries with APPROX_COUNT_DISTINCT queries. Query results for APPROX_COUNT_DISTINCT queries are returned faster than the equivalent COUNT (DISTINCT expr) queries. APPROX_COUNT_DISTINCT queries are useful for situations where a tolerable amount of error is acceptable in order to obtain faster query results than with a COUNT (DISTINCT expr) query.
approx_for_percentile	APPROX_FOR_PERCENTILE converts exact percentile functions to their approximate percentile function counterparts. Approximate percentile function queries are faster than their exact percentile function query counterparts, so they can be useful in situations where a tolerable amount of error is acceptable in order to obtain faster query results.
asm_io_processes	ASM_IO_PROCESSES specifies the number of I/O worker processes to be started in an Oracle Automatic Storage Management (Oracle ASM) IOServer instance. This parameter is applicable only in an Oracle ASM IOServer instance, which runs out of an Oracle Grid home. The default value should work in most cases
autotask_max_active_pdbs	AUTOTASK_MAX_ACTIVE_PDBS enables you to specify the maximum number of PDBs that can schedule automated maintenance tasks at the same time (during a maintenance window). This parameter only affects PDBs. The CDB$ROOT container (CDB root) for a CDB can always schedule and run maintenance tasks during a maintenance window. The default value is 2.
awr_pdb_autoflush_enabled	AWR_PDB_AUTOFLUSH_ENABLED enables you to specify whether to enable or disable automatic Automatic Workload Repository (AWR) snapshots for all the PDBs in a CDB or for individual PDBs in a CDB. Default value is false.
cdb_cluster	[undocumented]
cdb_cluster_name *	[undocumented]
clonedb_dir *	CLONEDB_DIR sets the directory path where CloneDB bitmap files should be created and accessed. By default the CloneDB bitmap file is created under the $ORACLE_HOME/dbs directory.
containers_parallel_degree	CONTAINERS_PARALLEL_DEGREE can be used to control the degree of parallelism of a query involving containers(). The value of containers_parallel_degree, if set, will override the default DOP for a containers() query. By default, a containers() query uses a degree of parallelism equal to (1 + number of open PDBs) in the case of CDB root and (1 + number of open application PDBs) in the case of application root. If the value of CONTAINERS_PARALLEL_DEGREE is lower than 65535, then this value is used as the degree of parallelism of a query involving  containers(). Otherwise (when the value is 65535), the default degree of parallelism is (1 + number of open PDBs) or (1 + number of open application PDBs) as described above.
cursor_invalidation	CURSOR_INVALIDATION controls whether deferred cursor invalidation or immediate cursor invalidation is used for DDL statements by default.
data_guard_sync_latency	Data Guard SYNC latency
data_transfer_cache_size	DATA_TRANSFER_CACHE_SIZE sets the size of the data transfer cache (in bytes) used to receive data blocks (typically from a primary database in an Oracle Data Guard environment) for consumption by an instance during execution of an RMAN RECOVER ... NONLOGGED BLOCK command
default_sharing	DEFAULT_SHARING sets the value of the sharing clause in statements creating objects in an application root. Specifying SHARING= in the create DDL overrides the value of the DEFAULT_SHARING parameter.
disable_pdb_feature *	[undocumented]
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	RESOURCE_MANAGE_GOLDENGATE determines whether Oracle GoldenGate apply processes in the database are resource managed. To enable Resource Manager, set the RESOURCE_MANAGER_PLAN parameter. By default, Oracle GoldenGate apply processes in the database are not resource managed. Given that replication to a PDB requires a separate Oracle GoldenGate apply process,
sga_min_size	SGA_MIN_SIZE sets the guaranteed SGA size for a pluggable database (PDB). When SGA_MIN_SIZE is set for a PDB, it guarantees the specified SGA size for the PDB. Setting this parameter at the CDB level has no effect.
shrd_dupl_table_refresh_rate	duplicated table refresh rate (in seconds)
standby_db_preserve_states	STANDBY_DB_PRESERVE_STATES is meaningful on a physical standby database that is open in real-time query mode. The parameter controls whether user sessions and other internal states of the instance are retained when a readable physical standby database is converted to a primary database. The possible values for the parameter are NONE, SESSION, and ALL
target_pdbs*	[undocumented] Parameter is a hint to adjust certain attributes of the CDB
uniform_log_timestamp_format	UNIFORM_LOG_TIMESTAMP_FORMAT specifies that a uniform timestamp format be used in Oracle Database trace (.trc) files. When the value of UNIFORM_LOG_TIMESTAMP_FORMAT is TRUE, the format used for timestamps in trace files is standardized on universal time with millisecond precision.