Advice on setting sga_max_size for ASM

From: Manmohan Jalsingh <>
Date: Wed, 14 Nov 2012 16:09:13 -0800
Message-ID: <>


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

Received on Thu Nov 15 2012 - 01:09:13 CET

Original text of this message