How To Avoid ORA-04030/ORA-12500 In 32-bit Windows Environment [Video]
(Doc ID 373602.1)
Last updated on FEBRUARY 14, 2022
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Microsoft Windows (32-bit)
This Note is applicable to any 32-bit Windows release capable of running Oracle.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!