Select For UPDATE NOWAIT
is performed on a table by 20 processes in parallel
The error below is returned by the 4 processes out of 20 (16 processes are successful)
SQL_UPDATE_ERROR- : SQL update error ORA-02049: timeout: distributed transaction waiting for lock ORA-02063
Are there some parameters in Oracle, which define how many connections can be made to a table using a database link?
Order of the Steps is Select