When Exporting or Running A Large Query, Discoverer Plus/Viewer Fails With "The Server is running low on Virtual Memory..." (Doc ID 135031.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Discoverer - Version 4.1.37 to 11.1.1.6.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 07-Nov-2012***
***Checked for relevance on 04-June-2014***
***December 21, 2015***

Symptoms

When running a Discoverer Plus or Viewer query and/or an export, it fails with the following error:

"An Error Occurred While Trying To Run The Query.(The server is running low
on virtual memory. This can happen due to insufficient disk space
or heap space on the server. Please contact your Discoverer Administrator
for assistance.)'


or

"The server is running low on virtual memory. This can
happen due to insufficient disk space or heap space on the server. Please
contact your Discoverer Administrator for assistance."

Changes

You may have reduced the Discoverer cache settings or the server may be running other applications that are consuming resources.

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