Alert Log: For optimal performance, configure system with expected number of pages
We are on Oracle 12.1.02. In the alert log, I am seeing a recommendation. We do not have huge pages configured. The database parameter for use_large_pages= True and large_pool_size=0. Is this recommending that we configure huge pages?
Thanks,
Nancy
Here is the recommendation:
Sat Jul 10 05:00:03 2021
Available system pagesizes:
4K, 2048K
Sat Jul 10 05:00:03 2021
Supported system pagesize(s):
Sat Jul 10 05:00:03 2021
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Sat Jul 10 05:00:03 2021
4K Configured 6 8912902 NONE
Sat Jul 10 05:00:03 2021
2048K 0 17409 0 NONE
Sat Jul 10 05:00:03 2021
RECOMMENDATION:
Sat Jul 10 05:00:03 2021
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next