Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock granularity?
- 1 Answers
- 5260 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 |
What is the virtual memory?
How do I stop chkdsk at startup?
Is 64 bit excel faster?
What has triggered the need for multitasking in PCs?
What are the thread states?
What are merits and demerits of systems supporting multiple file structure and systems supporting a stream of bytes?
Can you move program files x86 to another drive?
Why is it that a single, all – encompassing metric cannot be developed for programme complexity or programme quality?
How do I know if my motherboard is 32 bit or 64 bit?
What is the best suited algorithm to avoid internal fragmentation?
What advantage is there in having different time-quantum sizes on different levels of a multilevel queuing system?
How can I tell if a program is 64 bit?
Windows 
