My Oracle Support Banner

Materialized View Refresh Statistics Causing High CPU and Logical Reads (Doc ID 2764909.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

 

Changes

 DBRU OCT 2019

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.