Re: Tuning SGA

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: bunjibry@xxxxxxxxx
  • Date: Wed, 23 Mar 2005 01:10:16 +0000

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

Other related posts: