Materialized View Refresh Statistics Causing High CPU and Logical Reads
(Doc ID 2764909.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Issue started after applying DBRU for October 2019.
During the "hanging" period, the database executes calls to DBMS_IREFSTATS.PURGE_STATS_MV_RP, which accumulates high quantities of DB Cpu time, associated with high logical read count
DBRU OCT 2019
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document