How to set Kernel Parameters on Redhat for oracle database
Hello,
I want to thank you for your great support.
Please let me ask about setting the kernel parameters on Redhat 7.8 for Oracle database 12.2.
What is the best practice?
please find the following information :
[oracle@DB sysctl.d]$ free -g -h -t
total used free shared buff/cache available
Mem: 176G 21G 1.8G 22G 153G 131G
Swap: 19G 985M 19G
Total: 196G 22G 20G
==================================================================
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 99840M
sga_min_size big integer 0