Advice on setting sga_max_size for ASM

From: Manmohan Jalsingh <mjalsingh_at_gmail.com>
Date: Wed, 14 Nov 2012 16:09:13 -0800
Message-ID: <CAOaH3=UFqfJQ+M4zEJ3LPMf81t_j7GkffNZ0QFzjGwhPYQ4TXQ_at_mail.gmail.com>

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

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

This message: [ Message body ]
Next message: De DBA: "OT? OVM repository lost - can we salvage the OVM pool?"
Previous message: Walker, Jed S: "v$rowcache outstanding_alerts"
Next in thread: Andy Gmail: "Re: Advice on setting sga_max_size for ASM"
Reply: Andy Gmail: "Re: Advice on setting sga_max_size for ASM"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message