SQL Activity for the last hour

Cyrille Modiano

OCP Oracle DBA in Montreal at Desjardins

Latest posts by Cyrille Modiano (see all)

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.