Materialized View - Oracle
NEXT SYSDATE +1 means the materialized view will be automatically refreshed every day at the same time when the view is created. 

In order to refresh the materialized view every 6 hours use NEXT SYSDATE +6/24

DISABLE QUERY REWRITE indicates that the materialized view is not eligible to be used by the query optimizer to rewrite sql queries on the base tables.