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: 63911
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: How get full data from table
Goto Forum:

Current Time: Sat Oct 22 15:19:06 CDT 2016

Total time taken to generate the page: 0.24847 seconds