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

Last updated on JANUARY 31, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.7 [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)


Symptoms

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.

Changes

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms