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?



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

Post New Answer

More Operating Systems General Concepts Interview Questions

Describe the Operating System concept of Segmentation

0 Answers   Tech Mahindra,


To ensure one program doesnt corrupt other program in a Multi program enviornment what you should do?

0 Answers  


What is Difference between thread and process?

28 Answers   AirTies, Azingo, Bloomberg, Encora, Goldman Sachs, HCL, HP, MES, Microsoft, Samsung,


What are the typical elements of a process image?

3 Answers   Accenture,


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

0 Answers  


What are the different types of scheduling algorithms?

0 Answers  


How do I install operating system?

0 Answers  


List the possible threads a thread can have?

0 Answers  


How do I know if my ram is corrupted?

0 Answers  


Why do we use semaphore?

0 Answers  


What are the various capacities in which a ram is available?

0 Answers  


What is a 32 bit integer?

0 Answers  


Categories