Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock granularity?
- 1 Answers
- 5139 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 get to the root directory?
Is 32 gigs of ram overkill?
How do I recover files from my usb?
What is the unified memory architecture? Explain.
How do I upgrade my excel to 64 bit?
How do you exit a screen?
How do I know if I have a 64 bit processor?
Explain the following file systems : NTFS, Macintosh(HPFS), FAT ?
How do I know if my motherboard is 32 bit or 64 bit?
Explain the difference between micro-kernel and macro-kernel? Give an examples of micro-kernel and macro-kernel?
Under what circumstances do page faults occur? Describe the actions taken by the operating system when a page fault occurs?
Difference between a thread and process?
Windows 
