merge into using 插入数据效率较慢

merge into using插入数据效率较慢,有啥好的优化方法吗?

代码如下:
MERGE INTO HHB_UO_INFO_TEMP T1
USING(

select
#{item.opId,jdbcType=VARCHAR} opId,
#{item.opName,jdbcType=VARCHAR} opName,
#{item.phone,jdbcType=VARCHAR} phone,
#{item.createDate,jdbcType=DATE} createDate,
#{item.opStatus,jdbcType=VARCHAR} opStatus,
#{item.validDate,jdbcType=DATE} validDate,
#{item.expireDate,jdbcType=DATE} expireDate,
#{item.cityId,jdbcType=VARCHAR} cityId,
#{item.countyId,jdbcType=VARCHAR} countyId,
#{item.orgId,jdbcType=VARCHAR} orgId,
#{item.regType,jdbcType=VARCHAR} regType,
#{item.regNbr,jdbcType=VARCHAR} regNbr,
#{item.address,jdbcType=VARCHAR} address,
#{item.postCode,jdbcType=VARCHAR} postCode,
#{item.lockStatus,jdbcType=VARCHAR} lockStatus,
#{item.sdyy,jdbcType=VARCHAR} sdyy,
#{item.sdDate,jdbcType=DATE} sdDate,
#{item.orgType,jdbcType=VARCHAR} orgType,
#{item.validStatus,jdbcType=VARCHAR} validStatus,
#{item.opType,jdbcType=VARCHAR} opType
from DUAL

)T2
ON (1 = 0)
WHEN NOT MATCHED THEN INSERT
(USER_NAME,USER_MOBILE,OP_ID,CREATE_DATE,OP_STATUS,VALID_DATE,EXPIRE_DATE,CITY_ID,COUNY_ID,ORG_ID,REG_TYPE
,REG_NBR,ADDRESS,POST_CODE,LOCK_STATUS,LOCK_REASON,LOCK_DATE,ORG_TYPE,VALID_STATUS,OP_TYPE)
VALUES
(T2.opName,T2.phone,T2.opId,T2.createDate,T2.opStatus,T2.validDate,T2.expireDate,T2.cityId,T2.countyId,T2.orgId,T2.regType,T2.regNbr,T2.address,T2.postCode,T2.lockStatus,T2.sdyy,T2.sdDate,T2.orgType,T2.validStatus,T2.opType)

oracle企业版功能建议去咨询企业工单同学。
建议你通过以下方式寻求帮助:
1.如你所在的企业客户已签署OceanBase企业版销售合同,请你联系客户经理;
2.如你所在的企业客户尚未签署OceanBase企业版销售合同,你可通过OceanBase官网商务咨询页面留下你的联系方式,OceanBase企业版的业务顾问会在一个工作日内与你联系。
OceanBase官网商务咨询

https://www.oceanbase.com/contactus?fromPage=https%3A%2F%2Fwww.oceanbase.com%2Fsoftwarecenter-enterprise&dataSources=softwarecenter-enterprise_footercontact_d2022