Reports Tuning [message #532489] |
Wed, 23 November 2011 01:51 |
|
ramoradba
Messages: 2457 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
|
|
|
|