What is lock granularity?
- 1 Answers
- 4283 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 |
Explain the difference between trap and trapdoor?
Explain 32 bit application/OS vs 64 application/OS?
File which stores the DNS configuration at client side?
What are numerous ways in which a thread can enter the waiting state?
List the possible threads a thread can have?
Explain the difference between demand-paging and pre-paging?
How much ram can you put in a 64 bit system?
What is the difference between tty and pts?
Does chkdsk erase data?
What is bursting?
Will chkdsk fix bad sectors?
What is preemptive multitasking?
Windows 
