oracle前端数据缓存,TimesTen:Cache Group局部数据缓存及Aging

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) |

Advanced | 2255 |