This content has been marked as final. Show 2 replies
I am using forms&reports 10g with database 10gr2 version. I am trying to run an excel report with webutil configuration. In database the report query retrieves 15000+ records. When I am trying to run excel report from UI report
generation becomes very slow and eventually stops in the middle(around 4000 records) without completing the generation.
In database the query is tuned with indexes and retrieves fast.
Kindly suggest me what kind of performance steps I can do in database level or forms level to the generate the entire report.