Re: Hugepages - benefits / drawbacks
Date: Tue, 7 Oct 2008 10:14:44 -0400
Could you please provide an evidence for "on Solaris PGA uses ISM and will not get paged out to disk". In my current understanding PGA is an aggregated size of private data areas for all background processes and it has nothing to do with ISM. Please correct me if I'm wrong.
On Mon, Oct 6, 2008 at 8:51 PM, Krishna Manoharan <krishmanoh_at_gmail.com>wrote:
> Please note the below about Huge pages.
> 1. Huge pages are used for SGA only. Don't reserve more than you intend to
> allocate to SGA (SGA_MAX_SIZE). Otherwise, you are going to see heavy
> 2. Huge pages cannot be paged out. They are locked in memory (similar to
> ISM on Solaris) and even if un-used, not freed back to the OS. No other
> application other than Oracle can use this memory.
> 3. Since PGA cannot use Huge Pages (on Solaris PGA uses ISM and will not
> get paged out to disk), make sure that enough free memory is available on
> the system for PGA + OS requirements + other apps.
> 4. The formula you want to use
> Physical Memory > shmall > (shmmax = nr_hugepages)
> Physical Memory - nr_hugepages = PGA + OS + Other apps
> 5. Huge pages are more efficient because of the bigger pagesize (2M) and
> also help reduce TLB misses (assuming you are having a system with more than
> 16GB Memory).
> 6. Huge Pages do not give you a bigger heap size
> (_realfree_heap_pagesize_hint is not applicable).
> Krishna Manoharan
> On Mon, Oct 6, 2008 at 3:37 PM, Nuno Souto <dbvision_at_iinet.net.au> wrote:
>> Yong Huang wrote,on my timestamp of 7/10/2008 3:43 AM:
>>> The previous DBA setting up the server and database didn't
>> > use huge pages. I don't know if he was unaware of it or was
>> > afraid of the big page size.
>> My guess is "unaware". Most folks aren't even aware of
>> the problem hugepages address. That sort of knowledge is
>> frowned upon by the point-and-click tuition brigade,
>> And in some cases it's taken care of silently, which
>> is IMO the best way to approach this. Make it part
>> of default settings if the h/w addressing is 64-bit
>> class: that way no one can forget to "click" it on.
>> Nuno Souto
>> in sunny Sydney, Australia