Re: Graphs from AWR reports

Morning Ram Raman,

> Is there a freeware that you can recommend to create graphs ( or even
> text output) from a bunch of AWR reports.

Possibly. VisualAWR is something I've seen recently in use by Oracle themselves. It's documented by Stephen Furlong on his blog at

http://visualawr.blogspot.com/ or more specifically, 
http://visualawr.blogspot.com/2017/12/new-release-and-now-open-sourced.html. 
Stephen's Github is at https://github.com/sfurlong/visual-awr.

I've had a few problems with this with Java versions > 8 (or maybe 7) and I've forked Stephen's repository to my own at https://github.com/NormanDunbar/visual-awr and made a couple of small changes to get it to compile and run under Java 12.

I've been communicating with Stephen on a few other foibles of Oracle pluggable databases etc, but he's gone awol recently and is probably working away somewhere. You need to be connected to the container database, not the pluggable.

On Stephen's blog page, the comments are missing a couple of later ones from me, but it's mostly to confirm the above.

VisualAWR can either load its data from the database directly querying the tables - if you have the appropriate licence of course - or from a file created by a script which dumps the AWR data to a CSV file.

HTH

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l