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 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
.
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.
The following sections describe each of the autorefresh attributes: