Question

what is lock table and how we can avoid our transaction from strarvation?​

Answer 1

Answer:

A locked table remains locked until you either commit your transaction or roll it back, either entirely or to a savepoint before you locked the table. A lock never prevents other users from querying the table. A query never places a lock on a table.

Random selection of processes for resource allocation or processor allocation should be avoided as they encourage starvation. The priority scheme of resource allocation should include concepts such as aging, where the priority of a process is increased the longer it waits. This avoids starvation.

hope it helps u

#NAWABZAADI