On 03/22/2005 07:39:38 PM, Bryan Wells wrote: > All... >=20 > we are moving a production 9iR2 data warehouse to a new 4-way with 8G > memory. was wondering if its worth upping my SGA to take advantage of > this extra memeory? currently we are using less than 2 on 4G and my > hit ratio as of today is 1. Brian, you are waking up the worst in me. Please don't do that. Talking abo= ut=20 100% hit ratio makes me want to write some things that Steve Adams probably wouldn't approve of. No, I'll take that back: he most certainly wouldn't ap= prove. I am trying to stay away from the Dark Side and you are tempting me. Shame = on you! Blessed are the cheesemakers! --=20 Mladen Gogala Oracle DBA -- //www.freelists.org/webpage/oracle-l