Home » Developer & Programmer » Reports & Discoverer » Reports Performance
Reports Performance [message #252892] Fri, 20 July 2007 08:53 Go to next message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
I am running reports 6i.

I run a query with a UNION in pl/sql developer and the queries executes within a minute. I cut and paste the same query into reports and it takes over 10 minutes. Fiddled with the order by fields and still no improvement.

Thanks
Re: Reports Performance [message #252894 is a reply to message #252892] Fri, 20 July 2007 09:05 Go to previous messageGo to next message
diku
Messages: 23
Registered: April 2007
Junior Member
Check out which part of the execution is holding up your report.

It might not be your SQL Code but conditional formatting in Reports which you do. Are you fetching data from remote servers? That could also slow the execution.
Re: Reports Performance [message #252899 is a reply to message #252894] Fri, 20 July 2007 09:43 Go to previous messageGo to next message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
No remote servers and no conditional formatting with triggers.

However I noticed if the report is in tabular format it runs in under 5 min but as soon as I change it to a multiple break report it impacts on the performance.
Re: Reports Performance [message #253509 is a reply to message #252899] Tue, 24 July 2007 02:46 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

Open your report in report builder
TOOLS----->Trace
specify here trace file and trace mode
Also check trace options according to your report
You will come to know each module in report getting how much time..
Then u can tune your report easily i think...
Previous Topic: Create Report in Chinese
Next Topic: order by in 5 queries report
Goto Forum:
  


Current Time: Sat Dec 03 06:05:24 CST 2016

Total time taken to generate the page: 0.06840 seconds