Re: Advice on setting sga_max_size for ASM
- From: Andy Gmail <andrew.kerber@xxxxxxxxx>
- To: "mjalsingh@xxxxxxxxx" <mjalsingh@xxxxxxxxx>
- Date: Wed, 14 Nov 2012 22:05:35 -0600
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
Other related posts:
