oracle跨库关联慢,跨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);

单独执行SELECT,用时0.078s

SELECT SYSDATE,

'3',

EPARCHY_CODE,