创建每5分钟刷新一次的实例化视图 [英] Creating materialized view that refreshes every 5 min

问题描述

我创建了一个实例化视图，该视图每5分钟刷新一次，但是当我在实例化视图上插入并执行选择时，是否得到了相同的旧数据?我需要手动刷新吗?

I created a materialized view that refreshed every 5 min but when I do insert and perform select on materialized view I get same old data? Do I need to refresh manually?

CREATE MATERIALIZED VIEW MVW_TEST
REFRESH FORCE ON DEMAND 
START WITH TO_DATE('01-01-2009 00:01:00', 'DD-MM-YYYY HH24:MI:SS') NEXT SYSDATE + 1/1152 
As select * from TEST12

推荐答案

我已经演示了在每个one minute之后，物化视图都会刷新的步骤， 在5分钟后使用next(sysdate+5/1440)

I have demonstrated in steps where a materialized view refresh after every one minute ,for having a mv which refresh after 5 minute use next(sysdate+5/1440)

第一步:

Create table temp (A int);

第二步:

Create Materialized view temp_mv
      refresh complete start with (sysdate) next  (sysdate+1/1440) with rowid
        as select * from temp;

第3步:

select count(*) from temp;

       COUNT(*)
      ----------
          0

第四步:

select count(*) from temp_mv;

       COUNT(*)
      ----------
          0

第5步:

begin
      for i in 1..10 loop
         insert into temp values (i+1);
      end loop;
end;
/

Step6:

commit;

Step7:

select count(*) from temp;

       COUNT(*)
     ----------
        10

Step8:

select count(*) from temp_mv;

       COUNT(*)
       ----------
          0

Step9:

select to_char(sysdate,'hh:mi') from dual;

       TO_CH
       -----
       04:28

步骤10:

select to_char(sysdate,'hh:mi') from dual;

       TO_CH
        -----
       04:29

Step11:

select count(*) from temp;

      COUNT(*)
     ----------
        10

Step12:

select count(*) from temp_mv;

      COUNT(*)
      ----------
         10

这篇关于创建每5分钟刷新一次的实例化视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！