Longer Database Startup times when large pages are enabled on 64-bit Windows 2003
Last updated on JANUARY 31, 2013
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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.
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