Total Pageviews

May 1, 2017

5/01/2017 11:45:00 AM

Oracle Reports Performance issues

Oracle Reports : Performance Improvement tips

Repeating frames

  • In particular, setting the size of repeating frames and their contents to fixed, improves performance.
  • Fixed graphical objects require more processing overhead as their contents have to be scaled to fit. Variable objects grow or shrink with the contents eliminating the need for scaling.
  • Use the SUBSTR function in the report query to truncate the data at the database level, instead of truncating a character string from a field in the Report Builder layout.

For paper layout only reports, .rdf and .rep files run faster than a.jsp file

  • Keep in mind that the larger and more complex a query gets, the more difficult it is to be maintained. Then we have to  decide when to achieve the balance between performance and maintenance requirements.
  • Format triggers can be used against repeating frames to filter data. However, by introducing filtering at appropriate levels, not only improve a report's performance but also reduce the complexity

Use the following filtering order whenever possible:

  • Modify the SQL statement to prevent the data being returned from the server.
  • Use the group filter to introduce filtering in the Data Model.
  • Use return false inside the format trigger.
  • Format triggers should be placed at the highest level possible in the object/frame hierarchy so that the trigger fires at the lowest possible frequency