How To Troubleshoot Materialized View Fast Log Timestamp-based Refresh Performance Issues
(Doc ID 1388637.1)
Last updated on MARCH 12, 2021
Oracle Database - Enterprise Edition - Version 18.104.22.168 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Information in this document applies to any platform.
This note was created to facilitate troubleshooting materialized view fast log timestamp-based refresh performance issues.
MV Fast Refresh includes the following phases:
Setup (refresh initialization and mview log setup)
MV Refresh (generation and execution of refresh expressions, sometimes called as Instantiate)