Tuning SGA
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Mar 2005 17:39:38 -0700
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@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
