OraFAQ Forum: Performance Tuning » MEMORY_TARGET and MEMORY_MAX

Home » RDBMS Server » Performance Tuning » MEMORY_TARGET and MEMORY_MAX_TARGET (11.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MEMORY_TARGET and MEMORY_MAX_TARGET [message #489382]

Sat, 15 January 2011 10:06

sean1970
Messages: 13
Registered: January 2010

Junior Member

Hi,
I have a confusion with MEMORY_TARGET and MEMORY_MAX_TARGET parameter. if i set SGA_TARGET, SGA_MAX_SIZE along with MEMORY_TARGET and MEMORY_MAX_TARGET then how oracle will manage the memory? Because as per my understanding if we set MEMORY_TARGET and MEMORY_MAX_TARGET then no need to set SGA and PGA because oracle will manage the memory.

Thanks,
-Sujith

Report message to a moderator

Re: MEMORY_TARGET and MEMORY_MAX_TARGET [message #489384 is a reply to message #489382]

Sat, 15 January 2011 10:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

If you don't answer our questions/requests, why should we answer yours?

When all else fails Read The Fine Manual
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams138.htm#sthref402

Report message to a moderator

Re: MEMORY_TARGET and MEMORY_MAX_TARGET [message #489390 is a reply to message #489382]

Sat, 15 January 2011 10:58

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please SEARCH before posting.
This has been asked and answered THIS WEEK.

http://www.orafaq.com/forum/mv/msg/164697/488533/102589/#msg_488533

Regards
Michel

Report message to a moderator

Re: MEMORY_TARGET and MEMORY_MAX_TARGET [message #489392 is a reply to message #489390]

Sat, 15 January 2011 11:15

sean1970
Messages: 13
Registered: January 2010

Junior Member

Thanks Michel. Next time i will search before posting.

Report message to a moderator

Previous Topic:	Confusion over Keep Cache (2 Merged)
Next Topic:	Avoid chain rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 16:56:34 CST 2025