Home » RDBMS Server » Server Administration » sga_max_size - how to find the max value for AIX 5L (Oracle 9i, AIX)
sga_max_size - how to find the max value for AIX 5L [message #352119] Mon, 06 October 2008 04:10 Go to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi all,

I would like to know how we can find the max value from sga_max_size depending of the OS.
Thanks for you response.
Re: sga_max_size - how to find the max value for AIX 5L [message #352123 is a reply to message #352119] Mon, 06 October 2008 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Most likely the limit is your RAM.

Regards
Michel
Re: sga_max_size - how to find the max value for AIX 5L [message #352192 is a reply to message #352123] Mon, 06 October 2008 10:10 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
I heart that for Linux 32 bit, one process can not use more than 2,7 Go RAM.
Re: sga_max_size - how to find the max value for AIX 5L [message #352200 is a reply to message #352192] Mon, 06 October 2008 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your title mention: "AIX 5L".
So you have the answer for "AIX 5L".

Regards
Michel
Re: sga_max_size - how to find the max value for AIX 5L [message #352206 is a reply to message #352200] Mon, 06 October 2008 10:48 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Thanks Michel.

I thought there was a limit depending of the OS.
Re: sga_max_size - how to find the max value for AIX 5L [message #352211 is a reply to message #352206] Mon, 06 October 2008 11:20 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is and so you had the answer for the OS you mentioned.

Regards
Michel
Previous Topic: ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'
Next Topic: LISTENER consuming 95% CPU
Goto Forum:
  


Current Time: Sun Dec 04 08:43:00 CST 2016

Total time taken to generate the page: 0.08185 seconds