When exclusive lock is on process, no other lock can be placed on the row or table. Every other process has to wait until the exclusive lock completes its tasks.
An update lock is a type of exclusive lock, except that it can be placed on the row which already has shared lock on it. Update lock can read the data of the row which has the shared lock. As soon as the update lock is ready to change the data it converts itself to the exclusive lock.
An update lock is a type of exclusive lock, except that it can be placed on the row which already has shared lock on it. Update lock can read the data of the row which has the shared lock. As soon as the update lock is ready to change the data it converts itself to the exclusive lock.
Update lock can read the data of the row which has the shared lockkole locksmith indianapolis
ReplyDeleteIt is a very helpful and informative blog post. I would like to thank to you for providing such information I have also have a website providing very good information. Bus ren
ReplyDelete