View Single Post
  #2 (permalink)  
Old March 7th, 2008, 12:07
nick.polites nick.polites is offline
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 240
Thanks: 0
Thanked 35 Times in 35 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
nick.polites is on a distinguished road
Re: Issue Running Report in OTM - too much data

Have you tried scheduling the report to run so it emails you when it is finished? You can also increase the timeout of the apache server running reports to see if that helps, but I wouldn’t recommend it. Any report that takes over 5 minutes to execute is too long and should be optimized as no doubt there is a bad query within the report. Imagine running a few of these at the same time, you will most likely not only bring down the reports instance but OTM as well.
__________________
MavenWire Hosting Admin
Over 7 years of OTM experience
The Oracle OTM / G-Log GC3 Experts
Offering Incubator and Production OTM instances
www.mavenwire.com
Reply With Quote