This post is about the view which we use in Oracle.

What is  Materialized View?

The view which we use to make a replica of a target master from a single point in a time is known materialized view.

As we know why do we need materialized view in Oracle?

  • redesign the system and eliminate those “tough” queries
  • cache the results of such queries
  • using materialized views.

Let’s have a look at the query which we use to Check Materialized View Refresh Schedule


SELECT job, what mview_name, TO_CHAR (last_date, 'mm/dd/yyyy hh24:mi:ss') last_execution,
TO_CHAR (next_date, 'mm/dd/yyyy hh24:mi:ss') next_execution, INTERVAL
FROM dba_jobs WHERE what LIKE 'dbms_refresh.refresh%';


Job  MVIEW_NAME                                LAST_EXECUTION      NEXT_EXECUTION      INTERVAL
223 dbms_refresh.refresh('"SCOTT"."ACCOUNT"'); 07/22/2014 09:07:25 07/22/2014 10:07:25 SYSDATE + 1/24
126 dbms_refresh.refresh('"SCOTT"."EMP"');     07/22/2014 09:07:00 07/22/2014 10:07:00 SYSDATE + 1/24


Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.