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 OCTOBER 20, 2017

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

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 hundreds of Community platforms