We help IT Professionals succeed at work.

Difference between the sga_target and sga_max_size

joe_echavarria
on
Medium Priority
2,234 Views
Last Modified: 2012-05-12
Hi,

  I will appreciate to know about this two parameters :

     - The difference of each one.
     - What they do each one.
     - If i have set sga_target to 2 G and sga_max_size to 8 G, what is really the memory allocated by the SGA ?
     - Does it matter to increase the sga_max_size but not to increase the sga_target ?
     - I need to increse both parameters to have a better performance ?

Thanks  for the help.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
The online documentation goes into great detail on what these parameters are.

I suggest you start there.

>> I need to increse both parameters to have a better performance

Maybe.  Maybe not.  It depends on where your performance problems are.

There is also a point where more memory will not affect performance.

A tuning strategy will help you figure this out.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented: