oracle物化视图刷新时间 [英] oracle materialized view refresh time
本文介绍了oracle物化视图刷新时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
谁能告诉我使用以下设置plz刷新实例化视图的频率是多少?
anyone able to tell me how often a materialized view is set to refresh with the following setting plz?
按需刷新力始于sysdate + 0 NEXT(round(sysdate)+ 1/24)+1
REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT (round(sysdate) + 1/24) + 1
我认为我每个小时都读一次,但不确定
i think i read it as every hour but i'm not sure
推荐答案
SQL> alter session set nls_date_format = 'yyyy-mm-dd :hh24:mi:ss';
Session changed.
SQL> select sysdate from dual;
SYSDATE
--------------------
2008-12-19 :12:18:28
SQL> select (round(sysdate) + 1/24) + 1 from dual;
(ROUND(SYSDATE)+1/24
--------------------
2008-12-21 :01:00:00
这篇关于oracle物化视图刷新时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文