New Release v02f. Printing of Charts now Supported.

Printing of charts is now supported.  Also exporting of AWRMinor and OSWatcher data sets is now supported.  Many other smaller feature enhancements and bug fixes.

Added new Feature to Export OSWatcher data in new release v02e

The capability to Export aggregated OSWatcher/ExaWatcher data has been added.  Also numerous other smaller enhancements have been added for better reporting.

New Release of VisualAWR v02a Now Supporting OSWatcher/ExaWatcher

This new Release Supports TopStat and IOStat metrics collected by OSWatcher or ExaWatcher.  When using to report on IOPS from Exadata Storage Cells, a separate chart for FLASH and DISK can be generated.

Visual AWR tested on Solaris

Visual AWR has now been tested on Solaris SuperCluster and used to chart databases running on a SPARC SuperCluster.  Charting Direct from DB was used.

New VisualAWR version v01g with 2 new charts

This new release contains 2 new charts:
1. Average Active Sessions By Wait Type
2. Top Timed Events Bar Chart

Download this new version below.  Several other small bug fixes have been made as well.

The Top Timed Events is a good chart to start you performance analysis with.  In most cases "DB CPU" should be the dominant percentage of overall DB Time.

Alpha Version of Visual AWR Released

This tool will chart Oracle Database AWR performance metrics by directly connecting to the target Oracle database or by reading the output from an AWRMiner collection text file.

Visual AWR is not supported or endorsed by Oracle.  It was developed independently by me and is intended for experienced Oracle DBAs and database performance engineers.

This project owes a debt to the seminal database performance work done by Tyler Muth from Oracle. Specifically his AWRMiner project was leveraged as a guide for the SQL queries used to extract data from the Oracle AWR tables.


Samples of almost 50 different performance and capacity metrics to chart from