Shared Pool Memory Errors Occur In Logfiles

(Doc ID 1058336.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5.05.06 to 6.2.7 [Release 5.5 to 6.2]
Information in this document applies to any platform.
***Checked for relevance on 21-May-2014***

Symptoms


The system is running out of Shared Memory Pool throwing an error similar to this:

java.sql.SQLException: ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","update order_release_line se...","sga heap(2,0)","library cache")

This can happen when users attempt to update Order Releases, Shipments, Invoices, etc., anytime when data is updated or inserted. It applies for the entire application since there is no more memory in the Shared Pool.

Cause

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 hundreds of Community platforms