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

Can you run 32 bit applications on a 64 bit operating system?

0 Answers  


How much ram do I need laptop?

0 Answers  


what is assembler?

4 Answers  


What is process spawning?

4 Answers   Syntel,


What is spooling?

0 Answers  


What is Marshalling?

1 Answers  


What is a mission critical system?

0 Answers   CSE,


How do I know if my cpu is overheating?

0 Answers  


What is virtual memory and where it exhist ?

0 Answers   MCN Solutions,


What was the last 32 bit processor?

0 Answers  


Explain what are device drivers used for?

0 Answers   BPL,


Semafore is used for? a) synchronization b) dead-lock avoidence c)box d) none

6 Answers   HCL,


Categories