Re: Compare two AWR execution plan

I normally do not care about plans from the past. I use cardinality feedback, to find out where the optimizer goes wrong. I try to fix the stats and the statement text so that the optimizers estimates correct. That normally does the job. The result is quite often a better plan than the "good" plan from the past.

On 07.11.2016 21:21, Karl Arao wrote:
>
> I would use SQLT-compare on the good and bad plans
>
> here's my notes
> http://karlarao.tiddlyspot.com/#SQLT-compare
>
>
>
> -Karl
>
>
>
> On Mon, Nov 7, 2016 at 2:59 PM, Sanjay Mishra
> <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org>> wrote:
>
> Hi
>
> Can someone help in guiding the way to compare very big execution
> plan available in AWR. I had same statement behaving differently
> in one of 10g Dagtabase and after checking the SQL ID and
> different plan Hash value found big difference in timing. Now need
> to compare 5 page Execution plan and so if someone has done it and
> can share any process
>
> I had compared the same using sql developer but that is done by
> running the SQL with some change in syntax and comparing Autotrace
> option. Here SQL is same but plan was different which can be due
> to Statistics or so
>
> TIA
> Sanjay
>
>
>
>
> --
> Karl Arao
> Blog: karlarao.wordpress.com <http://karlarao.wordpress.com>
> Wiki: karlarao.tiddlyspot.com <http://karlarao.tiddlyspot.com>
> Twitter: _at_karlarao <http://twitter.com/karlarao>

-- 





--
http://www.freelists.org/webpage/oracle-l