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 220.127.116.11 and later
Information in this document applies to any platform.
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!