在timesten的cachegroup中,readonly的autorefresh功能是系统提供的,里面有一个参数“state”是以前我一直忽视的,昨天研究清楚了,记录一下:
下面是create readonly cache group的例子:
CREATE READONLY CACHE GROUP [Owner.]GroupName [AUTOREFRESH [MODE {INCREMENTAL | FULL}] [INTERVAL IntervalValue {MINUTE[S] | SECOND[S] | MILLESECOND[S] }] [STATE {ON|OFF|PAUSED}] ]FROM {[Owner.]TableName ( {ColumnDefinition[,…]} [,PRIMARY KEY(ColumnName[,…])] [,FOREIGN KEY(ColumnName [,…]) REFERENCES RefTableName (ColumnName [,…]) [ON DELETE CASCADE] [UNIQUE HASH ON (HashColumnName[,…]) PAGES=PrimaryPages] [WHERE ExternalSearchCondition] [AGING USE ColumnName LIFETIME Num1 {MINUTE[S] |HOUR[S] | DAY[S]} [CYCLE Num2 {MINUTE[S] |HOUR[S] |DAY[S]}] [ON|OFF] ] } [,...]; |
注意中间的“[STATE {ON|OFF|PAUSED}]”,根据timesten的文档,缺省的情况下,这个状态是Paused的,下面是这三个状态的具体说明:
1、 OFF,不捕捉和记录oracle表的变化
2、 PAUSED,捕捉并记录oracle表的变化,但是不提交到timesten中
3、 ON,当然就是捕捉并记录oracle表的变化,并反映到timesten中去了