Unanswered: Increasing the distributed_timeout lock
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 ='@'
ON ( local_matrix.PROD = remote_matrix.PROD
local_matrix.SLID_CODE = remote_matrix.SLIDCODE
WHEN MATCHED THEN
local_matrix.PSWD_GROUP = remote_matrix.PSWDGROUP