OraFAQ Forum: Performance Tuning » Memory issue with PGA and AMM (merged)

Home » RDBMS Server » Performance Tuning » Memory issue with PGA and AMM (merged) (12.1.0.2.0,Oracle Linux 7,x86_64)

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

Memory issue with PGA and AMM (merged) [message #643638]

Wed, 14 October 2015 10:00

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Total Server memory is 64GB and i am using AMM with Memory_Target set to 32GB
The AMM automatically allocates SGA of 10GB and PGA_aggregate_target of 30GB.
I checked the total session PGA usage which is aggregating to 2Gb.

My quest is why the PGA_aggregate_target goges over the Memory_Target limit as it should be Memory_Target minus SGA.
Also when the session PG is only 2GB then where is the rest PGA_aggregate_target of 30GB being used any why do we have memory issues ?

Report message to a moderator

Re: Memory issue with PGA and AMM [message #643639 is a reply to message #643638]

Wed, 14 October 2015 10:11

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

Senior Member

Please can you show the queries you are running that give you this information?

Report message to a moderator

More PGA allocated than SGA [message #643778 is a reply to message #643638]

Sun, 18 October 2015 02:21

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Using the AMM with Memory_Target=128GB
The Enterprise Manager Memory Advisor graph shows 70% memory used for the PGA and only 30% for SGA.
Anyone knows the reason why it shows such a high amount of PGA aloocation whereas normally it should be 20% for PGA and rest for SGA ?

Report message to a moderator

Re: More PGA allocated than SGA [message #643779 is a reply to message #643778]

Sun, 18 October 2015 03:16

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

Senior Member
Account Moderator

Not it should not be it depends on what you do.
And, as this is the same question than your previous topic, I'll merge both.
You know you MUST NOT do that but answer the questions that are posted to you.

Report message to a moderator

Previous Topic:	Please help for Tuning sql Query.
Next Topic:	A SQL query with self join and analytical function is running slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 13:39:21 CST 2025