4 Replies Latest reply: Sep 26, 2013 1:28 AM by JAGORACLE RSS

    FETCH > Execute in TKPROF.

    JAGORACLE

      Hi,

       

      SELECT N_ORIGIN,SUB_ACC_ID,STAT_DATE,TYPE,PAGE_TOT,PAGE_NO,CL_BAL,CL_BAL_DC

      FROM

      O_950P  WHERE   N_ORIGIN  = :P03137  AND  SUB_ACC_ID  = :P03140  AND 

        TO_CHAR ( ORA_TO_PRO4_DATE ( STAT_DATE ) )  ||  '/'  ||  PAGE_TOT  ||  '/' 

        ||  PAGE_NO  =  ( SELECT  MAX ( TO_CHAR ( ORA_TO_PRO4_DATE ( P.STAT_DATE ) )

          ||  '/'  ||  P.PAGE_TOT  ||  '/'  ||  P.PAGE_NO  )  FROM  O_950P  P 

        WHERE  P.N_ORIGIN  = :P03137  AND  P.SUB_ACC_ID  = :P03140  AND  TO_CHAR (

        ORA_TO_PRO4_DATE ( P.STAT_DATE ) )  ||  '/'  ||  P.PAGE_TOT  ||  '/'  || 

        P.PAGE_NO  != :P03158  ||  '/'  || :P03148  ||  '/'  || :P03153  )

       

       

       

       

      call     count       cpu    elapsed       disk      query    current        rows

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

      Parse        0      0.00       0.00          0          0          0           0

      Execute     48      0.03       0.02          0          0          0           0

      Fetch       96   1947.78    1904.24          0    1132434          0          48

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

      total      144   1947.81    1904.26          0    1132434          0          48

       

       

      Misses in library cache during parse: 0

      Optimizer mode: RULE

      Parsing user id: 13074 

       

       

      Elapsed times include waiting on following events:

        Event waited on                             Times   Max. Wait  Total Waited

        ----------------------------------------   Waited  ----------  ------------

        SQL*Net message to client                      96        0.00          0.00

        SQL*Net message from client                    96        0.00          0.12

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

       

       

       

      Having this following tkprof output.where it shows execute is actually 48 and fetch 96 . This looks quite wierd to me.Any ideas ?