AUTOREFRESH Cache Group Attribute Overview

The AUTOREFRESH cache group attribute can be specified when creating a read-only cache group or a user managed cache group using a CREATE CACHE GROUP statement.

AUTOREFRESH specifies that committed changes on cached Oracle Database tables are automatically refreshed to the TimesTen cache tables. Autorefresh is defined by default on read-only cache groups.

The AUTOREFRESH method determines how cache consistency is maintained either through trigger-based capture or GoldenGate's log-based capture. It allows TimesTen to automatically refresh the cache tables by tracking changes on the Oracle Database. This method can be used to manage cache group refreshes either through log-based capture or through triggers, based on how the cache is configured.

The following are the default settings of the autorefresh attributes:

• The autorefresh mode is incremental.

• The autorefresh interval is 5 minutes.

• The autorefresh state is PAUSED.

• The autorefresh method is trigger.

The following sections describe each of the autorefresh attributes:

• Autorefresh Mode Attribute Settings

• Autorefresh Interval and State Settings

• Restrictions for Autorefresh

If you create a unique index on a cache group with the AUTOREFRESH cache group attribute, the index is changed to a non-unique index to avoid a constraint violation. A constraint violation could occur with a unique index because conflicting updates could occur in the same statement processing on the Oracle Database table, while each row update is processed separately in TimesTen. If the unique index exists on the Oracle Database table that is being cached, then uniqueness is enforced on the Oracle Database table and does not need to be verified again in TimesTen.