Re: Maximize Number of Instances on RHEL 7.9

From: <asterger_at_earthlink.net>
Date: Sat, 7 Oct 2023 13:32:31 -0400
Message-ID: <b778e2e0-7703-303b-0fd2-27e96ba912de_at_earthlink.net>


Jared - Thanks for replying.

 From my research, hugepages was recommended for SGAs over 4G. Most of my SGAs are in the 1.2-3G range.

Thanks,

On 10/7/2023 12:40 PM, Jared Still wrote:
> One of the things I am curious about is why no hugepages?
>
> I'm not aware of hugepages being non-useful due to small SGA size.
>
> With so many instances I would think it rather a good feature to employ.
>
>
> On Sat, Sep 2, 2023, 3:17 PM Alan Sterger <asterger_at_earthlink.net> wrote:
>
> Hello,
>
> Looking for guidance in maximizing number of Oracle instances on a
> RHEL
> 7.9 server for Dev/Val testing, not Production.
>
> We are running Oracle SE2 with threaded_execution and small SGAs
> therefore, not using server HugePages.  Databases
> use_large_pages=false
> along with _ksmg_granule_size=4194304 (4M). Currently hosting 31
> instances, using memory_target with half of the instances set to
> 2560M,
> the other half at 1240M.  Most are 19c, 6 at 12c.
>
>                total        used        free      shared buff/cache
> available
> Mem:            92G         10G         30G         35G
> 51G         45G
> Swap:           31G          0B         31G
>
> Assume I need to alter kernel parameters SHMMAX and SHMALL from their
> defaults setting ~80% of the 92G for oracle databases.
>
> What can you add or suggest doing?
>
> Thanks,
>
> -- Alan
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 07 2023 - 19:32:31 CEST

Original text of this message