Re: Maximize Number of Instances on RHEL 7.9

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