OraFAQ Forum: Server Administration » Automamtic memory Management

Home » RDBMS Server » Server Administration » Automamtic memory Management (11.2.0.3)

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

Automamtic memory Management [message #666836]

Tue, 28 November 2017 04:28

sukdeepds@gmail.com
Messages: 2
Registered: November 2017

Junior Member

Is SGA is constrained to 22 GB in thE below setting . To make SGA + PGA complete autotune and to use 60 GB under AMM does sGA_MAX_TARGET is to be set zero

Version : 11.2.0.3
SGA_MAX_SIZE=22400M
SGA_TARGET=0
MEMORY_TARGET=60
MEMORY_MAX_SIZE=60G

Report message to a moderator

Re: Automamtic memory Management [message #666837 is a reply to message #666836]

Tue, 28 November 2017 04:47

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Quote:

Is SGA is constrained to 22 GB in thE below setting

Yes.

Quote:

To make SGA + PGA complete autotune and to use 60 GB under AMM does sGA_MAX_TARGET is to be set zero

Yes.

Report message to a moderator

Re: Automamtic memory Management [message #666838 is a reply to message #666837]

Tue, 28 November 2017 04:58

sukdeepds@gmail.com
Messages: 2
Registered: November 2017

Junior Member

THank you for the confirmation

Report message to a moderator

Re: Automamtic memory Management [message #666843 is a reply to message #666836]

Tue, 28 November 2017 06:29

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

https://community.oracle.com/thread/4101608

Report message to a moderator

Re: Automamtic memory Management [message #667160 is a reply to message #666843]

Tue, 12 December 2017 00:46

AnnabellB
Messages: 1
Registered: December 2017

Junior Member

THank you for the confirmation

Report message to a moderator

Previous Topic:	global temporay table does not work!
Next Topic:	which one should be install first

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:43:14 CST 2025