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