Re: what is the parameter to throttle back how often Oracle ASMM/AMM resize ops run?
From: TheBoss <TheBoss_at_invalid.nl>
Date: 22 Jul 2011 20:43:03 GMT
Message-ID: <Xns9F2AE71C7CD0CTheBossUsenet_at_194.109.133.133>
Charles Hooper <hooperc2001_at_gmail.com> wrote in news:60ebe3ad-f1bd-4c16- a718-688b08d2f2ea_at_15g2000vbw.googlegroups.com:
>
> A bit of Google digging found a couple that might be what you are
> remembering.
> You might be thinking of _memory_broker_stat_interval, which I found
> briefly described in these two articles:
> http://jonathanlewis.wordpress.com/2007/04/16/sga-resizing/ (see the
> Update note)
> http://www.bluegecko.net/oracle/ora-04031-and-asmm/
>
> ---
> You might also be thinking of the _memory_imm_mode_without_autosga
> parameter, described here:
> http://www.ora600.be/category/blog/memoryimmmodewithoutautosga
>
> ---
>
> John, I know that you are aware of this, but just a warning for anyone
> else who might read this message in the future. Changing hidden
> parameters should only be performed after consulting with Oracle
> support. Just because 2 or 3 articles describe a hidden parameter in
> a similar fashion, it is not automatically safe to assume that the
> hidden parameter could be safely modified without undesirable side-
> effects.
>
Date: 22 Jul 2011 20:43:03 GMT
Message-ID: <Xns9F2AE71C7CD0CTheBossUsenet_at_194.109.133.133>
Charles Hooper <hooperc2001_at_gmail.com> wrote in news:60ebe3ad-f1bd-4c16- a718-688b08d2f2ea_at_15g2000vbw.googlegroups.com:
> On Jul 22, 2:00 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>> Sorry having trouble finding it at the moment. Working on a >> presentation ... not a big fan of AMM and/or ASMM anyway. >> >> There is some kind of parameter ( maybe underscore parameter ) to have >> Oracle back off how often it does the resizing of SGA stuff ... anyone >> remember what that is? >> >> Thanks in advance
>
> A bit of Google digging found a couple that might be what you are
> remembering.
> You might be thinking of _memory_broker_stat_interval, which I found
> briefly described in these two articles:
> http://jonathanlewis.wordpress.com/2007/04/16/sga-resizing/ (see the
> Update note)
> http://www.bluegecko.net/oracle/ora-04031-and-asmm/
>
> ---
> You might also be thinking of the _memory_imm_mode_without_autosga
> parameter, described here:
> http://www.ora600.be/category/blog/memoryimmmodewithoutautosga
>
> ---
>
> John, I know that you are aware of this, but just a warning for anyone
> else who might read this message in the future. Changing hidden
> parameters should only be performed after consulting with Oracle
> support. Just because 2 or 3 articles describe a hidden parameter in
> a similar fashion, it is not automatically safe to assume that the
> hidden parameter could be safely modified without undesirable side-
> effects.
>
Changing the hidden parameter _MEMORY_BROKER_STAT_INTERVAL is actually
described in MOS as a work-around for cases where V$SGA_RESIZE_OPS shows
alternating shared pool and buffer cache resizes within minutes of each
other. See MOS-note 7189722.8
The command used there is:
alter system set "_memory_broker_stat_interval"=999; --- 999sec
Note however that this only seems valid for 10g, not 11g ...
HTH
-- JeroenReceived on Fri Jul 22 2011 - 15:43:03 CDT