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: 65143
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: Fri Aug 18 13:31:37 CDT 2017

Total time taken to generate the page: 0.11226 seconds