Instance Crash Or ORA-04030 Errors When Pagefile Is Full (Doc ID 1358570.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 30-Jan-2015***

Symptoms

Various ORA-7445 and ORA-4030 errors occur due to all the Windows pagefile space having been used up despite physical memory being free on the server. Checking the Oracle trace files will show free memory is available but there is insufficient free pagefile space, e.g.:

Memory (Avail/Total): Ph:25261M/30709M, Ph+PgF:38M/80709M


The Windows Event Viewer may also show a warning indicating that the low system resource was due to the ORAVSSW.EXE process, e.g.:

Log Name: System
Source: Microsoft-Windows-Resource-Exhaustion-Detector
Date: 29/08/2011 19:26:39
Event ID: 2004
Task Category: Resource Exhaustion Diagnosis Events
Level: Warning
Keywords: Events related to exhaustion of system commit limit (virtual memory).
User: SYSTEM
Computer: myserver
Description:
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: oravssw.exe (1936) consumed 29900058624 bytes, oravssw.exe (1964) consumed 22195634176 bytes, and oravssw.exe (1992) consumed 12582133760 bytes.
...

Cause

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