Shared memory error
Date: Tue, 4 May 2021 18:32:13 +0530
Message-ID: <CAEjw_fgAXQGnyf6AfJuj_YYJYma6dB=FfZoD-bAhbRv=pAfbxw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 04 2021 - 15:02:13 CEST