Slow performance. Each page takes 5 min to display

[jjain]

Hello, My problem is that I have a custom report that used to run under 2 min in release 11.5.3. After we upgraded to 11.5.7 it takes 1 1/2 hr. I've already checked indexes explain plans, etc. everything looks normal. What I found by running the it from Reports Builder is that although the reports executes relatively fast and prints the first page, everytime I click the next page button it takes 5 minutes to format the next page!! The report usually generates 18 pages, that the 1 1/2 hr. Why would it take so long to format, any tips?? Thanks!

 

[bandarna]

If you are running through the oracle forms, re-fresh the .rep file. Remove old one and compile your report and create new .rep file. Even if it doesn’t help, If I were your I would recreate the entire report from the scratch with the help of old report and Ctrl+C and Ctrl+v key board help. I solved several problems like this.

I know this is little bit of strange. $$$???

 

[rcasan]

Try going into the report (via Reports Dev) and changing Elasticity properties to "Fixed" where ever possible. This is usually means all of the data fields that are not frames or repeating frames. Moreover, if you can control the direction in which a Repeating or regular Frame repeat or expand, this will help allot. That is, change the Elasticity from "Variable" to Expand wherever possible. The less the reports engine has to compute, the faster it will be.

If you want to take it a step further you can use the .rdf file format (Reports Binary file) which is precompiled, performace will improve.