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: 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