Skip Headers
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
11g Release 1 (11.1.1)

Part Number B32121-05
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

24   Diagnosing and Tuning Oracle Reports

As your reporting requests grow in size and complexity and your user base increases, you must consider streamlining your report's performance (or your report's execution time) as much as possible. This maximizes its reach and minimizes its delivery time. Consider the following essentials before you tune the performance of your reports:

Investigating some of these areas can result in significant performance improvements. Some may result in minor performance improvements and others may have no affect on the actual report performance but can improve the perceived performance. Perceived performance refers to events that contribute to the end result (measured in terms of the final output). See Section 24.7.1, "Fetching Ahead" for an example of perceived performance.

This chapter provides a number of guidelines and suggestions for good performance practices in building, implementing, and tuning individual reports. The suggestions given are general in nature and not all suggestions might apply to all cases. However, implementing some or all of the points in a given application environment should improve the performance of report execution (real and perceived).


This chapter does not address Oracle Reports deployment or scalability issues. Refer to the Oracle Reports Services Scalability white paper on OTN ( for more information.

This chapter will help you look at your report in the broader context of:

After identifying the context of your report, you can gear the tuning process towards optimizing and minimizing:

To achieve these objectives, you should focus your tuning on the following distinct aspects of your report:

This chapter addresses these aspects in the following sections: