How To Avoid ORA-04030/ORA-12500 In 32-bit Windows Environment [Video] (Doc ID 373602.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Microsoft Windows (32-bit)
This Note is applicable to any 32-bit Windows release capable of running Oracle.


Symptoms

Checked for relevance on 03-FEB-2011

You are encountering ORA-04030 or ORA/TNS-12500 in the 32-bit Windows environment. It is assumed that your server machine has less than 16GB of physical RAM, and that both the /3GB and /PAE switches have been set in the BOOT.INI file (see <Note 225349.1> to understand why this is significant).

This document is intended as an adjunct to the excellent information in:

<Note 225349.1> Using Address Windowing Extensions (AWE) or VLM on Windows
<Note 46001.1> Oracle Database and the Windows NT memory architecture
<Note 46053.1> Windows NT Memory Architecture Overview

and it is assumed that these Notes have been read.

The purpose of this article is to go into further detail with respect to the spread of memory usage in a 32-bit Windows environment, in the hope that errors such as ORA-4030 and ORA/TNS-12500 may be avoided or reduced.

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