New answers tagged lock
Got a Solution. Increase the Value of INITRANS and Rebuild the Indexes Helped. Table accessed via DB_LINK has INITRANS = 1, resulting in too much ITL Waits ~200 and Row Lock Waits ~100000. Now the INITRANS Value is increased to 20, resulting in No Row Lock wait for Distributed/Concurrent Transactions.
Top 50 recent answers are included