ORA-7445 [keswxCheckActive] and/or ORA-7445 [keswxDumpPlanEntry] Errors with High 'library cache lock' Waits
(Doc ID 2928784.1)
Last updated on JULY 20, 2024
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 |