OraFAQ Forum: Server Administration » sga_max_size - how to find the max value for AIX 5L

Home » RDBMS Server » Server Administration » sga_max_size - how to find the max value for AIX 5L (Oracle 9i, AIX)

Mon, 06 October 2008 04:10

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.

Mon, 06 October 2008 04:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Most likely the limit is your RAM.

Regards
Michel

Mon, 06 October 2008 10:10

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.

Mon, 06 October 2008 10:21

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your title mention: "AIX 5L".
So you have the answer for "AIX 5L".

Regards
Michel

Mon, 06 October 2008 10:48

psoftneto
Messages: 44
Registered: July 2008

Member

Thanks Michel.

I thought there was a limit depending of the OS.

Mon, 06 October 2008 11:20

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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: Mon Feb 24 09:28:45 CST 2025