My Oracle Support Banner

Performance Degradation and JI Lock Contention Observed During Batch Load of Tables With On-Commit Materialized Views (Doc ID 371869.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 to 11.1.0.6 [Release 8.1.5 to 11.1]
Information in this document applies to any platform.


Symptoms

When running concurrent batch jobs against tables with on-commit materialized views, the jobs run very slowly and JI lock contention on the materialized views is observed.

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
Cause
Solution

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