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:
“Painting consumes labour not disproportionate to its effect; but a fellow will hack half a year at a block of marble to make something in stone that hardly resembles a man. The value of statuary is owing to its difficulty. You would not value the finest head cut upon a carrot.”
—Samuel Johnson (1709–1784)
“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)