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 :-)
Independent Oracle performance consultant and researcher
Upendra nerilla <nupendra@xxxxxxxxxxx> hat am 14. September 2018 um 04:54--
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
Wondering if there is anything else that I could look into while waiting?