Strange parse counter on tkprof
From: Elir <elire_at_amdocs.com>
Date: 9 May 2004 06:15:11 -0700
Message-ID: <e7cbfa45.0405090515.31bdfc27_at_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 .
,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.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.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.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_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,
PRODUCT where ((CUSTOMER_ID=:b80 and PRODUCT_CODE=:b81) and PRODUCT_ISSUE_NUM=:b82)
------- ------ -------- ---------- ---------- ---------- ----------
------- ------ -------- ---------- ---------- ---------- ----------
Date: 9 May 2004 06:15:11 -0700
Message-ID: <e7cbfa45.0405090515.31bdfc27_at_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:i79from
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 4705Received on Sun May 09 2004 - 15:15:11 CEST