What is lock granularity?
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 load-time dynamic linking and run-time dynamic linking?
What does echo $$ do?
How do I know if my ram is corrupted?
What are dynamic loading, dynamic linking and overlays?
Define demand paging?
What is 32 bit operating system?
Describe the actions taken by the operating system when a page fault occurs?
What is starvation and aging?
What are the functions of the ram ic`s?
how to install operating system through USB pen drive ?
What is x32 and x64?
What are the possible threads a thread can have?