How to Increase Discoverer Plus and Viewer Performance
(Doc ID 793584.1)
Last updated on JANUARY 05, 2024
Applies to:
Oracle Discoverer - Version 10.1.2.0.2 to 11.1.1.7.0 [Release 10.1.2 to 11g]Information in this document applies to any platform.
Goal
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.
Solution
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
| Goal |
| Solution |
| References |