Re: Sizing ASM memory
From: Andreas Piesk <a.piesk_at_gmx.net>
Date: Mon, 08 Oct 2012 19:26:56 +0200
Message-ID: <50730CE0.5040705_at_gmx.net>
On 08.10.2012 17:30, Niall Litchfield 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.
Date: Mon, 08 Oct 2012 19:26:56 +0200
Message-ID: <50730CE0.5040705_at_gmx.net>
On 08.10.2012 17:30, Niall Litchfield 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.
i changed our corporate default to 1G because asm upgrade 11.2.0.2 -> 11.2.0.3 failed with ora-4031, something you don't want to see during an upgrade.
there's a metalink document
Oracle Exadata Database Machine Grid Infrastructure Upgrade to 11.2.0.2 fails with ASM ORA-4031 [ID 1279525.1]
about the issue we had.
MfG,
-ap
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 08 2012 - 19:26:56 CEST