Re: Memory Sizing Advice

Pat <pat.casey_at_service-now.com> wrote in news:c3b1b601-abd9-4d2c-acaa- e4d947b44bc5_at_d77g2000hsb.googlegroups.com:

> Working set is
> hard to estimate, but in analagous 100G systems I see a buffer hit
> ratio or around 70% with a 2.3 G SGA (about as big as I can get it on
> a 32 bit OS). Based on this and a fair amount of spitball analysis I'd
> guess the working set on the new box to be around 8-10G.

Choose any hit ratio

http://www.oracledba.co.uk/tips/choose.htm

Using BCHR for anything other than pure wishful dreaming, is like using Tarot cards to select your spouse.

There is NO, NO, NO relationship between raw database size (200GB) and database performance as measured by ANY metric!

Good Luck on your search for the Holy Grail! Received on Thu May 08 2008 - 22:31:07 CDT