ORA-4031 error for "PRTMV^hex-number", "Allocate kctph/ckyph/ckyprt array" in v18.104.22.168
(Doc ID 1203424.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
On RDBMS 11gR1 or 11gR2 up to v188.8.131.52, when attempting to perform a Partition operation (i.e. INSERT, LOCK TABLE), the following error occurs.
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","table-name","PRTMV^hex-number","Allocate kctph/ckyph/ckyprt array")
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document