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

Purpose

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.

Scope

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

Details

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