Hi,

I have a MERGE...UPDATE/INSERT running across a dblink.
Im getting an error -> 'ORA-02049: timeout: distributed transaction waiting for lock'.

I have read the solution might be to increase the distributed timeout parameter in init.ora

1) Would this need to be increased on local or remote server? Or both?
2) Could this cause problems for any other applications that might be in use on the server or can this be localised for the database Im working with?

Thank You for your help.


MERGE INTO TBL_PROD_MATRIX_DIM local_matrix
USING ( SELECT * FROM wafer.PC_MATRIX2 -- ***A view that uses dblink
WHERE slidcode ='@'
) remote_matrix
ON ( local_matrix.PROD = remote_matrix.PROD
AND
local_matrix.SLID_CODE = remote_matrix.SLIDCODE
)
WHEN MATCHED THEN
UPDATE
SET
local_matrix.PSWD_GROUP = remote_matrix.PSWDGROUP
................