This discussion is archived
1 Reply Latest reply: Sep 13, 2013 7:35 AM by InoL RSS

Reprot running more than 3 hours

user-Keen Explorer
Currently Being Moderated

Dear

 

I have developed reprots which has been running for the last three hours and still in progress. However, i ran this query on "PL/SQL Developer" by giving fixed parameter it completed within 2 minutes.

 

Finally i copied the whole query on report builder which took 2 minutes but in reprot still taking too much time ank keep running.

 

Could you pls share your experienc regarding this issue.

 

thanks.

  • 1. Re: Reprot running more than 3 hours
    InoL Guru
    Currently Being Moderated

    You can simply google for "oracle reports slow toad fast" and you will find that this question has been asked and answered so many times. One answer that says it all:

     

    One of the things I always comment on is that TOAD does not bring all rows back. It only brings back the first 25 or so, depending upon how you have it configured. If you have asked Discoverer to create a Crosstab or Page Items then you are forcing it to retrieve ALL rows before it can even build the worksheet.

     

    (replace Discoverer by Reports and Crosstab by Matrix Report).

    In Reports you can also have program units that work on your data.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points