Re: Advice on setting sga_max_size for ASM

From: Andy Gmail <andrew.kerber_at_gmail.com>
Date: Wed, 14 Nov 2012 22:05:35 -0600
Message-Id: <305A71CA-F40F-437A-8F1F-BA7638D56CBA_at_gmail.com>

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

Received on Thu Nov 15 2012 - 05:05:35 CET