Database Memory & 4030/4031 (MOSC)

MOSC Banner

Does SGA and PGA memory goes hand-in-hand

edited Aug 29, 2013 7:26AM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered
We are on 11.2.0.3 database and we have a situation on this database where OEM advisory shows that our DB requires an increase in SGA to 17 GB but the PGA is perfectly fine. On this version , we have set the below parameters in the spfile as follows :
sga_target=9 GB
pga_aggreegate_target=4GB 

So my questions to the forum member is as follows ==> 
Que 1) If i approximately doubles the SGA of my system from 9 GB to 17 GB , then would that have any effect on my PGA?  Also, does increase in SGA also mandates increase/decrease in corresponding PGA as well. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center