ORA-4031 on Shared Pool with High Allocation in PRTMV Even if Patch 20635353 is Applied (Doc ID 2517921.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

The following error occurs:

even if <Patch 20635353> is already applied.

Reference:

     <Bug 20635353> - High PRTMV Memory Allocations when Inserting into Partitioned Tables Simultaneously with Partition Maintenance Operations (<Note 20635353.8>)

Top pool memory allocations in shared pool shows as "PRTMV":

select name, round((bytes/1024/1024),0) MB
from v$sgastat where pool='shared pool'
and bytes > 10000000
order by bytes desc
/

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.