Link to home
Create AccountLog in
Avatar of joe_echavarria
joe_echavarriaFlag for Dominican Republic

asked on

Difference between the sga_target and sga_max_size

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.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account