Re: 11gr2 sql issue

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 8 Nov 2011 19:30:47 -0800
Message-ID: <CAGXkmitfU1f20qmV4o7mOFksonGdV1dzCzcJCLgo15MrospOHw_at_mail.gmail.com>

I'd disagree that this is useful -- the most useful information with plan changes is simply the full plans (dbms_xplan) and you dont even need a 10053 trace for that.

On Tue, Nov 8, 2011 at 7:05 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
> Hi
> As part of regression testing in our db upgrade from 11.1.0.7 to 11.2.0.2,
> one of the developers reported a slow sql (attached slow_sql.sql)
> We did a 10053 trace and noticed one of the things was wip_entities was not
> doing a Index scan in 11gR2 vs 11gR1.
> But what is most useful till this point is Tanel's se.sql script which
> reports this

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 08 2011 - 21:30:47 CST