Re: Tuning SGA

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 23 Mar 2005 01:10:16 +0000
Message-Id: <1111540216l.29600l.0l@medo.noip.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2005 - 20:13:52 CST