Tuning SGA

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Tue, 22 Mar 2005 17:39:38 -0700
Message-ID: <b78d5a2005032216396286ac56@mail.gmail.com>

All...

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.

If so what pieces of the SGA are best to up since most processing occurs in batch overnight from 1am to 8am. I can see upping Buffer Cache but this is my first attempt at this and look to the experts.

thanks, as always.
--

Bryan S Wells - DBA Newbie
bunjibry_at_gmail.com
--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 22 2005 - 19:43:14 CST