RE: Excessive transaction tables consistent reads - undo records applied in 11.2.0.3
From: Administrator User <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 5 Oct 2012 06:24:10 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90B2347_at_exmbx06.thus.corp>
From: tanel_at_poderc.com [tanel_at_poderc.com] on behalf of Tanel Poder [tanel_at_tanelpoder.com] Sent: 05 October 2012 03:54
To: Administrator User
Cc: oracle-l_at_freelists.org
Subject: Re: Excessive transaction tables consistent reads - undo records applied in 11.2.0.3
Date: Fri, 5 Oct 2012 06:24:10 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90B2347_at_exmbx06.thus.corp>
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_at_poderc.com [tanel_at_poderc.com] on behalf of Tanel Poder [tanel_at_tanelpoder.com] Sent: 05 October 2012 03:54
To: Administrator User
Cc: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 05 2012 - 08:24:10 CEST