Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is lock granularity?

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


Please Help Members By Posting Answers For Below Questions

What is starvation and aging?

1081


What is run level 1?

978


Explain the main purpose of an operating system?

1066


Hi Freinds, Any body is wotking as System Administrator, Please mail me rakesh.kesh881@gmail.com

2149


How much ram do I need 2019?

908


What is hard disk?

965


Is 32 gb ram enough for gaming?

877


What killed mandla maseko?

982


What do you understand by multi-threading and multi-tasking?

1003


Tell me about different OS related issues for a given set of C-programs (mainly address issues address space, paging etc.)

1010


Differentiate between Multiprocessing, Mutliprogramming and Multithreading.

1215


What is the difference between logical address space and physical address space?

1040


Under what circumstances do page faults occur?

1109


Differentiate between swapping and paging.

1055


What are the advantages of distributed system?

921