Home » RDBMS Server » Performance Tuning » SGA
SGA [message #253875] Wed, 25 July 2007 03:25 Go to next message
dirish
Messages: 205
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
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle rounds it up to the next granule.

Regards
Michel
Previous Topic: ARCH wait on SENDREQ
Next Topic: Database hanged
Goto Forum:
  


Current Time: Wed Dec 07 10:31:01 CST 2016

Total time taken to generate the page: 0.11694 seconds