RE: Advice on setting sga_max_size for ASM
Date: Thu, 15 Nov 2012 15:08:42 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD1121718AF_at_G5W2734.americas.hpqcorp.net>
Might be "Bug 14292825 - ORA-4031 in ASM as default memory parameters values for 11.2 ASM instances low" which basically states default allocation is incorrect, too low, and suggests 1024M.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Gmail
Sent: Wednesday, November 14, 2012 11:06 PM
To: mjalsingh_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Advice on setting sga_max_size for ASM
I would definitely go with what support says. But their official doc says the out of box parameters are fine....
Sent from my iPhone
On Nov 14, 2012, at 6:09 PM, Manmohan Jalsingh <mjalsingh_at_gmail.com> wrote:
> Hi
>
> I am getting "ORA-04031: unable to allocate 3896 bytes of shared"
> errors in the asm instance of a cluster node.
> Currently the SGA_MAX_SIZE is set to default value (400 MB) and there
> are about a dozen databases on the server.
> I am looking for some advice on the parameter. Support indicated 1GB
> is a good start.
>
> The grid/asm version is 11.2.0.3.
>
> Thanks & Regards
> Man mohan
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 15 2012 - 16:08:42 CET