Graph from v$active_session_history

Cyrille Modiano

OCP Oracle DBA in Montreal at Desjardins

Latest posts by Cyrille Modiano (see all)


This query generate the data needed to build the load graph from v$active session_history, the output represent what sessions did in your database for the last hour, be careful, the v$active_session_history is part of the diagnostic pack, if you don’t have a license for this pack you should not run this query.

Query to get graph from v$active_session_history

The previous query will only work in 11g and more as it uses the PIVOT keywork, the following will work with 10g.

Here is a sample graph I generated using SQL Server Reporting Services:


I would like to thank Yannick Jaquier, for providing these queries, you can find his orginal post here

1 thought on “Graph from v$active_session_history

Leave a Reply

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