Database Tuning (MOSC)

MOSC Banner

Alertlog hugepage recommendation at startup?

edited Apr 23, 2020 10:52AM in Database Tuning (MOSC) 6 commentsAnswered ✓

In my alert log on a 19.6c database running on RHEL7 I am getting the following recommendation at startup:

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

2020-04-21T13:45:42.243460-06:00

        4K       Configured              11         3211275        NONE

2020-04-21T13:45:42.243677-06:00

     2048K             1236            7505            1233        NONE

2020-04-21T13:45:42.243775-06:00

RECOMMENDATION:

2020-04-21T13:45:42.243868-06:00

1. For optimal performance, configure system with expected number

of pages for every supported system pagesize prior to the next

instance restart operation.

My sys admin and I have reviewed and implemented the recommendations from  doc 401749.1. The two databases on the host are up and I don't believe we are using AMM.

Tagged:

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