Answer Posted / 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 |
Post New Answer View All Answers
How are the wait/signal operations for monitor different from those for semaphores?
What are the states of a process?
How does operating system kernel work?
How much cpu usage is normal?
Explain the concept of the timesharing operating systems?
What are distributed systems?
What happens if you install 64 bit on 32?
What is ecc in reference to ram?
What is a socket?
State the main difference between logical from physical address space.
Give an example of Priority Inversion in Scheduling. What are the consequences of Priority Inversion?
How do I empty my mac cache?
Can you tell what a device is by mac address?
Will chkdsk repair corrupt files?
Do I need both program files and program files x86?