Read Tkprof for Tuning Purpose

Hi Gurus,

One of the concurrent programs is having performance issue . I had the dba provide the TKprof file for the concurrent run so that I could identify the SQLs that are taking time and tune it.

In the TKProf i could see

XPLAIN PLAN option disabled.

********************************************************************************

BEGIN xxcu_invoice_pkg.start_invoicing(:errbuf,:rc,:A0,:A1,:A2,:A3)

  ; END;

call               count       cpu         elapsed            disk           query              current                  rows

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

Parse             1           0.00            0.00               0                    0                    0                          0

Execute         1       24569.03        26880.22    1428527      1832151230       667544056           1

Fetch             0           0.00            0.00               0                    0                    0                           0

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

total              2       24569.03        26880.22    1428527        1832151230       667544056           1

Misses in library cache during parse: 1

Misses in library cache during execute: 1