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
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

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?

Regards
H
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: 64103
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).

Regards
Michel

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

Report message to a moderator

Previous Topic: Tuning with Oracle Collections
Next Topic: How get full data from table
Goto Forum:
  


Current Time: Sat Dec 03 10:20:29 CST 2016

Total time taken to generate the page: 0.07825 seconds