The reason for a tool like PerfSheet.js is to make the analysis of AWR data easier by providing a graphical interactive interface and by automating several repetitive steps of data extraction and chart preparation. Pivot charts provide a flexible and easy to use way to navigate around the many metrics and dimensions of AWR data. PerfSheet4 is a tool that I have been using for a few years for AWR data analysis (following previous original work by Tanel Poder).
The main components of PerfSheet.js are:
- Visualization with interactive pivot charts. This is implemented using PivotTable.js by Nicolas Kruchten.
- Additional customization provide pre-configured starter charts and a basic interface to load data from CSV files.
- A set of SQL scripts to extract performance metrics of interest from Oracle AWR tables into CSV files.
- A few example data files come with the tool, to help first-time users.
Here is a screenshot of PerfSheet.js:
Here is an introductory video:
References and acknowledgements
PerfSheet.js is based on PivotTable.js by Nicolas Kruchten. Additional dependencies include: C3.js, D3.js, jQuery, jQueryUI, PapaParse. PerfSheet.js is based on previous work on PerfSheet4 which in turn is based on original work by Tanel Poder.