Home » RDBMS Server » Server Administration » sga_max_size (Oracle 10g Rel2, Linux AS4)
sga_max_size [message #362136] Mon, 01 December 2008 03:16 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi,

How do we configure the optimal value for sga_max_size . Is there any formula or any kind of base value for that.
I did read that it should not be more than 50% of our RAM, and in some read that it can be 10% of RAM for Limux systems . I'm bit confused on that .

Can somebody tell me how much will be optimal for OLTP database.

Kindly help me out .

Regards,
Raj
Re: sga_max_size [message #362142 is a reply to message #362136] Mon, 01 December 2008 03:24 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
As more as well, if the prod database is the only one application in server! But it should not exceed 75-80% physical RAM normally.
And this is my experience!
Re: sga_max_size [message #362147 is a reply to message #362142] Mon, 01 December 2008 03:34 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
There are other peoplesoft applications on that server.
Previous Topic: how many instances can be run in one server?
Next Topic: Undo Tablespace Full
Goto Forum:
  


Current Time: Mon Dec 05 06:57:58 CST 2016

Total time taken to generate the page: 0.09176 seconds