Re: ASM Memory Sizing

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Tue, 21 Aug 2012 23:32:30 -0500
Message-ID: <CAN5iexFyQw8XcQixazNhHdmqK_ue+6NUsq_g77RVD-UEdRO-rg_at_mail.gmail.com>

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

Received on Tue Aug 21 2012 - 23:32:30 CDT

This message: [ Message body ]
Next message: Nisha Mohan: "RMAN error"
Previous message: Hemant K Chitale: "ASM Memory Sizing"
In reply to: Hemant K Chitale: "ASM Memory Sizing"
Next in thread: Andrew Kerber: "Re: ASM Memory Sizing"
Reply: Andrew Kerber: "Re: ASM Memory Sizing"

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

Original text of this message