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

Report message to a moderator

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: 68665
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:15:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.