Re: SGA bigger than 50G
- From: amit bansal <amit.bansal82@xxxxxxxxx>
- To: yong321@xxxxxxxxx
- Date: Mon, 10 May 2010 19:51:27 +0530
Sanjay,
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
now.
Regards
Amit
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
>
> http://yong321.freeshell.org/oranotes/HugePages.txt
>
> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
