reports builder 6i incomplete trace

Environment

1. EBS 11.5.10.2
2. Report builder 6i
3. Database oracle 9i (9.2.0)

For a report by enabling trace via (tools -> trace -> option trace_all ticked)

I get following output

      Logged onto server:

      Username:

LOG :       Logged onto server: testdb

      Username: xxx

+-------------------------------------+

                        | Report Builder Profiler statistics |

+-------------------------------------+

             TOTAL ELAPSED Time: 4285726.29 seconds

            Reports Time: 4285725.29 seconds ( 0.00% of TOTAL)

                    ORACLE Time:       1.00 seconds ( 0.00% of TOTAL)



                            UPI:       0.00 seconds

                            SQL:       1.00 seconds

 TOTAL CPU Time used by process: N/A

Where as I was expecting that it will give a detail trace containing SQLs as well as application level timings

This is a long report taking almost 4 mts & i want to find the timing of each sql as well as formula during run time,

Please help me to give some pointers regarding the solutions/ problem.

Thanks in advace.

Shikhar Received on Tue Sep 16 2008 - 06:03:05 CDT