| SGA [message #253875] |
Wed, 25 July 2007 03:25  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Oracle rounds it up to the next granule.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
