My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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.

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!


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