Shared Pool Memory Errors Occur In Logfiles

(Doc ID 1058336.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 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***


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.


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