Last month,
Jeff Smith wrote an excellent blog about Toad’s new Stats Pack capabilities. And as Jeff pointed out, Stats Pack is an older – but free technology. While Oracle’s AWR and ADDM reports are clearly the next generation of performance diagnostics tools – and arguably preferable, you must purchase the OEM Tuning and Diagnostics packs to utilize these facilities. So even though DBA’s can access AWR and ADDM reports either through PL/SQL calls or the Toad DBA GUI – which simplifies access further, many people who use AWR and ADDM may not be properly licensed. Thus Stats Pack may well remain relevant for some time into the future due to its cost.
However, sometimes people need a picture or road map in order to more thoroughly comprehend what Stats Pack has to offer – and how to best decipher that information. Look again at a screen snapshot of all the graphical content in Toad’s Stats Pack screen shown here:
Click image to view larger
While most anyone can read such simplistic charts – where does this information come from and how is it interrelated. The reasons you might want to know this is in case you do want to build custom selections – or better yet, in case you decide to write you own custom SQL scripts or reports off this information. Heck, it might even be helpful if we just want to look at the standard Oracle scripts SPREPORT.SQL and SPREPINS.SQL simply understand what they do.
So here’s a data model to aide with such efforts:
Stats Pack Entity Relationship Diagram – courtesy of Toad Data Modeler