My Oracle Support Banner

High Library Cache Lock and Library Cache Load Lock Waits During Concurrent Heavy Mixed PMOPs and DML on Several Partitioned Tables (Doc ID 2181034.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

High "library cache lock" with "library cache load lock" waits were seen when there were parallel maintenance operations (PMOPs) with concurrent DML on the same table.  In this case, for the same table, a new partition was added and a different one dropped about every second while DML was also occurring.   This same type of workload was being done on other partitioned tables at the same time. 

An AWR might look something like the following:

 

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!


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