1. Cache Guide
  2. Cache Performance
  3. Improving Performance for Autorefresh Operations
  4. Reducing Contention for Dynamic Read-Only Cache Groups with Incremental Autorefresh
  5. Requirements for Setting DynamicLoadReduceContention

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