At 06:09 AM 29/08/2010, Michael Ludwig wrote:

>Okay, I'll try, in the hope of being corrected by the pros if my
>assessment is flawed.
>.....
>Your old transaction is unlikely to be READ COMMITTED as the oldest
>snapshot is even much older, and READ COMMITTED transactions do not
>hold on to old snapshots so do not inhibit garbage collection

Not so. The only condition under which that is true is if the Read Committed transaction is read-only. All uncommitted read-write transactions stay "interested" in records they touch, even if they are only reading them.

./heLen