SGA [message #253875] |
Wed, 25 July 2007 03:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi Friends,
on a sun solaris server running oracle 9 I want to increase the SGA.
I have gather these details.
Physical Memory: 3GB = 3 000 000 000 bytes
SQL> show parameter sga_max_size;
NAME VALUE
sga_max_size 605521496
This is an extract of my init file:
sga_max_size=600000000
This means that this parameter (sga_max_size)should be modified?
Also how can i calculate the maximum sga_max_size i can set?
Thank you
Dirish
|
|
|
Re: SGA [message #253878 is a reply to message #253875] |
Wed, 25 July 2007 03:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Oracle rounds it up to the next granule.
Regards
Michel
|
|
|