ORA-04031: unable to allocate 40 bytes of shared memory (“shared pool”,”unknown
object”,”KGLH0^92c529c4″,”kglHeapInitialize:temp”)

Cause:

This error is common which occur due to shortage of memory and manual memory configuration

SQL> show parameter sga_target
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","unknown
object","KGLH0^92c529c4","kglHeapInitialize:temp")


SQL> alter system set sga_target=3000M scope=spfile;

System altered.

SQL> alter system set sga_max_size=3500M scope=spfile;

System altered.

SQL> alter system set inmemory_size=2000M scope=spfile;

System altered.

SQL> startup force;
ORACLE instance started.

Total System Global Area 3670013776 bytes
Fixed Size                  9172816 bytes
Variable Size             826277888 bytes
Database Buffers          734003200 bytes
Redo Buffers                3407872 bytes
In-Memory Area           2097152000 bytes
Database mounted.
Database opened.

Solution:

Increase memory or adjust memory by reducing the required pools

Leave a Reply