What is lock granularity?
- 1 Answers
- 4287 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 major difference between Thread.start() & Thread?run() method?
Why do we need inter process communication?
What is chkdsk command?
Explain briefly about, processor, assembler, compiler, loader, linker and the functions executed by them.
Can I install 64 bit on x86?
How do you tell if your os is corrupted?
What is rdram?
Define trashing?
I was able to change my MAC-ID(Physical Address)? I would like to know will that MAC-ID i created is not default, how could i make the ID default?
What are the different types of kernel?
What is a 64 bit operating system?
Can you please explain the difference between trap and trapdoor?
Windows 
