Shared pool error even it shows enough free memory
From: Lok P <loknath.73_at_gmail.com>
Date: Thu, 2 Jun 2022 17:31:03 +0530
Message-ID: <CAKna9VZ19QzUTHhk3M3ZjJK26SMazi9REPvKyro942652kYjyQ_at_mail.gmail.com>
Hello Listers. Its oracle version is 19.11. We are suddenly seeing many queries failing with Ora-04031 even if we see the "free memory" as ~5GB in v$sgastat where pool='shared pool'. We then flushed the shared pool and also increased the shared pool size to 8GB from initial 6GB, and things ran fine for a couple of hours but we again encountered the same error after a couple of hours of good run. What could be the cause?
Date: Thu, 2 Jun 2022 17:31:03 +0530
Message-ID: <CAKna9VZ19QzUTHhk3M3ZjJK26SMazi9REPvKyro942652kYjyQ_at_mail.gmail.com>
Hello Listers. Its oracle version is 19.11. We are suddenly seeing many queries failing with Ora-04031 even if we see the "free memory" as ~5GB in v$sgastat where pool='shared pool'. We then flushed the shared pool and also increased the shared pool size to 8GB from initial 6GB, and things ran fine for a couple of hours but we again encountered the same error after a couple of hours of good run. What could be the cause?
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","IDX1","pacdHds_kkpaco","kksgaAlloc: firstN")
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 02 2022 - 14:01:03 CEST