SGA_MAX_SIZE/MEMORY_MAX_TARGET Preallocated In 220.127.116.11 On AIX
Last updated on NOVEMBER 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
On AIX 7.1 platform, after upgrading from Oracle 22.214.171.124 to Oracle 126.96.36.199 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:
Upgrade to 12c
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms