ORACLE.EXE Virtual Memory Keeps Increasing on x64 Windows
(Doc ID 1062406.1)
Last updated on FEBRUARY 14, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5.0 [Release 10.2]
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 x64 (64-bit)
NOTICE that this is a PLATFORM SPECIFIC problem for 10gR2 on x64 Windows systems
ORACLE.EXE continuous increases the amount of virtual memory used, and you see zombie thread accumulation on 64-bit MS Windows environment.
No ORA-4030 seen, but instance needs be restarted frequently to bring down the amount of virtual memory consumed by the oracle.exe process. Eventually, if all virtual memory has been consumed, ORA-4030 will occur.
Using Perfmon or TaskManager you see that the virtual size of oracle.exe is constantly growing (up to several 100's MB per day).
Using the VMMap tool to analyze the oracle.exe process, you see that the process stack accumulates zombie threads that holds around 3072 KB per zombie thread, accounting for the excess virtual memory consumption.
VMMap is a process virtual and physical memory analysis utility (available for free) (technet.microsoft.com/sysinternals).
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