Re: Sizing ASM memory

  • From: Nilo Segura <nilosegura@xxxxxxxxx>
  • To: martin.a.berger@xxxxxxxxx
  • Date: Mon, 8 Oct 2012 19:54:31 +0200

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@xxxxxxxxx>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@xxxxxxxxx
> > 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
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


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


Other related posts: