Home » RDBMS Server » Performance Tuning » sga_max_size: Oracle reserves all at ones?
sga_max_size: Oracle reserves all at ones? [message #293589] Mon, 14 January 2008 03:37 Go to next message
Messages: 258
Registered: May 2007
Senior Member

I have a question, when using sga_max_size you set the maximum value for the SGA. I have 1GB of sga_max_size and sga_target 400M, will Oracle reserve 1GB immediately? Or will it only allocate more memory when it needs it?

Re: sga_max_size: Oracle reserves all at ones? [message #293592 is a reply to message #293589] Mon, 14 January 2008 03:41 Go to previous message
Michel Cadot
Messages: 65149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It allocates the maximum at startup (it seems to me that this changes in 11g for some platforms but I'm not sure).


[Updated on: Mon, 14 January 2008 03:41]

Report message to a moderator

Previous Topic: Tuning with Oracle Collections
Next Topic: Newbie: Query uses index and runs slow
Goto Forum:

Current Time: Mon Aug 21 14:38:44 CDT 2017

Total time taken to generate the page: 0.01434 seconds