Re: ASM Memory Sizing

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 22 Aug 2012 17:45:09 -0500
Message-ID: <CAJvnOJbb-NHX229cPQaLYAN5jMW+bzWAQC2tX25syf9UcNAEGA_at_mail.gmail.com>



See metalink note 437924.1. Its fairly comprehensive. Basically it says use the default parameters, then explains what to do if you dont use them.

On Tue, Aug 21, 2012 at 11:32 PM, K Gopalakrishnan <kaygopal_at_gmail.com>wrote:

> Hemant,
>
> It depends on the size of the database and redundancy level, not based
> on the number of data files and concurrent sessions
>
> IIRC the conservative estimate is 3MB/100GB in external redundancy.
> Multiple the numbers by number of fail groups (in case of external or
> high).
>
> Also the ASM AU size plays a bigger role in shared pool usage.
>
> -Gopal
> .
>
>
> On Tue, Aug 21, 2012 at 9:29 PM, Hemant K Chitale
> <hemantkchitale_at_gmail.com> wrote:
> > Are there any guidelines for sizing memory (SHARED_POOL_SIZE) for an ASM
> > Instance ?
> > Say for an ASM Instance that has 1 DiskGroup supporting a Database
> instance
> > with 320 datafiles and 1600 concurrent sessions ?
> > --
> > Hemant K Chitale
> > http://hemantoracledba.blogspot.com
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2012 - 17:45:09 CDT

Original text of this message