Re: SGA bigger than 50G

  • From: amit bansal <amit.bansal82@xxxxxxxxx>
  • To: yong321@xxxxxxxxx
  • Date: Mon, 10 May 2010 19:51:27 +0530


I second Andrew and Nuno's suggestion on configuring swap to 3/4th of
physical RAM. I have seen "out of space" errors pre-dominantly with under
configured swap setting. Could you please increase it and see if it works


On Fri, May 7, 2010 at 8:24 PM, Yong Huang <yong321@xxxxxxxxx> wrote:

> > As for huge pages, you need to configure just a little bit more than
> > what you need for the SGA (PGA won't use huge pages). For example, if
> > you want to use an SGA of 30gb, you'd configure huge pages to be
> > 30gb + a few tens of MBs to allow for a bit of overhead.
> >
> > Harel
> I agree. It's better to make sure the HugePages memory covers all
> instances simultaneously running on the box, including ASM if available.
> HugePages is guaranteed to be locked in physical memory regardless its
> version. Any unused bit of it is wasted. I have some write-up about this
> topic at
> By the way, 50GB SGA on a 64GB box is not a wise decision as others
> said. Every bit of increase in PGA is benefitial for hashing (but not
> sorting) when it's in one-pass phase, common to a data warehouse.
> Yong Huang
> --

Other related posts: