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: @OracleSK
Jessica Mason <jessica.masson85@xxxxxxxxx> 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