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@xxxxxxxxx> 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.... > -- //www.freelists.org/webpage/oracle-l