My Oracle Support Banner

Longer Database Startup times when large pages are enabled on 64-bit Windows 2003 (Doc ID 862690.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.1]
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)
Checked for relevance on 31-JAN-2013

Microsoft Windows Server 2003 (64-bit Itanium)Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)


64-Bit Microsoft Windows Server 2003 supports "Large Pages" which can provide some performance gains to applications such as Oracle Database, that use large amounts of memory.  When Oracle database large page support is enabled at database startup, Oracle allocates the entire SGA specified in the init.ora (or spfile) as large pages.  When large pages use is enabled in Oracle Database, the runtime database performance can improve noticeably.

However, systems which configure Oracle Database SGAs to an extremely large size may encounter slow database startup times when using Large Pages on Windows Server 2003.  Other applications on the same server may appear to be unresponsive as well, during the database startup.  In some cases, databases configured to use Large Pages may fail during startup with an out of resources error.


 The problem is encountered more often when startup is issued after the machine has been up and running for a long time.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Disabling Large Pages for Oracle Database:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.