Troubleshooting Oracle database using ASH
Video discusses about approach you can adopt to tune, optimize Oracle databases using ASH Data.
Active Session History (ASH) is an important part of the Oracle Diagnostics and Tuning Pack. It samples information from the [G]V$ views allowing you to see current and historical information about active sessions on the database.