RE: RAC install on Linux
Date: Fri, 23 Feb 2018 11:20:36 +0100 (CET)
Message-ID: <1957136609.100909.1519381237148_at_ox.hosteurope.de>
Hey guys,
_at_Amir
Never ever over-subscribe memory in a VM environment for database server VMs (e.g. memory ballooning). In theory you can over-subscribe memory in the VM itself (e.g. with multiple databases running in it) but this works only in case of "lazy memory allocation" for some specific time - in case of huge pages this does not work as the huge pages pool is a "separate" allocated memory area, cut-off right away and needs to be defined via kernel parameter. Heap memory (e.g. PGA) is a whole different topic.
_at_Ruel:
https://docs.oracle.com/cd/E37670_01/E37355/html/ol_about_hugepages.html "Huges pages remain pinned in memory and are not replaced, so the kernel swap daemon has no work to do in managing them" - so yes huge pages are locked and can not be swapped. "PRE_PAGE_SGA" is a different topic - Frits Hoogland has written a great blog post about it and what it really means (documentation is not true): https://fritshoogland.wordpress.com/2016/05/27/oracle-sga-memory-allocation-on-startup/
Huge pages can be used with manual memory management or ASMM but not with AMM (different implementation).
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
> "Ruel, Chris" hat am 22. Februar 2018 um 21:37 geschrieben:
>
>
> Someone correct me if I am wrong but HP's do not lock memory. They just use a larger page size. In fact some people had problems locking memory with HP's enabled. I don't know if Oracle ever admitted to this being a bug. This note is a little older but I know it affected us as late as 11.2.0.4:
>
> Oracle Support Document 1276966.1 (Rac Nodes Frequently Evicted (Rebooted) By CRS When PRE_PAGE_SGA is Set to True) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1276966.1
>
> Also, looking at the thread below, this is news to me that you must use ASMM with HP's. We use HP's with standard memory management in some cases and it seems to work fine. I know that AMM is a no-no.
>
> Chris..
>
> _____________________________________________________________________
> Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
> cruel_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir
> Sent: Thursday, February 22, 2018 3:06 PM
> To: contact_at_soocs.de; neil_chandler_at_hotmail.com
> Cc: Oracle-L Freelists
> Subject: RE: RAC install on Linux
>
>
> In those VM shops where memory is over-subscribed, how do Huge Pages work in terms of locking memory pages so that they cannot be swapped?
>
> Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 23 2018 - 11:20:36 CET