The Application DBA  

Oracle SQL Top Sessions Scripts

topsess_create.sql - Creates the table and a sequence needed for the session snaps.
topsess_snap.sql - Takes a snapshot of the current session data. At least two snaps must be taken before a query can be run.
topsess_query.sql - Runs the topsession query which shows the delta workload rate between the last two snaps.

 

Copyright 1998-2013 AppsDBA Consulting. All Rights Reserved.