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

1. Download report XMLs include in this repository
2. Open the Report pane from View --> Reports
3. User Defined Reports, Right Click, Open Report
4. 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