Re: 11gr2 sql issue
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 8 Nov 2011 19:37:17 -0800
Message-ID: <CAHDOOG51fuDT=T5JZ9b0rpxs2_B5D7vXFYvmtYcegXnj4_QeCA_at_mail.gmail.com>
Greg
I did explain plans too and there were changes (i thought i mentioned this..). We just took a 10053 trace to see if we can get any other useful information as originally when the developer ran this from TOAD the sql never completed. We did not even have a sql id at that time. But what striked me was this event. The same query runs fine when I use the ordered hint or set the optimizer_features_enabled to 11.1.0.7 and the event no longer appears
I was not mentioning about 10053 trace being useful though but se.sql . Explain plan does show differences obviously. On Tue, Nov 8, 2011 at 7:30 PM, Greg Rahn <greg_at_structureddata.org> wrote:
Date: Tue, 8 Nov 2011 19:37:17 -0800
Message-ID: <CAHDOOG51fuDT=T5JZ9b0rpxs2_B5D7vXFYvmtYcegXnj4_QeCA_at_mail.gmail.com>
Greg
I did explain plans too and there were changes (i thought i mentioned this..). We just took a 10053 trace to see if we can get any other useful information as originally when the developer ran this from TOAD the sql never completed. We did not even have a sql id at that time. But what striked me was this event. The same query runs fine when I use the ordered hint or set the optimizer_features_enabled to 11.1.0.7 and the event no longer appears
I was not mentioning about 10053 trace being useful though but se.sql . Explain plan does show differences obviously. On Tue, Nov 8, 2011 at 7:30 PM, Greg Rahn <greg_at_structureddata.org> wrote:
> 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-lReceived on Tue Nov 08 2011 - 21:37:17 CST