My Oracle Support Banner

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

Last updated on JUNE 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.


Symptoms

 

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

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
Symptoms
Cause
Solution
 Memory Breakup
 Current memory consumption
 Reducing Memory
 Shared Server
 Summary
 Conclusion
References

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