My Oracle Support Banner

ORA-04031 during instance startup (nomount stage) IF INMEMORY_SIZE >= 50% of MEMORY_TARGET (Doc ID 2618003.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.5.0.0.0 [Release 12.1 to 19]
Information in this document applies to any platform.

Symptoms

 

ORA-04031 during instance startup (nomount stage) IF INMEMORY_SIZE >= 50% of MEMORY_TARGET

Example
=====
memory_target = 40G
memory_max_target = 40G
inmemory_size = 20G

SQL> startup nomount
ORA-04031: unable to allocate 220160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kghx free lists")

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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