Re: what is the parameter to throttle back how often Oracle ASMM/AMM resize ops run?
From: onedbguru <onedbguru_at_yahoo.com>
Date: Fri, 22 Jul 2011 13:43:01 -0700 (PDT)
Message-ID: <e81e0064-082c-45db-8663-d32b6fd14210_at_q5g2000yqj.googlegroups.com>
On Jul 22, 4:11 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "John Hurley" <hurleyjo..._at_yahoo.com> a écrit dans le message de news:
> 58d62a85-7cdc-4227-9922-7d5244413..._at_d1g2000yqm.googlegroups.com...
> | 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
>
> v$sga_resize_ops
>
> Regards
> Michel
Date: Fri, 22 Jul 2011 13:43:01 -0700 (PDT)
Message-ID: <e81e0064-082c-45db-8663-d32b6fd14210_at_q5g2000yqj.googlegroups.com>
On Jul 22, 4:11 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "John Hurley" <hurleyjo..._at_yahoo.com> a écrit dans le message de news:
> 58d62a85-7cdc-4227-9922-7d5244413..._at_d1g2000yqm.googlegroups.com...
> | 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
>
> v$sga_resize_ops
>
> Regards
> Michel
v$sga_resize_ops is the view that tells you how frequently it is doing the resize. I believe the parameter is _memory_broker_stat_interval. Received on Fri Jul 22 2011 - 15:43:01 CDT