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:
“When the landscape buckles and jerks around, when a dust column of debris rises from the collapse of a block of buildings on bodies that could have been your own, when the staves of history fall awry and the barrel of time bursts apart, some turn to prayer, some to poetry: words in the memory, a stained book carried close to the body, the notebook scribbled by hand—a center of gravity.”
—Adrienne Rich (b. 1929)
“It is my contention that civil disobedients are nothing but the latest form of voluntary association, and that they are thus quite in tune with the oldest traditions of the country.”
—Hannah Arendt (1906–1975)