Home » RDBMS Server » Performance Tuning » SGA
SGA [message #253875] Wed, 25 July 2007 03:25 Go to next message
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;

sga_max_size 605521496

This is an extract of my init file:


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

Re: SGA [message #253878 is a reply to message #253875] Wed, 25 July 2007 03:35 Go to previous message
Michel Cadot
Messages: 64623
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle rounds it up to the next granule.

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

Current Time: Thu Mar 30 01:47:29 CDT 2017

Total time taken to generate the page: 0.08797 seconds