Tables are getting locked.

Tables are getting locked.

  

Hi Everyone,

                      I have a scenarios like -

i am doing two operation in a single transaction update record and then select the same record,

 so my question is what are the possible scenarios that the corresponding table will get locked.

My understanding is if one user is updating a record, and other user is trying to  select the same record at the same time then the table will get locked for user 2, until the user 1 update will not complete.



Thanks

Rajendra Singh 

Solution

Hi Rajendra,


Unless you are using the "GetForUpdate" actions, typically selects do not wait for update locks.
If you are updating the same records in multiple transactions and then doing long operations after it, you may need to consider doing explicit commits to release the locks when possible.


Regards,
João Rosado

Solution

João Rosado wrote:

Hi Rajendra,


Unless you are using the "GetForUpdate" actions, typically selects do not wait for update locks.
If you are updating the same records in multiple transactions and then doing long operations after it, you may need to consider doing explicit commits to release the locks when possible.


Regards,
João Rosado


Thanks João Rosado



Thanks

Rajendra Singh