How To Troubleshoot Materialized View Fast Log Timestamp-based Refresh Performance Issues
(Doc ID 1388637.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 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.
Purpose
<Internal_Only* ***
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)
