Re: Sizing ASM memory

From: Nilo Segura <nilosegura_at_gmail.com>
Date: Mon, 8 Oct 2012 19:54:31 +0200
Message-ID: <CAO8HWHa6TMoqcEKz_L42X1cBSDFb+0hP4Fqf6rNGpbEMeeNYig_at_mail.gmail.com>

This patch was released last Wednesday 11.2.0.3 on Linux x86-64 bits. Maybe for others as well.
14292825: DEFAULT MEMORY PARAMETER VALUES FOR 11.2 ASM INSTANCES LOW probably related...

On Mon, Oct 8, 2012 at 7:29 PM, Martin Berger <martin.a.berger_at_gmail.com>wrote:

> Niall,
> I have opened a SR as I had an ORA-04031
>
>
> "large
>
>
> pool"
>
> in 11.2.0.2 - Now I'm proud sponsor of Bug:11684854 .
> Our workaround is to set set large_pool_size=100M manually (and SGA to
> 1G).
>
> Maybe you have similar problems, then a similar solution might work.
>
> hth
> Martin
>
>
> On Mon, Oct 8, 2012 at 5:30 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com
> > wrote:
>
> > Does anyone have any guidelines/docs on sizing memory for ASM instances?
> > Note 437924.1 basically says "Use the default of 272mb and you will be
> fine
> > in all circumstances, and if you aren't log an SR" Having just had a
> > 11.2.0.2 instance crash taking out 6 db instances as a result of a 4031
> I'm
> > interested in any ways of estimating requirements. 272 plainly wasn't
> > enough as even a restart didn't help, whereas upping the allocation to
> > 500mb worked fine.
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Nilo Segura
Oracle Support - IT/DB
CERN - Geneva
Switzerland


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 08 2012 - 19:54:31 CEST