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 |
Can you run 32 bit applications on a 64 bit operating system?
How much ram do I need laptop?
what is assembler?
What is process spawning?
What is spooling?
What is Marshalling?
What is a mission critical system?
How do I know if my cpu is overheating?
What is virtual memory and where it exhist ?
What was the last 32 bit processor?
Explain what are device drivers used for?
Semafore is used for? a) synchronization b) dead-lock avoidence c)box d) none