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

Which technology does Pentium use - RISC or CISC?

0 Answers   Tech Mahindra,


What is short term scheduler in operating system (os)?

0 Answers  


What has triggered the need for multitasking in PCs?

1 Answers  


Can a 64 bit computer run 32 bit programs?

0 Answers  


Describe system calls and its type

0 Answers  


what is Linker?

3 Answers  


Explain the Functionality of Operating System?

0 Answers   Wipro,


What has triggered the need for multitasking in PCs?

1 Answers  


In a ram description ddr 2 1066mhz “2.5-3-3-8” what do the numbers in quotes signify?

0 Answers  


What do you mean by Belady's Anomaly. - Describe with example.

4 Answers   IBM,


How to stop a long running thread?

0 Answers   Sans Pareil IT Services,


Command Kill any user’s all processes.

0 Answers  


Categories