2 Replies Latest reply: Dec 4, 2013 11:33 PM by shivadbuser RSS

    Excel report genaration becomes slow

    shivadbuser

      Hi All,

       

      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.

       

       

       

      Thanks