In database management systems, block contention refers to multiple processes or instances competing for access to the same index or data block at the same time. In general this can be caused by very frequent index or table scans, or frequent updates. Concurrent statement executions by two or more instances may also lead to contention, and subsequently Busy waiting for the process without the lock.
Read more about Block Contention: Solutions
Famous quotes containing the words block and/or contention:
“No contact with savage Indian tribes has ever daunted me more than the morning I spent with an old lady swathed in woolies who compared herself to a rotten herring encased in a block of ice.”
—Claude Lévi-Strauss (b. 1908)
“The making of a picture ought surely to be a rather fascinating adventure. It is not; it is an endless contention of tawdry egos, some of them powerful, almost all of them vociferous, and almost none of them capable of anything much more creative than credit-stealing and self- promotion.”
—Raymond Chandler (1888–1959)