RE: Advice on setting sga_max_size for ASM
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Nov 2012 15:08:42 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Andy Gmail
Sent: Wednesday, November 14, 2012 11:06 PM
To: mjalsingh@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
