10 noviembre 2016

Nuevos parámetros SPFILE en base de datos Oracle

La Base de Datos Oracle 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 Ojo que algunos de ellos están sin documentar a día de hoy.

ALLOW_GLOBAL_DBLINKS specifies whether LDAP lookup for database links is allowed for the database.
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 (, database shared memory was created with owner and group access.
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 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 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 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 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 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_name *
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 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 controls whether deferred cursor invalidation or immediate cursor invalidation is used for DDL statements by default.
Data Guard SYNC latency
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 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 *
Enable/Disable Automated Maintenance for Non-Root PDB
Enable DNFS Dispatcher
List of Enabled PDB patterns
whether to encrypt newly created tablespaces
Enable Exafusion
external keystore credential location
Enable IMC support on ADG
Controls which In-Memory Expressions are populated in-memory
Controls which user-defined virtual columns are stored in-memory
time to delay an internal initiated abort (in seconds)
indicates whether the instance read-only or read-write or read-mostly
Use longer module and action
maximum number of concurrent Data Pump Jobs per PDB
maximum session idle time in minutes
MAX IO per second
MAX MB per second
max number of pdbs allowed in CDB or Application ROOT
Number of OFS threads
one_step_plugin_for_pdb_with_tde *
[undocumented] Facilitate one-step plugin for PDB with TDE encrypted data
controls all types of adaptive plans
controls all types of adaptive statistics
Outbound DBLINK Protocols allowed
default remote database recovery file location for refresh/relocate
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 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.
duplicated table refresh rate (in seconds)
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
 [undocumented] Parameter is a hint to adjust certain attributes of the CDB
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.

No hay comentarios:

Publicar un comentario

Por favor deja tu comentario, es valioso.