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:
“For Jews demand signs and Greeks desire wisdom, but we proclaim Christ crucified, a stumbling block to Jews and foolishness to Gentiles...”
—Bible: New Testament, 1 Corinthians 1:22-3.
“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)