DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Hi all,

    I am experiencing wiered problem.

    I have a requirement of inserting rows into a temp. table in Before Report trigger so that the report query runs on that table.

    I am able to test insert in TOAD and SQL*Plus and working very fast. Ex. for 800 rows, it takes 2 min.

    But when I use the same Insert statement in Before Report trigger in the report, it goes on and on. In before report trigger, I first truncate that table.

    Can someone tell me why it is happening so?

    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Sep 2000
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Maybe the TRUNCATE in the reports is processing a LOT of extents ? Try to make a trace level 12 of the report session, and see FOR WHAT it is waiting for.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.