Re: Excessive Logical IOs against which Table/Index

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 26 Apr 2016 10:32:52 +0200 (CEST)
Message-ID: <1558560440.873722.1461659572559.JavaMail.open-xchange_at_app04.ox.hosteurope.de>



Hello Jessica,
just be aware that AWR does not store the whole execution plan (e.g. access / filter predicates). So there is a fair possibility that your execution plan looks like the same when it is not. Unfortunately the plan hash value is not enough.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> Jessica Mason <jessica.masson85_at_gmail.com> hat am 26. April 2016 um 09:30 geschrieben:
>
> Hi Kellyn, Jonathan, Stefan, Lothar & Carlos
>
> Thanks you all for your suggestions and pointers.
>
> I have already requested the project team to keep the historical data for atleast 90 days, so that in future, we can compare the optimal plans with
> the problematic plan. I'm also pushing the management for more privileges so that I can leverage all the tools recommended by you and can
> troubleshoot issues more efficiently and effectively.
>
> Thanks
> JM

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 26 2016 - 10:32:52 CEST

Original text of this message