Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5.0 [Release 10.2]
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms