Home » RDBMS Server » Server Administration » Automamtic memory Management (11.2.0.3)
Automamtic memory Management [message #666836] Tue, 28 November 2017 04:28 Go to next message
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
Re: Automamtic memory Management [message #666837 is a reply to message #666836] Tue, 28 November 2017 04:47 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Automamtic memory Management [message #666838 is a reply to message #666837] Tue, 28 November 2017 04:58 Go to previous messageGo to next message
sukdeepds@gmail.com
Messages: 2
Registered: November 2017
Junior Member
THank you for the confirmation
Re: Automamtic memory Management [message #666843 is a reply to message #666836] Tue, 28 November 2017 06:29 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
https://community.oracle.com/thread/4101608
Re: Automamtic memory Management [message #667160 is a reply to message #666843] Tue, 12 December 2017 00:46 Go to previous message
AnnabellB
Messages: 1
Registered: December 2017
Junior Member
THank you for the confirmation
Previous Topic: global temporay table does not work!
Next Topic: which one should be install first
Goto Forum:
  


Current Time: Thu Mar 28 07:07:19 CDT 2024