We have an application used for online share trading and 400+
transaction per second. There are couple of small tables, like 1 row, 8
rows, 9 rows and 88 rows are accessed very frequently, I can say, every
transaction, touches these tables for updates. The session who access
these tables suddenly waits on latch free and system goes in hung
stage. We tried to keep one row in one block, still, we face the hot
block becuase tables are small. There an interesting paper from Poder
presented during hotsos 2004 seminar.
http://integrid.info/Poder_Small_Tables.pdf
Received on Mon Mar 13 2006 - 01:08:22 CST
