Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Materialized View refresh time info needed

759447Aug 4 2011 — edited Aug 19 2011
Hello,


How to check the refresh start time,Completion time ,Total refresh time ,error information if any and next day refresh start time of a materialized View?

Per DDL of Materialized views the time has been set up at 9 PM ,10 PM, 11 PM:
MV1: REFRESH COMPLETE ON DEMAND START WITH sysdate+0 NEXT TRUNC(SYSDATE+1)-3/24
MV2: REFRESH COMPLETE ON DEMAND START WITH sysdate+0 NEXT TRUNC(SYSDATE+1)-2/24
MV3: REFRESH COMPLETE ON DEMAND START WITH sysdate+0 NEXT TRUNC(SYSDATE+1)-1/24

But I think refresh time is not working properly. So just want to run a Query to find out exact timing information.

Thanks.

Edited by: user4845367 on Aug 4, 2011 1:59 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2011
Added on Aug 4 2011
#refresh
6 comments
4,220 views