SYS.CACHE_GROUP

The CACHE_GROUP table describes the definition of a TimesTen cache.

Columns

Column name	Type	Description
CGNAME	TT_CHAR (31) NOT NULL	Group name.
CGOWNER	TT_CHAR (31) NOT NULL	Group owner.
CGID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Id of this cache group.
ROOT	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Unique identifier for cache group's root table
SOURCE	TT_CHAR (8) NOT NULL	Data source for caching. In this release the only legal value is 'ORACLE'.
CGDURATION	TT_INTEGER NOT NULL	Duration
TBLCNT	TT_SMALLINT NOT NULL	Number of tables in cache group.
REFRESH_MODE	TT_CHAR (1) NOT NULL	The current auto refresh mode. 'N': No auto refresh. 'I': Incremental auto refresh. 'F': Full auto refresh.
REFRESH_STATE	TT_CHAR (1) NOT NULL	The current auto refresh mode. 'N': Off. 'Y': On. 'P': Paused.
REFRESH_INTERVAL	TT_BIGINT NOT NULL	Autorefresh interval in milliseconds.
CGATTRIBUTES	BINARY (4) NOT NULL	Bits 0-7 are for cache group types. Bits 8-15 are for autoload options. Bit 0: 1 - READONLY Bit 1: 1 - SYNCHRONOUS WRITETHROUGH Bit 2: 1 - AUTOREFRESH Bit 3: 1 - PROPAGATE Bit 8: 1 - Autoload on create (Always 1 for AUTOREFRESH) Bit 9: 1 - Dynamic cache group
REFRESH_WITH_LIMIT	TT_INTEGER NOT NULL	The maximum number of autorefresh change log records kept in the trigger log table in the Oracle database. A larger value causes the autorefresh to use more space at Oracle, while it prevents the truncation of logs that are not autorefreshed to TimesTen yet, and therefore reduces the possible fallback to full refresh. The field is used only by incremental autorefresh
ORATOP	TT_VARCHAR (409600) NOT INLINE	Reserved for future use
ORAPROXY	TT_VARCHAR (409600) NOT INLINE	Reserved for future use
ORABASE	TT_VARCHAR (409600) NOT INLINE	Reserved for future use
TTALIAS	TT_VARCHAR (409600) NOT INLINE	Reserved for future use