matheusdba Staff asked 2 years ago
How to troubleshoot the already ran sessions which ran long and finished?
matheusdba Staff answered 2 years ago
Oracle is great for this! As long as you fay for it… 🙂
In general, the features from the Diagnostic Pack, like AWR (for a Workload Performance and measuring the impact of a SQL), ADDM (for a specific SQL) or ASH (Active Session History) for granular information about the session from the last moments (days, hours, depending on the case).
In summary, you have to pay for official solutions to look back in time.
But remember that all those reports are made based on the “runtime” views. So you can create a manual system of your own to gather “snapshots” and build similar reports later.
We actually have something really nice in a similar line based on the ASH, build by the community. It’s the S-ASH (or, Simulated ASH). Google it!