My Oracle Support Banner

Explaining Oracle BI Discoverer Session Memory Management And Server Cache Settings (Doc ID 245752.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Discoverer - Version to [Release 10.1.2 to 11g]
Information in this document applies to any platform.


To explain and clarify the following:

  • How Discoverer memory management works.
  • Why large swap files may be seen in the temporary directory.
  • Why some users may experience the following issues / errors:

    • Running a very large workbook with page items fails with error

    • Exporting a large workbook to MS Excel ends with: Export Failed.
    • Intermittent error 'Unexpected error in state machine: java.lang.OutOfMemoryError' in the application.log while running a worksheet.
  • Why you may get conflicting information from Oracle Support to raise or lower the memory settings.


This document is intended for Discoverer Administrators or System Administrators as guidance and additional information to assist with capacity planning and performance related tuning.


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

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