Strange parse counter on tkprof

From: Elir <elire_at_amdocs.com>
Date: 9 May 2004 06:15:11 -0700
Message-ID: <e7cbfa45.0405090515.31bdfc27@posting.google.com>

Hi
The attach below query was execute 4705 times in Pro*c program . Dose anyone can explain the low parse counter below, comparing to the execute counter .

I will expect to have the same number for the parse & execute . Note the query is Fetch single row each time

Thanks .

select PRODUCT.rowid ,PRODUCT.CUSTOMER_ID ,PRODUCT.PRODUCT_CODE ,

  PRODUCT.PRODUCT_ISSUE_NUM  ,PRODUCT.PRODUCT_STATUS  ,
  PRODUCT.RETIREMENT_STATUS  ,PRODUCT.ACTIVITY_TYPE  ,
  PRODUCT.ADDITIONAL_ACTIVITY

,TO_CHAR(PRODUCT.ACTIVITY_DATE,'YYYYMMDD') ,
  TO_CHAR(PRODUCT.ACTIVITY_UPDATE_DATE,'YYYYMMDD')
,PRODUCT.ADVANCE_SALE_IND

   ,PRODUCT.PROSPECT_CODE ,PRODUCT.PROD_CURR_PROS_CODE ,   PRODUCT.PROSPECT_AGE ,PRODUCT.DOMINANT_HEADING ,   PRODUCT.DOMINANT_HEADING_AMT ,TO_CHAR(PRODUCT.LAST_CONT_PRINT_DATE,   'YYYYMMDD') ,PRODUCT.COMPLAINT_IND
,TO_CHAR(PRODUCT.COMPLAINT_DATE,

  'YYYYMMDD') ,TO_CHAR(PRODUCT.DIVISION_ARRIVE_DATE,'YYYYMMDD') ,

  PRODUCT.COMMERCIAL_NAME  ,PRODUCT.SRCH_COMMERCIAL_NAME  ,
  PRODUCT.DISPLAY_AD_EXIST_IND  ,PRODUCT.LOCAL_FOREIGN_IND  ,
  PRODUCT.CANVASS_CODE  ,PRODUCT.CANVASS_ISSUE_NUM

,PRODUCT.FIRST_ASSIGN_ID

,TO_CHAR(PRODUCT.FIRST_ASSIGN_DATE,'YYYYMMDD')
,PRODUCT.CURRENT_ASSIGN_ID

,TO_CHAR(PRODUCT.CURRENT_ASSIGN_DATE,'YYYYMMDD') , PRODUCT.CONTRACT_LOAD_PHASE ,PRODUCT.CONTINUITY_AGE
,PRODUCT.CHANNEL_AGE

  ,PRODUCT.ASSIST_ASSIGN_ID  ,PRODUCT.ASSIST_PERCENTAGE  ,
  PRODUCT.LENDING_ASSIGN_ID  ,PRODUCT.SELL_CANVASS_CODE  ,
  PRODUCT.SELL_CANV_ISS_NUM  ,PRODUCT.SELL_ASSIGN_ID  ,
  PRODUCT.CMSN_CANVASS_CODE  ,PRODUCT.CMSN_CANV_ISS_NUM  ,

  PRODUCT.CMSN_ASSIGN_ID ,PRODUCT.QUERY_STATUS
,PRODUCT.COMPLAINT_ASGN_ID ,

  PRODUCT.NIR_PRODUCT_IND
,TO_CHAR(PRODUCT.START_PUBLISH_DATE,'YYYYMMDD') ,
  PRODUCT.DURATION ,TO_CHAR(PRODUCT.ACTUAL_END_PUB_DATE,'YYYYMMDD')
,

  PRODUCT.RENEWAL_CONTRACT_IND  ,PRODUCT.PRODUCT_NAME  ,
  PRODUCT.NUM_OF_BOTS_ITEMS  ,PRODUCT.NUM_OF_NISD_ITEMS  ,
  PRODUCT.NUM_QUERIED_ITEMS  ,PRODUCT.LAST_YEAR_NISD_AMT  ,
  PRODUCT.ORIG_ASGN_BOTS_AMT  ,PRODUCT.OVER_RATE_BOTS_AMT  ,
  PRODUCT.BOTS_AMOUNT  ,PRODUCT.NISD_AMOUNT  ,PRODUCT.RESULTS_NISD_AMT

  PRODUCT.TAX_ID_LETTER  ,PRODUCT.TAX_ID_DATE  ,PRODUCT.TAX_ID_CODE  ,
  PRODUCT.E_MAIL_ADDRESS  ,PRODUCT.ASSIST_CANVASS_CODE  ,
  PRODUCT.ASSIST_CANV_ISS_NUM  ,PRODUCT.CURP_ID

,PRODUCT.HIGH_AMT_COLOR_CODE

,PRODUCT.PREV_HIGH_AMT_COLOR ,PRODUCT.CTCR_BATCH_PROG_ID , TO_CHAR(PRODUCT.CTCR_BATCH_PROG_DT,'YYYYMMDD') , PRODUCT.CTCR_ONLINE_USER_ID ,PRODUCT.CTCR_ONLINE_PROG_ID ,

  TO_CHAR(PRODUCT.CTCR_ONLINE_PROG_DT,'YYYYMMDD')  ,
  TO_CHAR(PRODUCT.CTCR_SYS_CRE_DT,'YYYYMMDDHH24MISS')  ,
  TO_CHAR(PRODUCT.CTCR_SYS_UPD_DT,'YYYYMMDDHH24MISS')  ,

  PRODUCT.CTCR_DBI_PROG_ID
,TO_CHAR(PRODUCT.CTCR_DBI_PROG_DT,'YYYYMMDD') ,
  TO_CHAR(PRODUCT.CTCR_CNV_DT,'YYYYMMDD') ,PRODUCT.CTCR_EVENT_ID into
  :b1:i1,:b2:i2,:b3:i3,:b4:i4,:b5:i5,:b6:i6,:b7:i7,:b8:i8,:b9:i9,:b10:i10,   :b11:i11,:b12:i12,:b13:i13,:b14:i14,:b15:i15,:b16:i16,:b17:i17,:b18:i18, :b11:i11,:b12:i12,:b13:i13,:b14:i14,:b15:i15,:b16:i16,:b17:i17,:b18:i18,

  :b19:i19,:b20:i20,:b21:i21,:b22:i22,:b23:i23,:b24:i24,:b25:i25,:b26:i26,
  :b27:i27,:b28:i28,:b29:i29,:b30:i30,:b31:i31,:b32:i32,:b33:i33,:b34:i34,
  :b35:i35,:b36:i36,:b37:i37,:b38:i38,:b39:i39,:b40:i40,:b41:i41,:b42:i42,
  :b43:i43,:b44:i44,:b45:i45,:b46:i46,:b47:i47,:b48:i48,:b49:i49,:b50:i50,
  :b51:i51,:b52:i52,:b53:i53,:b54:i54,:b55:i55,:b56:i56,:b57:i57,:b58:i58,
  :b59:i59,:b60:i60,:b61:i61,:b62:i62,:b63:i63,:b64:i64,:b65:i65,:b66:i66,
  :b67:i67,:b68:i68,:b69:i69,:b70:i70,:b71:i71,:b72:i72,:b73:i73,:b74:i74,
  :b75:i75,:b76:i76,:b77:i77,:b78:i78,:b79:i79

from
PRODUCT where ((CUSTOMER_ID=:b80 and PRODUCT_CODE=:b81) and PRODUCT_ISSUE_NUM=:b82)

call     count       cpu    elapsed       disk      query    current  
     rows

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

Parse     1063      0.10       0.17          0          0          0  
        0
Execute   4705      0.71       1.30          0          0          0  
        0
Fetch     4705      1.36       2.76         84      14115          0  
     4705

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

total    10473      2.17       4.23         84      14115          0  
     4705

Received on Sun May 09 2004 - 08:15:11 CDT