by "Ana C. Dent" <anacedent@[EMAIL PROTECTED]
>
May 9, 2008 at 03:31 AM
Pat <pat.casey@[EMAIL PROTECTED]
> wrote in news:c3b1b601-abd9-4d2c-acaa-
e4d947b44bc5@[EMAIL PROTECTED]
> 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 relation****p between raw database size (200GB)
and database performance as measured by ANY metric!
Good Luck on your search for the Holy Grail!
