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

Explain what you mean by memory alignment.

0 Answers   TCS,


What are loosely coupled systems?

0 Answers  


Is internet explorer still supported?

0 Answers  


Discuss some of the reasons for implementing process migration ?

1 Answers  


Explain the concept of Thread Pool? what its Benefits?

0 Answers   Sans Pareil IT Services,


Explain the handheld systems. List the issues related to the handheld system.

0 Answers  


What are dynamic loading?

0 Answers  


Why is ram also known as volatile memory?

0 Answers  


Can bad sectors cause blue screen?

0 Answers  


What are the popular strategies used for multiprocessor thread-scheduling?

0 Answers   Accenture,


Tell something about deadlock and how can we prevent dead lock?

0 Answers   TCS,


Does more ram increase fps?

0 Answers  


Categories