No question at this time
DBA Top 10
1 M. Cadot 15900
2 A. Kavsek 11800
3 B. Vroman 10800
4 M. Hidayathullah ... 7600
5 T. Boles 4800
6 P. Wisse 4000
7 J. Schnackenberg 3000
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 700
9 T. P 700
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 users48114
Total active users1700
Act. users last 24h12
Act. users last hour1
Registered user hits last week507
Registered user hits last month1127
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, 5 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, 5 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