New (some undocumented) Parameters in Oracle 12.1.0.2

Right now Roy and I are in the final steps to refresh our big slide deck to the new layout, but more important, to have Oracle 12.1.0.2 information included as well (were necessary). So I did my usual "compare parameters" query between releases - getting unusual surprises this time.

This is the list of new parameters introduced with the patch set Oracle Database 12.1.0.2. Where applicable I have added the link to the doc.

DBFIPS_140 enables Transparent Data Encryption (TDE) and DBMS_CRYPTO PL/SQL package program units to run in a mode compliant to the Federal Information Processing Standard (subsequently known as "FIPS mode&quot

Specifies a prefix that the names of common users, roles, and profiles in a multitenant container database (CDB) must start with. If COMMON_USER_PREFIX is set to an empty string, Oracle will not enforce any restrictions on the names of common or local users, roles, and profiles.

DB_PERFORMANCE_PROFILE <<updated Dec 16>>

Undocumented

See bug17861171, bug18406144 and bug19817284 - IORM feature on Exadata only

Enables you to specify a default In-Memory Column Store (IM column store) clause for new tables and materialized views. If the INMEMORY_CLAUSE_DEFAULT parameter is unset or set to an empty string (the default), only tables and materialized views explicitly specified asINMEMORY will be populated into the IM column store. Setting the value of the INMEMORY_CLAUSE_DEFAULT parameter to NO INMEMORY has the same effect as setting it to the default value.

Allows you to specify whether tables and materialized view that are specified asINMEMORY are populated into the In-Memory Column Store (IM column store) or not. The default value isDEFAULT. When this value is in effect, the IM column store is populated only with tables and materialized views specified asINMEMORY. IfOFFis specified, then even if the IM column store is configured on this instance, no tables or materialized are populated in memory.

Used to enable or disable in-memory queries for the entire database at the session or system level. This parameter is helpful when you want to test workloads with and without the use of the In-Memory Column Store (IM column store)

Sets the size of the In-Memory Column Store (IM column store) on a database instance. If a database does not have automatic memory management enabled, this parameter must be set to a nonzero value that reserves the amount of memory to use for the database's IM column store. The default value is 0, which means that the IM column store is not used. The database must be restarted after setting this parameter to enable the IM column store. The minimum size to which this parameter can be set is 100 MB.

Limits the maximum number of background populate servers used for In-Memory Column Store (IM column store) repopulation, as trickle repopulation is designed to use only a small percentage of the populate servers. The value for this parameter is a percentage of the INMEMORY_MAX_POPULATE_SERVERS initialization parameter value

Enables or disables all of the optimizer cost model enhancements for in-memory. Setting the parameter to false causes the optimizer to ignore the in-memory property of tables during the optimization of SQL statements. This behavior can also be achieved by setting theOPTIMIZER_FEATURES_ENABLE initialization parameter to values lower than 12.1.0.2

PDB_LOCKDOWN

Undocumented

Per feedback by the Multitenant team:

Not functional in Oracle 12.1.0.2

PDB_OS_CREDENTIAL

Undocumented

Per feedback by the Multitenant team:

Not functional in Oracle 12.1.0.2

May be functional with a future PSU allwoing then OS user
verfication/validation for PDBs

-Mike

PS: Forgot to mention this one as a parameter which had been disappeared in Oracle 12.1.0.2:

About

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.