SQL Activity for the last hour

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

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

email

4 thoughts on “SQL Activity for the last hour

Leave a Reply