How Memory Is Allocated On DB Server Especially PGA? (Doc ID 2307182.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.