How To Avoid ORA-04030/ORA-12500 In 32-bit Windows Environment [Video]
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Microsoft Windows (32-bit)
This Note is applicable to any 32-bit Windows release capable of running Oracle.
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.
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