Requirements for Setting DynamicLoadReduceContention
There are requirements when using the
DynamicLoadReduceContention
database system
parameter.
The DynamicLoadReduceContention
database system parameter requires
the following to be enabled:
-
Required Oracle Database privileges: You must grant two additional Oracle Database privileges to the cache administration user:
-
EXECUTE ON SYS.DBMS_FLASHBACK
-
SELECT ANY TRANSACTION
These are granted to the cache administration user when you execute the
grantCacheAdminPrivileges.sql
andinitCacheAdminSchema.sql
scripts. -
-
Support for Oracle Database: This feature requires the use of the Oracle Database Flashback Transaction Queries.With Oracle Database 12.2.0.1 with Multitenant option, Flashback Transaction Queries only supports Local Undo. You cannot use this feature with Oracle Database 12.2.0.1 Multitenant option with Shared Undo.
-
Required settings for active standby pair replication scheme:
-
Both active and standby masters must be installed. If you are replicating between active and standby masters where each is installed with different TimesTen versions, then this parameter cannot be enabled if one of the TimesTen versions does not support this feature.
-
The
DynamicLoadReduceContention
database system parameter must be set to the same value on both the active and standby masters.
Otherwise, an error is written to the daemon log. Replication will not progress until the settings and TimesTen versions conform on both the active and standby masters.
-