Re: High Number of undo writes
Date: Tue, 22 May 2012 13:52:55 +0530
Message-ID: <CAJsOtB5jhpAjcCLQod-aW5BnMu+dedvYKuZKie3Y96Q89omwkg_at_mail.gmail.com>
yes, Purav..those links are for ASSM and not for ASMM..mostly I copied the different link..
http://orachat.com/oracle-11g-feature-amm-restart/
to avoid further confusion I am copying the text from the above link..the tone is be cautious ..even if ASMM is disabled..
Quote
This post is from one of the emails I have recieved from my friend Mackenzie D’Cruz, he experienced this issue on his production environment.This information is published by Don Burleson at http://www.dba-oracle.com. So this is just a copy to let our readers know about this issue.
Beware, following new upgrades to 11gR2, you can find that AMM has reappeared, even if you think that you have disabled it.
Oracle Automatic Shared Memory Management (ASMM) was introduced in Oracle 10g for small databases where a one-sized-fits-all approach was used in small hands-off databases that did not have a DBA to intelligently allocate the SGA pools.
When a small system has a too small RAM region for the SGA, Oracle AMM will cause a performance problem with RAM thrashing and it tries to readjust all of the RAM regions.
In all large mission-critical databases, the DBA will disable AMM because an intelligent human will always do a better job than a simple software solution, especially when you need to intelligently reconfigure the SGA in anticipation of a changing workload.
The following references will be helpful in researching the behavior of AMM:
- Never use AMM with Linux hugepages<http://www.dba-oracle.com/oracle_news/news_linux_hugepages_asmm_memory.htm>
- Review these important notes<http://www.dba-oracle.com/t_amm_automatic_vs_manual_ram_pools.htm> on when to turn AMM off.
- Consult related notes<http://dba-oracle.com/googlesearchsite_proc.htm?cxon using AMM in large production databases.
Disabling AMM in Oracle 11g Release 2
You can enable and disable AMM by changing the value of these parameters to non-zero settings:
- sga_target
- sga_max_size
- pga_aggregate_target
- sga_max_size
- db_cache_size
- shared_pool_size
- java_pool_size
nfortunately a new feature in 11gR2 turns AMM on unless a hidden parameter called _memory_imm_mode_without_autosga is set to FALSE.
Important 11gR2 Note: Even if AMM has been disabled in Oracle 10g, AMM may reappear in Oracle 11g unless the following parameter is set:
alter system set “_memory_imm_mode_without_autosga”úLSE scope=both;
There is a MOSC note about AMM in 11gR2 that notes that this regression back to AMM is the expected behavior in 11.2 for immediate memory allocation requests and that Oracle added this behavior as a 11gR2 new feature when automatic memory management was disabled.
The 11.2 Oracle support metalink note on AMM regression is note number<https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id69139.1> 1269139.1<https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id69139.1>, titled:
SGA Re-Sizes Occurring Despite AMM/ASMM Being
Disabled(MEMORY_TARGET/SGA_TARGET=0)
UnQuote
On 21 May 2012 13:32, Purav Chovatia <puravc_at_gmail.com> wrote:
> Hi Subodh,
>
> thanks but the last 2 links are on ASSM whereas I was talking about ASMM
> i.e. Automatic Shared Memory Management.
>
> regards
>
>
> On Thu, May 17, 2012 at 9:49 PM, Subodh Deshpande <
> deshpande.subodh_at_gmail.com> wrote:
>
>> what sga size you gave for new instance while installing
>>
>> here are some few links, about ASSM there are various opinions I think..
>>
>> https://forums.oracle.com/forums/thread.jspa?threadIDi5072
>>
>>
>> http://hemantoracledba.blogspot.in/2008/08/assm-or-mssm-impact-on-inserts.html
>>
>> http://www.dba-oracle.com/art_builder_assm.htm
>>
>>
>>
>
-- ============================================= Love me or Hate me both are in my Favour. Love me, I am in your Heart. Hate me, I am in your Mind. ============================================= -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 22 2012 - 03:22:55 CDT