Shared memory error
From: Pap <oracle.developer35_at_gmail.com>
Date: Wed, 15 Jun 2022 14:50:55 +0530
Message-ID: <CAEjw_firbckPuJAD_3DQ8dq=DuWyXpjBR6Kn3LZ6OsOnqUM6Wg_at_mail.gmail.com>
We are hitting below Ora-4031 in one customer database. Even we have 'free memory' available (~2GB) in shared_pool during the error. And also the size of the "KKSSP" sub pool and it was showing null value only. Its version 19.11 database has the below memory setup. We do see the resize operation in which the shared_pool_size was 12GB and was GROWing and db_cache was 2GB and was tryin to SHRINK and both errored out.
Date: Wed, 15 Jun 2022 14:50:55 +0530
Message-ID: <CAEjw_firbckPuJAD_3DQ8dq=DuWyXpjBR6Kn3LZ6OsOnqUM6Wg_at_mail.gmail.com>
We are hitting below Ora-4031 in one customer database. Even we have 'free memory' available (~2GB) in shared_pool during the error. And also the size of the "KKSSP" sub pool and it was showing null value only. Its version 19.11 database has the below memory setup. We do see the resize operation in which the shared_pool_size was 12GB and was GROWing and db_cache was 2GB and was tryin to SHRINK and both errored out.
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^3497","kglseshtTable")
memory_target - 0, memory_max_target - 0,sga_max_size - 35GB,sga_target - 0,shared_pool_size - 8GB,shared_pool_reserved_size - 1.2GB,_shared_pool_reserved_pct - 15,db_cache_size- 20GB
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 15 2022 - 11:20:55 CEST