Re: Sizing ASM memory

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Mon, 8 Oct 2012 19:29:14 +0200
Message-ID: <CALH8A920_Wz87nuYNigQYDzjFbyeibjjU8P62L9Ft3qWtc6L-Q_at_mail.gmail.com>

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

Received on Mon Oct 08 2012 - 19:29:14 CEST