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