Database Administration (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center