My Oracle Support Banner

Windows Memory Configuration: 32-bit and 64-bit (Doc ID 873752.1)

Last updated on JULY 06, 2023

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows Server 2003
Microsoft Windows Itanium (64-bit)
z*OBSOLETE: Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
z*OBSOLETE: Microsoft Windows Server 2003 R2 (32-bit)
Microsoft Windows x64 (64-bit)

Goal

The goal is to understand the following concepts:

  • OS Memory Configuration
  • 32-bit and 64-bit systems
  • Boot.ini file
  • /3GB, /PAE, and /NOPAE Switches
  • Oracle Memory Configuration
  • Awe enabled
  • Performance Implications of 32-bit Oracle
  • Advantages of 64-bit Oracle

Only these versions of Windows fully support using the two switches in production systems:

  • Windows 2000 Advanced Server
  • Windows 2000 Datacenter Server
  • Windows 2003 Enterprise Edition
  • Windows 2003 Datacenter Edition

Solution

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
Goal
Solution
 32-BIT Addressing
 4GT (4GB Tuning) with /3GB
 32-bit Systems with PAE (36-bit)
 Windows 2003 /NOPAE Special Case (32-bit)
 AWE for 32-bit Oracle
 Performance Implications of 32-bit Memory Management
 
Conserving Memory for User Connections
 
Boot.ini Examples (32-bit)
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Windows 2003 64-bit System Advantages
 
64-bit Memory Support on Itanium based computers
 
64-bit Memory Support on EM64T and Opteron based computers
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Monitor Oracle Memory
References

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