Hello All,
Oracle 11gR2.
In our company we use an application that we cannot manipulate. This application connect to our Oracle database. In this application if you want to do any DML, the records are select with FOR UPDATE. The problem is NOWAIT clause is not used in this application. So when people want to manipulate rows simultaneous they have to wait each other. Therefore, sometimes tens of people have to wait the records to be unlocked.
So, I want to prevent these waiting process. If NOWAIT clause used in the app. Users didn't need to wait each other. Is there any way to stop waiting? Is there any parameter that I can set when SELECT FOR UPDATE statement run NOWAIT clause is automatically added?
Thanks in advance.