TimesTen:Cache Group局部数据缓存及Aging

原创 eygle 2009-04-16

719

简单测试，记录备忘。
按条件加载Cache Group数据，底层表是IOT表分区表，TimesTen表映射底层Oracle数据库表：

Command> load cache group ishipawt where ISHIP.idatet >'2009-04-10' commit every 0 rows;
0 cache instances affected.
Command> load cache group ishipawt where ISHIP.idatet >'2009-04-08' commit every 0 rows;
101630 cache instances affected.

修改数据表，增加数据老化周期，设定2小时老化：

Command> alter table iship add aging use idatet lifetime 2 hours cycle 30 minutes;
8007: Cannot change aging attributes or add/drop aging policy of replicated tables while replication Agent is running
The command failed.
Command> call ttrepstop;
Command> alter table iship add aging use idatet lifetime 2 hours cycle 30 minutes;
Command> call ttrepstart;

初始Cache数据有101631条：

Command> select count(*) from iship;
< 101631 >
1 row found.
Command> call ttagingschedulenow('ISHIP');
Command> desc iship;
Table EYGLE.ISHIP:
Columns:
*AINDEX NUMBER NOT NULL
*SMMSIH VARCHAR2 (20) INLINE NOT NULL
*IDATET DATE NOT NULL
*ODATET DATE NOT NULL
Aging use IDATET lifetime 2 hours cycle 30 minutes on
1 table found.
(primary key columns are indicated with *)

Aging之后，剩余一条记录：

Command> select count(*) from iship;
< 1 >
1 row found.

-The End-

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

TimesTen:Cache Group局部数据缓存及Aging

评论