My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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.


 Upgrade to 19c, and often 19.17 or higher.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.