ORA-00604 and ORA-04031 Shared memory JDBC connection Pool Error
####<Dec
19, 2013 11:59:37 AM EST> <Warning> <JDBC>
<machinename> <AdminServer> <[ACTIVE]
ExecuteThread: '0' for queue: 'weblogic.kernel.Default
(self-tuning)'> <<anonymous>> <>
<f51b4d0bdea44d7a:-6c6d8c99:1430bcbacd0:-8000-0000000000000002>
<1387472377377> <WL-001129> <Received exception while creating connection for pool "XXXXX": 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(1,0)","kglsim object batch")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kglsim heap")
>
####<Dec 19, 2013 11:59:37 AM EST> <Info> <JDBC> <machinename> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <f51b4d0bdea44d7a:-6c6d8c99:1430bcbacd0:-8000-0000000000000002> <1387472377377> <WL-001156> <Stack trace associated with message 001129 follows:
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select decode(u.type#, 2, u...","sga heap(1,0)","kglsim object batch")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kglsim heap")
>
####<Dec 19, 2013 11:59:37 AM EST> <Info> <JDBC> <machinename> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <f51b4d0bdea44d7a:-6c6d8c99:1430bcbacd0:-8000-0000000000000002> <1387472377377> <WL-001156> <Stack trace associated with message 001129 follows:
1