ORA-445 and Heavy 'latch: shared pool' and 'row cache *' Waits; RAC may Hang
(Doc ID 2954678.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
The first symptoms of the problem may be seeing the following in the alert log, although there may also be messages about not being able to attach to an incoming connection, etc. Eventually ORA-445 will be seen.
You may see high 'latch: shared pool' and/or 'row cache mutex' waits, and a RAC instance may hang. If you have dynamic connection pooling configured and it's configured for more than 10 * <number of physical CPUs> on the node, you may also have a connection storm.
Changes
Upgrade to 19c, and often 19.17 or higher.
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 |