Home » RDBMS Server » Performance Tuning » Reports Tuning (Oracle Report builder 6i or later ..)
Reports Tuning [message #532489] Wed, 23 November 2011 01:51 Go to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.oracle.com/technetwork/middleware/reports/275641-133007.pdf

Quote:

+-------------------------------------+
| Reports Profiler statistics |
+-------------------------------------+
Total Elapsed Time: 29.00 seconds
Reports Time: 24.00 seconds (82.75% of TOTAL)
Oracle Time: 5.00 seconds (17.24% of TOTAL)
UPI: 1.00 seconds
SQL: 4.00 seconds
TOTAL CPU Time used by process: N/A

From the profile, it is possible to see the execution time (total elapsed time) for the report, the
amount of time that was spent formatting the retrieved data (Reports Time)
In this example, the profile shows that the majority of the time was spent formatting (laying out)
the data rather than querying and fetching it.


In this Case How one can tune layout section to gain performance ....(more problems with Custom layouts)

Out of 29 sec 24 sec were performed on Layout section Only!In some cases it is more than 1000 sec.
Can anyone give some documents on it ?If available other than above ?

Thank you
Sriram Sanka

[Updated on: Wed, 23 November 2011 01:53]

Report message to a moderator

Re: Reports Tuning [message #532713 is a reply to message #532489] Thu, 24 November 2011 02:02 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Any update ?

Sriram
Previous Topic: MVIEW huge temp space
Next Topic: Table space with different block size inside same database
Goto Forum:
  


Current Time: Thu Mar 28 20:26:51 CDT 2024