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 |
Critical section is?
Give some benefits of multithreaded programming.
Hello this is gaurav garg I have completed BCA. plz TEll me how will ask question in interview.
Explain the trda?
How do you check if your computer is 32 or 64 bit?
Why do we need inter process communication?
What happens if we don’t override a run method?
What are the main advantages of the microkernel approach to system design?
How you can detect deadlock condition?
Differentiate between Multiprocessing, Mutliprogramming and Multithreading.
What are residence monitors?
What are the 7 c's of communication?