eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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

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

简单测试,记录备忘。

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


历史上的今天...
    >> 2018-04-16文章:
    >> 2013-04-16文章:
    >> 2011-04-16文章:
    >> 2008-04-16文章:
           DBA警世录:root操作需谨慎
    >> 2007-04-16文章:

By eygle on 2009-04-16 18:32 | Comments (0) | Advanced | 2255 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com