My Oracle Support Banner

SGA_MAX_SIZE/MEMORY_MAX_TARGET Preallocated In 12.1.0.2 On AIX (Doc ID 2329122.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On AIX 7.1 platform, after upgrading from Oracle 11.2.0.4 to Oracle 12.1.0.2 noticed database uses much more Memory than before, right after startup.

It is noticed memory reserved/used for SGA is larger than SGA_TARGET. Specifically it is observed that up to SGA_MAX_SIZE is actually allocated out from the OS.

Testcase to illustrate the same:

 

Changes

 Upgrade to 12c

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.