Re: Instrumenting Poor performance

Hello Upendra,
sure, if you have licensed Oracle's diagnostics/tuning pack.

You can run SQLd360 (https://github.com/sqldb360/sqldb360) for that particular SQL ID and then have a look at the "34. Plans Details" page (if historical SQL Monitoring Reports are not available anymore). It got a section called "Top Executions from history" and "Top 15 Wait events over historical time for PHV ....." which helps you to understand what is going on :)

Of course ASH data is not enough if it is some kind of fancy stuff but give it a try to spot something very obvious :-)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Upendra nerilla <nupendra_at_hotmail.com> hat am 14. September 2018 um 04:54 geschrieben:
>
> Thanks Martin. That helps.. 
> I have used orasrp and TVD$XTAT, both are great.
> I can generate the trace only when the performance issue pops up in a couple of weeks.. 
> Wondering if there is anything else that I could look into while waiting?

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