Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock granularity?
- 1 Answers
- 5369 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 are advantages of operating system?
Different types of real-time scheduling?
What is the major difference between Thread.start() & Thread?run() method?
Write syntax to set JVM Memory as min-256Mb & max 512Mb?
Differentiate between RAM and ROM?
8 Answers DELL, Polytechnic Ibadan,
Can chkdsk damage a hard drive?
How does swapping result in better memory management?
Tell me is windows nt a full blown object oriented operating system? Give reasons?
List the possible threads a thread can have?
semaphore is
What is a safe state and a safe sequence?
Explain segmentation with paging?
Windows 
