No question at this time
DBA Top 10
1 B. Vroman 15100
2 M. Cadot 14200
3 A. Kavsek 9300
4 J. Schnackenberg 6100
5 T. Boles 5500
6 M. Hidayathullah ... 5400
7 P. Wisse 2500
8 T. P 900
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48179
Total active users1662
Act. users last 24h2
Act. users last hour0
Registered user hits last week193
Registered user hits last month1054
Go up

Enabling AMM automatic memory managment in oracle12c
Next thread: Explain Plan vs Actual Execution Plan
Prev thread: Facing issue during applying PSU Patch July-2017 patch 26609783

Message Score Author Date
Dear Friends, In our production server memory m...... Prasathi Ji Jan 12, 2018, 08:10
Hi Friends, pga_aggregate_limit is oracle12c pa...... Prasathi Ji Jan 12, 2018, 09:17

Follow up by mail Click here


Subject: Enabling AMM automatic memory managment in oracle12c
Author: Prasathi Ji, India
Date: Jan 12, 2018, 08:10, 101 days ago
Os info: RHEL Server release 6.8 (64bit)
Oracle info: oracle12c release 1
Message: Dear Friends,

In our production server memory management is static not dynamic.Automatic memory management is disabled.

We are planning to enable memory tuning and diagnostic pack.

Parameter Name Parameter Value
memory_target As per database current value
memory_max_target As per database current value
control_management_pack_access DIAGNOSTIC+TUNING
Statistics_level TYPICAL

Before enable AMM we are reviewing static parameter which is already set on Prod Server.
AMM is disabled :-

sga_max_size big integer 2512M
pga_aggregate_limit big integer 2G
pga_aggregate_target big integer 800M

java_pool_size big integer 64M
large_pool_size big integer 208M
shared_pool_size big integer 912M
streams_pool_size big integer 96M

------------------------------------------------------------------------------------------------
After AMM enabled:-

we set memory_max_target= sga_max_size + pga_aggregate_limit = 4GB;
or memory_max_target= sga_max_size + pga_aggregate_target=2.8GB but max size of PGA depends on pga_aggregate_limit.
and memory_target=2GB

After enabling AMM memory_max_target value must be 4GB or 2.8GB

But I feel that memory_max_target must be 4GB.
It is urgent.So please reply ...:-)

Thanks in advance

Regards
Prasathi
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Enabling AMM automatic memory managment in oracle12c
Author: Prasathi Ji, India
Date: Jan 12, 2018, 09:17, 100 days ago
Message: Hi Friends,

pga_aggregate_limit is oracle12c parameter which is set in production server because of this I have little confusion.

It is silly question but sorry for that.

Regards
Prasathi
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here