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_BIGINT NOT NULL	ID of this cache group
ROOT	TT_BIGINT NOT NULL	Unique identifier for cache group's root table
SOURCE	TT_CHAR(8) NOT NULL	Data source for caching The only supported value is 'ORACLE'.
CGDURATION	TT_INTEGER NOT NULL	Internal use.
TBLCNT	TT_SMALLINT NOT NULL	Number of tables in cache group
REFRESH_MODE	TT_CHAR(1) NOT NULL	The current autorefresh mode 'N': No autorefresh 'I': Incremental autorefresh 'F': Full autorefresh
REFRESH_STATE	TT_CHAR(1) NOT NULL	The current autorefresh 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 for cache group types Bits 8-15 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 in the Oracle database, 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.
CVGRIDID	TT_INTEGER NOT NULL	Not used
GRIDINFO	VARBINARY(409600) NOT INLINE	Internal use
ORATOP	TT_VARCHAR(409600) NOT INLINE	Future use
ORAPROXY	TT_VARCHAR(409600) NOT INLINE	Future use
ORABASE	TT_VARCHAR(409600) NOT INLINE	Future use
TTALIAS	TT_VARCHAR(409600) NOT INLINE	Future use
ORASCN	VARBINARY (409600) NOT INLINE NOT NULL	When using an Oracle Active Data Guard setup, this column contains the Oracle SCN used to refresh the cache group represented by the row (SYS.CACHE_GROUP.CGNAME).