MS-Windows 32-bit Enterprise Edition: Detailed steps to solve ORA-04030 errors on 10g/11g (Doc ID 1446866.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Microsoft Windows (32-bit) - OS Version: 7
Microsoft Windows (32-bit)

Goal

For the 32-bit MS-Windows Enterprise Edition, to configure the Oracle Database to use memory below and above the 4Gb boundary, please implement the following steps.

Please note that the PC must have >4Gb of RAM.

Also, please note the following MicroSoft limitation statement:

The exception is when the /3GB switch is used in conjunction with the /PAE switch. In this case, the operating system does not use any memory in excess of 16 GB.

Solution

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