Re: Maximize Number of Instances on RHEL 7.9
Date: Sat, 7 Oct 2023 13:32:31 -0400
Message-ID: <b778e2e0-7703-303b-0fd2-27e96ba912de_at_earthlink.net>
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-lReceived on Sat Oct 07 2023 - 19:32:31 CEST