According to an old copy of oraus.msg, that's been around since at least 10.2.0.1 - and I missed it ! Still, those oraus.msg files aren't what you'd call a gripping read on cold winter's evening. Anyone got a 9.2.0.8 or 10.1.0.4 to check if it arrived even earlier than 10.2 ? Regards Jonathan Lewis ________________________________ From: tanel@xxxxxxxxxx [tanel@xxxxxxxxxx] on behalf of Tanel Poder [tanel@xxxxxxxxxxxxxx] Sent: 05 October 2012 03:54 To: Administrator User Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Excessive transaction tables consistent reads - undo records applied in 11.2.0.3 If you don't mind occasionally getting wrong results (as this is undocumented, unused and unsupported feature), you can use event 10460 "Perform backward tablescans for consistent read reduction" for backwards full table scans ;-) -- Tanel Poder -- //www.freelists.org/webpage/oracle-l