Check Materialized View Refresh Schedule in Oracle

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

Query

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%';

Output

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: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp