Re: Advice on setting sga_max_size for ASM
- From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
- To: mjalsingh@xxxxxxxxx
- Date: Tue, 15 Jan 2013 22:34:04 +0100
Hello,
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@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
>
>
--
http://www.stefanocislaghi.eu
The SQLServerAgent service depends on the MSSQLServer service, which
has failed due to the following error: The operation completed
successfully.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
