How Memory Is Allocated On DB Server Especially GPA?

(Doc ID 2307182.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle Communications ASAP - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Goal

Here is what we want to understand, if you see the difference between 5 and 6, you see  that in #6,  ASAP is started. So we see the memory increasing  from 21G to 29G. PGA allocation is only 4.3 GB, SGA was from 14.7 , so from where did additional 3.7G get allocated in the  DB server?

No. Event                                                     Memory Utilized                             # of Connections
1 Before Server Restart                                     30G                                               3238
2 After ASAP Application Shutdown                    21G                                                470
3 After DB Shutdown                                        20G                                                401
4 After Reboot                                                  20G                                                386
5 After DB Restart                                             21G                                   No data captured
6 After ASAP Application Start                            29G                                               3175

Please find the Current SGA and PGA allocation.

 
INSTANCE_NUMBER SGA PGA     TOT TIME
--------------- ---------- ---------- ------- ---------
1                        14717  4321 19038 24-Aug-17

SGA Max Size is defined as 20G
SGA Target is defined as 15G
PGA Aggregrate Limit = 10G
PGA Aggregrate Target = 10G
 

Solution

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