Inserting data into CUST table via BDF is running very long (Doc ID 2558686.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

Inserting data into CUST table via BDF is running very long.
  insert /*+APPEND */ into
  CUST(CUST_INTRL_ID,FNCL_PRFL_LAST_UPDT_DT,DMCLD_BRCH_ORG_ID,CUST_TYPE
  _CD,CUST_ADD_DT,TAX_ID,TAX_ID_FRMT_CD,MANTAS_CUST_BUS_TYPE_CD,ANNL_IN
  CM_RPTG_AM,ANNL_INCM_BASE_AM,NET_WRTH_RPTG_AM,NET_WRTH_BASE_AM,LQD_NE
  T_WRTH_RPTG_AM,LQD_NET_WRTH_BASE_AM,EQTY_KNLDG_CD,BND_KNLDG_CD,OPTN_K
  NLDG_CD,OVRALL_KNLDG_CD,DAY_TRD_KNLDG_CD,EQTY_EXP_YR_QT,BND_EXP_YR_QT
  ,OPTN_EXP_YR_QT,OVRALL_EXP_CD,DAY_TRD_EXP_CD,ANNL_EQTY_TRD_QT,ANNL_BN
  D_TRD_QT,ANNL_OPTN_TRD_QT,AVG_EQTY_TRD_AM,AVG_BND_TRD_AM,AVG_OPTN_TRD
  _AM,RPTG_CRNCY_CD,FIRST_NM,LAST_NM,MIDL_NM,SUFF_NM,TITL_NM,MPLYR_FINC
  L_INST_FL,BIRTH_DT,CTZSHP_CNTRY1_CD,CTZSHP_CNTRY2_CD,RES_CNTRY_CD,MPL
  YR_NM,MPLMT_STAT_CD,MRTL_STAT_CD,DPNDT_QT,OCPTN_NM,ORG_NM,AGE_YR_CT,C
  TZSHP_STAT_CD,WLTH_SRC_DSCR_TX,EMP_FL,ORG_LGL_STRUC_CD,PWD_LAST_CHG_D
  T,ALIAS_NM,FRGN_ASSETS_FL,MPLYR_INDUS_CD,JOB_TITL_NM,CUST_BUS_RISK_NB
  ,CUST_GEO_RISK_NB,BUS_DMN_LIST_TX,JRSDCN_CD,SRC_SYS_CD,CUST_CDT_RTNG_
  SRC,CUST_CDT_SCORE,CUST_STAT_CD,TAXTN_CNTRY_CD,CUST_INDUS_CD,CUST_INC
  _DT,RGSTN_TYPE_CD,PUBLC_PRIVT_CD,ALT_CUST_ID,WLTH_COMP_FL,CMDTY_KNLDG
  _CD,CMDTY_EXP_YR_QT,AVG_CMDTY_TRD_AM,ANNL_CMDTY_TRD_QT,FRGN_PUBLC_OFF
  CL_FL,RETRMT_YEAR,CUST_GNDR_CD,CUST_NAICS_CD,RECALCITRANT_FL,NON_US_C
  TZN_RES_FL,NON_US_DOC_HOLDER_FL,CERT_LOSS_NATION_FL,CNTRY_OF_BIRTH,CN
  TRY_OF_INC,MAX_DAILY_ATM_WDRWL_AM,GOVT_DOC_FL,THRD_PARTY_CDT_RPT_FL,F
  RGN_TAX_RPTNG_CERT_FL,EXCEPTED_NFFE_FL,FATCA_ORG_TYPE_CD,GEO_JRSDCN_C
  D,INCM_RNG_CD,CUST_SEQ_ID,PRCSNG_BATCH_NM,DATA_DUMP_DT,CUST_EFCTV_RIS
  K_NB,FULL_NM,CSTM_1_TX,CSTM_2_TX,CSTM_3_TX)SELECT
  /*+Parallel(stg_party_master,8)*/
  STG_PARTY_MASTER.V_PARTY_ID,STG_PARTY_DETAILS.D_FIN_PROF_LAST_UPD_

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.