5 Replies Latest reply on Jun 29, 2015 5:37 AM by NewAppsDBA

    PO Approval Taking Long time in r12.1.2

    NewAppsDBA

      Hi,

       

      PO Approval Taking Long time in r12.1.2.

       

       

      Sometime it is fast and sometimes it is not.I have taken a trace when it was taking time. Please help me to find the root cause of it.

       

       

      Thanks.

        • 1. Re: PO Approval Taking Long time in r12.1.2
          Srini Chavali-Oracle

          Pl elaborate on what exactly did you trace. What does the trace data show ?

          • 3. Re: PO Approval Taking Long time in r12.1.2
            Srini Chavali-Oracle

            I have no idea what has been traced.

             

            Trace file: dugprd1_ora_477_12269.trc

            Trace file compatibility: 10.01.00

            Sort options: prsela  exeela  fchela

                   5  sessions in tracefile.

                2049  user  SQL statements in trace file.

                9361  internal SQL statements in trace file.

                2388  SQL statements in trace file.

                 402  unique SQL statements in trace file.

            Over 2000 SQL statements in the trace file !

             

            The bottom shows

             

            OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

             

            call     count       cpu    elapsed       disk      query    current        rows

            ------- ------  -------- ---------- ---------- ---------- ----------  ----------

            Parse     1219      0.39       1.25          0        268        404           0

            Execute   3799      2.47     161.79         52       4199       4302         662

            Fetch     5861      0.85       3.79        129      25136          8        9227

            ------- ------  -------- ---------- ---------- ---------- ----------  ----------

            total    10879      3.72     166.83        181      29603       4714        9889

            and the very first line is

             

            begin XXWF_PROJ_APPRV_CUST_PKG.update_budget (:v1, :v2, :v3, :v4, :v5); end;

            which is custom code and shows an elapsed time of 155.61 secs (of the total of 166.83).

             

            Whats is in this custom code ? Is this custom code included in the trace ?

            • 4. Re: PO Approval Taking Long time in r12.1.2
              NewAppsDBA

              Hi,

               

              Yes.. Because I enabled the trace before user hit 'OK' button. It should be there in the trace. But same package executes all the time, why only some time its taking longer time.

               

               

              Thanks

              • 5. Re: PO Approval Taking Long time in r12.1.2
                NewAppsDBA

                Hi Schivali,

                 

                 

                Steps followed,

                 

                Purchasing end user responsibility

                After PO Creation

                User Clicks on Approve it will go to Approve screen.

                 

                I have enabled the trace for this,

                 

                user select Help | Diagnostics | Trace and click in the “Trace With Binds and Waits” box right before they do the part of the transaction that runs slow
                .

                Thanks