Answer Posted / 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 |
Post New Answer View All Answers
How can a vfs layer allow multiple file systems support?
What do you mean by threads in Operating System?
Explain the difference between logical & physical address.
What is Page-Stealer process?
How many types of os are there?
What happens if you install 64 bit on 32?
Explain paging, faulting, and deadlock?
What is eide?
What are the different types of fragmentation?
Explain High Severity and Low Priority with example?
Who made the first 64 bit processor?
Hello this is gaurav garg I have completed BCA. plz TEll me how will ask question in interview.
Is it possible to have a deadlock involving only one process?
What is the difference between shared memory and message passing?
How does gcd work?