What is lock granularity?
Answer / vishal the expert
The level and type of information that the lock protects is
called locking granularity. Locking granularity affects
performance. When a user cannot access a row or key, the
user can wait for another user to unlock the row or key. If
a user locks an entire page, a higher probability exists
that more users will wait for a row in the page. The
ability of more than one user to access a set of rows is
called concurrency. The goal of the database administrator
is to increase concurrency to increase total performance
without sacrificing performance for an individual user.
Is This Answer Correct ? | 3 Yes | 0 No |
What is synchronously and asynchronously?
What are the functions of the ram ic`s?
what is Demand Paging?
What is ThreadPool?
What is the function of the control lines in ram?
In the context of memory management, what are placement and replacement algorithms?
What is a safe state and its’ use in deadlock avoidance?
Explain latency, transfer and seek time with respect to disk i/o.?
Is non-pre-emptive scheduling frequently used in a computer? Why?
What is the need of device status table?
How do you fix a blue screen?
Can you please explain the difference between trap and trapdoor?