Set of SQL Developer reports to visualize Statpack data and to dig deep with performance issues

Setup Statpack

Use below commands to install and schedule statpack

$ORACLE_HOME/rdbms/admin/spcreate.sql
$ORACLE_HOME/rdbms/admin/spauto.sql

More information on installing statpack can be found here: https://oracle-base.com/articles/8i/statspack-8i

Download and install SQL Developer

Download SQL Developer from https://www.oracle.com/database/technologies/appdev/sql-developer.html

Import Reports

Download report XMLs include in this repository
Open the Report pane from View --> Reports
User Defined Reports, Right Click, Open Report
Select downloded xml.

This work is inspired by oraculix. You can find many useful reports there.

Please contribute and keep me posted with your issues/suggestions [email protected].

Have fun!

DSJ