1 Reply Latest reply: Sep 13, 2013 9:35 AM by InoL RSS

    Reprot running more than 3 hours

    user-Keen

      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

          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.