My Oracle Support Banner

ORA-04031 with Allocation Comment "kglsim per-gran bkt" (Doc ID 1982979.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Instance startup with granule size equal to 4194304 bytes fails with error ORA-04031:

ORA-04031: unable to allocate 4795232 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim per-gran bkt")

 

Alert log shows following parameters:

sga_max_size             = 64G  
 _ksmg_granule_size       = 4194304

Trace file for the error ORA-04031 shows stack trace as:

 kgesec5 <- kghnospc <- kghalp <- kglsim_sga_init <- kqlnfy <- kscnfy <- ksmcsg

 

 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.