ORA-04031: unable to allocate 3896 bytes of shared memory
Issue
- JON does not seem to use bind variables for its queries to the Oracle DB
- The error on the client side is:
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select decode(u.type#, 2, u...","sga heap(3,0)","kglsim object batch")
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kglsim object batch")
Environment
- Red Hat JBoss Operations Network (ON) 3.3.5
- Oracle Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
