SQLdb360 is a new and free open-source performance diagnostics toolset comprising of two complementing tools, eDB360 and SQLd360. (1) eDB360 is database-wide health check and diagnosis tool complementing Exacheck, raccheck and oracheck. (2) SQd360 on the other hand is a performance diagnostic tool for a single SQL. The tools are authored by ex Oracle and Enkitec staff, Carlos Sierra and Mauro Pagano. Both tools are non-intrusive and can run on the source database without installing anything on the database, producing a set of files for offline diagnostics review using a HTML browser or text editor. Some of the information gathered includes AWR, ASH amd ADDM reports depending on licensing. They can be use independent of each other. This presentation will demonstrate what the tools are, how to use them and review their outputs. One of the helpful features of both tools is that they use Google charts libraries to produce effective charts and diagrams to present the raw data in an easy to understand format.
