Last updated on APRIL 23, 2015
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.5 to 11.1]
Information in this document applies to any platform.
ORA-4031 errors occur periodically in the shared pool when using Java stored procedures. This will typically shows errors such as:
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","sql area","tmp")
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms