How to Increase Discoverer Plus and Viewer Performance
Last updated on MARCH 28, 2018
Applies to:Oracle Discoverer - Version 10.1.2.0.2 to 126.96.36.199.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 28-Mar-2018***
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.
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