New Parameters in Oracle Database 12c

New Parameters in Oracle Database 12c

Several new parameters are available in Oracle Database 12c. These are listed and described in the following table.

Parameter Name	Description
CONNECTION_BROKERS	Used to specify connection broker types, the number of connection brokers of each type, and the maximum number of connections per broker.
DNFS_BATCH_SIZE	Controls the number of asynchronous IOs that can be queued by an Oracle process when Direct NFS Client is enabled.
ENABLE_PLUGGABLE_DATABASE	A bootstrap initialization parameter to create a container database (CDB).
HEAT_MAP	When set to ON, causes the database to track read and write access of all segments, as well as modification of database blocks, due to DMLs and DDLs. Note that this feature does not work with Multitenant databases in the initial release of Oracle Database 12c.
MAX_STRING_SIZE	Controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL. Enable this parameter only when in upgrade mode, and run utl32k.sql script after enabling it.
OPTIMIZER_ADAPTIVE_FEATURES	Enables or disables all of the adaptive optimizer features.
OPTIMIZER_ADAPTIVE_REPORTING_ONLY	Controls reporting-only mode for adaptive optimizations. When set to TRUE, information required for an adaptive optimization is gathered, but no action is taken to change the plan.
PDB_FILE_NAME_CONVERT	Maps names of existing files to new filenames when processing aCREATE PLUGGABLE DATABASE statement, as well as when processing the ENABLE PLUGGABLE DATABASE clause of the CREATE DATABASE statement, if file_name_convert_clause is not specified and Oracle Managed Files is not enabled.
PGA_AGGREGATE_LIMIT	Specifies a limit on the aggregate PGA memory consumed by the instance.
PROCESSOR_GROUP_NAME	Instructs the database instance to run itself within the specified operating system processor group. All Oracle processes will be bound to the CPUs in this group and will only run on these CPUs.
NONCDB_COMPATIBLE	Provides behavior similar to a non-CDB when issuing SQL commands inside a pluggable database (PDB) in a CDB.
SPATIAL_VECTOR_ACCELERATION	Enables or disables the spatial vector acceleration.
TEMP_UNDO_ENABLED	Determines whether transactions within a particular session can use a temporary undo log rather than a permanent one. The default choice for database transactions in prior versions of Oracle has been to have a single undo log per transaction. This parameter provides the ability for Oracle to split UNDO into two separate streams, one for permanent operations and one for temporary ones.
THREADED_EXECUTION	Specifies whether to enable the multithreaded Oracle model.
UNIFIED_AUDIT_SGA_QUEUE_SIZE	Specifies the size of the SGA queue for unified auditing.
USE_DEDICATED_BROKER	Determines how dedicated servers are spawned.