“Performing a refresh operation requires temporary space to rebuild the indexes and can require additional space for performing the refresh operation itself.”
“Not all materialized views may be fast refreshable. Therefore, use the package DBMS_MVIEW.EXPLAIN_MVIEW to determine what refresh methods are available for a materialized view.”
Refresh methods:
- Incremental : Two types: logg-based refresh and partition change tracking (PCT).
“The incremental refresh is commonly called FAST refresh as it usually performs faster than the complete refresh.” - Complete refresh
DBMS_MVIEW package
- DBMS_MVIEW.REFRESH
- DBMS_MVIEW.REFRESH_ALL_MVIEWS
- DBMS_MVIEW.REFRESH_DEPENDENT
Traditional methods:
FAST (‘F’), COMPLETE (‘C’), PCT (‘P’), and FORCE (‘?’).
- Monitoring and information about the refresh
- V$SESSION_LONGOPS;
- DBA_JOBS_RUNNING;
- MVIEW_NAME;
https://www.youtube.com/watch?v=_JOu5cg70Js – Oracle sql materialized view refresh fast by Sridhar Raghavan
Data Warehousing and Business Intelligence -> Database Data Warehousing Guide -> 7 Refreshing Materialized Views
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.