My Oracle Support Banner

ORA-7445 [keswxCheckActive] and/or ORA-7445 [keswxDumpPlanEntry] Errors with High 'library cache lock' Waits (Doc ID 2928784.1)

Last updated on MARCH 03, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.13.0.0.0 [Release 12.2 to 19]
Information in this document applies to any platform.

Symptoms

Errors such as the following are noted in the alert log:

At the same time, the instance suffered from high library cache lock waits, e.g. from an AWR report:

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Avg Wait % DB time Wait Class
  library cache lock    31,365    1M  32.25 s     93.2   Concurrency 
  DB CPU   62.26K         5.8  

 

Changes

 

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.