Re: what is the parameter to throttle back how often Oracle ASMM/AMM resize ops run?

From: TheBoss <>
Date: 22 Jul 2011 20:43:03 GMT
Message-ID: <Xns9F2AE71C7CD0CTheBossUsenet_at_194.109.133.133>

Charles Hooper <> wrote in news:60ebe3ad-f1bd-4c16-

> On Jul 22, 2:00 pm, John Hurley <> 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:
> (see the
> Update note)
> ---
> You might also be thinking of the _memory_imm_mode_without_autosga
> parameter, described here:
> ---
> 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 ...


Received on Fri Jul 22 2011 - 15:43:03 CDT

Original text of this message