Re: Advice on setting sga_max_size for ASM

check on MoS for document 1502764.1. You will find some info about ASM and ORA-4031 with 11.2.0.3. There are few bugs. Moreover the note 437924.1 talks about ASM and shared pools and which calculation you must do in order to avoid memory exhaustion. Also post the full error message, it's interesting to know which function is causing the error and in which moment (during a DG mount, a backup, normally,etc.)

Thanks
Ste

On 15 November 2012 01:09, 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.stefanocislaghi.eu

The SQLServerAgent service depends on the MSSQLServer service, which
has failed due to the following error: The operation completed
successfully.
--
http://www.freelists.org/webpage/oracle-l