Home » Other » General » max size of SGA (Oracle 11G, Solaris 10, x86 processor)
max size of SGA [message #513985] Thu, 30 June 2011 09:22 Go to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Hi all,

What is the maximum size of SGA memory for Oracle 11G can be define on x86 processor?

Thx
Re: max size of SGA [message #513989 is a reply to message #513985] Thu, 30 June 2011 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What is the maximum size of SGA memory for Oracle 11G can be define on x86 processor?

when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/limits004.htm#i288165
Re: max size of SGA [message #523589 is a reply to message #513985] Mon, 19 September 2011 07:29 Go to previous messageGo to next message
mjana
Messages: 1
Registered: September 2011
Location: hyderabad
Junior Member
sga_max_size;

alter system set sga_max_size
Re: max size of SGA [message #523590 is a reply to message #523589] Mon, 19 September 2011 07:31 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How does this give you the maximum size you can set for a x86 processor?

Regards
Michel
Previous Topic: please tell me
Next Topic: oracle database migration issues (merged 2)
Goto Forum:
  


Current Time: Thu Mar 28 06:28:32 CDT 2024