Small Pages not allowed for SGA from 19.27 and newer on Exadata

Having good friends in Oracle is key. And honestly one of the best things in my role. Philippe Fierens, product manager for Oracle’s Fleet Patching and Provisioning mailed me yesterday night sharing that there is an interesting change coming with Database Release Update 19.27: Small Pages not allowed for SGA from 19.27 and newer on Exadata.

What does this mean?

As you can read in MOS Note: 3081878.1 – Starting DBRU 19.27 Small Pages Are Not Allowed for RDBMS SGA In Exadata, from Release Update 19.27 onward (this is the April 2025 RU), you can’t start a database on Exadata anymore with a small pages SGA. This means that for instance memory_target (luckily!) will not work anymore.

The error you will see during startup is: ORA-27138: unable to allocate large pages with current parameter setting. As a consequence, the database will not start.

The same behavior will be seen from Oracle Database Release Update 23.8.0 onward as well.

Important addition since some people asked:
This will be enforced on Exadata only. It does not affect other platforms or environments.

In addition, the MOS note has been updated recently on April 18 to clarify settings and add more information.

 

What do you have to do?

  1. Remove MEMORY_TARGET
  2. Set SGA_TARGET
  3. Set USE_LARGE_PAGES=ONLY
    .

Further Links and Information

–Mike