Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock granularity?
- 1 Answers
- 5371 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How do I enable plugins on firefox?
What is a semaphore? What are the different types of semaphores?
What is the most used operating system?
What are starvation and aging?
Can a 64 bit computer run 32 bit programs?
What are the main functions of a kernel?
Should I use x86 or x64?
Is faster ram worth it?
Do I need program files and program files x86?
Explain the stipulations of c2 level security?
When does trashing occur?
What is the purpose of the command interpreter? Why is it usually separate from the kernel?
Windows 
