跨DBLINK Insert into慢的问题解决

一、问题描述

今天用户给出一个SQL，select执行很快，但是insert进表时就很慢，半天没个动静。

SQL执行用时：310s

INSERT INTO uop_sta_cen.WXL_IDC_STATE

  (INS_DATE, DOMAIN_ID, EPARCHY_CODE, CUST_ID, USER_ID, SERIAL_NUMBER)

  SELECT SYSDATE,

         '3',

         EPARCHY_CODE,

         to_char(CUST_ID),

         to_char(USER_ID),

         SERIAL_NUMBER

    FROM UCR_CRM3.TF_F_USER@UQRY_SEL_TO_HACRMDB22 T

   WHERE T.REMOVE_TAG = '0'

     AND T.USER_ID IN

         (SELECT A.USER_ID

            FROM UCR_CRM3.TF_F_USER_SVC@UQRY_SEL_TO_HACRMDB22 A

           WHERE A.SERVICE_ID IN ('46000003', '46000005', '46000006')

             AND SYSDATE BETWEEN A.START_DATE AND A.END_DATE);