DB version : 19c
OS : RHEL, Oracle Linux 7.9
I am going build few 19c databases on Red Hat Linux and Oracle Linux 7.9 servers.
Let say, my physical server which going to run Oracle DB has 100 GB physical RAM.
Because of the performance enhancements of using huge pages, can I ask Linux admin to create huge pages which is equivalent to 100 GB.
Hope my below calculation is right
100 GB = 102,400 MB
102,400/2 MB = 51,200 Huge pages
But, my DBA colleague said if I allocate all physical RAM to huge pages, then there won't be any memory left for PGA to be used by the Oracle database ? Is that right ?