Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When table is going to be locked?

JackKOct 14 2021

Hi All.
In our application we are using Java as backend layer.
We have a requirement to allow several operations in a database and changes should be commited only after the user's click on "Save" button.
We obey above requirement by the use of transactionality in DB.
However, we are facing an issues with locks.
When user1 is editing "card1 object" and user2 wants to edit "card2 object" sometimes user2 is even not able to read data from table containing "card objects".
We are not using any "lock table" command.
Is there any limit of number of rows changed in a table that when exceeded results in exclusive table lock?
If yes, is it configurable and may it me increased to some high value to prevent exclusive locks?
If no, what solution do you suggest to prevent locks? I am thinking about involving temporary tables.

Any help is highly welcomed.
Regards,
Jacek

Comments
Post Details
Added on Oct 14 2021
14 comments
1,360 views