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 |
Explain Belady's Anomaly?
Does deleting all files uninstall a program?
Describe system calls and its type
Explain briefly about compiler and its functioning?
What is DRAM?
What are the advantage of using threads?
Can ROM be used as stack?
What are the stipulations of C2 level security?
Can I use ie with google chrome?
What is meant by arm-stickiness?
Explain the concept of the multi-processor systems or parallel systems?
How do I remove a second operating system from my computer?