How To Troubleshoot Materialized View Fast Log Timestamp-based Refresh Performance Issues
(Doc ID 1388637.1)
Last updated on SEPTEMBER 20, 2022
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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)