A tool for DBAs and Oracle performance analysts.It provides a simplified interface to extract and visualize Oracle AWR data using Excel pivot charts.
Author: [email protected]
Created: March 2013, latest updates June 2016
Blog entry: http://externaltable.blogspot.ch/2015/02/latest-updates-to-perfsheet4-tool-for.html
Note: see also PerfSheet.js at https://github.com/LucaCanali/PerfSheet.js
Contents:
| Script name | Short description |
|---|---|
| PerfSheet4_v3.7.2 | Main version of PerfSheet4. Run with Excel, versions 2010, 2013, 2016. Windows 7/8.1/10. |
| PerfSheet4_v3.7.2_noActivex_Controls | A lightweight version of PerfSheet4 modified by removing Activex Controls. This makes it easier to run on older versions of Excel and/or if there are compatility problems with Excel Activex controls. |
| PerfSheet4_v3.7.2_HPS | Customized version by Hans-Peter and Mark Sloot. This version adds a filter mask to the UI. It also adds three more pre-defined queries, including a query for Statspack. |
| sqlplus_scripts | Folder with example SQL scripts to extract data from AWR into csv files. |
| example_data | A few example csv files with AWR data. |
- Getting started video: http://youtu.be/sdvx4zB-fvo
