Maximize Number of Instances on RHEL 7.9

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 Received on Sun Sep 03 2023 - 00:15:51 CEST