Hello Listers, It's a 4 node RAC database with version 11.2.0.4. It's using
ASMM. We saw queries failing with ORA-04031 error twice in the past , even
if the sum of all the components of the shared_pool was around ~15GB during
the time(with sga_target being set as ~100GB on each node). We are not
seeing any such spike/variation in overall usage of the shared_pool
components but still getting this below error intermittently. .
And i remember, we used to see the same error in few other databases in the
past, but there we used to see the component "KGH-NO ACCESS" of shared pool
used to grow rapidly chewing up all the sga memory. But in this case we are
not seeing such symptoms and we seem to have free memory left while it's
errored out. So wondering if there is any associated bug?
*Parameters from V$parameter:-*
sga_max_size - 120GB
sga_target - 100GB
shared_pool_size - 0
memory_target - 0
*Error:*
ORA-04031: unable to allocate 760 bytes of shared memory ("shared
pool","unknown object","KKSSP^847","kglss")
ORA-04031: unable to allocate 256 bytes of shared memory ("shared
pool","unknown object","KKSSP^1807","kgllk")
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Regards
Pap
