My Oracle Support Banner

Guided SR: Out Of Memory Errors (Doc ID 1547014.1)

Last updated on OCTOBER 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The following error is raised on the Streams pool when using the Oracle Messaging Gateway:

ORA-04031: unable to allocate 152 bytes of shared memory ("streams pool","unknown object","streams pool","KWQDL hash ta")

Analysis of the generated trace file shows a large allocation of the "KWQDL hash ta" heap and hardly any free space in the pool.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.