OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sga limit

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sga limit [message #62480]

Fri, 23 July 2004 07:23

shyam
Messages: 25
Registered: January 2001

Junior Member

hi friends
i am working on solaris 5.9 and oracle 8i.WE have 512 mb ram.Now had
allocated sga to 128 mb.This is the only one database in the server (its a old server)>What's the maximum that i can allocate to this db.Shall i allocate around 200mb to SGA
with regards
shyam

Report message to a moderator

Re: sga limit [message #62482 is a reply to message #62480]

Fri, 23 July 2004 07:49

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

hi..
first sga limit is not depend upon ram but it will effect the performance of your server..

if your ram size is 128mb and you have design total sga size=200mb.then more swapping will occur to satisfy the requriment ..so your server will perform poor. normally choose your sga size less than your ram size..

hope u will get some from this.

Report message to a moderator

Re: sga limit [message #62492 is a reply to message #62482]

Fri, 23 July 2004 23:02

shyam
Messages: 25
Registered: January 2001

Junior Member

hi freind

My ram size is 512 not 128 so shall i increase the current sga max size (128) to 200 or any problems
shyam

Report message to a moderator

Re: sga limit [message #62509 is a reply to message #62492]

Sun, 25 July 2004 22:46

BhavinShah
Messages: 105
Registered: February 2004

Senior Member

is any other application is running on ur server.???

if only oracle is running on ur server then u can set ur sga size to 200mb.

Report message to a moderator

Re: sga limit [message #62863 is a reply to message #62480]

Fri, 20 August 2004 06:27

Balaji
Messages: 102
Registered: October 2000

Senior Member

Hi Shyam

the practive is to allocate about 50% of the RAM to the SGA if you do not have any other application hosted on the machine and the instances hosted are 1 .
so try with a 256MB SGA .

hppe this works better
with best wishes

balaji

Report message to a moderator

Previous Topic:	ORA-00313, ORA-00312 & ORA-07360
Next Topic:	Migration from 8.1.7.4 to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 14:54:44 CST 2025