Hi,
I am relatively new to oracle reports and report builder.
One of the report in our application is taking long time (5-7 Minutes) to execute. To pin point the reason, I executed the report and generated TKPROF for sql trace file. Execution of queries in database are not taking long (entire execution at database end finishes in 1 minute). That done, now I am trying to identify if formatting of the report (report is generated in PDF format) is consuming time.
To enable tracing, i referred steps as mentioned in oracle documentation
http://docs.oracle.com/html/B14048_02/pbr_tune.htm#i1006821
however, on my report builder, the tracing option is disabled.
Could anyone direct me to the right direction.
Report Builder version
Report Builder 11.1.2.1.0
ORACLE Server Release 11.1.0.7.0
Oracle Procedure Builder 11.1.2.1.0
Oracle ORACLE PL/SQL V11.1.0.7.0 - 64bit Production
Oracle database version
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production