Re: Advice on setting sga_max_size for ASM

From: Stefano Cislaghi <>
Date: Tue, 15 Jan 2013 22:34:04 +0100
Message-ID: <>


check on MoS for document 1502764.1. You will find some info about ASM and ORA-4031 with 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.)


On 15 November 2012 01:09, Manmohan Jalsingh <> 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
> Thanks & Regards
> Man mohan
> --


The SQLServerAgent service depends on the MSSQLServer service, which
has failed due to the following error: The operation completed
Received on Tue Jan 15 2013 - 22:34:04 CET

Original text of this message