Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

HOLD Files take 15 minutes to run

HOLD Files take 15 minutes to run

HOLD Files take 15 minutes to run

I have a report fex which returns the record set via a direct sql pass thru to Oracle in less than 15 seconds.

However, the report fex creates 5 HOLD files in order to manipulate / format the report.  The HOLD file procedures takes over 15 minutes, therefore, my browser times out.

I have two choices:
1) Run the report deferred
2) Optimize the HOLD file procedures.

My problem is that the report fex resides in the REPOSITORY, therefore, I can not change its properties to "RUN AS DEFERRED REPORT ONLY".  

Here is the scenario.  The calling FEX is a parameter page which allows the users to select the desired parameters.  Then, the user clicks on a SUBMIT button which calls the report FEX.




RE: HOLD Files take 15 minutes to run

If the report is in MRE, you can always add a radio button or hard code the parameter to run deferred.  That would however, only mask the real problem.  My suggestion would be (b) to optimize the report.  You must be doing something in at least one of your passes that is doing a table scan.  

RE: HOLD Files take 15 minutes to run


Based on the time it takes, I can only guess that you're retrieving LOTS of data. Can you post the query. There are optimization techniques (such as using TABLEF rather than TABLE), which might help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close