SQL Activity for the last hour

This script can be used to show the top 10 SQL activity for the last hour.
It uses the v$active_session_history view to search top SQL by resource consumption.

Top 10 SQL Activity

Here is the result you can obtain:

SQL activity

and the active sessions history graph for the same period:

instance activity last hour

4 thoughts on “SQL Activity for the last hour

Leave a Reply