My Oracle Support Banner

How to Increase Discoverer Plus and Viewer Performance (Doc ID 793584.1)

Last updated on JANUARY 05, 2024

Applies to:

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


This note describes steps on how to increase Discoverer Plus and Viewer performance.
Before going through this note please make sure that your workbook and database design is proper.

Discoverer performance depends on your workbook design, machine resources, number of users, etc. Poorly designed workbooks can still fail due to lack of resources even on client machines that appear to have adequate resources.

Discoverer performance is largely determined by how well the database has been designed and tuned for queries.
A well-designed database will perform significantly better than a poorly designed database.
Workbook design can also affect query performance.

NOTE:  Connection and export issues on Discoverer are not dealt with in this note.


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.