Re: Sizing ASM memory

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 8 Oct 2012 15:29:56 -0400
Message-ID: <CAGurbTO5w1fBR9-jNztpT_aUskMfbFOhrGYrWnYHbDCEWtZy7g_at_mail.gmail.com>



Niall,

The formula seems to be

  1. If PROCESSES parameter is explicitly set: The MEMORY_TARGET should be set to no less than: 256M + (PROCESSES*132K) -- (64bit) or 256M + (PROCESSES*120K) -- (32bit)
  2. If PROCESSES parameter is not set: The MEMORY_TARGET should be set to no less than: 256M + ((available_cpu_cores * 80 + 40) * 132K) -- (64bit) or 256M + ((available_cpu_cores * 80 + 40) * 120K) -- (32bit)

so if you have 1000 processes set then for 64 bit then your memory_target becomes (256*1024)+(1000*132) K in size, which is about 384M, for ASM that is a bit of a jump from 256M..

I think it is plus (integer * multipled by 132k) not plus 132k.

oh well, we tried.
Raj

On Mon, Oct 8, 2012 at 3:18 PM, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> Hi Raj
>
> I don't find that a great formula since it boils down to 256 (mb) plus
> integer plus 132 (kb). Which for all reasonable CPU cores per server is less
> than 272mb unless there's a missing unit per process. Any time I see two
> different units added together in a 'formula' my hackles rise....
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 08 2012 - 21:29:56 CEST

Original text of this message