www.eygle.com

« TimesTen 7.0.5 For Linx安装过程记录 | Blog首页 | 2009 CSDN英雄会记事 - 时间规划非常重要 »

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

简单测试，记录备忘。

按条件加载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-

By eygle on 2009-04-16 18:32 | Comments (0) | Posted to Advanced | Edit |Pageviews:

留言 (0)

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: